Uutiset:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu
Advertisement:

Udpdate to RC3 - table error

Aloittaja Cache-man, elokuu 23, 2006, 07:06:08 AP

« edellinen - seuraava »

Cache-man

I have tried to update my forum at forums.cache-community.co.uk today.
I uploaded all the files from the RC3 update, and ran the upgrade.php. Everything seemed to update apart from the following error which prevents the update from completing:
Updating Settings.php... Successful.
Creating new tables and inserting default data... Successful.
Converting activity logs... Unsuccessful!
This query:

    SELECT lmr.ID_BOARD, lmr.ID_MEMBER, lmr.logTime
    FROM smf_log_mark_read AS lmr
    LEFT JOIN smf_log_boards AS lb ON (lb.ID_BOARD = lmr.ID_BOARD AND lb.ID_MEMBER = lmr.ID_MEMBER)
    WHERE lb.logTime < lmr.logTime;

Caused the error:

    Unknown column 'lmr.logTime' in 'field list'



It seems there is a table, or a column missing, although thats just a guess as I'm no SQL expert.
Is anyone able to help me fix this, as I really don't know where to start. Please.

xenovanis

You need the updatepackage, not the upgradepackage.
"Insanity: doing the same thing over and over again and expecting different results."

Cache-man

Sorry, I shuould have given a little more information.
My forum was 1.1RC2, and wanted to run the update to 1.1RC3.
I did first use the 1.1RC3 UPDATE package (latest one from the SMF downloads page), although this created the previously detailed error.
I then also tried the upgrade package, just in case I was missing any files maybe from older versions, and still got the same error.

May the solution be as simple as adding a column into the tables somewhere in phpMyAdmin, or are there any other fixes I could try.

I think the last alternative may be to do a fresh install of RC3, and add my template to it, and import the database, although surely this would create the same error with using the same database?!?!

Advertisement: