hi im getting a mysql error can anyone help please

[Vapour]

hi im trying to add Furni to my retro but i keep on getting a syntax error can anyone help me with this?


here is the error
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `furniture` (`id` ,`public_name` ,`item_name` ,`type` ,`width` ,`len' at line 2

here is the insert into part

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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326588' , 'squarethrone', 'squarethrone', 's', '0', '0', '0', '0', '1', '0', '1326588', '1', '1', '1', '1', '1', 'default', '0', '', '0', '', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326589' , 'squarethrone2', 'squarethrone2', 's', '0', '0', '0', '0', '1', '0', '1326589', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326590' , 'squarethrone3', 'squarethrone3', 's', '0', '0', '0', '0', '1', '0', '1326590', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326591' , 'squarethrone4', 'squarethrone4', 's', '0', '0', '0', '0', '1', '0', '1326591', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326592' , 'squarethrone5', 'squarethrone5', 's', '0', '0', '0', '0', '1', '0', '1326592', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326593' , 'squarethrone6', 'squarethrone6', 's', '0', '0', '0', '0', '1', '0', '1326593', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326594' , 'squarethrone7', 'squarethrone7', 's', '0', '0', '0', '0', '1', '0', '1326594', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326595' , 'squarethrone8', 'squarethrone8', 's', '0', '0', '0', '0', '1', '0', '1326595', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')
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` ,`height_adjustable` ,`effectM` ,`effectF`) VALUES ('1326596' , 'squarethrone9', 'squarethrone9', 's', '0', '0', '0', '0', '1', '0', '1326596', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0')

 

[Marcel]

What emulator ?

 

[Vapour]

it dosent matter not i have sorted it thanks dude.

 

[Marcel]

Alright bro, contact me via Conversation if more help is required.

 

[Vapour]

phx 3.0 ?? still getting this error??

 

[Mastah]

Can you tell us how you've fixed it would be handy. Some people are able to use it too when having problems.


Verzonden vanaf mijn iPhone met Tapatalk