Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: Lum-chan on July 06, 2011, 11:18:09 AM

Title: Converting from PHP-Nuke 8.1 to SMF 2.0 Final
Post by: Lum-chan on July 06, 2011, 11:18:09 AM
Currently, I'm trying to convert my old forum which is running on PHP-Nuke 8.1 to SMF 2.0 Final. When I have done all pre-converting duties, like backing up current forum/database, installed a fresh copy of SMF 2.0 and run the converter, the conversion seems to go OK, besides some messages about missing avatars. After the conversion the userbase is filled and so are the boards. But when I check the boards, the topic numbers are there but the topics are gone. The same goes for the userbase. Database is filled, memberlist is correct but the stats give only one user (me).

I used this converter: http://download.simplemachines.org/?converters;software=phpnuke
The boards run forum-module phpbb 2.0.23 and use the latest security-patch 3.5 for PHP-Nuke 8.1

[edit]
I messed-up somehow. The installer wasn't done yet. I'm getting the following output:

Quote
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

I tried some tools as provided in the stickies but these didn't help me any further. Any suggestions or solutions are more than welcome.

Thanks in advance
Title: Re: Converting from PHP-Nuke 8.1 to SMF 2.0 Final
Post by: Oldiesmann on July 14, 2011, 02:39:15 AM
The stats should be updated at the end of the conversion process. If not, you can update them through the admin center afterwards.

What happens if you make this change to the SQL file?

Find
t.topic_poster AS id_member_started, p.poster_id AS id_member_updated,

Replace
t.topic_poster AS id_member_started, IFNULL(p.poster_id, 0) AS id_member_updated,
Title: Re: Converting from PHP-Nuke 8.1 to SMF 2.0 Final
Post by: Lum-chan on July 18, 2011, 03:42:56 AM
Thanks for your suggestions but these didn't do the trick for me. I did get the conversion done by removing SMF2.0 (and it's db content) and installing SMF 1.1.14, downloaded the SMF1 converter (2 files in one archive) somewhere from this site and the conversion went OK. Then I upgraded to 2.0 Final and as far as I can see, it works as it should be.

Me very happy  ;D