SMF Support > Install and Upgrade Help

Independant DB upgrade?

<< < (2/8) > >>

nosferatu:
Hi all. I've got a Mysql db for yabbse 1.5.4 and have successfully installed smf on a different server. You say above that I just need to transfer the yabb db onto the smf db and run upgrade.php.
However, when I do that I always get the following:

--- Code: ---Updating Settings.php with changes... 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 log_mark_read AS lmr
LEFT JOIN 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.ID_MEMBER' in 'field list'

--- End code ---

I've tried uninstalling and am just about to go outside and scream into a bucket so any advice would be much appreciated (both by me and the neighbours).
Many thanks

Oldiesmann:
Make sure you copied the log_mark_read table properly. The ID_MEMBER column is there so it can keep track of who marked which topc(s) read when.

nosferatu:
Thanks for the swift reply but unfortunately I still can't get it. I've re-dumped the db from the old site and uploaded it to the smf site. I then ran the upgrade.php and had exactly the same message. The smf site will run perfectly well with its original db in place but not with the 1.5.4 db.
If I try to open the forum page after receiving the above message the user will see this message instead of the forum page:
Notice: Undefined index: time_format in /home/motorcycleuk/public_html/forum/Sources/Load.php on line 195
Warning: Undefined index: ip in /home/motorcycleuk/public_html/forum/Sources/Errors.php on line 110
8: Undefined index: time_format
/home/motorcycleuk/public_html/forum/Sources/Load.php
195
Is it easier to install yabbse on the new server and then upgrade from there?
many thanks for your help

Oldiesmann:
You should be able to update from your YaBB database without having to completely reinstall stuff. I've done this at least twice and had no problems. The only thing I can think of is that you're running an old version of MySQL that doesn't like the LEFT JOIN statement. Look at the log_mark_read table in your database and see if there's an ID_MEMBER column there.

Ben_S:
Let's see, you are uploading SMF and then trying to run a YSE 1.5.4 database on it, that will not work, run upgrade.php to convert the YSE database to SMF format.

Navigation

[0] Message Index

[#] Next page

[*] Previous page