Can't import BcStorm DB

sim0n

Member
Feb 16, 2013
227
15
So I was going to import my database, and everything was going as planned until I ran the file.
I am using the database that is provided together with Leensters BcStorm March 3 emulator. When I ran the phoenix file it worked fine. I am using Navicat to impor the database.

This is the error im getting:
Code:
[Err] 1265 - Data truncated for column 'visible' at row 1
[Err] INSERT INTO `catalog_pages` VALUES ('123', '4', 'Hello', '0', '35', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_hello_header1_en', 'catalog_hello_teaser1_en', '', 'Hello Furni is available with Pixels and is perfect if you are decorating your room for the very first time. The Furni is yours to keep and therefore cannot be traded.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('125', '4', 'Special Effects', '0', '61', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_pixeleffects_headline1_en', 'catalog_pxl_teaser1_en', '', 'Tune your character with cool effects that fit the occasion. Ride the hoverboard and spit on the mic. Effects can be activated from the menu, by clicking on your avatar.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('126', '3', 'Tiki', '0', '59', '1', '1', '1', '0', '0', '4', 'default_3x3', 'catalog_tiki_header1_en', 'tiki_teaser', '', 'Nada mejor que cargar tu cesto de picnic, encontrar un pedazo de verde acogedor, descalzarse y... nada más. ¡Relax!', '', '', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('128', '1011', 'Urban', '0', '26', '1', '1', '1', '0', '0', '100', 'default_3x3', 'urban_header_en', 'urban_teaser_en', '', 'New York City styled furni range, Urban is perfect for any street, alleyway or road. Rubbish bins, street lights and benches, all the Urban furniture you need!', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('129', '4', 'Automobile', '0', '16', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_automobile_header1_en', 'catalog_automobile_teaser1_en', '', 'Every Habbo needs a car effect! Not only do they bring a bit of the outside inside, they also enhance the air quality! And what better gift for a friend than a beautiful traffic sign or elegant pile of tires...', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('130', '1011', 'Country', '0', '21', '1', '1', '1', '0', '0', '100', 'default_3x3', '', '', '', 'Go green with our environmentally friendly Environment range! This selection of furni is perfect for a beautiful, relaxing garden.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('134', '91', 'System', '0', '1', '', '', '7', '0', '0', '100', 'default_3x3', 'catalog_frontpage_headline2_en', 'catalog_limited_teaser_en', '', '', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('137', '1011', 'Orgy', '51', '1', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_frontpage_headline2_en', '', '', 'The latest range from Ann Summers, the Orgie line. Made of soft, wipe clean plastic, its perfect for any three, four or fivesome!', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('136', '1011', 'Bling', '0', '86', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_header_bling_en', '', '', 'Bling, Bling! Flash, Flash! Want to have that real celebrity lifestyle? Well, go somewhere else, all we have here is a tacky range of furni.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('160', '14', 'Accessories', '0', '43', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_pet_headline1', 'ctlg_pet_teaser1', 'catalog_special_txtbg2', 'This page has everything you need to give your pet the happy life it deserves. We\'ve got a huge selection!', '', 'Click on an item for more information.', 'Keep \'em happy!', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('143', '1011', 'Flower Power', '0', '73', '1', '1', '1', '0', '0', '100', 'default_3x3', 'flowerpower_header_en', '', '', 'Woah! Far out man... let the petals take control. Lets collaborate on a hippy hideout and plant some seeds! Lucy in the sk
[Msg] Finished - Unsuccessfully
--------------------------------------------------
 

Baevus

the names ethan
Nov 4, 2012
565
47
So I was going to import my database, and everything was going as planned until I ran the file.
I am using the database that is provided together with Leensters BcStorm March 3 emulator. When I ran the phoenix file it worked fine. I am using Navicat to impor the database.

This is the error im getting:
Code:
[Err] 1265 - Data truncated for column 'visible' at row 1
[Err] INSERT INTO `catalog_pages` VALUES ('123', '4', 'Hello', '0', '35', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_hello_header1_en', 'catalog_hello_teaser1_en', '', 'Hello Furni is available with Pixels and is perfect if you are decorating your room for the very first time. The Furni is yours to keep and therefore cannot be traded.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('125', '4', 'Special Effects', '0', '61', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_pixeleffects_headline1_en', 'catalog_pxl_teaser1_en', '', 'Tune your character with cool effects that fit the occasion. Ride the hoverboard and spit on the mic. Effects can be activated from the menu, by clicking on your avatar.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('126', '3', 'Tiki', '0', '59', '1', '1', '1', '0', '0', '4', 'default_3x3', 'catalog_tiki_header1_en', 'tiki_teaser', '', 'Nada mejor que cargar tu cesto de picnic, encontrar un pedazo de verde acogedor, descalzarse y... nada más. ¡Relax!', '', '', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('128', '1011', 'Urban', '0', '26', '1', '1', '1', '0', '0', '100', 'default_3x3', 'urban_header_en', 'urban_teaser_en', '', 'New York City styled furni range, Urban is perfect for any street, alleyway or road. Rubbish bins, street lights and benches, all the Urban furniture you need!', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('129', '4', 'Automobile', '0', '16', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_automobile_header1_en', 'catalog_automobile_teaser1_en', '', 'Every Habbo needs a car effect! Not only do they bring a bit of the outside inside, they also enhance the air quality! And what better gift for a friend than a beautiful traffic sign or elegant pile of tires...', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('130', '1011', 'Country', '0', '21', '1', '1', '1', '0', '0', '100', 'default_3x3', '', '', '', 'Go green with our environmentally friendly Environment range! This selection of furni is perfect for a beautiful, relaxing garden.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('134', '91', 'System', '0', '1', '', '', '7', '0', '0', '100', 'default_3x3', 'catalog_frontpage_headline2_en', 'catalog_limited_teaser_en', '', '', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('137', '1011', 'Orgy', '51', '1', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_frontpage_headline2_en', '', '', 'The latest range from Ann Summers, the Orgie line. Made of soft, wipe clean plastic, its perfect for any three, four or fivesome!', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('136', '1011', 'Bling', '0', '86', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_header_bling_en', '', '', 'Bling, Bling! Flash, Flash! Want to have that real celebrity lifestyle? Well, go somewhere else, all we have here is a tacky range of furni.', '', 'Click on an item for more information.', '', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('160', '14', 'Accessories', '0', '43', '1', '1', '1', '0', '0', '100', 'default_3x3', 'catalog_pet_headline1', 'ctlg_pet_teaser1', 'catalog_special_txtbg2', 'This page has everything you need to give your pet the happy life it deserves. We\'ve got a huge selection!', '', 'Click on an item for more information.', 'Keep \'em happy!', '', '', '', '0', '', '');
INSERT INTO `catalog_pages` VALUES ('143', '1011', 'Flower Power', '0', '73', '1', '1', '1', '0', '0', '100', 'default_3x3', 'flowerpower_header_en', '', '', 'Woah! Far out man... let the petals take control. Lets collaborate on a hippy hideout and plant some seeds! Lucy in the sk
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Delete the Phoenix then add this, You can't have a phoenix catalogue with a BcStorm, The code is slightly different. So you do it manually.
 

sim0n

Member
Feb 16, 2013
227
15
Delete the Phoenix then add this, You can't have a phoenix catalogue with a BcStorm, The code is slightly different. So you do it manually.
Dude, i'm not importing this into the phoenix database.. its a new fresh database. I have even deleted the phoenix db.
 

Users who are viewing this thread

Top