|
|
Joined: May 2003
Posts: 48
User
|
User
Joined: May 2003
Posts: 48 |
Hi guys
My site crashed today and since it was rebooted this appears at the top when I open a thread/topic:
SQL ERROR: Unable to do_query: SELECT R_Rating FROM w3t_Ratings WHERE R_What = '207547' AND R_Rater = '2365' AND R_Type = 't' Can't open file: 'w3t_Ratings.MYD'. (errno: 145) Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalkinsider.com/httpdocs/forums/mysql.inc.php on line 133
Warning: Cannot add header information - headers already sent by (output started at /usr/local/psa/home/vhosts/koptalkinsider.com/httpdocs/forums/mysql.inc.php:219) in /usr/local/psa/home/vhosts/koptalkinsider.com/httpdocs/forums/ubbt.inc.php on line 269
---
Any ideas how I could fix this please?
Thanks, as ever!
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
This is the corrupt table:
Can't open file: 'w3t_Ratings.MYD'. (errno: 145)
do this SQL Command:
REPAIR TABLE w3t_Ratings
|
|
|
|
Joined: May 2003
Posts: 48
User
|
User
Joined: May 2003
Posts: 48 |
Thankyou so much Josh, that worked.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 69
Joined: January 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|