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.
You need the updatepackage, not the upgradepackage.
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?!?!