SMF 2.0.19 has been released! Please update. Read more.
Started by JayBachatero, January 08, 2007, 11:25:48 AM
Converting posts (this may take some time)... Successful.Converting polls... Successful.Converting poll options... Successful.Converting poll votes... Successful.Converting personal messages (step 1)... Successful.Converting personal messages (step 2)... Successful.Converting topic notifications... Unsuccessful!This query: SELECT m.ID_MEMBER, lt.ID_TOPIC, lt.notificationSent AS sent FROM (`spocrati_ht4uforum`.yabbse_log_topics AS lt, `spocrati_ht4uforum`.yabbse_members AS m) WHERE notificationSent != 0 AND lt.memberName = m.memberName LIMIT 0, 500;Caused the error: Unknown column 'lt.memberName' in 'where clause'
Converting...Converting topic notifications... Incomplete.Not quite done yet!This conversion has paused to avoid overloading your server, and hence not working properly.Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.
QuoteConversion CompleteCongratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Quote from: Chuck on February 14, 2007, 12:52:59 AMHi, I have been trying to convert my yabbse forum to SMF using the files in this thread. It works fine until after it converts the post and then it gets an Internal Sever Error.Any ideas?Thanks.
Quote from: Chris Cromer on February 15, 2007, 06:44:37 AMI don't know why but after using this converter random members have an ID_GROUP setting of 11... even though that group does not exist. This caused me alot of headaches since the members with that group id could not see anything. It was funny that when they logged in the boards where gone, but when they logged back out they came back. I already fixed it in my conversion since it was just a matter of running an update query, but thought I would report it for you to look into.
CASE WHEN mem.memberGroup = 'Administrator' THEN 1 WHEN mem.memberGroup = 'Global Moderator' THEN 2 WHEN mg.ID_GROUP = 8 THEN 2 WHEN mg.ID_GROUP = 1 THEN 1 WHEN mg.ID_GROUP > 8 THEN mg.ID_GROUP ELSE 0 END AS ID_GROUP
Quote from: Chuck on February 15, 2007, 02:40:19 PMThe last message that I get before the internal sever error is Converting private messages step 2 incomplete..