Issues after transfer

[jkcerda]

changed servers from Yahoo to hostgator

got tons of issues

cant upload pictures to albums, after setting the correct path for Imagemagik
database errors when trying to edit pics already in albums

VMS give an error when first posted, but they appear after refreshing the age

heres one error

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT value
FROM usercss
WHERE userid = 1
AND property = 'background_image'
AND value LIKE '31,%';

MySQL Error : Incorrect key file for table 'usercss'; try to repair it
Error Number : 1034
Request Date : Friday, November 13th 2009 @ 08:23:08 PM
Error Date : Friday, November 13th 2009 @ 08:23:08 PM
Script : http://redneckarcher.com/album.php?d...&frompicture=1
Referrer : http://redneckarcher.com/album.php?a...&pictureid=261
IP Address : xxx
Username : Uxxxx
Classname : vB_Database
MySQL Version : 5.1.30

[HMBeaty]

AdminCP > Maintenance > Repair / Optimize Tables > Set both options (Optimize Tables, and Repair Tables) to yes and click continue

Edit: Sorry, click "Check all" to check all tables to repair and optimize

[porcupine73]

How did you move over the database? Did you just copy the bin's or did you export it and then reimport it? Maybe some sort of table repair would help?

[jkcerda]

Originally Posted by HMBeaty

AdminCP > Maintenance > Repair / Optimize Tables > Set both options (Optimize Tables, and Repair Tables) to yes and click continue

Edit: Sorry, click "Check all" to check all tables to repair and optimize

done it a few times already

--------------- Added [DATE]1258167085[/DATE] at [TIME]1258167085[/TIME] ---------------

Originally Posted by porcupine73

How did you move over the database? Did you just copy the bin's or did you export it and then reimport it? Maybe some sort of table repair would help?

looking into it, thanks:up:

the database was moved by the new host.

[HMBeaty]

Originally Posted by jkcerda

done it a few times already

--------------- Added [DATE]1258167085[/DATE] at [TIME]1258167085[/TIME] ---------------



looking into it, thanks:up:

the database was moved by the new host.

Try the solution that worked in this thread

[jkcerda]

I get this when I try to upload a pic to an album

Imageinfo Failed:
sh: /usr/local/bin/identify: No such file or directory

[jkcerda]

Originally Posted by HMBeaty

Try the solution that worked in this thread

looking into it. thanks:up:

[porcupine73]

Originally Posted by jkcerda

I get this when I try to upload a pic to an album

Imageinfo Failed:
sh: /usr/local/bin/identify: No such file or directory

Hm are you sure imagemagick is installed on the new server?

[jkcerda]

Originally Posted by porcupine73

Hm are you sure imagemagick is installed on the new server?

should be, I have hostgator as my new server host

changed to GD and got DB errors as well

I contacted them and they said yes, it was installed

[porcupine73]

You might need to try mysql_upgrade. Just not knowing how they got the database over, they might have just copied all your files from one server to the other, without checking the mysql versions.