PHPBB Mysql Error Fix

If you get error notices on mysql using phpbb – view the database structure in PHPMYADMIN and see if all tables are listed. If you only get a partial listing with an error message for a particular table, here’s how to fix it.

In PHPMYADMIN with your specific database called up click “SQL” – this will open up an SQL query window where you can insert a repair command for the particular table malfunction. If the table error is “phpbb_search_wordmatch” then you can enter this in the MYSQL Query window:
REPAIR TABLE phpbb_search_wordmatch

Then click “go” – on larger databases the process may take a while. My experience has been that usually only one table will be corrupted in a database at a time – and usually occurs after a server reboot.

***************

Sample error message for above fix:

Error in deleting post

DEBUG MODE

SQL Error : 1034 Incorrect key file for table: ‘phpbb_search_wordmatch’. Try to repair it

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (172970)

Line : 419
File : functions_search.php