Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Navicat error when importing database

Newbie Spellweaver
Joined
Feb 18, 2016
Messages
67
Reaction score
1
I'm importing a database from my hotel as I'm reopening it, but I get this error when the query is at 56%

Code:
[SQL] Query grotte start[ERR] 1265 - Data truncated for column 'is_arrow' at row 1[ERR] INSERT INTO `items_base` VALUES ('7779049', 'paris_c15_vegstall3 name', 'paris_c15_vegstall3', 's', '1', '1', '1', '0', '0', '0', '7779049', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779050', 'paris_c15_food1 name', 'paris_c15_food1', 's', '1', '1', '0.1', '0', '0', '0', '7779050', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779051', 'paris_c15_awning name', 'paris_c15_awning', 's', '3', '1', '0.001', '0', '0', '0', '7779051', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779052', 'paris_c15_food3 name', 'paris_c15_food3', 's', '1', '1', '0.1', '0', '0', '0', '7779052', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779053', 'paris15_bicycle name', 'paris15_bicycle', 's', '1', '2', '1.7', '0', '1', '0', '7779053', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779054', 'clothing_breton name', 'clothing_breton', 's', '1', '1', '0.2', '0', '0', '1', '7779054', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779055', 'paris_c15_chair name', 'paris_c15_chair', 's', '1', '1', '1.1', '0', '1', '0', '7779055', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779056', 'paris_c15_building1 name', 'paris_c15_building1', 's', '3', '1', '8.1', '1', '0', '0', '7779056', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779057', 'paris_c15_vegstall2 name', 'paris_c15_vegstall2', 's', '1', '1', '1', '0', '0', '0', '7779057', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779058', 'paris_c15_shadow name', 'paris_c15_shadow', 's', '2', '2', '0.001', '0', '0', '1', '7779058', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779059', 'paris_c15_vegstall1 name', 'paris_c15_vegstall1', 's', '1', '1', '1', '0', '0', '0', '7779059', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779060', 'paris_c15_wall name', 'paris_c15_wall', 'i', '1', '1', '1', '0', '0', '0', '7779060', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779063', 'Pterodactyl Nest', 'nest_pterosaur', 's', '1', '1', '1.5', '0', '0', '1', '7779063', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779064', 'yttv_retro name', 'yttv_retro', 's', '2', '1', '1', '0', '0', '1', '7779064', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779096', '15marquee', 'marquee*11', 's', '1', '1', '0', '0', '0', '0', '7779096', '0', '1', '0', '1', '1', 'gate', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779097', '15pillar', 'pillar*10', 's', '1', '1', '3.5', '0', '0', '0', '7779097', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779098', '15pillow', 'pillow*10', 's', '1', '1', '0.9', '0', '0', '0', '7779098', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779099', '15rare_beehive_bulb', 'rare_beehive_bulb*3', 's', '1', '1', '1', '0', '0', '0', '7779099', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779100', '15rare_dragonlamp', 'rare_dragonlamp*10', 's', '1', '1', '1', '0', '0', '0', '7779100', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779101', '15rare_elephant_statue', 'rare_elephant_statue*3', 's', '1', '1', '1', '0', '0', '0', '7779101', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779102', '15rare_fan', 'rare_fan*10', 's', '1', '1', '1', '0', '0', '0', '7779102', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0');INSERT INTO `items_base` VALUES ('7779103', '15rare_fountain', 'rare_fountain*4', 's', '1[SQL] Finished unsuccessfully

1265 - Data truncated for column 'is_arrow' at row 1
 
Banned
Banned
Joined
Aug 25, 2009
Messages
431
Reaction score
190
@MaKKo Where did you get this SQL from? You have `is_arrow` in your table where this SQL isn't expecting it.
 
Upvote 0
Back
Top