Recently I tried to upgrade form Yabb 1.5.4 to the latest version of SMF. Unfortunately without success.
Installing SMF wasn't any problem, nicely installed with a prefix in the same database, good.
When trying to convert I got this:
Converting members... Unsuccessful!
Now I found out that that this wansn't a faulty convertion or something wrong with SMF but a database error on the YaBB forum which I didn't discover until now. I get this error right under the 'Info center' :
Unknown column 'b.ID_LAST_TOPIC' in 'on clause'
File: /home/sites/webhosting/trforum/trforum/www/forum/Sources/Recent.php
Line: 45
I can see all the different categories and boards but as soon as I try to access a board I get this error:
Unknown column 'm.ID_MEMBER' in 'on clause'
File: /home/sites/webhosting/trforum/trforum/www/forum/Sources/MessageIndex.php
Line: 267
I can click on a topicname directly and read the specific topic (Today at 17:24:03 in Re:topic about blabla...by Natla) and I can also post replys in the topic. But I can't see the board indexes with all the topics listed.
What can I do?
I sure that this database error is responsible for a the conversion troubles.