[SMF Converter] IPB 2.2.x

SMF Support > IPB

(1/40) > >>

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 :

--- Quote ---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

--- End quote ---

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

Second problem :

--- Quote ---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

--- End quote ---

$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:

--- Quote ---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...

--- End quote ---

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.

Navigation

[0] Message Index

[#] Next page

Go to full version