Phoenix Furniture Tabel Problem

BEGames

BEGames

New Member
Mar 4, 2016
7
0
Hello Guy's,

I have a problem whit the phoenix sql its posted on a ducth forum form *****

and i have tis problem :
Unknown column 'HeightOverride' in 'field list'

Can sombody give me the fix for tis ?

Thanks
 
Sort by date Sort by votes
JayC

JayC

Always Learning
Aug 8, 2013
5,494
1,398
First of all, we need to see the SQL you are even trying to input we aren't mind readers and we don't just magically come up with answers. SQL please.
 
Upvote 0 Downvote
BEGames

BEGames

New Member
Mar 4, 2016
7
0
JayCustom said:
First of all, we need to see the SQL you are even trying to input we aren't mind readers and we don't just magically come up with answers. SQL please.
Click to expand...
Tis is the Furniture sql form rn (posted by *****)"]Tis is the Furniture sql form rn (posted by *****)
Tis is the Furniture sql form rn (posted by *****)
## Furniture ##
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779096, '15marquee', '15marquee', 's', 1, 1, '0.0', '0', '0', '1', 7779096, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779097, '15pillar', '15pillar', 's', 1, 1, '3.5', '0', '0', '1', 7779097, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779098, '15pillow', '15pillow', 's', 1, 1, '0.9', '0', '0', '1', 7779098, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779099, '15rare_beehive_bulb', '15rare_beehive_bulb', 's', 1, 1, '0.0', '0', '0', '1', 7779099, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779100, '15rare_dragonlamp', '15rare_dragonlamp', 's', 1, 1, '0.0', '0', '0', '1', 7779100, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779101, '15rare_elephant_statue', '15rare_elephant_statue', 's', 1, 1, '1.0', '0', '0', '1', 7779101, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779102, '15rare_fan', '15rare_fan', 's', 1, 1, '0.0', '0', '0', '1', 7779102, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779103, '15rare_fountain', '15rare_fountain', 's', 1, 1, '1.0', '0', '0', '1', 7779103, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779104, '15rare_icecream', '15rare_icecream', 's', 1, 1, '0.0', '0', '0', '1', 7779104, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779105, '15rare_parasol', '15rare_parasol', 's', 1, 1, '1.0', '0', '0', '1', 7779105, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779106, '15scifidoor', '15scifidoor', 's', 1, 1, '0.0', '0', '0', '1', 7779106, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779107, '15scifiport', '15scifiport', 's', 1, 1, '0.0', '0', '0', '1', 7779107, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779108, '15scifirocket', '15scifirocket', 's', 1, 1, '1.0', '0', '0', '1', 7779108, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779109, '15sleepingbag', '15sleepingbag', 's', 1, 3, '0.8', '0', '0', '1', 7779109, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779110, '15wooden_screen', '15wooden_screen', 's', 1, 2, '2.0', '0', '0', '1', 7779110, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779111, 'habbo15_comp_blocks name', 'habbo15_comp_blocks', 's', 1, 1, '1', '0', '0', '1', 7779111, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779112, 'habbo15_comp_clothing name', 'habbo15_comp_clothing', 's', 1, 1, '1', '0', '0', '1', 7779112, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779113, 'habbo15_comp_furni name', 'habbo15_comp_furni', 's', 1, 1, '1', '0', '0', '1', 7779113, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779114, 'habbo15_comp_photo name', 'habbo15_comp_photo', 's', 1, 1, '1', '0', '0', '1', 7779114, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779115, 'habbo15_comp_room name', 'habbo15_comp_room', 's', 1, 1, '1', '0', '0', '1', 7779115, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779116, 'habbo15_comp_video name', 'habbo15_comp_video', 's', 1, 1, '1', '0', '0', '1', 7779116, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779117, 'Habbo 15 Prize Balloon', 'habbo15_crackable', 's', 1, 1, '0.000001', '0', '0', '1', 7779117, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779118, 'habbo15_placeholder name', 'habbo15_placeholder', 's', 1, 1, '1', '0', '0', '1', 7779118, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779119, 'Habbo 15 Rare Prize Balloon', 'habbo15_rare_crackable', 's', 1, 1, '0.000001', '0', '0', '1', 7779119, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779120, 'room_hall15_barch name', 'room_hall15_barch', 's', 1, 1, '0.000001', '0', '0', '1', 7779120, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779121, 'room_hall15_pillar name', 'room_hall15_pillar', 's', 1, 1, '1', '0', '0', '1', 7779121, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779122, 'room_hall15_sofa name', 'room_hall15_sofa', 's', 2, 1, '1.1', '0', '0', '1', 7779122, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779123, 'room_hall15_window name', 'room_hall15_window', 's', 1, 2, '0.000001', '0', '0', '1', 7779123, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779124, 'room_hall_trophy1 name', 'room_hall_trophy1', 's', 1, 1, '1.5', '0', '0', '1', 7779124, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
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`, `height_adjustable`, `effectM`, `effectF`, `HeightOverride`) VALUES (7779125, 'room_hall_trophy2 name', 'room_hall_trophy2', 's', 2, 2, '2.03', '0', '0', '1', 7779125, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0, 0, '0');
Click to expand...
 
Upvote 0 Downvote
JayC

JayC

Always Learning
Aug 8, 2013
5,494
1,398
Are you sure your using the SQL for your emulator because I am guessing that it's invalid column name/doesn't exist. Make sure if you're using GTE you select GTE SQL
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
🌙  Switch to Dark Theme

Latest posts

Top