UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Users getting error when trying to LogIn PLEASE HELP!

When trying to log into:
http://www.ijo.com/ubbthreads/ubbthreads.php

Everyone gets the message:
SQL ERROR: Database error only visible to forum administrators

Warning: Supplied argument is not a valid MySQL result resource in /www/docs/ijo/ubbthreads/mysql.inc.php on line 130

Everything was fine a few hours ago and now this is happening. We didn't change a thing!

No one can log in. Any ideas on what to do?

We'd need to know the actual error that you are getting. If you have never setup mysql logs for .threads then you'll need to edit the mysql.inc.php file. Line 185 of that file has a variable called $showerror, that is set to 0 by default. Change that to a 1 and it will display the actual mysql error.

We are getting errors on lots of pages.

We get this error on the /ubbthreads/categories.php?Cat=
page:

SQL ERROR: 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 127 from table handler
Warning: Supplied argument is not a valid MySQL result resource in /www/docs/ijo/ubbthreads/mysql.inc.php on line 130

And a similar error on the /ubbthreads/showmembers.php?Cat=&page=1 page:

SQL ERROR: Unable to do_query: SELECT U_Username,U_Registered,U_Extra1,U_Homepage,U_TotalPosts,U_Status,U_Number FROM w3t_Users WHERE U_Approved = 'yes' AND U_Number <> 1 ORDER BY U_Username ASC LIMIT 25
Got error 127 from table handler
Warning: Supplied argument is not a valid MySQL result resource in /www/docs/ijo/ubbthreads/mysql.inc.php on line 157

[]
Got error 127 from table handler[/]

This means the table is corrupt.

This SQL command should fix it:

REPAIR TABLE w3t_Users

Okay I think I got it. After several hours of reading the MySQL book and the MySQL web site I found that the w3t_Users table was crashed. There were several other tables that had also not been closed properly. I used the myisamchk command to fix all the databases and now everything is up and running.

However, any ideas that would have caused this are appreciated.

MySQL Data corruption can happen for a variety of reasons, if the server crashes or has an overloaded MySQL server, it can happen alot. If it's occational, don't worry about it. But if it happens consistantly, then it's usually a sign of a bigger problem. Nothing really threads related, but something to talk about with your host.

You'll also find this thread useful:
https://www.ubbcentral.com/boards/showflat.php?Cat=&Number=35663

OK, there's wieeeerd stuff going on here.

This is my *first* post here, by the way - when I registered for this board, I was told I was logged in as "MariaB"...!

Now I seem to have inherited her posts and changed her name into the bargain. My guess is she isn't best pleased. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Yes, there is a slight problem with the groupee integration work that I did 2 days ago. Thanks for pointing this out. I'm working on the fix right now.