Advertisement:

Author Topic: Convert to SMF, YaBB dbase error.  (Read 5865 times)

Offline Xabre

  • Semi-Newbie
  • *
  • Posts: 25
Convert to SMF, YaBB dbase error.
« 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:

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

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

Quote
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.

Offline Xabre

  • Semi-Newbie
  • *
  • Posts: 25
Re: Convert to SMF, YaBB dbase error.
« Reply #1 on: April 02, 2007, 06:18:32 AM »
Anyone? :'(

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Convert to SMF, YaBB dbase error.
« Reply #2 on: April 16, 2007, 04:09:42 PM »
Try using the converter in this topic: YaBB SE 1.5.4
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert