Advertisement:

Author Topic: [PHP-Nuke] Conversion error  (Read 6136 times)

Offline Prospero

  • Semi-Newbie
  • *
  • Posts: 13
[PHP-Nuke] Conversion error
« on: August 25, 2008, 03:27:40 AM »
Guys, please help me. I've almost finished converting from PHP-Nuke to SMF 1.1.5 and this is what I got in the end:

Code: [Select]
Converting topics... Unsuccessful!
This query:

    INSERT INTO `spnrussia_testbetasite2`.sr20_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('11', '0', '12', '202967', '29', '18503', '30', '', '0', '1610', '53733'),
    ('12', '0', '13', '196601', '9', '16', '7', '', '0', '62', '5562'),
 
[a lot of similar lines here]

    ('1189', '0', '52325', '197002', '463', '22428', '24', '110', '0', '63', '3286'),
    ('1193', '0', '52366', '197992', '1411', '20949', '9', '111', '0', '189', '6859'),
    ('1194', '0', '52379', '166135', '1573', '19839', '17', '', '0', '38', '2143');

Caused the error:

    [b]Duplicate entry '11' for key 1[/b]

What can I do with this '11' entry?

Offline Prospero

  • Semi-Newbie
  • *
  • Posts: 13
Re: [PHP-Nuke] Conversion error
« Reply #1 on: August 25, 2008, 04:01:00 AM »
Searched some more and found a tip that clicking "CONTINUE" may cause the converter to double-copy some entries. Re-did the conversion. Still no luck.
« Last Edit: August 25, 2008, 07:32:01 AM by Prospero »

ThorstenE

  • Guest
Re: [PHP-Nuke] Conversion error
« Reply #2 on: August 25, 2008, 06:38:23 AM »
edit the phpnuke_to_smf.sql and search for:

Code: [Select]
---* {$to_prefix}topics
replace with:
Code: [Select]
---* {$to_prefix}topics
---{
$ignore = true;
---}

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,805
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: [PHP-Nuke] Conversion error
« Reply #3 on: August 25, 2008, 06:39:43 AM »
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Offline Prospero

  • Semi-Newbie
  • *
  • Posts: 13
Re: [PHP-Nuke] Conversion error
« Reply #4 on: August 25, 2008, 11:23:49 PM »
edit the phpnuke_to_smf.sql and search for:

Code: [Select]
---* {$to_prefix}topics
replace with:
Code: [Select]
---* {$to_prefix}topics
---{
$ignore = true;
---}
This helped, thanks. A lot of threads and posts are missing from the forum, though. Will probably have to try doing it again or find another way to move from PHP-Nuke (Nuke -> phpBB2 -> SMF, perhaps?)

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,805
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: [PHP-Nuke] Conversion error
« Reply #5 on: August 25, 2008, 11:38:09 PM »
Did you read my post and link to thread?  TE's option skips the whole process and wouldn't convert and posts.

I'm sure you had different issues in your later post.  I've just gone through a test conversion myself and this was the changes I needed to make:
[PHP-Nuke] Conversion fixes and issues.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Offline Prospero

  • Semi-Newbie
  • *
  • Posts: 13
Re: [PHP-Nuke] Conversion error
« Reply #6 on: August 27, 2008, 02:25:44 AM »
Quote
Did you read my post and link to thread?  TE's option skips the whole process and wouldn't convert and posts.
Actually it did convert all the posts after all. The first time it went wrong because another admin was working with DB at the same time. I reran the conversion script and it worked just fine.

Thanks for your post and a link to a thread with your experience, though. It is very interesting to read, I just wish I paid more attention to this yesterday (maybe I could keep the signatures' first letters). Now I probably won't rerun the conversion once again. I have 200K topics and 27K users and it's a pretty long (and exhausting if something goes wrong) process. And I didn't even start integrating them to Wordpress (my, that's gonna be a pain in the ass).

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,805
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: [PHP-Nuke] Conversion error
« Reply #7 on: August 27, 2008, 04:01:32 AM »
Yeah that is why I ran a test run on my localhost, I don't have as many topics/members (~64K/~14k) as you but I wanted to do a full test before committing to live.  Having a WAMP (or equivalent) localhost web server is such a benefit for these type of tests, I've got mine running on a lowly 1100mhz AMD machine with only 384MB RAM so it doesn't require a killer machine (for the most part).
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]