Can't add furni R63B

[DDOSer]

I cant add any furni to R63B my retro! Everytime i try it comes up with errors when i run it as a query through navicat Need help very soon!

 

[Joe]

What errors..?

 

[DDOSer]

You must be registered for see images attach

Thats the errors @JMG

 

[NotoriousJameson]

That means you are missing a column called "is_arrow"

 

[DDOSer]

@Jameson Do u have the query for it

 

[NotoriousJameson]

Just remove ,'is_arrow' from that query and the last ,'0' part from that query.

 

[DDOSer]

@Jameson Theres one with catalog items now
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(98104, 'PAGE ID', '98104', 'WWE Pillow', '1', '0', '0', '1');
Its unknown about item_ids but i removed it and there was a new error

 

[Joe]

@Jameson Theres one with catalog items now
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(98104, 'PAGE ID', '98104', 'WWE Pillow', '1', '0', '0', '1');
Its unknown about item_ids but i removed it and there was a new error

This looks like an old R63A query, the new tables don't have those columns. It's not hard to check what columns you need and add them in.

For example, cost_snow doesn't exist.

 

[Liam]

You're either missing the columns or you don't need them, look at your furniture and catalog_items table.