Advertisement:

Author Topic: [SMF Converter] IPB 2.2.x  (Read 191430 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] IPB 2.2.x
« on: January 24, 2007, 07:30:01 PM »
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.
« Last Edit: July 18, 2009, 02:47:24 PM by TE »
Follow me on Twitter

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

Offline N!c0

  • Newbie
  • *
  • Posts: 9
    • Laser Game Evolution
Re: [SMF Converter] IPB 2.2.x
« Reply #1 on: January 26, 2007, 10:50:26 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.2.x
« Reply #2 on: January 26, 2007, 10:55:21 AM »
thanks ;)

Offline N!c0

  • Newbie
  • *
  • Posts: 9
    • Laser Game Evolution
Re: [SMF Converter] IPB 2.2.x
« Reply #3 on: January 26, 2007, 11:40:23 AM »
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #4 on: January 26, 2007, 12:15:37 PM »
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

Offline TonyL

  • Semi-Newbie
  • *
  • Posts: 30
Re: [SMF Converter] IPB 2.2.x
« Reply #5 on: January 28, 2007, 06:13:47 AM »
Hi there,
Using both the updated .sql and php files, I still get the

Quote
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

 :)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #6 on: January 28, 2007, 01:26:14 PM »
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

Offline willem2

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] IPB 2.2.x
« Reply #7 on: January 29, 2007, 12:42:29 PM »
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


Offline TonyL

  • Semi-Newbie
  • *
  • Posts: 30
Re: [SMF Converter] IPB 2.2.x
« Reply #8 on: January 29, 2007, 04:24:49 PM »
Where do you get the duplicate entry?  What table?

Hallo, its in the posts table

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #9 on: January 29, 2007, 04:59:43 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

Offline willem2

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] IPB 2.2.x
« Reply #10 on: January 30, 2007, 06:11:22 AM »
Oeps missed that one thanks m8

 

Offline Prof

  • Newbie
  • *
  • Posts: 7
  • Gender: Male
    • NintenDifference
Re: [SMF Converter] IPB 2.2.x
« Reply #11 on: February 03, 2007, 01:08:33 PM »
The poll that have a multiple questions are converted correctly?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #12 on: February 03, 2007, 10:26:56 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

Offline EDivMountie

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.2.x
« Reply #13 on: February 04, 2007, 03:15:12 PM »
Hi there. I get the following error:

Quote
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #14 on: February 05, 2007, 01:27:20 AM »
Hi there. I get the following error:

Quote
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)
« Last Edit: February 05, 2007, 01:29:03 AM by JayBachatero »
Follow me on Twitter

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

Offline EDivMountie

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.2.x
« Reply #15 on: February 09, 2007, 02:49:42 AM »
Hi there. I get the following error:

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

Quote
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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #16 on: February 09, 2007, 08:55:27 AM »
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

Offline EDivMountie

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.2.x
« Reply #17 on: February 09, 2007, 02:27:32 PM »
Hmmm... that is kind of screwed up. The message is listed twice, and the line breaks are all messed. I will fix it. Thanks.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 2.2.x
« Reply #18 on: February 10, 2007, 01:18:16 PM »
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

Offline EDivMountie

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.2.x
« Reply #19 on: February 16, 2007, 12:30:52 AM »
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