News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

upgrade to 2.0.14 hung script problem

Started by jjr8, June 25, 2017, 11:12:20 AM

Previous topic - Next topic

jjr8

ftp upgrade

from

1.1.24

to

2.0.14

Here is where it stops:

Converting "log_boards"... Unsuccessful!
This query:
SELECT hxxp:lmr.id [nonactive]_BOARD, hxxp:lmr.id [nonactive]_MEMBER, lmr.logTime
FROM smf_log_mark_read AS lmr
LEFT JOIN smf_log_boards AS lb ON (lb.ID_BOARD = hxxp:lmr.id [nonactive]_BOARD AND hxxp:lb.id [nonactive]_MEMBER = hxxp:lmr.id [nonactive]_MEMBER)
WHERE lb.logTime < lmr.logTime;
Caused the error:
Unknown column 'lmr.logTime' in 'field list'

help...

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

jjr8


Ok, the very last in the 1.1.x  series, can't see the page right now as I am stuck in between...

vbgamer45

Do sql command
show create table smf_log_mark_read;
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

jjr8


jjr8


Nope, that didn't fix it, but the error description changed...

onverting "log_boards"... Unsuccessful!
This query:
SELECT hxxp:lmr.id [nonactive]_BOARD, hxxp:lmr.id [nonactive]_MEMBER, lmr.logTime
FROM smf_log_mark_read AS lmr
LEFT JOIN smf_log_boards AS lb ON (lb.ID_BOARD = hxxp:lmr.id [nonactive]_BOARD AND hxxp:lb.id [nonactive]_MEMBER = hxxp:lmr.id [nonactive]_MEMBER)
WHERE lb.logTime < lmr.logTime;
Caused the error:
Unknown column 'lmr.logTime' in 'field list'

Been awhile since I was into some of this, would love some help...

Advertisement: