|
#40628
05/20/2004 2:37 PM
|
Joined: May 2004
Posts: 5
stranger
|
stranger
Joined: May 2004
Posts: 5 |
When trying to log into: http://www.ijo.com/ubbthreads/ubbthreads.phpEveryone 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?
|
|
|
#40629
05/20/2004 7:00 PM
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
#40630
05/20/2004 11:12 PM
|
Joined: May 2004
Posts: 5
stranger
|
stranger
Joined: May 2004
Posts: 5 |
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
|
|
|
#40631
05/21/2004 1:52 AM
|
Joined: Jun 2006
Posts: 742
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 742 |
[] Got error 127 from table handler[/]
This means the table is corrupt.
This SQL command should fix it:
REPAIR TABLE w3t_Users
|
|
|
#40632
05/21/2004 2:11 AM
|
Joined: May 2004
Posts: 5
stranger
|
stranger
Joined: May 2004
Posts: 5 |
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.
|
|
|
#40633
05/21/2004 4:18 AM
|
Joined: Jun 2006
Posts: 742
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 742 |
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
|
|
|
#40634
05/21/2004 5:16 PM
|
Joined: May 2004
Posts: 5
stranger
|
stranger
Joined: May 2004
Posts: 5 |
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="" />
|
|
|
#40635
05/21/2004 10:07 PM
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|