|
|
Joined: May 2003
Posts: 48
User
|
User
Joined: May 2003
Posts: 48 |
Hi huys
Woke up this morning and found this error. Nobody can get in but I can access the admin area:
SQL ERROR: Unable to do_query: SELECT O_Board,COUNT(*),O_Type FROM w3t_Online WHERE O_Last > '1080748652' GROUP BY O_Board,O_Type Got error 127 from table handler 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 SQL ERROR: Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description FROM w3t_Category WHERE Cat_Type = 'forum' ORDER BY Cat_Number Lost connection to MySQL server during query 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
Any ideas?
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
"Lost connection to MySQL server during query"
Can you get to your database?
|
|
|
|
Joined: May 2003
Posts: 48
User
|
User
Joined: May 2003
Posts: 48 |
I can get in to my admin section where the SQL command prompt is if that's what you mean
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
yes but it sounds like your losing connetions to your mysql server. is it on the same server as your forums?
|
|
|
|
Joined: May 2003
Posts: 1,068
Junior Member
|
Junior Member
Joined: May 2003
Posts: 1,068 |
Is this the sit you are talking about? http://www.koptalk.org/forums/ubbthreads.phpRight now it looks fine and I can access it. From the looks of it you lost your connection to the DB as Medar pointed out. If it happens again try restarting your MySql service, or ask your server host to do it for you.
|
|
|
|
Joined: May 2003
Posts: 48
User
|
User
Joined: May 2003
Posts: 48 |
No the link is: http://www.koptalkinsider.com/forums/ubbthreads.php?Cat=Some people can get in now it would seem but there are errors all over such as: SQL ERROR: Unable to do_query: SELECT O_Type,O_Board,COUNT(*) FROM w3t_Online WHERE O_Board = 'insiderfootballchat' GROUP BY O_Type Got error 127 from table handler 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 S.O.S. Josh
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
Looks like table corruption in your w3t_Online table. Since this table just holds temporary data you should be able to correct this just by deleting everything from that table with the sql command below. NOTE: Do not do this on any other table DELETE FROM w3t_Online Normal tables when you see table corruption you would use: REPAIR TABLE tablename
UBB.threads Developer
|
|
|
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: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|