UBB.Developers Forums UBB.threads 7 Development How Do I? SQL Error/Help!!!!

guys.

can someone check on my site and tell me how i can fix it?!?!??. It crashed alll of a sudden?????

my site is

www.omanforum.com

looks like some of your pal boxes are throwing errors so either you have a bad table somewhere or something else is afoot.. all we can see if not an admin is the following.. "SQL ERROR: Sun, Jul 18 2004 13:46:01 -0400 Database error only visible to forum administrators" so we can't really see much. I would advise ya to go to the mysql error logs and see exactly what it says.

Below is the error?


SQL ERROR: Sun, Jul 18 2004 13:51:51 -0400 Unable to do_query: SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username FROM w3t_Moderators AS t1, w3t_Users AS t2 WHERE t1.Mod_Uid = t2.U_Number
Got error 127 from table handlerSQL ERROR: Sun, Jul 18 2004 13:51:51 -0400 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 handlerSQL ERROR: Sun, Jul 18 2004 13:51:51 -0400 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 2 AND (t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') AND (t1.Bo_LastNumber = t3.B_Number OR t1.Bo_LastNumber ='0') AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%' OR t1.Bo_Read_Perm LIKE '%-2-%') ORDER BY t1.Bo_Sorter
Got error 127 from table handlerSQL ERROR: Sun, Jul 18 2004 13:51:51 -0400 Unable to do_query: SELECT COUNT(*) FROM w3t_Users WHERE U_BirthMonth = 'Jul'
Got error 127 from table handlerSQL ERROR: Sun, Jul 18 2004 13:51:51 -0400 Unable to do_query: SELECT COUNT(*) FROM w3t_Users WHERE U_BirthMonth = 'Jul' AND U_BirthDay = '18'
Got error 127 from table handler Today's Active Topics
New Since Your Last Visit

Hmmm go to your phpMyAdmin or threads admin sql section and run this query

SELECT U_Username,U_Number FROM w3t_Users WHERE U_Approved='yes' ORDER BY U_Number DESC LIMIT 0,1

this should NOT fail unless your w3t_Users table is messed up at which case you MAY have to repair it but run that query first.

This what I got , anything else?

SQL ERROR: Sun, Jul 18 2004 14:03:48 -0400 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

well then there are only two possible solutions er reasons.. 1) your out of memory and have a HUGE w3t_Users table or the table is bad and needs to be repaired. I would 1) backup your database and then 2) try the following command

repair TABLE w3t_Users;

thats SHOULD fix the problem unless there is more afoot and you will have a backup if there is.

how should i do the backup, do you mean through the threads admin, where it says DB backup?.

If that what you mean, isnt there a problem i may end up backing up the corrupted table instead?

Yappeeeeeeee thanks its fixed now.

But why did this happened to begin with?

And also althought the forum is functioning, I noticed when I post a topic, on the very top it gives me this ERROR: Any ideas?


SQL ERROR: Sun, Jul 18 2004 14:32:30 -0400 Unable to do_query: SELECT t2.U_Language,t2.U_Email,t2.U_EmailFormat FROM w3t_Favorites AS t1, w3t_Users AS t2 WHERE t1.F_Thread = '134515' AND t1.F_Type = 'f' AND t1.F_Owner = t2.U_Number AND t2.U_EReplies = 'On'
Got error 127 from table handler

Login to your SQL admin panel to see if any other tables are corrupt, and if so, repair them using the same method (just replace w3t_Users with whatever it's called).

yeah looks like w3t_favorites may be messed up also so I would try and

repair TABLE w3t_Favorites;

scroungr,

i tried that command but i received error still, any otehr advice?

okay now I find another ERROR

SQL ERROR: Mon, Jul 19 2004 07:33:22 -0400 Unable to do_query: SELECT L_Board,L_Last FROM w3t_Last WHERE L_Uid = '2'
Can't open file: 'w3t_Last.MYD'. (errno: 145) Today's Active Topics
New Since Your Last Visit

ok I think i fixed it all it was that ";" which caused the errors,

now Can someone TELL ME PLEASE WHAT DID THE ERROR OCCURS and how I can avoid them in future, appreciate it thanks

Did you recently optimize the tables before this happened?

That can sometimes cause it from my experience.

I do however find it troubling that you had 2 tables corrupt at the same time like that.