(arcturus) sql error furni

[sunnie]

Hi,

I had a problem to add furni to arcturus, thats fixed. But now when i build the sqls for arcturus from te bazaar furni i get this error when i go to run:

(This are the errors

[SQL] INSERT INTO `items_base` VALUES ('1000002157', '1000002157', 'clothing_alluringeyes name', 'clothing_alluringeyes name', 's', '1', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002156', '1000002156', 'bazaar_r17_throne name', 'bazaar_r17_throne name', 's', '1', '1', '1', '0', '1', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002155', '1000002155', 'bazaar_r17_monkey name', 'bazaar_r17_monkey name', 's', '1', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002154', '1000002154', 'bazaar_r17_fountain name', 'bazaar_r17_fountain name', 's', '2', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002153', '1000002153', 'bazaar_ltd17_ele name', 'bazaar_ltd17_ele name', 's', '2', '2', '3', '0', '1', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002152', '1000002152', 'bazaar_c17_vasepink name', 'bazaar_c17_vasepink name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002151', '1000002151', 'bazaar_c17_vaseyellowbluetrim name', 'bazaar_c17_vaseyellowbluetrim name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002150', '1000002150', 'bazaar_c17_vaseyellow name', 'bazaar_c17_vaseyellow name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002149', '1000002149', 'bazaar_c17_vasepurpleyellowtrim name', 'bazaar_c17_vasepurpleyellowtrim name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002148', '1000002148', 'bazaar_c17_vasepurple name', 'bazaar_c17_vasepurple name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002147', '1000002147', 'bazaar_c17_vasepinkbluetrim name', 'bazaar_c17_vasepinkbluetrim name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002146', '1000002146', 'bazaar_c17_vasemystic name', 'bazaar_c17_vasemystic name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002145', ' 1000002145', 'bazaar_c17_vasegreenpurpletrim name', 'bazaar_c17_vasegreenpurpletrim name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002144', '1000002144', 'bazaar_c17_vasegreen name', 'bazaar_c17_vasegreen name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002143', '1000002143', 'bazaar_c17_vasebluepinktrim name', 'bazaar_c17_vasebluepinktrim name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002142', '1000002142', 'bazaar_c17_vaseblue name', 'bazaar_c17_vaseblue name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002141', '1000002141', 'bazaar_c17_vase name', 'bazaar_c17_vase name', 's', '1', '1', '2', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002140', '1000002140', 'bazaar_c17_sticklizard name', 'bazaar_c17_sticklizard name', 's', '1', '1', '1', '0', '0', '0', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', ''),
INSERT INTO `items_base` VALUES ('1000002139', '1000002139', 'bazaar_c17_spice name', 'bazaar_c17_spice name', 's',
[Err] 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 `items_base` VALUES ('1000002156', '1000002156', 'bazaar_r17_throne ' at line 2


Someone can see whats fault? Or wrong?

Thanks!

 

[Elias123]

add me on discord Elias#5329

 

[The General]

Yeah because you do an insert into after another insert into while your syntax shows a , instead of a ; so it expects another value set but instead it gets a new INSERT INTO statement.

Replace the , at the end of every line with a ; OR remove all INSERT INTO text except the first one and end the whole query with a ; instead od an ,