Reply to thread

Message

<blockquote data-quote="Techie" data-source="post: 140833" data-attributes="member: 21185">Hello Dev Ive been trying to add customs for a while now and it jsut stops me with 2 errors when i run the codes of the mysql in my db tables query ive followed many tutorials over and over but still dnt work heres the common errors i get 1-#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 '[&quot;s&quot;,&quot;6553&quot;,&quot;spiro&quot;,&quot;123654&quot;,&quot;0&quot;,&quot;1&quot;,&quot;1&quot;,&quot;&quot;,&quot;Red Dragon Egg&quot;,&quot;Coded by Vrop93&quot;,&quot;' at line 1&nbsp;2-#1136 - Column count doesn't match value count at row 1i type in the right codes this is wa it tells me in ntoepad-------------------------------------------------------------------------------------------------------------------------------------&nbsp;Furniture SQL:&nbsp;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 (1937, 'spiro', 'spiro', 's', 1, 1, 1, '0', '0', '0', 6553, '1', '1', '1', '1', '1', 'default', 4, '0', '0')&nbsp;Catalog_items SQL:INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES (1937, '94', '1937', 'spiro', '50000', '0', '1');&nbsp;&nbsp;Furnidata SQL:&nbsp;INSERT INTO `catalog_items` (`id`, `901`, `item_ids`, `Pedro Egg`, `0`, `1000`, `4`, `amount`) VALUES (1937, '94', '1937', 'spiro', '50000', '0', '1');--------------------------------------------------------------------------------------------------------------------------------------Ill also attach the custom file</blockquote>

[QUOTE="Techie, post: 140833, member: 21185"] Hello Dev Ive been trying to add customs for a while now and it jsut stops me with 2 errors when i run the codes of the mysql in my db tables query ive followed many tutorials over and over but still dnt work heres the common errors i get 1-[FONT=sans-serif][COLOR=#000000]#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 '["s","6553","spiro","123654","0","1","1","","Red Dragon Egg","Coded by Vrop93","' at line 1[/COLOR][/FONT] [FONT=sans-serif][COLOR=#000000]2-[/COLOR][/FONT][FONT=sans-serif][COLOR=#000000]#1136 - Column count doesn't match value count at row 1[/COLOR][/FONT] i type in the right codes this is wa it tells me in ntoepad ------------------------------------------------------------------------------------------------------------------------------------- Furniture SQL: 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 (1937, 'spiro', 'spiro', 's', 1, 1, 1, '0', '0', '0', 6553, '1', '1', '1', '1', '1', 'default', 4, '0', '0') Catalog_items SQL: INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES (1937, '94', '1937', 'spiro', '50000', '0', '1'); Furnidata SQL: INSERT INTO `catalog_items` (`id`, `901`, `item_ids`, `Pedro Egg`, `0`, `1000`, `4`, `amount`) VALUES (1937, '94', '1937', 'spiro', '50000', '0', '1'); -------------------------------------------------------------------------------------------------------------------------------------- Ill also attach the custom file [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members