>> Site Map >> Forums >> General 6x
Forum module - topics in forum:
General 6x - Discussions reagarding any other PHP-Nuke Problems.
Could not query forums information
WHAT?! i dont understand this error.. i looked on line 214 and cnt work out the error with the sql
| Code: : |
| DEBUG MODE SQL Error : 1030 Got error 127 from table handler SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order Line : 214 File : /var/www/html/modules/Forums/index.php |
Looks like the table has got corupte, in phpMyAdmin go into the the table thats causing the problem, click on operations from the menu along the top then try the repair operation, that will hopefully fix it.
what if that didn't work?? i clicked on repair and it didn't work.. can somebody do a step by step (if possible) because i've tried and it aint working for me.
I have looked into theis problem in a little more detail and its not actually your site that is the problem but your database.
The Error Code 127 : Record-file is crashed
Your post table has crashed. Run Repair/Optimize in the phpMyAdmin.
- Open phpMyAdmin
- Select your database from the left hand side drop down menu (only need to do this if you have more than one database)
- A list of tables now show on the right hand side, put a tick box on the nuke_bbposts and the nuke_users table
- Underneath the list of table you will see "With Selected" in a combo box, pick repair from the list and it should repair both tables.
- Now repeat steps 3 and 4 but this time select Optimize from the list
tnx for that m8, worked a treat
