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?do=editpictures&albumid=31&pictureid=261&frompicture=1
Referrer : http://redneckarcher.com/album.php?albumid=31&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 (http://dev.mysql.com/doc/refman/5.1/en/myisam-repair.html) would help?

[jkcerda]

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:confused:

--------------- Added 1258167085 at 1258167085 ---------------

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 (http://dev.mysql.com/doc/refman/5.1/en/myisam-repair.html) would help?

looking into it, thanks:up:

the database was moved by the new host.

[HMBeaty]

done it a few times already:confused:

--------------- Added 1258167085 at 1258167085 ---------------



looking into it, thanks:up:

the database was moved by the new host.

Try the solution that worked in this thread (http://www.vbulletin.com/forum/archive/index.php/t-145555.html)

[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]

Try the solution that worked in this thread (http://www.vbulletin.com/forum/archive/index.php/t-145555.html)

looking into it. thanks:up:

[porcupine73]

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]

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 (http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html). 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.

[jkcerda]

You might need to try mysql_upgrade (http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html). 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.

the Mysql versions ARE different from one server to the new one, Ill point that out to them, thanks
thye installed everything from a back up I had

--------------- Added 1258222702 at 1258222702 ---------------

one fo my tables was corrupt,, they got that fixed,,now it just takes forever to post a VM