News:

Join the Facebook Fan Page.

Main Menu

[SMF Converter] IPB 2.3.x

Started by SleePy, May 09, 2008, 10:35:02 PM

Previous topic - Next topic

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

Quote from: ThorstenE on August 01, 2008, 07:08:05 AM
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
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.
                        
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dark-Master

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

There were

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.
http://bbs.xgaming.in.th/

IPB date tables.
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

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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

[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 [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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Naerth

well i have 1567 topics and 65129 messages

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


[!--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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Naerth

well i have this message of the end

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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? ^^

Advertisement: