.. Database Wyd

[ColourfulConnor]

I uploaded a database.sql onto a retro hosted on my own PC to test it out, it worked, no errors, hotel ran perfectly.
I then went onto my VPS and uploaded that same database.sql and it had errors, I honestly have no idea how.

Using this Database:

You must be registered for see links

Screenshots:
My PC(Yes, She's Old.. It's slow.. Time: 300 Years.)

VPS

Errors:

[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532556', 'summer_sunset_wall', 'summer_sunset_wall', 'i', '1', '1', '1', '0', '0', '0', '4412', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532591', 'CF_300_bricks', 'CF_300_bricks', 's', '1', '1', '0.5', '1', '0', '0', '8134', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532592', 'room_info15_shrub1', 'room_info15_shrub1', 's', '1', '1', '1', '1', '0', '0', '7981', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532593', 'memorial_size', 'memorial_size', 's', '2', '1', '1', '1', '0', '0', '6274', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532594', 'hween14_rare1', 'hween14_rare1', 's', '3', '3', '1', '1', '0', '0', '6223', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532595', 'runway_head', 'runway_head', 's', '1', '1', '1', '1', '0', '0', '3432', '0', '1', '0', '1', '1', 'default', '7', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532596', 'sb_tag1', 'sb_tag1', 'i', '2', '1', '1', '1', '0', '0', '4406', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532600', 'room_info15_div', 'room_info15_div', 's', '1', '1', '1', '1', '0', '0', '8088', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532601', 'room_info15_gate', 'room_info15_gate', 's', '1', '1', '0.001', '1', '0', '0', '8089', '0', '1', '0', '1', '1', 'gate', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532602', 'room_info15_tree1', 'room_info15_tree1', 's', '1', '1', '1', '1', '0', '0', '7987', '0', '1', '0', '1', '1', 'default', '4', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532603', 'prize_alienplush', 'prize_alienplush', 's', '1', '1', '1', '1', '0', '0', '7980', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('532605', 'es_build1', 'es_build1', 'i', '1', '1', '1', '1', '0', '0', '4362', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540000', 'sb_tag2', 'sb_tag2', 'i', '1', '1', '1', '1', '0', '0', '4408', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540001', 'sb_tag3', 'sb_tag3', 'i', '2', '1', '1', '1', '0', '0', '4409', '0', '1', '0', '1', '1', 'default', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540002', 'statue_dragon', 'statue_dragon', 's', '1', '2', '1', '1', '0', '0', '5070', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540003', 'statue_griffin', 'statue_griffin', 's', '1', '2', '1', '1', '0', '0', '5071', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540004', 'statue_elk', 'statue_elk', 's', '2', '2', '1', '1', '0', '0', '5073', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540021', 'tiki_gate', 'tiki_gate', 's', '1', '1', '0.001', '1', '0', '0', '3595', '0', '1', '0', '1', '1', 'gate', '2', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('540022', 'bling11_wall4', 'bling11_wall4', 'i', '1', '1', '1', '1', '0', '0', '4375', '0', '1', '0', '1', '1', 'default', '1', '0', '0', '0', '0', '', '0', '0');
[Err] 1265 - Data truncated for column 'tab_colour' at row 1
[Err] -- ----------------------------
-- Records of ranks
-- ----------------------------
INSERT INTO `ranks` VALUES ('1', 'User', 'VIP', '', '');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[Sledmore]

I believe that's down to MySQL strict mode.

You can run the following query for a quick change, though it isn't perm.

SET GLOBAL sql_mode = "";

To change this perm, do the following:

You must be registered for see links

 

[ColourfulConnor]

Thanks! That's Fixed! :] Everything is working except this little guy at the bottom right, catalog is fine, any idea on where I messed up for him to go wrong?

 

[Xuxu]

Thanks! That's Fixed! :] Everything is working except this little guy at the bottom right, catalog is fine, any idea on where I messed up for him to go wrong?

your external_variables, dont forget override if its not empty....

 

[Sledmore]

The above is correct. If you're using Google Chrome, hit f12 and check the network tab or the console tab, and you'll see some red lines, which indicate the errors, you can click them (or if on console view) just view the URL, use that to amend the links in the external_variables (or the overrides).