UBB.Developers Forums UBB.threads 7 Development How Do I? SQL Errors in Boards

Our boards at http://www.passporterboards.com starting generating SQL errors around 4;16 this afternoon. I contacted our web host to restart mySQL. They restarted it, but it made no difference.

I had a similar problem back in November, and it turned out that some tables became damaged (error 144). I'm getting error 145 now, however, and I'm not sure if that's the same thing. Here is a sample of the errors I see:

SQL ERROR: 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_AnonNameFROM 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 = 1 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-%') ORDER BY t1.Bo_Sorter
Can't open file: 'w3t_posts.MYD'. (errno: 145)

I haven't touched the installation or even logged into the FTP server in days. The only changes have been normal user stuff -- registering, posting, etc.

Looking at the mySQL files via FTP, it looks like w3t_posts could be the only affected file/table, as the others all have recent modification times.

Thanks in advance!

Your posts table has become corrupted.

If you can get into your admin panel type this in the SQL command area -

Repair table w3t_posts

Otherwise you'll need to run that command via phpmyadmin or command line.

Thank you! The board is working fine again.

One question -- the tech support guy at my web host thought that the size of the w3t_posts table (250 MB) might have something to do with why it became corrupted. Any thoughts on that?

If MySQL is tuned properly and you have the disc space and enouhg memnory 250 megs is nothing. If you're out of disc space att imes (like during log rotate), short on memory, or running an operating system with suspect file locking 250 megs is a lot. Only your tech support guy can answer that, as he knows his own system the best.

I'd bet you could prune 100 thousand messages out of the sunroom (leaving 75 thousand) and nobody would notice. That would help. You'll want to close the board when you do it. Then optimize your tables. Definately have the board closed when you do the optimize.