Error after moving catalogue into VPS? [D0WNF4LL CATALOGUE V10]

[PRIZM]

Hey guys, and girls maybe? :3
I have moved all my stuff I have worked on into my VPS, but when I inserted my database I got this error, and also the catalogue cache in Phoenix emu, I don't have the error on my computer, only the VPS?
Here you go:

Also in code:
[Err] 1265 - Data truncated for column 'is_arrow' at row 1
[Err] INSERT INTO `furniture` VALUES ('90050', 'anna_table*4', 'anna_table*4', 's', '2', '2', '1', '1', '0', '0', '3953', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('90049', 'anna_table*3', 'anna_table*3', 's', '2', '2', '1', '1', '0', '0', '3952', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('90048', 'anna_table*2', 'anna_table*2', 's', '2', '2', '1', '1', '0', '0', '3951', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('90047', 'anna_table*1', 'anna_table*1', 's', '2', '2', '1', '1', '0', '0', '3950', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('90044', 'anna_stool*3', 'anna_stool*3', 's', '1', '1', '1.2', '1', '1', '0', '3947', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('90045', 'anna_stool*4',

Theres more, but it's too much to paste ^^

Anyone?

Greetz,
Prizm

[MentaL]

[TheRook]

I had the same problem when I used Navicat. Try using PMA, that solved the problem for me.

[PRIZM]

I had the same problem when I used Navicat. Try using PMA, that solved the problem for me.

Thanks for the reply, I just installed PHPMyAdmin on the server. /;


anyone help??

[Gilibert]

Make a new install

[PRIZM]

Make a new install

You serious? I have edited my catalogue in some weeks now -.-''

[Habland]

No lol, I had this problem many times before.
Use Navicat, that isn't the problem.

Uninstall your MySQL Server and install XAMPP 1.8.1, I don't know what the newest one is.
Use the MySQL of the XAMPP and use Navicat + IIS and it'll work perfect.

[Habland]

Did it help for you?

[NathStanley]

I think I saw D0WNF4LL say before you have to truncate the table first? Always try it on a localhost hotel first, just a recommendation.