I recently acquired the site Baja.com. We had significant traffic through the forum. When I click on forum now, I receive this error. Any advice would be appreciated.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
145 - Table './db80314_baja/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE ip='204.255.28.111' LIMIT 1
Run this SQL query in phpMyAdmin:
REPAIR TABLE `mybb_sessions`;
Edit : not seen above response
____________________________
log into web server (web host panel) AND run below query thru database manager
repair table `mybb_sessions`;
Thanks faviouz!
Wish I knew where to begin, e.g., find phpMyAdmin. Is this something I can find with my hosting provider?
Yes, it is. You should be able to find it in the databases section of your web host's control panel (e.g. cPanel, DirectAdmin). Contact them for more details.
I guess the starting point is understanding mybb. Is this hosted with my hosting provider or somewhere else? Not sure where to access...
edit : this was again a late response - didn't see the expert ..
____________________________________________________
see :
common SQL queries & how to run
Thank you. I contact MediaTemple to help me navigate...
The link that was provided is broken -- to help navigate SQL queries. Can you check and resend? Thanks!
MyBB attempts to repair tables every hour through a task, which you can also execute within the moment. In case you prefer not to use phpMyAdmin, you can go to Admin CP > Tools & Maintenance > Task Manager. Then click the small alarm icon next to Tables Check. Please note this is not an alternative to running SQL queries, it's just a specific task that allows you to repair crashed tables.
But the link posted by ranjani wasn't broken. I just checked and it's working fine. However, this tutorial is a little more detailed:
http://community.mybb.com/thread-4720.html
Great! It worked. Thanks for the help!!! Easier than expected. Second Q... I would like to continue offering the forum; however, it's plagued with spam. How do I both (i) limit spam, and (ii) implement a moderated forum? I can't have 3000 posts for viagra sales....