[BCSTORM] Navicat Database Error!

Status
Not open for further replies.

Femq

New Member
Sep 30, 2012
5
0
When i try import my database to Navicat i get this error.

[Err] 1265 - Data truncated for column 'visible' at row 1
[Err] 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', '', '', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
and there is loads more than just that error.
Does anyone know why it does this? would help alot thanks ;]
 

Femq

New Member
Sep 30, 2012
5
0
Iv tryed more than 5 Database's all of LeenStars newest updates + Some others, i cant even upload a phx emu database, i get the errors still well some times, iv not tryed one from Otaku tryed a friends Edit but i wanna use bcstorm, it works great on localhost/xampp on my home computer just not on a VPS?
 

Femq

New Member
Sep 30, 2012
5
0
Other BCSTORM emu gives me this Error
[Err] 1304 - PROCEDURE getroomitems already exists
[Err] -- Dumping structure for procedure bc.getroomitems

CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)
BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
END;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
 
Status
Not open for further replies.

Users who are viewing this thread

Top