[Help] Adding furni to hotel

[Zurg]

Hi Everyone

I am having difficulty adding furniture to the hotel via Navicat

I have tried to follow this thread

You must be registered for see links

I have put the SWF in the hof_furni
Under productdata.txt I have added ["s","6553","spiro","123654","0","1","1","","Red Dragon Egg","Coded by Vrop93","","-1","-1"] (the tut said to put it under furnidata but that one is the .xml file)

In Navicat under 'hotel' I have ran a new query to add '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');'
For which I am receiving the error:
[Err] 1054 - Unknown column 'is_arrow' in 'field list'


and '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')'
For which I am receiving the error:
[Err] 1136 - Column count doesn't match value count at row 1

I have tried a few other downloads for furni, none have worked successfully in Navicat yet

Any help would be appreciated! My disc is Zurg#0692 if anyone wants to chat there

Post automatically merged: Jun 2, 2020

To note as well I have tried to manually add the furniture into the tables 'furniture', 'catolog_items' etc following the tables and values, when I click the black tick at the bottom to save, exit then renter, the entry has been deleted.

 

[Morohara]

Hi again!

The queries you are running are resulting in errors so therefore are not being added to the Database.

What this error means [Err] 1054 - Unknown column 'is_arrow' in 'field list' Is that the "column" which is what defines furni for price or icon images ect ect is not found, the way to find this is load up the table "catalog_items" and at the top of all the data you will see names to each column, I can see that the query you are running (presuming its not editted) hasn't been altered to fit the table that you are putting it into. I would also suggest using a sql generator which are available on devbest and other rival forums just give it a google and learn how to use the program.

If you need extra help Малонала#0998 Is my discord I am quite busy at the moment but I am willing to help you if you can't figure it out.