Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: Bengtson on February 03, 2009, 12:54:06 PM

Title: YaBB 2.3 conversion failure
Post by: Bengtson on February 03, 2009, 12:54:06 PM
I have installed V 1.17 of SMF and used the YaBB 22 converter but got this error.
Converting topics (part 1)... Unsuccessful!
This query:

    INSERT INTO `XXXXX_smf1`.smf_topics
    (ID_BOARD, isSticky, locked, num_views, ID_LAST_MSG, ID_FIRST_MSG)
    VALUES ('1', '0', '0', '49', '1136290503', '1136290503');

Caused the error:

    Unknown column 'num_views' in 'field list'

I changed the DB name here in the message.

Kay
Title: Re: YaBB 2.3 conversion failure
Post by: ThorstenE on February 03, 2009, 02:27:51 PM
uhh, is this the converter from our downloads page? SMF 1.1.7 don't have a "num_views" field (it's called numViews in SMF 1.1.7 and num_views in SMF 2)

please try the yabb22_to_smf.php attached to this post:
http://www.simplemachines.org/community/index.php?topic=249777.0
Title: Re: YaBB 2.3 conversion failure
Post by: Bengtson on February 03, 2009, 03:35:25 PM
Yes it was from your downloads page. I used the one that was in the thread. It has worked fine!
Thank you!
Kay