PhpBB 3.0.7 To SMF 2.0 Conversion Errors

[XtcruleZ]

Im trying to convert my phpbb 3.0.7 forum to smf 2.0 final and so far the conversion halts on this error. Any idea how to fix it?

Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)

[Norv]

Can you please try using the attached .sql file instead?

[XtcruleZ]

Using a fresh install of SMF 2.0 and using your suggested sql file, i was met immediately with the following error:

Converting...
Converting ranks... Unsuccessful!
This query:

    DELETE FROM `orias155_smf2`.smf_membergroups
    WHERE groupName LIKE 'phpBB %';

Caused the error:

    Unknown column 'groupName' in 'where clause'

[IchBin™]

I'm guessing Norv attached the wrong file. It looks like that file is for SMF1.x

[Norv]

Sorry about that! Please find re-attached the file here.

[XtcruleZ]

Well the new sql file got further, but halts with this error:

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
Converting posts...The database value you're trying to insert does not exist: modified_name

[Norv]

Please try this one. (attached)

[XtcruleZ]

Ok getting further now, but now i get this:

Converting...
Converting posts...
Successful.
Converting polls... Unsuccessful!
This query:

    SELECT
    t.topic_id AS id_poll, t.poll_title AS question, t.poll_max_options AS max_votes, IF((t.poll_start + t.poll_length) < 0, 0, IFNULL((t.poll_start + t.poll_length), 0) AS expire_time,
    t.poll_vote_change AS change_vote, t.topic_poster AS id_member, IFNULL(m.username, 0) AS poster_name
    FROM `orias155_phpbb`.phpbb_topics AS t
    LEFT JOIN `orias155_phpbb`.phpbb_users AS m ON (m.user_id = t.topic_poster)
    WHERE t.poll_title != ''
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS expire_time,
    t.poll_vote_change AS change_vote, t.topic_poster AS id_member,' at line 2

[XtcruleZ]

Can anyone please help with this error?

[Norv]

Sorry about that! Please, find the corrected file here.

[XtcruleZ]

Got past that one, but now this:

Converting...
Converting polls...
Wrong value type sent to the database. Integer expected. (expire_time)

[Norv]

Please try this file, and let me know how it works. (I'm sorry, I don't have a phpbb3 installation with a enough tricky fields on the laptop I'm for the moment, but we'll get through this)

The converter should always empty the SMF database and insert the new data, and never touch the phpBb3 database. (only to read from it, of course)

[XtcruleZ]

I appreciate all the help. It stopped on the same error:

Converting posts...
Successful.
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)

[XtcruleZ]

Actually, i refreshed the page and got a different error now: Sorry for the confusion.

Converting...
Converting posts...
Duplicate entry '28047' for key 'PRIMARY'

[XtcruleZ]

Anyone know what may be causing that last error?

[XtcruleZ]

Bump.

[Norv]

Sorry for the delay. Does this happen if you run the converter from the beginning? The cause is likely that one of the tables in smf installation (likely the smf_messages table, that is, the posts), may have not been emptied before importing again the phpbb data in it.

[XtcruleZ]

Using a fresh install, i got this error again:

Converting...
Converting posts...
Successful.
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)

[XtcruleZ]

Now this is strange. I let that last error page sit overnight and when i woke up, there was a new error message:

Converting...
Converting posts...
Duplicate entry '27838' for key 'PRIMARY'

[snodrog742]

I'm having these same issues