Topic: [SMF Converter] IPB 2.3.x

[Dark-Master]

Is this compatible with smf 2.0 ?

I got an error like this when I try to convert ipb 2.3.4 to smf 2.0 beta3.1

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

Converting members... Unsuccessful!
.........bla bla bla,,,,,,,
Caused the error:

    Unknown column 'memberName' in 'field list'

[ThorstenE]

no, not at this time..

converters for 2.0  are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..

[Dark-Master]

no, not at this time..

converters for 2.0  are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..

Ok thanks a lot, but I got this error with 1.1.5 too

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

    INSERT INTO `xgsmf`.smf_members
----- bla bla bla-----

Caused the error:

    Incorrect date value: '' for column 'birthdate' at row 1

[ThorstenE]

are you using the invision23_to_smf.sql from this topic (attachment in first post) and convert.php from here?
maybe, you are using the wrong conversion file from the download page?

[Dark-Master]

Sure,

I'm using

convert.php from another topic and invision23_to_smf.sql from this topic .

And this is my phpinfo http://bbs.xgaming.in.th/info.php

[ThorstenE]

i have no database-dumb from an ipb2.3 myself so i cannot check it.. there are two possible solutions:

1) remove this block from the invision23_to_smf.sql

Code: [Select]

IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,it is converting the birthdates from your users.. if you delete this block birthdays would not be converted.

2) post a screenshot from ipb's members-table, so that i can see which format the birthdays have and i will modify this block for you..

[SleePy]

Dark-Master,

I think MySQL is running in strict mode here. Though I am not to sure why you still receive that error. It would only occur if it was empty or not used during part of the conversion. Which is odd as it is being used right there.
                         

[Dark-Master]

THANKS you both, I removed the error thing from invision23_to_smf.sql.

There were

Code: [Select]

IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate, */

p.edit_time AS modifiedTime

p.pid AS ID_POLL.

After I removed those 3s, the conversion can be done. Thanks to smf and you all.

And here is the result.

Code: [Select]

http://bbs.xgaming.in.th/
IPB date tables.

Code: [Select]

http://img.xgaming.in.th/temp/2008-08-02_093410.png

[Djuka]

I get this message when trying to convert from 2.3.4 to SMF 1.1.5

Code: [Select]

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.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: SELECT command denied to user 'username'@'localhost' for table 'ibf_members'

[SleePy]

Common conversion errors.
 

[Naerth]

Hello,

for me, Converter was OK from IPB 2.3.1 to SMF 1.1.

all is fine but just BBCode not run good since i do converter

now where i read all topics where we have photos, color code and quote i have this kind of line on all my messages

Code: [Select]

[img src=\"http://farm2.static.flickr.com/1076/527942244_324d8f3580_o.jpg\" border=\"0\" class=\"linked-image\" /]

when i was on IPB the code was

Code: [Select]

[img][/img]
do know how i can resolv this problem, i use the Panel Admin for check errors en problems : SMF is ok

thanks a lot for your answer

[SleePy]

Can you provide us a raw message from the IPB database that has this issue?
You will need to use phpMyAdmin or similar to get ahold of this, but this will provide us the message in its raw format so we know what it is looking like before any bbc code work is done on it.

[Naerth]

how i do that fort give you a Raw

i have 65100 messages (photos on the forum)

my forum it's a photo-forum

[SleePy]

Do you know the message id of a post that has this issue?
If you link me to a post I could most likely figured out its message id.

We then go look at just that message body in the database.

[Naerth]

well i have 1567 topics and 65129 messages

this is the typical bug that i have on all my message

Code: [Select]

[!--coloro:#4169E1--][span style=\"color:#4169E1\"][!--/coloro--]Merci Nikolas pour cette info.
Je passerai à la FNAC évaluer le contenu des 2 livres.[!--colorc--][/span][!--/colorc--]

Ci-joint 2 des clichés tout juste pris à Lyon ce week-end sans réelle prise en main du K20
 
[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon05-07-08.jpg\" border=\"0\" class=\"linked-image\" /]

[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon02.jpg\" border=\"0\" class=\"linked-image\" /]

[SleePy]

How does this one work?

[Naerth]

well i have this message of the end

Code: [Select]

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `db214843381`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

[Naerth]

but for images all is fine now

thanks a lot

[SleePy]

Common conversion errors.
 

[Ellion Cold]

I have a problem, when i was converting i got this error:

Converting...
Converting poll logs... Unsuccessful!
This query:

    INSERT INTO `bgforum`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('1', '31'),
    ('1', '50'),
    ('1', '188'),
    ('1', '517'),
    ('2', '2'),
    ('2', '5'),
    ('2', '7'),
    ('2', '12'),
    ('2', '14'),
    ('2', '15'),
    ('2', '16'),
    ('2', '31'),
    ('2', '43'),
    ('2', '50'),
    ('2', '56'),
    ('2', '68'),
    ('2', '73'),
    ('2', '79'),
    ('2', '80'),
    ('2', '156'),
    ('2', '208'),
    ('2', '224'),
    ('2', '312'),
    ('2', '503'),
    ('2', '520'),
    ('3', '3'),
    ('3', '5'),
    ('3', '7'),
    ('3', '9'),
    ('3', '10'),
    ('3', '12'),
    ('3', '14'),
    ('3', '16'),
    ('3', '31'),
    ('3', '68'),
    ('3', '312'),
    ('3', '503'),
    ('', '3'),
    ('', '5'),
    ('', '7'),
    ('', '9'),
    ('', '10'),
    ('', '12'),
    ('', '14'),
    ('', '16'),
    ('', '31'),
    ('', '68'),
    ('', '312'),
    ('', '503'),
    ('1', '31'),
    ('1', '50'),
    ('1', '188'),
    ('1', '517'),
    ('2', '2'),
    ('2', '5'),
    ('2', '7'),
    ('2', '12'),
    ('2', '14'),
    ('2', '15'),
    ('2', '16'),
    ('2', '31'),
    ('2', '43'),
    ('2', '50'),
    ('2', '56'),
    ('2', '68'),
    ('2', '73'),
    ('2', '79'),
    ('2', '80'),
    ('2', '156'),
    ('2', '208'),
    ('2', '224'),
    ('2', '312'),
    ('2', '503'),
    ('2', '520'),
    ('3', '3'),
    ('3', '5'),
    ('3', '7'),
    ('3', '9'),
    ('3', '10'),
    ('3', '12'),
    ('3', '14'),
    ('3', '16'),
    ('3', '31'),
    ('3', '68'),
    ('3', '312'),
    ('3', '503'),
    ('', '3'),
    ('', '5'),
    ('', '7'),
    ('', '9'),
    ('', '10'),
    ('', '12'),
    ('', '14'),
    ('', '16'),
    ('', '31'),
    ('', '68'),
    ('', '312'),
    ('', '503'),
    ('4', '510'),
    ('4', '503'),
    ('4', '508'),
    ('4', '171'),
    ('5', '171'),
    ('5', '503'),
    ('5', '15'),
    ('5', '508'),
    ('5', '68'),
    ('5', '510'),
    ('5', '80'),
    ('5', '5'),
    ('6', '171'),
    ('6', '508'),
    ('6', '503'),
    ('6', '68'),
    ('7', '171'),
    ('7', '5'),
    ('7', '15'),
    ('7', '80'),
    ('7', '510'),
    ('7', '50'),
    ('7', '593'),
    ('8', '171'),
    ('8', '520'),
    ('8', '5'),
    ('8', '31'),
    ('8', '80'),
    ('8', '7'),
    ('8', '647'),
    ('8', '50'),
    ('8', '545'),
    ('8', '15'),
    ('8', '68'),
    ('8', '16');

Caused the error:

    Duplicate entry '1-31-0' for key 1



Can someone help me please? ^^