Topic: [SMF Converter] IPB 2.2.x

[JayBachatero]

Software: IPB
Version: 2.2.x

This is the official support topic for IPB 2.2.x converter.  Use this topic to ask for support for this converter.  I merged all the changes that were floating around.  Lets use this topic to get a final working version.

Changelog
! Attachment typo. (ipb22_to_smf.sql)
! More regex bugs . (ipb22_to_smf.sql)
! Replace  \n with <br /> for the maintenance mode message. (ipb22_to_smf.sql)
! Cast width and height as a string for the database insert when converting attachments. (ipb22_to_smf.sql)
! When converting attachments add the width and height for images. (ipb22_to_smf.sql)
! Convert the permissions properly. (ipb22_so_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.

[N!c0]

Hello
I've test this ipb22_to_smf.php.

First problem :

Converting permissions... Unsuccessful!
This query:

    SELECT
    g_id AS ID_GROUP, g_title AS groupName, g_max_messages AS maxMessages,
    g_view_board AS view_stats, g_mem_info AS view_mlist,
    g_view_board AS who_view, g_use_search AS search_posts, g_email_friend AS send_topic,
    g_edit_profile AS profile_identity_own, g_post_new_topics AS post_new,
    g_reply_own_topics AS post_reply_own, g_reply_other_topics AS post_reply_any,
    g_edit_posts AS modify_own, g_delete_own_posts AS delete_own,
    g_post_polls AS poll_post, g_post_polls AS poll_add_own, g_vote_polls AS poll_vote,
    g_use_pm AS pm_read, g_use_pm AS pm_send, g_is_supmod AS moderate_forum,
    g_is_supmod AS manage_membergroups, g_is_supmod AS manage_bans,
    g_access_cp AS manage_smileys, g_access_cp AS manage_attachments,
    g_can_remove AS delete_any, g_calendar_post AS calendar_post, g_post_closed AS lock_own,
    g_edit_topic AS modify_any, g_open_close_posts AS lock_any
    FROM `IPB-test`.ibf_groups
    WHERE g_id NOT IN (1, 4, 5)
    LIMIT 0, 100;

Caused the error:

    Champ 'g_calendar_post' inconnu dans field list

I remove this : "g_calendar_post AS calendar_post," because not exist in ibf_groups for IPB 2.2.1


Second problem :

Converting attachments... Unsuccessful!
This query:
    INSERT INTO `smf`.smf_attachments
    (ID_MSG, oldEncrypt, downloads, filename)
    VALUES ('1421', 'post-23-1117620387.jpg', '0', '0001.jpg'),
    ('1422', 'post-23-1117620993.jpg', '0', '0002.jpg'),
    ('1469', 'post-23-1117803077.jpg', '0', '0003.jpg'),
    ('1621', 'post-141-1118095630.jpg', '0', '0004.jpg'),
    ('1697', 'post-23-1118226324.png', '0', '0005.png'),
    ('1797', 'post-7-1118387863.png', '0', '0006.png'),
    ('1810', 'post-23-1118418040.jpg', '0', '0007.JPG'),
    ('1816', 'post-23-1118418235.jpg', '0', '0008.JPG'),
    ('1846', 'post-7-1118435094.jpg', '0', '0009.JPG'),
    ('1925', 'post-23-1118667173.jpg', '0', '0010.JPG'),
    ('1927', 'post-23-1118667399.jpg', '0', '0011.JPG'),
    ('1928', 'post-23-1118667427.jpg', '0', '0012.JPG'),
    ('1929', 'post-23-1118667456.jpg', '0', '0013.JPG'),
    ('1930', 'post-23-1118667485.jpg', '0', '0014.JPG'),
    ('1932', 'post-23-1118667525.jpg', '0', '0015.JPG'),
    ('1933', 'post-23-1118667563.jpg', '0', '0016.JPG'),
    ('1934', 'post-23-1118667585.jpg', '0', '0017.JPG'),
    ('8981', 'post-220-1131651025.jpg', '0', '0018.JPG'),
    ('0', 'post-757-1168952663.gif', '0', '0019.gif');

Caused the error:
    Champ 'oldEncrypt' inconnu dans field list

$row['oldEncrypt'] is not initalize in ipb22_to_smf.php
For the moment I'm not need Attachement, so I remove all this code line....

After, installation work, but identifaction failed => password error.
I check encryption key in IPB data base and SMF, it's the same....

I add a new user, with the same password, and now the encryption key in SMF data base is different of import
How can I solve this encription problem ?


So, now I'm login, and surprise on public page, I see board and child-board, but there are mixed, and in Admin section, I see only category with none board or child-board.

My IPB structur on fisrt page :
-> Main Cat01 (category)
 --> Cat 001 (board)
  --> Section 001 (child-board)
  --> Section 002
  --> Section ...
 --> Cat 002
  --> Section 001
  --> Section 002
  --> Section ...
-> Main Cat02
...
-> Main Cat...

How can I solve this presentation problem ?



Thanks

[FrankeisteiN™]

thanks

[N!c0]

So, now I'm login, and surprise on public page, I see board and child-board, but there are mixed, and in Admin section, I see only category with none board or child-board.

My IPB structur on fisrt page :
-> Main Cat01 (category)
 --> Cat 001 (board)
  --> Section 001 (child-board)
  --> Section 002
  --> Section ...
 --> Cat 002
  --> Section 001
  --> Section 002
  --> Section ...
-> Main Cat02
...
-> Main Cat...

In fact, in smf_categories.ID_CAT the max value is : 255
But with import, my first ID_CAT value is 354...

For solve this problem, the ID_CAT must an int(4) and not tinyint(4).
I must change all definition of ID_CAT in the file : install_1-1.sql in smf_categories, smf_boards, and smf_collapsed_categories

May be possible to change this type of ID_CAT for the next version of SMF ?

Thanks

[JayBachatero]

Ok I updated the converter.  I had a type-o causing the attachments step to use the wrong column names.

[TonyL]

Hi there,
Using both the updated .sql and php files, I still get the

Duplicate entry '7854' for key 1

error as was reported in earlier versions of the converter.

I'm using IPB 2.2.1 and a version 4 MySQL database

 

[JayBachatero]

Where do you get the duplicate entry?  What table?

[willem2]

I have a database from ipb 2.2

Looking also into that

Till now import is ok but not in the right forums

if that is all then there is no problem just move it to the right one

when it is working ok i will put it here

[TonyL]

Where do you get the duplicate entry?  What table?

Hallo, its in the posts table

[JayBachatero]

Where do you get the duplicate entry?  What table?

Hallo, its in the posts table

Try dropping the index in the posts table.

[willem2]

Oeps missed that one thanks m8

 

[Prof]

The poll that have a multiple questions are converted correctly?

[JayBachatero]

The poll that have a multiple questions are converted correctly?

Not really sure how it handles it since SMF doesn't support multiple polls.  I'll take a look and see.

[EDivMountie]

Hi there. I get the following error:

Converting attachments... Unsuccessful!

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 ' ),
    (3, 2668557, 'pare_e.pdf', 132, 39, , ),
    (4, 84588, 'RCMP_Ca' at line 4

Could this have to do with height and width values being null?
I am converting to SMF 1.1.1 from IVPB 2.1.4.

Thanks in advance.

Pete

[JayBachatero]

Hi there. I get the following error:

Converting attachments... Unsuccessful!

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 ' ),
    (3, 2668557, 'pare_e.pdf', 132, 39, , ),
    (4, 84588, 'RCMP_Ca' at line 4

Could this have to do with height and width values being null?
I am converting to SMF 1.1.1 from IVPB 2.1.4.

Thanks in advance.

Pete

Reuploaded it.

! Cast width and height as a string for the database insert when converting attachments. (ipb22_to_smf.sql)

[EDivMountie]

Hi there. I get the following error:

Converting attachments... Unsuccessful!

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 ' ),
    (3, 2668557, 'pare_e.pdf', 132, 39, , ),
    (4, 84588, 'RCMP_Ca' at line 4

Could this have to do with height and width values being null?
I am converting to SMF 1.1.1 from IVPB 2.1.4.

Thanks in advance.

Pete

Reuploaded it.

! Cast width and height as a string for the database insert when converting attachments. (ipb22_to_smf.sql)

Thanks for fixing that. Now I get the following:

At this URL: ../convert.php?step=1&substep=36&start=0

Parse error: parse error, unexpected T_STRING in /home/domain/public_html/bbs/Settings.php on line 35

Any ideas?

Pete

[JayBachatero]

What does $mmessage say in Settings.php?

[EDivMountie]

Hmmm... that is kind of screwed up. The message is listed twice, and the line breaks are all messed. I will fix it. Thanks.

[JayBachatero]

I'll fix this for this converter as well.  The 2.0.0 had the same problem.

[EDivMountie]

Thanks for all your help so far. Everything appears to be working now except the private messages. They get imported, or so it would seem, however they show up as a label and there is no way to view them. Any ideas?

Pete