UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Error Messages

I've never seen these before. In fact, I rarely have problems, but this is at the top of my board, and I don't know what this is:

SQL ERROR: Tue, Sep 16 2003 18:20:26 -0700 Unable to do_query: SELECT U_Username,U_Number FROM w3t_Users WHERE U_Approved='yes' ORDER BY U_Number DESC LIMIT 0,1
Got error 134 from table handler
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/www/virtual1/66/175/27/145/html/forum/mysql.inc.php on line 130

Any ideas?

Thanks. Bushhog

What version are you using? Can you post a link to the board?

--
UBBDesign.com:
Installation, upgrades, and custom layouts/themes for ubb.classic â„¢ & ubbthreads â„¢ Contact me

[b]6.2.1
CLICK HERE

Thanks. Bushhog

Error code 134: Unknown error 134
134 = Record was already deleted (or record file crashed)


Try to do run this command from your sql command box in the admin panel:

repair table w3t_Users;

I got the following reply from the query:

SQL ERROR: Thu, Sep 18 2003 14:44:00 -0700 Unable to do_query: repair table w3t_Users;
You have an error in your SQL syntax near '; ' at line 1 row(s) affected by your query.

Thanks. Bushhog

Well, Cedant, my host provider, has fixed the problem. They realized they caused the problem and repaired it (so far). It happens when the following occurs: (This is from Cedant)

From what I understand, the server this account was hosted on experienced a failure of it's power supply yesterday - which resulted in an immediate uncontrolled system halt - on UNIX systems these types of crashes can result in corruption of files that are open for writing at the time (e.g. your forums database tables). <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" />

Thanks. Bushhog