Upgrading from YABBSE 3 to SM

[buzzbe]

while  upgrading, the following message appeared, any ideas?

B

-- -- -- -- -- -- -- -- -- -- -- -- -- -- --


Backing up old table data... Successful.

Updating Settings.php with changes... Successful.

Creating new tables and inserting default data... Successful.

Converting activity logs... Unsuccessful!
This query:

    SELECT hxxp:lmr.id [nonactive]_BOARD, hxxp:lmr.id [nonactive]_MEMBER, lmr.logTime
    FROM yabbse_log_mark_read AS lmr
    LEFT JOIN yabbse_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.ID_MEMBER' in 'field list'

[Owdy]

What is YabbSE 3?

[[Unknown]]

I hope you created a backup.  This may be recoverable even if not, but the upgrader is meant for YaBB SE 1.5.1 or higher.  You need to upgrade if you're using an older version.

-[Unknown]

[buzzbe]

I meant Yabbse 1.3.

Can I not modify the structure of the database to add the field an move on in the upgrade?
Or should I do a complete install as if new?

[Daniel D.]

You've to upgrade to 1.5.1 and then convert it to SMF.

[buzzbe]

I tried upgrading to that version and there were problems there.

It is gettting old and there seems to be a problem every time.

It looks like scrapping the old completely and installing the most current version may be the least time consuming and less hair pulling event.

[[Unknown]]

I tried upgrading to that version and there were problems there.

It is gettting old and there seems to be a problem every time.

It looks like scrapping the old completely and installing the most current version may be the least time consuming and less hair pulling event.

Well, what have you tried to upgrade and what problems have you had?  Some of us used to write or support YaBB SE and its upgraders, so we can help.

-[Unknown]