PDA

View Full Version : I just got this error please help


threat
Tue 24th Jun '08, 12:33am
My site was working fine when I left Friday from vacation, I come back today and i see this

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 1;

MySQL Error : Table './/customavatar' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, June 23rd 2008 @ 11:27:38 PM
Error Date : Monday, June 23rd 2008 @ 11:27:38 PM
Script : http://www.gixxerplanet.com/index.php
Referrer : http://www.gixxerplanet.com/home/
IP Address : 75.70.248.53
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community

Steve Machol
Tue 24th Jun '08, 1:30am
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

Also please see these instructions for other available methods to repair a database:

http://dev.mysql.com/doc/refman/5.0/en/repair.html

threat
Tue 24th Jun '08, 2:29am
THANKS that worked but for some reason all my thumbnails for pics are not showing and I get error message, i ran the thumbnail cycle from the admin panel but it did not work at all. I get this message when I click the link that is in place of the thumbnail now

Warning: fopen(/home5/gixxerpl/public_html/images/attachments/2/5/0/2/2175.attach) [function.fopen]: failed to open stream: No such file or directory in [path]/attachment.php on line 261I noticed that home5 is not even my forum name it is home. I dont understand how these errors came to be when it was working fine. I attached a pic showing the error when I try to upload a pic now and how all the thumbnails look.

Zachery
Tue 24th Jun '08, 4:03am
Have you moved servers or sites recently?