Habbo Custom Help

[Techie]

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 '["s","6553","spiro","123654","0","1","1","","Red Dragon Egg","Coded by Vrop93","' at line 1

2-#1136 - Column count doesn't match value count at row 1
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

 

[Techie]

Can Anyone Help?

 

[Weasel]

Because the first line needs to go in your FURNIDATA.TXT

 

[Techie]

• what u meen i added the furni data bit its
• NSERT INTO `catalog_items` (`id`, `901`, `item_ids`, `Pedro Egg`, `0`, `1000`, `4`, `amount`) VALUES (1937, '94', '1937', 'spiro', '50000', '0', '1');?

 

[Weasel]

This line:

["s","6553","spiro","123654","0","1","1","","Red Dragon Egg","Coded by Vrop93","","-1","-1"],

Needs to go in your Furnidata.TXT (.TXT IS A FILE) in your gamedata map.

 

[Techie]

Yeh i added it in there like i said i followed the tutorial

 

[Weasel]

No... you are adding it into your Database trough Navicat or something:

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 '["s","6553","spiro","123654","0","1","1","","Red Dragon Egg","Coded by Vrop93","' at line 1

2-#1136 - Column count doesn't match value count at row 1

 

[Techie]

i did php it told me to add it to furni data catalogue_items and furniture
but it gives me tha error when i enter it into the sql for catalogue_items and furniture