UseBB Community

My company has been using this community forum for close to a year, so far without any problems however yesterday afternoon one of our users reported a problem with the forum. upon checking the forum I was met with the following message.


"UseBB General Error

An error was encountered. We apologize for any inconvenience.

In file sources/db_mysql.php on line 117:

SQL_ERROR - Can't open file: 'usebb_sessions.MYI' (errno: 145)Can't open file: 'usebb_sessions.MYI' (errno: 145)

SELECT s.user_id, s.started, s.location AS slocation, s.pages, s.ip_addr, u.* FROM usebb_sessions s LEFT JOIN usebb_members u ON u.id = s.user_id WHERE sess_id = '9d7605dda5efe81a3452613d800687a7'

Enable debug mode level 2 to see the error and erroneous SQL query.

This error should probably not have occured, so please report it to the webmaster. Thank you for your help.

If you are the webmaster of this board and you believe this is a bug, please send a bug report."


In the 24 hours prior to this error the forum was working fine in fact I had posted a new bulletin on our forum about 2 hours prior to this error.

With the exception of posting the bulletin nothing else has been altered or modified in any way. If anyone knows a simple way to correct this problem your help would be appreciated.

Thank you

This is an issue with the database. If you have access to phpMyAdmin or something similar you should repair the tables over there. phpMyAdmin can do this per table when viewing database details.

You can also manually execute

REPAIR TABLE usebb_sessions;

using mysql on the command line. See http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

Ok that resolved that issue the forum was working fine all week and now its giving me a new error, this time it says:

An error was encountered. We apologize for any inconvenience.

In file sources/db_mysql.php on line 87:

E_WARNING - mysql_connect(): Access denied for user -filtered- (using password: YES)

It seems UseBB is not installed yet. If you are the webmaster of this board, please see docs/index.html for installation instructions.

If UseBB is installed, please check your database connection.


and when i try to log into phpmyadmin i get the following message

#1045 - Access denied for user 'snaggstuff'@'localhost' (using password: YES)


I really hope this doesn't become a weekly thing for me ... thanks again for your help

You should contact your host about that... it's a permissions issue.

ok it appears that one of our new programers was trying to edit something on the site and somehow affected the forum which is what gave me the error but now hes made it even worse. I have no idea what he has done but now when i go to our forum link it takes me to the phpmyadmin login page where it still wont let me log in. I have full access to website is there an easy way i can repair this without losing everything on the forums? maybe a simple file manipulation?

update i have regained access to phpmyadmin and made a backup of my database now the problem i am encountering is the link that once went to my forum has not been altered but it now takes me to the phpmyadmin login page as opposed to the forum or any error pages i trust this is not safe. quick way to fix this?

update again i got it working again turns out he deleted the index page everything is back in working order thanks again for your help