Advertisement:

Author Topic: [SMF Converter] IPB 2.3.x  (Read 213302 times)

Offline Dark-Master

  • Semi-Newbie
  • *
  • Posts: 41
Re: [SMF Converter] IPB 2.3.x
« Reply #20 on: August 01, 2008, 06:03:06 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #21 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..


Offline Dark-Master

  • Semi-Newbie
  • *
  • Posts: 41
Re: [SMF Converter] IPB 2.3.x
« Reply #22 on: August 01, 2008, 07:44:36 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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #23 on: August 01, 2008, 08:09:16 AM »
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?

Offline Dark-Master

  • Semi-Newbie
  • *
  • Posts: 41
Re: [SMF Converter] IPB 2.3.x
« Reply #24 on: August 01, 2008, 08:15:56 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #25 on: August 01, 2008, 11:04:11 AM »
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..

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #26 on: August 01, 2008, 07:52:01 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Dark-Master

  • Semi-Newbie
  • *
  • Posts: 41
Re: [SMF Converter] IPB 2.3.x
« Reply #27 on: August 01, 2008, 10:42:49 PM »
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
« Last Edit: August 01, 2008, 10:50:25 PM by Dark-Master »

Offline Djuka

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] IPB 2.3.x
« Reply #28 on: August 14, 2008, 02:14:48 PM »
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'

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #29 on: August 14, 2008, 03:25:37 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Naerth

  • Semi-Newbie
  • *
  • Posts: 24
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #30 on: August 17, 2008, 04:04:21 PM »
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


Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #31 on: August 18, 2008, 12:32:26 AM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Naerth

  • Semi-Newbie
  • *
  • Posts: 24
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #32 on: August 18, 2008, 10:56:08 AM »
how i do that fort give you a Raw

i have 65100 messages (photos on the forum)

my forum it's a photo-forum

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #33 on: August 18, 2008, 01:35:07 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Naerth

  • Semi-Newbie
  • *
  • Posts: 24
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #34 on: August 18, 2008, 03:35:07 PM »
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\" /]

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #35 on: August 18, 2008, 06:15:01 PM »
How does this one work?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Naerth

  • Semi-Newbie
  • *
  • Posts: 24
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #36 on: August 19, 2008, 03:20:06 AM »
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

Offline Naerth

  • Semi-Newbie
  • *
  • Posts: 24
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #37 on: August 19, 2008, 03:23:12 AM »
but for images all is fine now

thanks a lot

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #38 on: August 19, 2008, 01:27:41 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Ellion Cold

  • Semi-Newbie
  • *
  • Posts: 19
Re: [SMF Converter] IPB 2.3.x
« Reply #39 on: August 19, 2008, 10:54:12 PM »
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? ^^