Advertisement:

Author Topic: Converting from PHP-Nuke 8.1 to SMF 2.0 Final  (Read 3550 times)

Offline Lum-chan

  • Semi-Newbie
  • *
  • Posts: 88
  • Gender: Male
  • Lum-chan is cute!
    • The World of Urusei Yatsura's Lum
Converting from PHP-Nuke 8.1 to SMF 2.0 Final
« 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
« Last Edit: July 06, 2011, 04:02:27 PM by Lum-chan »
Lum-chan


Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Converting from PHP-Nuke 8.1 to SMF 2.0 Final
« Reply #1 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
Code: [Select]
t.topic_poster AS id_member_started, p.poster_id AS id_member_updated,
Replace
Code: [Select]
t.topic_poster AS id_member_started, IFNULL(p.poster_id, 0) AS id_member_updated,
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline Lum-chan

  • Semi-Newbie
  • *
  • Posts: 88
  • Gender: Male
  • Lum-chan is cute!
    • The World of Urusei Yatsura's Lum
Re: Converting from PHP-Nuke 8.1 to SMF 2.0 Final
« Reply #2 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
Lum-chan