UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Please help with this error message

Still trying to recover from a server failure. The hosting company I use does not allow for me to directly see error messages so what do I need to do or tell them/ask them for?

Error Message:
-------------------------------------------------

SQL ERROR: Database error only visible to forum administrators

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site204/web/boards/ubbthreads/mysql.inc.php on line 121
SQL ERROR: Database error only visible to forum administrators

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site204/web/boards/ubbthreads/mysql.inc.php on line 121

--------------------------------------------------
TIA for your help!

I'll assume you're using UBB.threads 6.1.1.

Edit mysql.inc.php, and near the end of the file, temporarily change:
<pre>if ( ($user['U_Status'] != "Administrator")
&& ( (!stristr($What,"createtable")) && ...
$error = "Database error only visible to forum administrators";
}
else {
$this->errordesc = mysql_error();
}</pre>
To:
<pre>$this->errordesc = mysql_error();</pre>

That will allow you to see the actual MySQL error. By the way, the subsequent two warnings are not of interest. They're just secondary errors caused by the initial error.

Thanks for the really quick response Dave! Here's the new error message:

--------------------------------------------------
Can't open file: 'w3t_Users.MYD'. (errno: 145)
Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site204/web/boards/ubbthreads/mysql.inc.php on line 121
---------------------------------------------------
Is this something I can fix myself or do I need to ask my hosting company to do something? TIA (again!)

Can't open file: 'w3t_Users.MYD'. (errno: 145)

I think that means you need to repair that table. Try searching these forums for that message, or various parts of it. It's come up before.

That's absolutley what it means - Dave is right on.

Ask your host to repair that table if at all possible - if they can't then perhaps they can roll a backup of your database back up - you may lose posts/members added since the last backup but if they can't recover the table that may be your only other option.

Regards,

Brett Harris
Infopop Corporation