[BETA] SMF 1.1 RC2 Converter - Including update for vB 3.5

[Hangulama]

hm I am having problems converting miniBB 2.0 RC5a to SMF 1.1RC2 . Seems like working fine, then it stops and when I continue again I get

Converting topics... Unsuccessful!
This query:
INSERT INTO `antibb`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, numReplies, numViews, locked, ID_FIRST_MSG, ID_LAST_MSG)
VALUES ('3163', '0', '11', '69', '2', '62', '0', '6914', '6935'),
('3164', '0', '11', '0', '0', '44', '0', '6915', '6915'),
('3165', '0', '3', '0', '1', '31', '0', '6929', '6936'),...
........
.......
Caused the error:

Duplicate entry '3163' for key 1

Any suggestion would be highly appreciated.
Thanks

[Oldiesmann]

Make sure you don't have any duplicate values (ie for moved topics or something) in your topics table.

[tt3]

Just tried it, worked a charm! 

[Hangulama]

Well everything is fine except in minibb_posts table . I tried to find duplicate topic_id there and got this result

^{mysql> SELECT COUNT( * ) - COUNT( DISTINCT topic_id ) AS 'duplicateids' FROM minibb_posts ;
+--------------+
| duplicateids |
+--------------+
|        46215 |
+--------------+
1 row in set}

Is that the problem ? if it is then how can I get rid of this ?

thanks

[Hangulama]

Well it works when I get rid of that. But as I had thought only the topics are shown all the replies are gone.

Any idea which correct duplicate entries should I look for ?

thanks

[Hangulama]

Alright got it. Just don't click on the Continue button. Let it do it by itself .

[GuNeR]

When I try to run your last convert.php I get:

Code Select Expand

Notice: Undefined variable: dbname in /home/ravnoves/public_html/convert.php(331) : eval()'d code on line 1

Notice: Undefined variable: table_prefix in /home/ravnoves/public_html/convert.php(331) : eval()'d code on line 1

I'm use SMF 1.1 RC2 and phpBB 2.0.6

[rajuthan]

Does Anyone Have A Convertor for vBulletin v3.5.4?

Becuase this one doesnt work with vb 3.5.4

[JayBachatero]

Guner try reuploading the file.

rajuthan what errors do you get when trying to convert?

[ametzler]

I am trying to convert from e107.  I open up the convert.php and all the info is correct and when I click continue I receive the following message:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user: 'thejedi_smf1@localhost' for table 'thejedi_user'


Thank you in advance for any and all help.  It's probably something really minor knowing me..lol.

Adam W. Metzler

[JayBachatero]

make sure the the SMF user has access to the e107 database.  You can do this by creating or assining the same user to both databases.

[NecatPace]

i have this error

Converting topic notifications... Unsuccessful!
This query:

Caused the error:

    Duplicate entry '9-209-0' for key 1

i have a phpbb2 2.0.19 to smf 1.1 RC2

thanxs a lot

[Oldiesmann]

Go through phpBB's notifications table and delete any duplicate entries, then try again.

[NecatPace]

now i try to migrate and have this error

Caused the error:

    Duplicate entry '1623' for key 1

i delete 10 entry and nothing, now i block my site

please help me, thanxs

[Oldiesmann]

Are you sure you deleted all the duplicate entries from all of your phpBB tables? For some reason there are duplicate entries in some tables.

[NecatPace]

i delete entry for entry, i delete ten, all say the same msg, buy with the another database work ok, i try with a backup of febrery and work, but now i try with the database of today.

my web site is www.ecuatuning.com and this now i locked all forums.

thanxs

[NecatPace]

now

Caused the error:

    Duplicate entry '1672' for key 1

i delete 50 entrys and nothing

Caused the error:

    Duplicate entry '1877' for key 1

and i delete 200 entry and nothing

[Sheepdog360]

ok ran into snag...

converting phpbb 2.0.18 to smf 1.1RC2

Path to SMF: /domain/smf

Path to phpBB2: /domain/forums

phpbb_ tables in same DB as smf_

I uploaded and tried convert.php and phpbb_to_smf from HERE, this topic and the
downloads page with all giving the same error:

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

so if anyone wants to post the correct phpBB to smf converter file for me to use, it would be great.
Thanks in advance. (ps I searched forums and didnt have any luck)

[NecatPace]

now its ok, its work my site , i use the old database, and insert the new post, post text and topic, and this work, thanxs a lot , i use the beta

[Sheepdog360]

ok ran into snag...

converting phpbb 2.0.18 to smf 1.1RC2

Path to SMF: /domain/smf

Path to phpBB2: /domain/forums

phpbb_ tables in same DB as smf_

I uploaded and tried convert.php and phpbb_to_smf from HERE, this topic and the
downloads page with all giving the same error:

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

so if anyone wants to post the correct phpBB to smf converter file for me to use, it would be great.
Thanks in advance. (ps I searched forums and didnt have any luck)

my problem is now resolved thanks to another member providing the correct converter files