can someone help me fix my sql code?

[william wardenier]

the code is:



INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_f
igure`) VALUES
(650137002, 'rcktegg', 'rcktegg', 's', 1, 1, 1, '1', '0', '0', 650137002, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137003, 'rckteg2', 'rckteg2', 's', 1, 1, 1, '1', '0', '0', 650137003, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137004, 'rckteg3', 'rckteg3', 's', 1, 1, 1, '1', '0', '0', 650137004, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137005, 'rckteg4', 'rckteg4', 's', 1, 1, 1, '1', '0', '0', 650137005, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137006, 'rckteg5', 'rckteg5', 's', 1, 1, 1, '1', '0', '0', 650137006, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137007, 'rckteg6', 'rckteg6', 's', 1, 1, 1, '1', '0', '0', 650137007, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0');




it says Unknown column 'foot_figure' in 'field list'





Please can someone fix this code for me so i can run it?






Thanks.

 

[Dzetki]

Simple, phoenix doesn't have "foot_figure" in its database. Just remove it from the query like this:

INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`) VALUES
(650137002, 'rcktegg', 'rcktegg', 's', 1, 1, 1, '1', '0', '0', 650137002, '1', '1', '0', '1', '1', 'default', 1, '0', '0'),
(650137003, 'rckteg2', 'rckteg2', 's', 1, 1, 1, '1', '0', '0', 650137003, '1', '1', '0', '1', '1', 'default', 1, '0', '0'),
(650137004, 'rckteg3', 'rckteg3', 's', 1, 1, 1, '1', '0', '0', 650137004, '1', '1', '0', '1', '1', 'default', 1, '0', '0'),
(650137005, 'rckteg4', 'rckteg4', 's', 1, 1, 1, '1', '0', '0', 650137005, '1', '1', '0', '1', '1', 'default', 1, '0', '0'),
(650137006, 'rckteg5', 'rckteg5', 's', 1, 1, 1, '1', '0', '0', 650137006, '1', '1', '0', '1', '1', 'default', 1, '0', '0'),
(650137007, 'rckteg6', 'rckteg6', 's', 1, 1, 1, '1', '0', '0', 650137007, '1', '1', '0', '1', '1', 'default', 1, '0', '0');

That should work if I am correct.

 

[william wardenier]

thanks

 

[william wardenier]

what about this one?







INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_f
igure`) VALUES
(650137002, 'rcktegg', 'rcktegg', 's', 1, 1, 1, '1', '0', '0', 650137002, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137003, 'rckteg2', 'rckteg2', 's', 1, 1, 1, '1', '0', '0', 650137003, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137004, 'rckteg3', 'rckteg3', 's', 1, 1, 1, '1', '0', '0', 650137004, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137005, 'rckteg4', 'rckteg4', 's', 1, 1, 1, '1', '0', '0', 650137005, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137006, 'rckteg5', 'rckteg5', 's', 1, 1, 1, '1', '0', '0', 650137006, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137007, 'rckteg6', 'rckteg6', 's', 1, 1, 1, '1', '0', '0', 650137007, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0');

 

[william wardenier]

oops nvm

 

[Dzetki]

what about this one?







INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_f
igure`) VALUES
(650137002, 'rcktegg', 'rcktegg', 's', 1, 1, 1, '1', '0', '0', 650137002, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137003, 'rckteg2', 'rckteg2', 's', 1, 1, 1, '1', '0', '0', 650137003, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137004, 'rckteg3', 'rckteg3', 's', 1, 1, 1, '1', '0', '0', 650137004, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137005, 'rckteg4', 'rckteg4', 's', 1, 1, 1, '1', '0', '0', 650137005, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137006, 'rckteg5', 'rckteg5', 's', 1, 1, 1, '1', '0', '0', 650137006, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0'),
(650137007, 'rckteg6', 'rckteg6', 's', 1, 1, 1, '1', '0', '0', 650137007, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0');

Once again, remove the " , 'foot_figure' ". Other than that, the last ", '0' " should be removed aswell as that's the value for foot_figure. Do that and you don't need our help with this problem the next time

If you have problems doing so, I can gladly do it for you once again and at the same time try to make a very very small tutorial just for you while giving you the codes. However, I won't do it more than twice.

 

[william wardenier]

thanks dude