Topic: [SMF Converter] IPB 2.2.x

[JayBachatero]

What do you mean that they show up as a label?

[EDivMountie]

The following assumes the default template. In the menu bar at the top of the page, it tells the user they have X# of messages. You click to enter the PM page both the inbox and outbox are empty. Under "Labels" there is a number in bold and brackets that represents the same number that is listed under "My messages". There is nowhere to click to view these messages. If you perform a search for a simple word on the PM's you can see that they are still there. Could this be something to do with the way they are indexed?

[JayBachatero]

Try this converter.

[EDivMountie]

No go. Now it fails on topics. 

Converting topics... Unsuccessful!
This query:

    INSERT INTO `tensixty_smf`.smf_topics
    (ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG, locked)
    VALUES ('3239', '0', '6', '701', '687', '', '6', '195', '46918', '46980', '0'),
    ('3241', '0', '8', '1137', '809', '', '4', '103', '46964', '47024', '0'),
    ('3242', '0', '10', '1137', '876', '', '6', '113', '46965', '47049', '0'), ...

Caused the error:

    Duplicate entry '3239' for key 1

[JayBachatero]

Try emptying the topics table and messages table.

[Retrolock]

after converting I cant see any posts...  

[JayBachatero]

Did any of the steps fail?

[shadow2004]

Hi, my name is Lars.

I tryed the converter and the last sql-file from this post to convert an IPB 2.2 with latest fixes to SMF 1.1.2. It works nearly good. (about 50.000 posts) Just one error was written out:

Code: [Select]

Converting user avatars...
Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58

Warning: copy(/av-2.gif) [function.copy]: failed to open stream: No such file or directory in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58

Warning: copy(/upload:av-5.jpg) [function.copy]: failed to open stream: No such file or directory in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58
This is the code from convert.php (Line 829)

Code: [Select]

<826> while ($row = convert_fetch_assoc($special_result))
<827> {
<828> if ($special_code !== null)
<829> eval($special_code);
But in my opinion it comes out of the sql-file. This is the only file, where something is written about "oldAvatarDir". It seems, that the upload-directory isn't set right.

greetings shadow2004

[JayBachatero]

Try this file.

[nip0n]

Hi, first tnx for converter

second:

I have IPB 2.2.2 and when I try to convert I get this error message:

-----
Converting attachments... Unsuccessful!
This query:

    SELECT
    attach_pid AS ID_MSG, attach_location AS oldEncrypt,
    attach_hits AS downloads, attach_file AS filename
    FROM `mojozon`.ibf_attachments
    LIMIT 0, 500;

Caused the error:

    Unknown column 'attach_pid' in 'field list'

----

[BobSuch]

How do we use the attached .sql files?


I mean, do we just import it into a new database? Or..?

[JayBachatero]

Can you get me a database structure for the attachments table?

[infonlinebr]

error in converting:

Converting attachments... Unsuccessful!
This query:

    SELECT
    attach_pid AS ID_MSG, attach_location AS oldEncrypt,
    attach_hits AS downloads, attach_file AS filename
    FROM `annbr_forum`.annbr_attachments
    LIMIT 0, 500;

Caused the error:

    Unknown column 'attach_pid' in 'field list'

in invision22_to_smf.sql

line 996:

   attach_pid AS ID_MSG, attach_location AS oldEncrypt,

to

   attach_id AS ID_MSG, attach_location AS oldEncrypt,

in the folder of uploads of ipb 2,2 of chmod777 in all archives, so that in the following step the archives are transferred to the folder of smf

JayBachatero, has a problem with the converted signatures it had come with codes HTML and instructions of divs

[JayBachatero]

Can you post the problem with the sig?  Also post the before and after effect.  Make sure to get them straight from the database.

[infonlinebr]

before

Code: [Select]

[font=Verdana][right][color=#000080]RPG:[/color] [url=http://www.annbr.com/forum/index.php?showtopic=66][color=#8B0000]Sétimo[/color][/url].[url=http://www.annbr.com/forum/index.php?showtopic=67]Chama da Fênix[/url] ~ [url=http://www.annbr.com/forum/index.php?showtopic=154][color=#2E8B57]Demona[/color][/url].[url=http://www.annbr.com/forum/index.php?showtopic=148&st=0]Badges[/url]
[img]http://i111.photobucket.com/albums/n139/victorvaz/sign_setimo2.jpg[/img]
[color=#000080]Grupos:[/color] [url=http://img340.imageshack.us/img340/4423/agspamqn1.jpg]Spam Team[/url] ~ [url=http://img273.imageshack.us/img273/4801/bannerrpgzc4.jpg] RPG Yeah![/url] ~ [url=http://img60.imageshack.us/img60/8097/pfspartidofloodersocialnk5.png] PFS[/url] ~ [url=http://img297.imageshack.us/img297/9079/xdcopyfg4.jpg]xD[/url]
[url=http://www.annbr.com/forum/index.php?showtopic=2105&st=0#entry33143][img]http://serv2.imagehigh.com/imgss/5493557_Comicbannerspawn.jpg[/img][/url]
[color=#000080]Noivete:[/color] [url=http://www.annbr.com/forum/index.php?showuser=100]Mila-Chan[/url] [color=#000080]Manhê:[/color] [url=http://www.annbr.com/forum/index.php?showuser=15]Sakuragome[/url]
[img]http://www.sedentario.org/wp-includes/images/yahoo/winkwink.gif[/img] [url=http://www.annbr.com/forum/index.php?showtopic=2244&hl=][color=#8B0000]Desafio for Seven[/color]... Vote... ou não[/url][/right][/font]
after

Code: [Select]

[div align=\"right\"]RPG: . ~ .
[img]http://i111.photobucket.com/albums/n139/victorvaz/sign_setimo2.jpg\" border=\"0\" class=\"linked-sig-image\" /]
Grupos: ~ ~ ~ ~
Noivete: Manhê:
[img]http://www.sedentario.org/wp-includes/images/yahoo/winkwink.gif\" border=\"0\" class=\"linked-sig-image\" /] [/div]

[JayBachatero]

That's not directly from the database. IPB stores the bbc tags as html in the database.

[infonlinebr]

    
What I passed above is as is bbcode direct in the forum ipb and later as it was in smf, does not have as to make this conversao of the HTML of ipb for smf?  

[bundus]

Bugs

in invision22_to_smf.sql

line 996:
attach_pid AS ID_MSG, attach_location AS oldEncrypt,

to:
attach_rel_id AS ID_MSG, attach_location AS oldEncrypt,

...attach_pid doesnt exist.  If you convert it to attach_id as the guy above says you just get an auto increment value.  attach_rel_id is the post that the attachment is actually attached to.

[JayBachatero]

   
What I passed above is as is bbcode direct in the forum ipb and later as it was in smf, does not have as to make this conversao of the HTML of ipb for smf? 

You need to go in phpMyAdmin and look directly into the tables for the post.  IPB when you edit a post it converts it to BBC tags but when you you save it it converts it back to html.

bundus thanks for the bug fix.  I'll update the file to reflect this.

[WarBirD]

Hello, my question, though it fits basically into this section, it goes the other way around. A friend of mine asked me to convert his SMF Forum, for buisness purposes, to the latest IPB 2.2.x ! You have shown here the converter from IPB 2.2.x to SMF, could you please help tell me or help me to find a converter that does the other way around, from latest SMF 1.1.2 to IPB 2.2.x ?

I really would appreciate any help !!!

Also, he has quite some mods installed in his SMF Installation, do we have to remove that stuff manually from the Database first, from a MySQL dump for example, to have that not interfear with any kind of Conversion ?

Please, I really would ask you guys here for help.

Thx in advance.
WarBirD