Update issues

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Locked
mankieapple
Registered User
Posts: 5
Joined: Sun Feb 01, 2009 11:20 pm

Update issues

Post by mankieapple » Sun Feb 01, 2009 11:35 pm

Hi guys,

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:
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()
Also when user posts a new topic or reply some people get errors.

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]
Last edited by ToonArmy on Sun Feb 01, 2009 11:39 pm, edited 1 time in total.
Reason: Removed email address

johnsemple
Registered User
Posts: 23
Joined: Sun Feb 01, 2009 10:42 pm

Re: Update issues

Post by johnsemple » Sun Feb 01, 2009 11:59 pm

I think I am correct in saying that you can not update directly from 3.0.1 to 3.0.4 (admin please correct me if I'm wrong) you have to go to 3.0.2 first then to 3.0.4

Phil
Registered User
Posts: 185
Joined: Sun Mar 11, 2007 3:20 am
Contact:

Re: Update issues

Post by Phil » Mon Feb 02, 2009 12:01 am

Run this query:

Code: Select all

REPAIR TABLE phpbb_search_wordmatch;
My phpbb.com account
Note that any of my opinions expressed in RFC topics are my own and not necessarily representative of the opinion of the phpBB Team.

mankieapple
Registered User
Posts: 5
Joined: Sun Feb 01, 2009 11:20 pm

Re: Update issues

Post by mankieapple » Mon Feb 02, 2009 12:05 am

iWisdom wrote:Run this query:

Code: Select all

REPAIR TABLE phpbb_search_wordmatch;
Thanks for the quick response, but I have already run this query in phpmyadmin - still no results whatsoever.

Is there any reason why I shouldn't be able to just restore the backup I have made onto a new forum? When ever I try this I just cant seem to get it to work?

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 135
Joined: Sun Dec 18, 2005 5:44 pm
Location: Texas
Contact:

Re: Update issues

Post by Noxwizard » Mon Feb 02, 2009 1:03 am

When you run that query, does it say, "table is already up to date"?

Locked