News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] IPB 2.2.x

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

Previous topic - Next topic

JayBachatero

What do you mean that they show up as a label?
Follow me on Twitter

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

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

Follow me on Twitter

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

EDivMountie

No go. Now it fails on topics. 

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

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

Retrolock

:( after converting I cant see any posts...  

JayBachatero

Follow me on Twitter

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

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:

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

Follow me on Twitter

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

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

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

infonlinebr

#32
error in converting:

QuoteConverting 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:
Quoteattach_pid AS ID_MSG, attach_location AS oldEncrypt,
to
Quoteattach_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.
Follow me on Twitter

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

infonlinebr

before

[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

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

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

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

Quote from: infonlinebr on April 02, 2007, 01:07:17 PM
   
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.
Follow me on Twitter

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

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

Advertisement: