Advertisement:
NameCheap

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

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 #20 on: February 16, 2007, 01:14:02 PM »
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

Offline EDivMountie

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.2.x
« Reply #21 on: February 16, 2007, 03:36:28 PM »
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?

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 #22 on: February 16, 2007, 08:06:22 PM »
Try this converter.
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 #23 on: February 19, 2007, 08:32:13 PM »
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


:(

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 #24 on: February 21, 2007, 07:48:14 PM »
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

Offline Retrolock

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.2.x
« Reply #25 on: February 26, 2007, 04:26:18 AM »
:( after converting I cant see any posts...  

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 #26 on: February 28, 2007, 10:24:20 AM »
Did any of the steps fail?
Follow me on Twitter

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

Offline shadow2004

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.2.x
« Reply #27 on: March 19, 2007, 04:04:55 PM »
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

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 #28 on: March 26, 2007, 09:34:34 AM »
Try this file.
Follow me on Twitter

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

Offline nip0n

  • Semi-Newbie
  • *
  • Posts: 24
Re: [SMF Converter] IPB 2.2.x
« Reply #29 on: March 27, 2007, 04:30:05 AM »
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'

----

Offline BobSuch

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.2.x
« Reply #30 on: March 28, 2007, 10:23:58 AM »
How do we use the attached .sql files?


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

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 #31 on: March 28, 2007, 01:49:06 PM »
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

Offline infonlinebr

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] IPB 2.2.x
« Reply #32 on: March 29, 2007, 03:18:49 PM »
error in converting:

Quote
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:
Quote
   attach_pid AS ID_MSG, attach_location AS oldEncrypt,
to
Quote
   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
« Last Edit: March 29, 2007, 03:46:00 PM by infonlinebr »

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 #33 on: March 30, 2007, 07:18:54 PM »
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

Offline infonlinebr

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] IPB 2.2.x
« Reply #34 on: March 31, 2007, 10:17:39 AM »
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]

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 #35 on: March 31, 2007, 11:54:10 PM »
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

Offline infonlinebr

  • Semi-Newbie
  • *
  • Posts: 15
Re: [SMF Converter] IPB 2.2.x
« Reply #36 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?  

Offline bundus

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.2.x
« Reply #37 on: April 05, 2007, 11:27:22 AM »
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.

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 #38 on: April 16, 2007, 04:04:42 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

Offline WarBirD

  • Semi-Newbie
  • *
  • Posts: 84
Re: [SMF Converter] IPB 2.2.x
« Reply #39 on: April 23, 2007, 06:17:15 AM »
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