Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: Xabre on April 01, 2007, 07:12:50 AM

Title: Convert to SMF, YaBB dbase error.
Post by: Xabre on April 01, 2007, 07:12:50 AM
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:

QuoteConverting 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' :

QuoteUnknown 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:

QuoteUnknown 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.
Title: Re: Convert to SMF, YaBB dbase error.
Post by: Xabre on April 02, 2007, 06:18:32 AM
Anyone? :'(
Title: Re: Convert to SMF, YaBB dbase error.
Post by: JayBachatero on April 16, 2007, 04:09:42 PM
Try using the converter in this topic: YaBB SE 1.5.4 (http://www.simplemachines.org/community/index.php?topic=140776)