News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] Yabb - 2.1

Started by JayBachatero, October 24, 2006, 12:07:33 PM

Previous topic - Next topic

nysthul


JayBachatero

Seems like I have some values mixed up.  I'll look into it and see where I messed up.  Did you have non post count based boards that posts are being counted on?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Mivso

Im getting the following error...

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

    ALTER TABLE `ftaindex_smf`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '409-4702' for key 1



Any ideas please??

Many thanks
SMF & Other opensource solutions developer.

JayBachatero

Are you using the convert files in this topic?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

naitram

Quote from: sleeper99 on March 04, 2007, 04:31:41 AM
Im getting the following error...

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

    ALTER TABLE `ftaindex_smf`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '409-4702' for key 1



Any ideas please??

Many thanks

i ran into this as well, i simply commented out that step inb the convertor. and after cleared the table and put the index on it

JayBachatero

That table should insert ignore into.  Gotta look into this error.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

daggoth

Everytime I try to convert my yabb 2.1 to SMF I just get this error:

Converting...

Warning: file(/home/max/public_html/yabb/Variables/Settings.pl) [function.file]: failed to open stream: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 98

Warning: Invalid argument supplied for foreach() in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/home/max/public_html/yabb/Variables/membergroups.txt) [function.file]: failed to open stream: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 120

Warning: Invalid argument supplied for foreach() in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 121
Successful.
Converting members...
Warning: dir(/home/max/public_html/yabb/Members) [function.dir]: failed to open dir: No such file or directory in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 214

Fatal error: Call to a member function read() on a non-object in I:\Programme\xampp\htdocs\yabb21_to_smf.php on line 246


Ideas anybody?
Thanks

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

Ok I see the reason for the duplicate key error.  Insert ignore doesn't work since it doesn't have an index at the time.  Need to come up with something to prevent this.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

daggoth

Quote from: JayBachatero on March 06, 2007, 07:08:26 PM
Fix the paths in the hxxp:paths.pl [nonactive] file.

Thanks so much!!!
It works... ahh... great! :D

kelltech

Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    ALTER TABLE `american_smf1`.smf_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);

Caused the error:

    Duplicate entry '16777215-0' for key 1

JayBachatero

Quote from: kelltech on March 07, 2007, 09:55:22 AM
Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    ALTER TABLE `american_smf1`.smf_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);

Caused the error:

    Duplicate entry '16777215-0' for key 1
Umm now that error shouldn't be happening.  What happens if you run it again?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kelltech

Quote from: JayBachatero on March 07, 2007, 01:04:22 PM
Quote from: kelltech on March 07, 2007, 09:55:22 AM
Hi guys-I've just re-installed a fresh version of smf in cpanel (1.1.1) and using the convert files found in this topic I get this error:
QuoteConverting...
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    ALTER TABLE `american_smf1`.smf_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);

Caused the error:

    Duplicate entry '16777215-0' for key 1
Umm now that error shouldn't be happening.  What happens if you run it again?
Thanks Jay...if I click the try again option or if I run the entire installation again it repeats the error. When re-running the installation it sometimes changes the numbers in the duplicate entry causing the error.

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kelltech

Quote from: JayBachatero on March 07, 2007, 04:37:47 PM
How big is your board?

Our users have made 7727 Posts within 1642 Topics, we have 202 registered members

JayBachatero

Umm so it shouldn't be giving those errors.  I'll have to look more into these errors.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

kelltech

Hi Jay, thanks for working on that-I appreciate your time. I tried a clean install and a clean convert and got the 'poll votes' error again:
QuoteConverting poll votes... Unsuccessful!
This query:

    ALTER TABLE `american_smf1`.smf_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);

Caused the error:

    Duplicate entry '16777215-0' for key 1

So I thought I'd pass on what mods are installed, I don't know if it makes a difference:
    * Quick Reply Box
    * Link IP Mod
    * YaBB 2 Backup
    * Distilled Email Domains

Thanks again, whenever you get a chance to take a look, no rush. Have a good weekend :-)

JayBachatero

Those mods shouldn't cause an error. I have to work this weekend but I'll see what I can do.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

TEOC2

Im probably being stupid here, but i cant find any instructions for using the converter.
Plz post the blindingly obvious link i am missing.   :-[

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: