News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[SMF Converter] IPB 2.2.x

Started by JayBachatero, January 24, 2007, 07:30:01 PM

Previous topic - Next topic

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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

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

$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


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

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

TonyL

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

QuoteDuplicate 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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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

Quote from: JayBachatero on January 28, 2007, 01:26:14 PM
Where do you get the duplicate entry?  What table?

Hallo, its in the posts table

JayBachatero

Quote from: TonyL on January 29, 2007, 04:24:49 PM
Quote from: JayBachatero on January 28, 2007, 01:26:14 PM
Where do you get the duplicate entry?  What table?

Hallo, its in the posts table
Try dropping the index in the posts table.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

willem2


Prof

The poll that have a multiple questions are converted correctly?

JayBachatero

Quote from: Prof on February 03, 2007, 01:08:33 PM
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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

EDivMountie

Hi there. I get the following error:

QuoteConverting 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

#14
Quote from: EDivMountie on February 04, 2007, 03:15:12 PM
Hi there. I get the following error:

QuoteConverting 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)
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

EDivMountie

Quote from: JayBachatero on February 05, 2007, 01:27:20 AM
Quote from: EDivMountie on February 04, 2007, 03:15:12 PM
Hi there. I get the following error:

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

QuoteAt 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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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

Advertisement: