UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Getting A SQL Error

I am getting the following error in my error log, can anyone help me fix?

Warning: OpenDir: No such file or directory (errno 2) in /home/crider/coloradorider.com/html/ubbthreads/admin/sqlerrors.php on line 57

Warning: Supplied argument is not a valid Directory resource in /home/crider/coloradorider.com/html/ubbthreads/admin/sqlerrors.php on line 59

Tough to know what's on those lines without knowing what version you are running - looks like it might have to do with the mysql error log not being writable or the directory/path not being right for it. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

It is version 6.3

I am now getting a LONG message...looks like the code from a file:

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_AnonName FROM w3t_MYISAMBoards AS t1 LEFT JOIN w3t_MYISAMUsers AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_MYISAMPosts 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_MYISAMPosts.MYD'. (errno: 145)
Warning: Supplied argument is not a valid MySQL result resource in /home/crider/coloradorider.com/html/ubbthreads/mysql.inc.php on line 131

I really have NO CLUE what happened to the board and NO CLUE how to fix it....Is there anyone that can help? Am willing to pay for HELP!!!!!!

Your posts table is corrupted.
Run this command from the sql command window:

Repair table w3t_Posts;

I ran it and there was no change

The original error is that it can't find and/or write to the SQL Error logs - check the path and make sure that the directory and files are writable.

The second error is a corrupt database table.
The command Astaran posted should have fixed it. If not, then you might need a more advanced database repair. Most likely this is something your host would have to do for you, unless it's your own server.

Have the names of your tables been changed?
[]
Can't open file: 'w3t_MYISAMPosts.MYD'. (errno: 145)[/]

You might try

REPAIR TABLE w3t_MYISAMPosts

OK- actually he contacted me to look at this for him.

That worked - I think he just had a custom table prefix which needed to be applied to the repair. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />