Can't Convert phpBB2 2.0.19 t smf 1.1 RC2

[NecatPace]

SMF Version: SMF 1.1 RC2
I cant convert, i use http://www.simplemachines.org/community/index.php?topic=38966.0

and copy convert.php and .sql

and maybe work

but i have this msg error

Converting topics... Unsuccessful!

Caused the error:

    Duplicate entry '1614' for key 1

Thanxs

[J. Williams]

Have you tried taking convert.php from [BETA] SMF 1.1 RC2 Converter?

Its either that the table is filled in smf.

[NecatPace]

i use the link http://www.simplemachines.org/community/index.php?topic=38966.0, and in this topic i can download a convert.php, i don't know if this is a beta release or a final, i try before with another http://www.simplemachines.org/download/?converters but don't work

thanxs

[J. Williams]

Download the convert.php from the other topic i mentioned.

[NecatPace]

yes y donwload but i have this error

onverting topics... Unsuccessful!

Caused the error:

    Duplicate entry '1614' for key 1

with this convert.php

[J. Williams]

Could you find that entry in phpmyadmin?

[redone]

You should be able to find the duplicate entry and remove it via phpmyadmin and run the conversion again.

[NecatPace]

yes, yesterday i deleted 4 entry, but and nothing

darksteel recomended this link http://www.simplemachines.org/community/index.php?topic=65677.0

i this i donwload the beta convert phpbb to smf

and work more, but now i have this error

Converting topic notifications... Unsuccessful!
This query:

Caused the error:

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

but the topics and post convert

[Mystique]

Make sure you get the converter file from THIS thread http://www.simplemachines.org/community/index.php?topic=65677.0 othewise it won't work.. take my word for it. I was going nuts to convert my 2.0.19 with the convert.php file that was listed in the Converters 1.1 thread.. it doesn't work. Grudge fixed the convert file and it seems to only be linked in that thread. The original convert file was like 56 kb's.. the new one is almost 60 Kb's in size and that's the one you want. Along with the phpbb2_to_smf.sql file.

It's the only one that worked when converting my phpbb 2.0.19

[rockinaway]

That happened to me all i did was Admin -> Forum Maintenance -> Find and repair any errors.

did this and all; worked fine after

[jyajay]

I tried the convert.php for the 1.1 RC2 but the error is still there.

My phpbb database has no errors at all but this message keeps comin.

How can I delete these duplicates through phpmyadmin?

Syntax looks like this:

Code Select Expand

(ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated)

('3479', 'USERNAME', 'USERNAME', 'a9173c22e7246e7105f1987116ea8016', '0', '1140479528', '', '0', '', '0', '[email protected], '0', '', '', '', '', '', '', '1', '-1', '1', '', '', '1', '0'),

[rockinaway]

try what i said

[jyajay]

Ok, i solved it that way:

Installed complete clean 1.0.7 SMF and imported my phpbb database. After that I did the upgrade to SMF 1.1 and now everything is fine!