I have recently updated my forum from phpBB 3.0.1 to 3.0.4 using the files provided by phpBB, however I am now having a world of problems! Initially i kept receiving issues to do with access to the /cache/data_global.php file, but I have managed to resolve that one. Now I am getting many others which I am really struggling to overcome.
The search function brings up the following error:
Also when user posts a new topic or reply some people get errors.General Error
SQL ERROR [ mysql4 ]
Table 'm0' is marked as crashed and should be repaired [1194]
SQL
SELECT SQL_CALC_FOUND_ROWS p.post_id FROM (phpbb_search_wordmatch m0) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 1902 GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC LIMIT 250
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: includes/search/fulltext_native.php
LINE: 712
CALL: dbal->sql_query_limit()
FILE: search.php
LINE: 418
CALL: fulltext_native->keyword_search()
I thought that I had updated the forum correctly however I am beginning to feel as though many things are conflicting.
Additionally I attempted to create a new forum and simply use a backup from my current forum to eliminate the issues. However, when I restore the backup the new forum tells me the restore was successful and when I look to see if it was.....nothing has changed.
If someone could help me it would amazing!! Thank you in advance.
My forum URL is : http://aftunes.net/v2/index.php
My email address is : [removed]