Advertisement:

Author Topic: trying to convert from yabb2.1 , now can't log in as admin  (Read 69058 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,376
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: trying to convert from yabb2.1 , now can't log in as admin
« Reply #80 on: October 31, 2008, 06:08:02 PM »
Open the Yabb21_to_smf.php

Find:
Code: [Select]
$field = trim(str_replace(array(' um ', ' de ', ' en ', ' la ', ' om '), ' at ', $field));
Replace:
Code: [Select]
$field = trim(str_replace(array(' um', ' de', ' en', ' la', ' om', ' at'), '', $field));
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline rkleemann

  • Jr. Member
  • **
  • Posts: 113
Re: trying to convert from yabb2.1 , now can't log in as admin
« Reply #81 on: December 02, 2008, 03:45:16 PM »
Guys,

It's been a few weeks since I initially tried the conversion. I got everything setup and I only ran the part1, all users, boards and personal messages converted.

Now, I wanted to convert the topics and messages. Shortly after converting, I start getting this error:

Converting topics (part 1)... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_topics
    (ID_BOARD, isSticky, locked, numViews, ID_LAST_MSG, ID_FIRST_MSG)
    VALUES ('6', '0', '0', '82', '1217894870', '1217894870');

Caused the error:

    Duplicate entry '1217894870-6' for key 2

This is using the yabb21-part2_to_smf.php script.

I even tried going into the database and deleting the offending topic, but it doesn't matter, it keeps coming back, it will complain about other duplicates and even come back and complain about the original one.

I have a pretty big YaBB2.1 board I'm trying to convert. The convert script got as far as converting 16,945 topics but now it just keeps on complaining about duplicate entries.

 :-[

Offline rkleemann

  • Jr. Member
  • **
  • Posts: 113
Re: trying to convert from yabb2.1 , now can't log in as admin
« Reply #82 on: December 02, 2008, 06:54:43 PM »
Please help guys...

I went as far as removing all the topics and restarting the conversion but I still get the same error once I get to around 16,895 topics converted...

It starts complaining about duplicate topics. Could the script not halt and just skip over the duplicates?

Converting topics (part 1)... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_topics
    (ID_BOARD, isSticky, locked, numViews, ID_LAST_MSG, ID_FIRST_MSG)
    VALUES ('6', '0', '0', '199', '1218580945', '1218580945');

Caused the error:

    Duplicate entry '1218580945-6' for key 2

ThorstenE

  • Guest
Re: trying to convert from yabb2.1 , now can't log in as admin
« Reply #83 on: December 05, 2008, 01:58:21 AM »
replied here:
http://www.simplemachines.org/community/index.php?topic=278569.0

please do not start more than one topic for the same issues please. Thank you..