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

[Artimidor]

Hmmm... I'm encountering a problem when trying to convert from PhpBB 2.0.10 to SMF 1.1 RC2. Actually I first imported the whole board into PhpBB coming from ezBoard (that seems to be the only way to make a proper conversion from ezBoard to SMF). This eventually worked, no major problem in general. I had to import some Forums twice, though, due to some glitches here and there. This results in a higher thread count obviously compared to the original board, because even though the threads were deleted, they still seem to count in the PhpBB statistics.

Anyway, now that I have everything in PhpBB2 I tried to move it to SMF with the SQL script offered here. I made a test run previously with 4 smaller Forums, that worked perfectly. Now I try to import again with the whole board and get the following message at the step "Converting Posts":

Converting posts (this may take some time)... Unsuccessful!
I get a long SQL listed and a statement "Caused the error: Duplicate entry '104674' for key 1"

Uhmmm... Any idea what I could do against that? Perhaps there are posts twice in the PhpBB board, which are now deactivated, but which the converter cannot deal with properly? Or something entirely else? Does the table/member reset not purge everything completely?

Any suggestions how to progress would be greatly appreciated!

[EDIT] After some researches I found out that it seems to be necessary to clear the PHPBB installation of double topics. However, I didn't find any SQL scripts, which would allow you to find those posts - and which rows from which tables you'd need to remove and how you do that best. Anything concrete somewhere to be found?

[JayBachatero]

You will have to go to phpMyAdmin and manually delete those entries.  The converter will tell you the table that has the dup entries.

[Artimidor]

The converter only gives me a single line (see above), though it's different every time I try to initiate conversion. To which table and field does this mentioned number refer?

I see it refers to a post_id... Right? But I also saw that when I delete this one I actually delete a post of the Forum right away! 

[JayBachatero]

Yea each time it will be different.  It's a pain in the *** to delete dup keys.  Ihad to do a vB conversion and it had a mess of these. 

What is the table with the dup?  The post table?

[Artimidor]

Well, I'm somewhat irritated, I have to admit.

Some corrections, more precise info on the issue:

What I saw is that the error message at the end of the SQL statements the converter is showing to me obviously tells us only about the first number which is a problem. There are all in all around 200 such statements on the page (it's a board with around 90.000 posts), looking like this (text altered for demonstration purposes):

('110400', '9864', '1026063840', '89', 'Member [email protected]', 'Re: Help? Help? Help! Yesssss!', 'Member Name', '0', '', '', 'Yeah. I have midterms not this coming week but the week after; I have so much I need to study. But it doesn\'t stop me from doing stuff here. <p><i><a href=http://www.xyz/test.html>...My signature...</a></i></p><i></i>', '48'),

So I would assume that the numbers on the top left of the SQL statements mean problems. The numbers are in more or less successing order (practically no "holes") from 110263 until 110461 BTW.

The insert statement on top look like this:

INSERT INTO `mydatabase`.dev_messages

(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)

Now I thought you mean that I should delete all the numbers the SQL statements mention. Well, for testing purposes I took such a number, looked for the a text according to that number in the database, to see what I'd delete, e.g. post_id=110400 means that in the posts_text table I find the correct subject and text. Now I saw that the text subject is unique and not double, and by doing a SELECT like this with the subject I found:

SELECT *
FROM `phpbb_posts_text`
WHERE post_subject = 'Re: Answer to Question XYZ'
LIMIT 0 , 30

Only one row. The post only exists once in the whole board obviously.

Now I deleted the row from the phpbb_posts table, looking before the delete command and after the command at the actual PhpBB Forum display. One of the posts is then gone. Forever it seems. And with that I would partly destroy posts of my board if I continue on that way - is that correct, or have I made a mistake somewhere?

[Artimidor]

Hmmm... Or do you mean to keep the PhpBB database completely untouched and delete these appearing numbers in the SMF table called "dev_messages"? And then click on "Try again" after I've cleared all? Would the data then be imported correctly without loss?

Furthermore: Even if I delete posts from the PhpBB Board as seems to be suggested, there'd be much more than 200 posts to remove as I noticed - not all problematic numbers are listed at this one error messages page. If I delete entries from the PhpBB tables, new numbers are added once I try to import to SMF.

[JayBachatero]

Keys are usually int fields.  So search for the id of the post.  110400 Like that one.

[Artimidor]

Have you read both my posts above, Jay? As your post doesn't seem to answer any of my questions... (Are you talking to me?)

A more precise question:

Doesn't the problem exist, because the SMF database isn't wiped completely clean of posts? Having only done the first steps of the import before hitting "Continue", I can still see the board being there with everything the converter has imported the last time (well, that is 3 Forums nearly).  The dev_messages table is still full - so I'm not surprised that the import fails if it tries to add the same data again. I did a test import last week already with 4 Forums, that worked, maybe the data is still there, only deactivated, and now the INSERT cannot succeed. Or am I completely off?

Would it help to clear all the tables manually? And which ones would be of relevance if that is an option? Any ideas?

[imako]

Hi!

Is there any way that converter can actually convert scandic characters like ä and ö correctly?

I cannot really use conversion now, because it makes the forum unreadable (main language in my forum is finnish). 

If there is some way i am eager to learn that.

Thanks in advance,
Henri

[GamingTrend]

I ran the conversion mentioned in this thread and it pulled all of my forum names and users across, as well as their number of posts, etc.  Unfortunately it isn't pulling the posts across.  THe forums are all empty.  The converter spits out this:

Converting topics... Unsuccessful!
This query:

    INSERT INTO `knight_smftest`.smftest_topics

    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

    VALUES ('1593', '0', '16293', '17968', '224', '587', '18', '', '0', '25', '1215'),

    ('1594', '0', '16307', '16616', '224', '122', '17', '', '0', '6', '200'),

    ('1595', '0', '16309', '16358', '370', '323', '17', '', '0', '2', '304'),

    ('1596', '0', '16315', '17219', '216', '506', '17', '', '0', '15', '321'),

    ('1597', '0', '16317', '16683', '737', '737', '17', '', '0', '7', '656'),

    ('1598', '0', '16346', '44031', '385', '202', '1', '', '0', '15', '709'),

    ('1599', '0', '16348', '17722', '385', '767', '17', '', '0', '39', '746'),

    ('1600', '0', '16349', '17040', '714', '560', '20', '', '0', '6', '326'),

    ('1601', '0', '16356', '16654', '216', '216', '17', '', '0', '2', '166'),

ad infinitum

('2116', '0', '22775', '23944', '78', '216', '11', '', '0', '16', '356'),

    ('2117', '0', '22779', '23591', '426', '144', '17', '', '0', '16', '1107'),

    ('2118', '0', '22801', '22829', '7', '14', '6', '', '0', '3', '17'),

    ('2119', '0', '22802', '24439', '787', '96', '17', '', '0', '62', '2679');

Caused the error:

    Duplicate entry '1593' for key 1

Really talk down to me like I'm a complete noob to what I'm doing, cuz uh...I am.  What do I do with this?  Save me from phpbb guys...save me.  (By the way, I'm using phpbb 2.0.19 to RC 1.1 RC2)  Thanks!!

[GamingTrend]

Also of note, while my users appear if I look at the stats, logging in isn't working.  When clicking on a user (to look at their stats for instance) I get : Please try again. If you come back to this error screen, report the error to an administrator.

[thegrimreaper]

im really new here and i am trying to upgrade from phpbb to smf, i have read everythign from here and also used the last versions posted to download but i get an error saying

Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `zippy_smf2`.smf2_boards
SET ID_LAST_MSG = 52, lastUpdated = 1149274931
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'

i am definately usin the latest version of convert and the sql file still with no joy, can anyone help?

[JayBachatero]

Umm in the .sql file find , lastUpdated = " . time() . " and remove it

[seberhan1907]

Sorry, the database connection information used in the specified installation of SMF cannot access the

installation of vBulletin 3. 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: Incorrect table name 'user'

that is the my problem

[J. Williams]

Check that your SMF user has permissions granted on the vbulletin database

[seberhan1907]

how can i check?
i'm sorry.. i don't know

[J. Williams]

Does your host have cpanel?

If it does, check via Mysql Databases

[seberhan1907]

yes it has cpanel..
i have entered mysql db
but i can't found how can i modarete permissions..

[SBGamesCone]

Any idea when these updates are going to make it to the downloads page?

http://www.simplemachines.org/download/?converters

I ran into problems with the SQL file mentioned here and the endless loop on step 2 substep 10.

[J. Williams]

Try running it again and when you see substep in the address, put 11