phpBB 2.0.21 to smf

[Ale2007]

Hello. I want to make a consultation on an error that appears to me in the convert of the data bases, which appears an error to me that is the following one:

---------------------------------------------------------------------------
Converting topics... Unsuccessful!
This query:

INSERT INTO `eca_anime`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('3', '0', '3', '3', '2', '2', '4', '', '0', '0', '338'),

((they follow but line))


Caused the error:

Duplicate entry '3' for key 1

----------------------------------------------------------------------------------------------

According to which I understand, it is that there are repeated things or that it lacks something. I want to know if there is a solution to this and to be able to pass the subjects and all the others that I have in the forum phpbb to smf.

I will thank for its aid to them.
And pardon by my English, manages to translate the text with google ^^.

[Dwolfo1]

I'd like to join in this topic since mine problem looks similar.  I would rather figure this out on my own, but if I cant I definately am wiling to pay some one to convert it for me.  Thanks!

Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/home/w0lfman/public_html/board/images/avatars/172177947945f02cc9e3ae1.jpg) [function.copy]: failed to open stream: No such file or directory in /home/w0lfman/public_html/12thman/convert.php(827) : eval()'d code on line 35
.
.
.Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `w0lfman_herds`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('1580', '0', '11600', '11692', '-1', '-1', '3', '', '0', '1', '321'),
.
.
.Caused the error:

Duplicate entry '12426-1' for key 2

[zeitwort]

I had the same problem

Did you use the latest files?

http://www.simplemachines.org/community/index.php?topic=142124.msg905972#msg905972

[Dwolfo1]

Thank YOU!  That is workinG great!

Its already converted my post topics, but I'm yet to see the datbase of usernames show up.  Will that happen when the full conver is finished?

[Dwolfo1]

It just finished, but I didnt get my user information.  The follow is the message I recieved after completion...

Converting...

Notice: Undefined index: convert_script in /home/w0lfman/public_html/12thman/convert.php on line 580

Warning: Invalid argument supplied for foreach() in /home/w0lfman/public_html/12thman/convert.php on line 583

Notice: Undefined index: convert_script in /home/w0lfman/public_html/12thman/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 945

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 963

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 989

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1037

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1049

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1061

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1071

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1078

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1085

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1111

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1129

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1156

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1193

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1236

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1299

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1354

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1827

Notice: Undefined variable: result in /home/w0lfman/public_html/12thman/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/w0lfman/public_html/12thman/convert.php on line 1378
Successful.

Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /home/w0lfman/public_html/12thman/convert.php on line 1454
installation.

We hope you had a smooth transition!

[Dwolfo1]

this converted topics back til the end of August.  Any reason what I would lose two months of post.  Thanks again...

[Dwolfo1]

Anyone have any thoughts on this?  Why can I convert my database, but it only goes back till august. I lose two months of data.

[JayBachatero]

That's weird Dwolfo.  Try converting again and see if it works.  Use the convert files from the stickied topic.

[Dwolfo1]

I've actually uninstalled and then reinstalled the SMF software and deleted the SMF coversion in myAdmin three times with the same result.  Cant figure it out.  I'll convert the database, but each time it only converts up to august.  I do get all of my users data though.  Any idea what can be hanging it up?

[JayBachatero]

Do you get any errors when converting?  How big is your forum?  Also did you do a stats recount?

[Dwolfo1]

Do you get any errors when converting?  How big is your forum?  Also did you do a stats recount?

The error logs is a couple of post up in this thread.  My forum has about 1450 members and is probably about 400 meg in size.  I did recalulate the numbers, but that didnt help bring all my topics or stickies over.  My latest topic is August 2007. 

[JayBachatero]

Can you PM me FTP info so that I can take a look at the conversion for you?

[Dwolfo1]

Jay thanks for your offer to help, but I think I figured it out.  I was using an older version of the convert.php.  After I used an upgraded one from one of your post it looks like everything is working properly.  thanks again for your offer to help.