Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: JohnSpera - huhtikuu 20, 2011, 02:54:39 AP

Otsikko: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: JohnSpera - huhtikuu 20, 2011, 02:54:39 AP
Hi,

The error that has me stuck is:

Lainaa
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'


Any suggestions on how to proceed.

Thanks,
John
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: kat - huhtikuu 20, 2011, 05:45:31 AP
This help?

http://www.simplemachines.org/community/index.php?topic=391638.msg2709301#msg2709301
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: JohnSpera - huhtikuu 20, 2011, 11:44:03 AP
Well I did read that over very carefully.

I am not comfortable modifying the SMF table structures. I did try the option to drop unimportant log files and that did not help.

At this point I think it best to reconsider my choice to upgrade to 1.1.13.

Thanks,
John
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: Illori - huhtikuu 20, 2011, 11:45:52 AP
there are security issues that have been resolved since 1.1.9 was released, i would recommend you try to find someone that is comfortable in the upgrade and have them do it for you. maybe posting in the help wanted board would work better for you.
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: SlammedDime - huhtikuu 20, 2011, 12:15:48 IP
Did you use the Large Upgrade package?  Try using the Small Update package instead.
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: JohnSpera - huhtikuu 20, 2011, 01:08:56 IP
Lainaus käyttäjältä: SlammedDime - huhtikuu 20, 2011, 12:15:48 IP
Did you use the Large Upgrade package?  Try using the Small Update package instead.

Yes I did use the Large Upgrade Package. I will that Small package option.

Thanks,
John
Otsikko: Re: 1.1.9 to 1.1.13 Upgrade
Kirjoitti: Aleksi "Lex" Kilpinen - toukokuu 03, 2011, 01:57:37 AP
High JohnSpera, any updates to this?