Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: JayBachatero on January 24, 2007, 07:30:01 PM

Title: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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 (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: N!c0 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: frankeistein on January 26, 2007, 10:55:21 AM
thanks ;)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: N!c0 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: TonyL 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

 :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 28, 2007, 01:26:14 PM
Where do you get the duplicate entry?  What table?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: willem2 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

Title: Re: [SMF Converter] IPB 2.2.x
Post by: TonyL on January 29, 2007, 04:24:49 PM
Where do you get the duplicate entry?  What table?

Hallo, its in the posts table
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: willem2 on January 30, 2007, 06:11:22 AM
Oeps missed that one thanks m8

 
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Prof on February 03, 2007, 01:08:33 PM
The poll that have a multiple questions are converted correctly?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 09, 2007, 08:55:27 AM
What does $mmessage say in Settings.php?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 16, 2007, 01:14:02 PM
What do you mean that they show up as a label?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 16, 2007, 08:06:22 PM
Try this converter.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: EDivMountie 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


:(
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 21, 2007, 07:48:14 PM
Try emptying the topics table and messages table.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Retrolock on February 26, 2007, 04:26:18 AM
:( after converting I cant see any posts...  
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 28, 2007, 10:24:20 AM
Did any of the steps fail?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: shadow2004 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on March 26, 2007, 09:34:34 AM
Try this file.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: nip0n 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'

----
Title: Re: [SMF Converter] IPB 2.2.x
Post by: BobSuch 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..?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on March 28, 2007, 01:49:06 PM
Can you get me a database structure for the attachments table?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: infonlinebr 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: infonlinebr 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]
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: 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?  
Title: Re: [SMF Converter] IPB 2.2.x
Post by: bundus 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero 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.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: WarBirD 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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: infonlinebr on May 02, 2007, 08:49:21 PM
I separated a list of things that are not being converted for sql of ipb 2.2

[img]IMAGEM.jpg\" border=\"0\" class=\"linked-sig-image\" /]

[div align=\"center\"]CONTENT[/div]

[div align=\"right\"]CONTENT[/div]

[!--quoteo--][div class=\'quotetop\']CONTENT[/div][div class=\'quotemain\'][!--quotec--]
Title: Re: [SMF Converter] IPB 2.2.x
Post by: cooky on May 07, 2007, 02:42:04 PM
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 !!!

here you go invision do a free convertor here http://community.ipslink.com/board/files/22converters.zip

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
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Nordoelum on May 25, 2007, 01:18:05 PM
Do I use the regular convert.php file? Because the one linked in the first post isn't working. The link isn't leading anywhere.

Please provide a proper link.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: tphilakone on May 27, 2007, 09:42:13 AM
thanks
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on May 29, 2007, 12:37:53 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
You came to the wrong place to ask buddy.  Try asking over at IPB ::).
Title: Re: [SMF Converter] IPB 2.2.x
Post by: dreiecon on June 08, 2007, 02:17:44 AM
Where can I get the convert.php file? The link you have in the first post does not work.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Alcamonster on June 10, 2007, 01:42:43 PM
+1
I can't download convert.php
Title: Re: [SMF Converter] IPB 2.2.x
Post by: NF on June 15, 2007, 07:11:13 AM
To get the converter to work, I just used the convert.php file from the other IPB conversion and renamed the "invision22_to_smf.sql" to "invision2_to_smf.sql" and it worked perfectly
Title: Re: [SMF Converter] IPB 2.2.x
Post by: commanderfluffy on June 18, 2007, 07:29:23 PM
Converting attachments... Unsuccessful!
This query:
SELECT
attach_pid AS ID_MSG, attach_location AS oldEncrypt,
attach_hits AS downloads, attach_file AS filename
FROM `shadowne_forums`.ibf_attachments
LIMIT 0, 500;
Caused the error:

Unknown column 'attach_pid' in 'field list'


any help with this i really need this. also when i try and look at my smf forums it doesnt show me anything since the converter failed at that point. any help with that the folder is already chpmod 777 but still no success... any ideas

regards
fluffy
Title: Re: [SMF Converter] IPB 2.2.x
Post by: satchownz on June 20, 2007, 10:05:57 AM
I separated a list of things that are not being converted for sql of ipb 2.2

[img]IMAGEM.jpg\" border=\"0\" class=\"linked-sig-image\" /]

[div align=\"center\"]CONTENT[/div]

[div align=\"right\"]CONTENT[/div]

[!--quoteo--][div class=\'quotetop\']CONTENT[/div][div class=\'quotemain\'][!--quotec--]


Anyone have a fix fir this? I just ran the converter and all the images are not working. Signature images and post images, both are broken.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: satchownz on June 20, 2007, 10:17:19 PM
I ran it again and got the same results. The board converts, but some of the bbcode is messed up. This converter is sooo close.

I have two boards I want to convert when this tool is ready. I'm tinkering with it. Is anyone else having any luck?

There's not much action around here lately.

 ::)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: satchownz on June 26, 2007, 01:54:28 PM
I really would like to use SMF over IPB but so far there has been no support for migrating data and getting set up.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: raffychan on June 30, 2007, 06:05:39 AM
I really need this converter too... I tried it at least 10 times and was able to fix some errors I had at frist (by changing some settings). But still I can't fix what follows:
1) private messages. They were succesfully converted. I checked out my smf pm table, and they all are there... but still, whenever I login, my smf forum keep on displaying "you've 5 new messages on 40" or something like that, but the box is empty... so I think the problem is not related to the converter itself, but there's something wrong when displaying the forum.
2) Attachments. Succesfully converted, but not displayed as clickable thumbnails as it should be (image attachments, I mean). It's not a matter of GD libraries, because I opened a new topic (after the conversion) and uploaded an image attachment, that was displayed as clickable thumbnail.
3) Avatars. This is weird, but it seems that I can't convert them. Avatars uploaded on other sites are succesfully converted, but the ones uploaded on my web space are not displayed when browsing topics... and if I go to my edit profile area, avatar setting, I can see my avatar!!
4) Signatures. Some tags are not proprerly converted, and the signatures are all messed up, even some bbcode.

Any idea?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: satchownz on July 03, 2007, 07:44:47 AM
I think we are out of luck here, there is no support for this converter.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: rvzlady on July 05, 2007, 09:53:02 PM
I am going CRAZY trying to convert my IPB 2.2 to SMF and I'm about ready to give up and sell my domain - I have read and tried EVERYTHING, but something ALWAYS goes wrong. Database too big, cant install SMF to my ibf server, can't install ibf my new server, on and on 3 days straight without sleep, how do I do this "SIMPLE" conversion????????
Title: Re: [SMF Converter] IPB 2.2.x
Post by: gmdb on July 08, 2007, 09:51:59 AM
Hey, when I tried to convert I got an error at the topics converting.

Converting topics... Unsuccessful!
This query:
SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED,
pl.pid AS ID_POLL, t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM (`b33_311902_1`.gmdbtopics AS t, `b33_311902_1`.gmdbposts AS p)
LEFT JOIN `b33_311902_1`.gmdbpolls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0
LIMIT 1000, 500;
Caused the error:

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Please help.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on August 08, 2007, 01:40:01 AM
Are you guys using the .sql file from the first post?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JiGs013 on August 25, 2007, 10:18:53 PM


 excuse me i download the convert.php link but it direct to this link: http://www.simplemachines.org/community/index.php?topic
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on August 26, 2007, 08:37:35 PM
Seems like your copy and paste messed up.  http://www.simplemachines.org/community/index.php?action=dlattach;topic=145284.0;attach=31445
Title: Re: [SMF Converter] IPB 2.2.x
Post by: placebo333 on August 31, 2007, 07:58:32 AM
Hello,
I just did a test conversion from IPB 2.3 to SMF. The converter finnished fine and nearly everything is working fine besides the above mentioned problems with attachments/signatures and that my pm box is empty but showing 1 new post.

1.Fixing PMs not beeing displayed
Code: [Select]
update `smf_pm_recipients` set labels = -1
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Flameykins on September 15, 2007, 02:17:31 AM
Hello,
I just did a test conversion from IPB 2.3 to SMF. The converter finnished fine and nearly everything is working fine besides the above mentioned problems with attachments/signatures and that my pm box is empty but showing 1 new post.

1.Fixing PMs not beeing displayed
Code: [Select]
update `smf_pm_recipients` set labels = -1
Hi, I was wondering what file I can find this in.   I've converted everything but have the same problem with PMs.  They're in the database but don't show up so I'd like to get rid of the labels that are showing new posts.
Kind regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on September 15, 2007, 02:20:50 AM
Need to run that query in phpMyAdmin.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Flameykins on September 15, 2007, 07:40:25 AM
Thank you!

I ran the query and now have all the PM's from IPB showing.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 11, 2007, 11:41:32 AM
Converting poll options...
Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `musiclif_musiclifelong`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('Do you like Musiclifelong?', 1, 255), 'Array', 1, 255), 'Array'),
(1, SUBSTRING('How You feel Here', 1, 255), 'Array', 1, 255), 'Array');
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 ''Array'),
(1, SUBSTRING('How You feel Here', 1, 255), 'Array', 1, 255), ' at line 3



What i have 2 do now
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 11, 2007, 12:04:10 PM
Hello sir Before i got poll chice error so i deleted the polls and i tried now i got this errors and finaly it says successfull but there is no forum Correctly converted 2smf..

Code: [Select]
Converting...

Notice: Undefined index: convert_script in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 580

Warning: Invalid argument supplied for foreach() in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 583

Notice: Undefined index: convert_script in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 945

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 963

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 989

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1037

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1049

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1061

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1071

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1078

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1085

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1111

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1129

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1156

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1193

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1236

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1299

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1354

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1378
Successful.

Help me plz...
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on November 11, 2007, 05:34:05 PM
Are you using the convert files in this topic?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 11, 2007, 10:30:28 PM
yes....

Can i convert once again.????
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on November 12, 2007, 12:34:42 AM
Yes just try running the converter again.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 12, 2007, 01:51:31 AM
Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.








I am getting ..bro can u do for me.....
Plz
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 12, 2007, 02:08:33 AM
Sir ..once plz chk ur inbox to..and help me to solve
Title: Re: [SMF Converter] IPB 2.2.x
Post by: placebo333 on November 12, 2007, 02:17:41 AM
Hi, i just did another test conversion, this time IPB 2.33 to SMF 1.14.

I spend some time looking at signatures as they are all broken after conversion. Following queries will remove unwanted tags and fix most of your signatures, executed in phpmyadmin.

Please do so at your own risk of course  :D

Code: [Select]
UPDATE smf_members SET `signature` = replace(signature,"[size=]","");
UPDATE smf_members SET `signature` = replace(signature,"[/size]","");
UPDATE smf_members SET `signature` = replace(signature,"class=\\\"linked-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"class=\"linked-sig-image\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"border=\\\"0\\\" class=\\\"linked-sig-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,".jpg\\",".jpg");
UPDATE smf_members SET `signature` = replace(signature,".gif\\",".gif");
UPDATE smf_members SET `signature` = replace(signature,".png\\",".png");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"center\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"right\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"left\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[/div]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"[/blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"[blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"","\"");
UPDATE smf_members SET `signature` = replace(signature,"\\'","'");
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 12, 2007, 05:43:11 AM
when i reconvert ...i got following errors ...

Converting yearly events... Unsuccessful!
This query:
SELECT
SUBSTRING(title, 1, 30) AS title,
CONCAT(year, '-', month, '-', mday) AS eventDate
FROM `musiclif_musiclifelong`.ibf_calendar_events
WHERE event_repeat = 1
AND repeat_unit = 'y'
LIMIT 0, 500;
Caused the error:
Table 'musiclif_musiclifelong.ibf_calendar_events' doesn't exis
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on November 12, 2007, 01:06:09 PM
What version of IPB are you using?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 12, 2007, 01:09:01 PM
2.3.1
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on November 13, 2007, 01:55:18 AM
Can I get a database dump of 2.3.x?  Seems like there were a few database changes.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 13, 2007, 06:17:09 AM
plz chk pm
Title: Re: [SMF Converter] IPB 2.2.x
Post by: samuelpage on November 18, 2007, 02:55:21 PM
Hi Jay,

I'm trying to convert my IPB 2.3 using the files from the converter download section. Hoever, I hit a brick wall at the poll options section:

Code: [Select]
Converting poll options...
Notice: Array to string conversion in /home/udqxrza/public_html/forum/convert.php(827) : eval()'d code on line 8

That code repeats many times and then outputs this:

Code: [Select]
Unsuccessful!
This query:

    INSERT INTO `udqxrza_smforum`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('How old where you, or was your child, when diagnosed with dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimination at work?', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('What level of assesement/support is your child at?', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('Do you disclose dyslexia in interviews and/or socially?', 1, 255), 'Array', 1, 255), 'Array'),
    (11, SUBSTRING('Why do you debate?', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Do you think, that dislexic&#39;s use more/have a bigger brain capacity ?', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Which Internet Browser do you Prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (12, SUBSTRING('Has participation in this forum helped anybody ?', 1, 255), 'Array', 1, 255), 'Array'),
    (13, SUBSTRING('Which scenario do you think is correct?', 1, 255), 'Array', 1, 255), 'Array'),
    (14, SUBSTRING('Public Or Private.', 1, 255), 'Array', 1, 255), 'Array'),
    (15, SUBSTRING('Are you diyslexic, and see 3D or not?', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('writing leters', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('Writing cheques', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('people names', 1, 255), 'Array', 1, 255), 'Array'),
    (19, SUBSTRING('who is the worst, depending uopn how histroy reports it, many people take the same path but get a diffent place in histoty', 1, 255), 'Array', 1, 255), 'Array'),
    (20, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (21, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (28, SUBSTRING('Does your dyslexia live in any of the following places?', 1, 255), 'Array', 1, 255), 'Array'),
    (23, SUBSTRING('Who can be trusted to do the right thing?', 1, 255), 'Array', 1, 255), 'Array'),
    (24, SUBSTRING('yes and I think it is due to my dyslexia', 1, 255), 'Array', 1, 255), 'Array'),
    (25, SUBSTRING(' crossword and word puzzles', 1, 255), 'Array', 1, 255), 'Array'),
    (26, SUBSTRING('Do you have or do you think you could have dyslexia and dyspraxia', 1, 255), 'Array', 1, 255), 'Array'),
    (27, SUBSTRING('Which one do you have (or you think is best)', 1, 255), 'Array', 1, 255), 'Array'),
    (30, SUBSTRING('what doe you think of the feed', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('My Dyslexia is a symptom of', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('As well as Reading, Writing, and spelling issues I have', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('Because of your Dyslexia have you developed', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession ARE you in?', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession DO YOU WISH you were in?', 1, 255), 'Array', 1, 255), 'Array'),
    (33, SUBSTRING('I read a theory all dyslexics have Dad&#39;s that fall into one of three corgeies. Which one&#39;s sounds most like your Dad?', 1, 255), 'Array', 1, 255), 'Array'),
    (34, SUBSTRING('Which UK party do you support at the moment?', 1, 255), 'Array', 1, 255), 'Array'),
    (35, SUBSTRING('send him to court or let him go free', 1, 255), 'Array', 1, 255), 'Array'),
    (36, SUBSTRING('How do you feel?', 1, 255), 'Array', 1, 255), 'Array'),
    (37, SUBSTRING('At what age did you discover your dyslexia or your childs dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (38, SUBSTRING('Does anyone have ADD', 1, 255), 'Array', 1, 255), 'Array'),
    (39, SUBSTRING('What would you do?', 1, 255), 'Array', 1, 255), 'Array'),
    (40, SUBSTRING('Cards', 1, 255), 'Array', 1, 255), 'Array'),
    (41, SUBSTRING('Please choose one of the following or leave a post, thank you', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('whta colouere lenses do yuo hvae ', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('do yuo waer thme?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Who&#39;ll win this year?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Will England manage a grand slam?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('And the most important question .... what beer while watching rugby?', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Non-Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (45, SUBSTRING('Do your pets make you feel less stressed?', 1, 255), 'Array', 1, 255), 'Array'),
    (46, SUBSTRING('Have you emailed the BDA yet', 1, 255), 'Array', 1, 255), 'Array'),
    (47, SUBSTRING('How good is your uni / college / school for dyslexics during exam time?', 1, 255), 'Array', 1, 255), 'Array'),
    (48, SUBSTRING('George Bush has spoken of the high point of his presidency what was it ', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('my education level', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('My Dyslexia level', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('did/ do you get humiliated by your teacher?', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('If you could not use the dictionary how was help offered', 1, 255), 'Array', 1, 255), 'Array'),
    (51, SUBSTRING('From first visiting the Being Dyslexic forum how long did it take you before you made your first post?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('How does smoking affect the environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('Why is second hand smoking bad?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('What are your feelings toward smoking?', 1, 255), 'Array', 1, 255), 'Array'),
    (53, SUBSTRING('would you tell a prosective firm you are dysleicx?', 1, 255), 'Array', 1, 255), 'Array'),
    (54, SUBSTRING('Would you be interested in Blogging in a Dyslexia friendly environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How fast do you work?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How tidy and disorganised are you?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('Do you think it will affect your job prospects', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (56, SUBSTRING('Do prefer to learn threw:', 1, 255), 'Array', 1, 255), 'Array');

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 ''Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimin' at line 3

Is there an easy fix for this, your help is very much appreciated.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on November 18, 2007, 10:42:28 PM
IPB 2.3 may not work with the 2.2.x converter.

Jay is working on updating converters, but he is a very busy person :(
Title: Re: [SMF Converter] IPB 2.2.x
Post by: creativemind.mll on November 18, 2007, 11:17:13 PM
Hi Jay,

I'm trying to convert my IPB 2.3 using the files from the converter download section. Hoever, I hit a brick wall at the poll options section:

Code: [Select]
Converting poll options...
Notice: Array to string conversion in /home/udqxrza/public_html/forum/convert.php(827) : eval()'d code on line 8

That code repeats many times and then outputs this:

Code: [Select]
Unsuccessful!
This query:

    INSERT INTO `udqxrza_smforum`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('How old where you, or was your child, when diagnosed with dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimination at work?', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('What level of assesement/support is your child at?', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('Do you disclose dyslexia in interviews and/or socially?', 1, 255), 'Array', 1, 255), 'Array'),
    (11, SUBSTRING('Why do you debate?', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Do you think, that dislexic's use more/have a bigger brain capacity ?', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Which Internet Browser do you Prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (12, SUBSTRING('Has participation in this forum helped anybody ?', 1, 255), 'Array', 1, 255), 'Array'),
    (13, SUBSTRING('Which scenario do you think is correct?', 1, 255), 'Array', 1, 255), 'Array'),
    (14, SUBSTRING('Public Or Private.', 1, 255), 'Array', 1, 255), 'Array'),
    (15, SUBSTRING('Are you diyslexic, and see 3D or not?', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('writing leters', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('Writing cheques', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('people names', 1, 255), 'Array', 1, 255), 'Array'),
    (19, SUBSTRING('who is the worst, depending uopn how histroy reports it, many people take the same path but get a diffent place in histoty', 1, 255), 'Array', 1, 255), 'Array'),
    (20, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (21, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (28, SUBSTRING('Does your dyslexia live in any of the following places?', 1, 255), 'Array', 1, 255), 'Array'),
    (23, SUBSTRING('Who can be trusted to do the right thing?', 1, 255), 'Array', 1, 255), 'Array'),
    (24, SUBSTRING('yes and I think it is due to my dyslexia', 1, 255), 'Array', 1, 255), 'Array'),
    (25, SUBSTRING(' crossword and word puzzles', 1, 255), 'Array', 1, 255), 'Array'),
    (26, SUBSTRING('Do you have or do you think you could have dyslexia and dyspraxia', 1, 255), 'Array', 1, 255), 'Array'),
    (27, SUBSTRING('Which one do you have (or you think is best)', 1, 255), 'Array', 1, 255), 'Array'),
    (30, SUBSTRING('what doe you think of the feed', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('My Dyslexia is a symptom of', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('As well as Reading, Writing, and spelling issues I have', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('Because of your Dyslexia have you developed', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession ARE you in?', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession DO YOU WISH you were in?', 1, 255), 'Array', 1, 255), 'Array'),
    (33, SUBSTRING('I read a theory all dyslexics have Dad's that fall into one of three corgeies. Which one's sounds most like your Dad?', 1, 255), 'Array', 1, 255), 'Array'),
    (34, SUBSTRING('Which UK party do you support at the moment?', 1, 255), 'Array', 1, 255), 'Array'),
    (35, SUBSTRING('send him to court or let him go free', 1, 255), 'Array', 1, 255), 'Array'),
    (36, SUBSTRING('How do you feel?', 1, 255), 'Array', 1, 255), 'Array'),
    (37, SUBSTRING('At what age did you discover your dyslexia or your childs dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (38, SUBSTRING('Does anyone have ADD', 1, 255), 'Array', 1, 255), 'Array'),
    (39, SUBSTRING('What would you do?', 1, 255), 'Array', 1, 255), 'Array'),
    (40, SUBSTRING('Cards', 1, 255), 'Array', 1, 255), 'Array'),
    (41, SUBSTRING('Please choose one of the following or leave a post, thank you', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('whta colouere lenses do yuo hvae ', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('do yuo waer thme?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Who'll win this year?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Will England manage a grand slam?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('And the most important question .... what beer while watching rugby?', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Non-Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (45, SUBSTRING('Do your pets make you feel less stressed?', 1, 255), 'Array', 1, 255), 'Array'),
    (46, SUBSTRING('Have you emailed the BDA yet', 1, 255), 'Array', 1, 255), 'Array'),
    (47, SUBSTRING('How good is your uni / college / school for dyslexics during exam time?', 1, 255), 'Array', 1, 255), 'Array'),
    (48, SUBSTRING('George Bush has spoken of the high point of his presidency what was it ', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('my education level', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('My Dyslexia level', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('did/ do you get humiliated by your teacher?', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('If you could not use the dictionary how was help offered', 1, 255), 'Array', 1, 255), 'Array'),
    (51, SUBSTRING('From first visiting the Being Dyslexic forum how long did it take you before you made your first post?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('How does smoking affect the environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('Why is second hand smoking bad?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('What are your feelings toward smoking?', 1, 255), 'Array', 1, 255), 'Array'),
    (53, SUBSTRING('would you tell a prosective firm you are dysleicx?', 1, 255), 'Array', 1, 255), 'Array'),
    (54, SUBSTRING('Would you be interested in Blogging in a Dyslexia friendly environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How fast do you work?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How tidy and disorganised are you?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('Do you think it will affect your job prospects', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (56, SUBSTRING('Do prefer to learn threw:', 1, 255), 'Array', 1, 255), 'Array');

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 ''Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimin' at line 3

Is there an easy fix for this, your help is very much appreciated.


Delete the polls and reconvert it ...


Then u wont face any prob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on December 10, 2007, 01:59:58 PM
samuelpage use the files on this topic.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: moczymorda on December 19, 2007, 08:11:29 AM
Hi. Im using this nvision22_to_smf.sql file from first post and have one problem:

Quote
Converting smileys... Unsuccessful!
This query:

    ALTER TABLE `gamerz_smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

Powered By IP.Board  2.2.2

Ok im fix this.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: pdavida on January 03, 2008, 01:25:18 AM
   
I am with the same problem of the post above ...

Needs to be done urgently to change ...

Thanks
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 03, 2008, 12:27:10 PM
Use the convert.php in this topic.  http://www.simplemachines.org/community/index.php?topic=140741.0
Title: Re: [SMF Converter] IPB 2.2.x
Post by: pdavida on January 03, 2008, 09:28:07 PM
The error continues .. Arrives this part and will not .. Already tried all sql and convert.php ..

Urgent need of this conversion ..
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 03, 2008, 09:40:02 PM
Edit the .sql file and change LENGTH(code) to code
Title: Re: [SMF Converter] IPB 2.2.x
Post by: pdavida on January 04, 2008, 03:22:32 AM
now

Recalculating forum statistics... Unsuccessful!
This query:

    SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.unreadMessages
    FROM `kazehot_portal`.smf_members AS mem
    LEFT JOIN `kazehot_portal`.smf_pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0 AND pmr.is_read = 0)
    GROUP BY mem.ID_MEMBER
    HAVING realNum != unreadMessages;

Caused the error:

    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Title: Re: [SMF Converter] IPB 2.2.x
Post by: Sarge on January 05, 2008, 05:01:06 AM
    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Download status.php from this post:
http://www.simplemachines.org/community/index.php?topic=49999.msg354073#msg354073

Upload it via FTP to your site and open the page in your browser. For example, if you upload it to your forum folder and your forum is located at yoursite.com/forum/ then you need to visit yoursite.com/forum/status.php

Go to the bottom of the page and click on the "Show more information..." link, or add ?mysql_info=1 to the URL. After the page reloads, search in the page for max_join_size and post the value here.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 11, 2008, 01:27:32 PM
pdavida were you able to convert?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 21, 2008, 05:42:46 AM
Hi, i just did another test conversion, this time IPB 2.33 to SMF 1.14.

I spend some time looking at signatures as they are all broken after conversion. Following queries will remove unwanted tags and fix most of your signatures, executed in phpmyadmin.

Please do so at your own risk of course  :D

Code: [Select]
UPDATE smf_members SET `signature` = replace(signature,"[size=]","");
UPDATE smf_members SET `signature` = replace(signature,"[/size]","");
UPDATE smf_members SET `signature` = replace(signature,"class=\\\"linked-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"class=\"linked-sig-image\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"border=\\\"0\\\" class=\\\"linked-sig-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,".jpg\\",".jpg");
UPDATE smf_members SET `signature` = replace(signature,".gif\\",".gif");
UPDATE smf_members SET `signature` = replace(signature,".png\\",".png");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"center\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"right\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"left\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[/div]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"[/blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"[blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"","\"");
UPDATE smf_members SET `signature` = replace(signature,"\\'","'");

I have managed to (partly) successfully convert from IPB 2.3.3 to SMF 1.1.4, I say partly because attachments and pictures posted do not show!

I get this;
[size=]Kang

[/size][div align=\"center\"][img]http://xxxxxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\" border=\"0\" class=\"linked-image\" /]
 Is there anyway to do for the posts what was done for the signatures?


Bob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 22, 2008, 03:51:17 AM
They might have changed the way they hangle BBC tag.  Again :(.  Post the original IPB message with the problem.  Get it directly from the database.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 22, 2008, 06:13:55 AM
No it's the same for all posted and attached pictures. The converter ran over this step with no problems?

The error comes later with the converted posts:

Quote
I get this;
[size=]Kang

[/size][div align=\"center\"][img]http://xxxxxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\" border=\"0\" class=\"linked-image\" /]


Bob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 22, 2008, 11:19:11 PM
Basically what I need is a routine to strip away all the unwanted tags in the posts, same as was done for the signatures.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 23, 2008, 12:34:13 AM
I need the raw data.  Straight from the database and not the one from the edit screen. IPB stores posts different than what they look on edit.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 23, 2008, 04:21:28 AM
OK I have attached a small dump of the posts table from 233 for you.

Bob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 23, 2008, 04:28:02 AM
Here is data from a topic with photos.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 24, 2008, 02:58:27 AM
Ok give this one a try.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 24, 2008, 03:43:03 AM
Sorry still no luck, see attached file.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 24, 2008, 04:24:50 AM
What is the exact code in SMF right now? Get it from the database.
/me curses IPB's stupid BBC style.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 24, 2008, 04:38:21 AM
Using the same post this is the line out of the smf db;

Quote
INSERT INTO `smf_messages` VALUES(71175, 9934, 135, 1199873939, 1, 0, 'Line up January &#39;08', 'Powerbob', 'bob@xxx.com', '125.27.31.10', 1, 0, '', 'Glad u enjoy the pics.<br /><br />Here some more.<br /><br />[size=]Kang<br /><br />[/size][div align=\\"center\\"][img]http://xxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG\\" border=\\"0\\" class=\\"linked-image\\" /]<br /><br /><br />[img]http://xxx.com/cpg1410/albums/userpics/10001/normal_kang2.JPG\\" border=\\"0\\" class=\\"linked-image\\" /]<br />[/div]', 'xx');

Thanks

Bob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 24, 2008, 04:50:00 AM
Weird.  Try converting again.  I see that the [/div] tag was converted and I had the converter remove it.  Also post the same message but from the IPB database.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 24, 2008, 05:06:41 AM
No Difference, here is the line from IPB db

Quote
INSERT INTO `ibf_posts` VALUES(71175, 0, NULL, 1, 'Powerbob', 1, 1, '125.27.31.10', 1199873939, 0, 'Glad u enjoy the pics.<br /><br />Here some more.<br /><br /><!--sizeo:5--><span style="font-size:18pt;line-height:100%"><!--/sizeo-->Kang<br /><br /><!--sizec--></span><!--/sizec--><div align="center"><img src="http://xxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG" border="0" class="linked-image" /><br /><br /><br /><img src="http://xxx.com/cpg1410/albums/userpics/10001/normal_kang2.JPG" border="0" class="linked-image" /><br /></div>', 0, 9934, NULL, 0, NULL, '3a3860c3a150890e211cfd4e89c5f835', 0, 0, '');
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 24, 2008, 11:30:27 AM
Heh it would help if I pass over the changes to the right file :P.  Here you go.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 25, 2008, 03:34:40 AM
Thanks Jay that worked, photos posted are now showing, I will check through and see what else still is not working. During conversion user avatars were not converted nor were polls, but that is no biggy ;D

Thanks

Bob
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 25, 2008, 04:02:32 AM
Polls should be converted.  What version of IPB are you running?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Powerbob on January 25, 2008, 05:20:08 AM
IPB 2.3.3 but I only had 2/3 polls so no problem for me.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 25, 2008, 11:49:31 AM
Oh ok.  This converter needs its own topic then.  I'll create it later.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: el canadiano on January 31, 2008, 09:52:19 AM
Code: [Select]
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11
Unsuccessful!
This query:

    INSERT INTO `stone_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, 1, "", ),
    (2, 1, "", ),
    (3, 1, "", ),
    (4, 1, "PS2", 0),
    (4, 2, "PS3", 2),
    (4, 3, "X-Box 360", 1),
    (4, 4, "Nintendo Wii", 1),
    (5, 1, "", ),
    (6, 1, "", ),
    (7, 1, "", ),
    (8, 1, "", ),
    (9, 1, "", ),
    (10, 1, "", ),
    (11, 1, "Yay", 3),
    (11, 2, "Nay", 0),
    (12, 1, "IE", 2),
    (12, 2, "Firefox (or the old Netscape)", 2),
    (12, 3, "Opera", 0),
    (12, 4, "Safari", 0),
    (12, 5, "Other", 0),
    (13, 1, "", ),
    (14, 1, "", ),
    (15, 1, "", ),
    (16, 1, "", ),
    (17, 1, "", ),
    (18, 1, "", ),
    (19, 1, "", ),
    (20, 1, "", ),
    (21, 1, "", ),
    (22, 1, "", ),
    (23, 1, "", ),
    (24, 1, "", ),
    (25, 1, "", ),
    (26, 1, "", ),
    (27, 1, "", ),
    (28, 1, "", ),
    (29, 1, "", ),
    (30, 1, "", ),
    (31, 1, "", ),
    (32, 1, "", ),
    (33, 1, "", ),
    (34, 1, "", ),
    (35, 1, "", ),
    (36, 1, "", ),
    (37, 1, "", ),
    (38, 1, "", ),
    (39, 1, "", ),
    (40, 1, "", ),
    (41, 1, "", ),
    (42, 1, "", ),
    (43, 1, "", ),
    (44, 1, "", ),
    (45, 1, "", ),
    (46, 1, "", ),
    (47, 1, "", ),
    (48, 1, "", ),
    (49, 1, "Texas Stadium (Dallas)", 2),
    (49, 2, "Rogers Centre (Toronto)", 1),
    (49, 3, "Allianz Arena (Munich)", 0),
    (49, 4, "Emirates Stadium (London)", 3),
    (49, 5, "Old Trafford (Manchester)", 4),
    (49, 6, "Other (Please specify)", 0),
    (50, 1, "1", 0),
    (50, 2, "2", 1),
    (50, 3, "3", 0),
    (50, 4, "4", 4),
    (50, 5, "5", 1),
    (50, 6, "6", 2),
    (50, 7, "7", 2),
    (50, 8, "8", 0),
    (50, 9, "9", 0),
    (50, 10, "10", 1),
    (50, 11, "11", 1),
    (50, 12, "12", 0),
    (50, 13, "13", 0),
    (50, 14, "14", 0),
    (50, 15, "15", 0),
    (50, 16, "16", 0),
    (50, 17, "17", 0),
    (50, 18, "18", 0),
    (50, 19, "19", 0),
    (51, 1, "Downloads Mod", 2),
    (51, 2, "Downloads Forum", 1),
    (52, 1, "Internet Explorer", 3),
    (52, 2, "Firefox", 13),
    (52, 3, "Safari (Macintosh)", 0),
    (52, 4, "Safari (Windows)", 1),
    (53, 1, "0/5", 0),
    (53, 2, "1/5", 0),
    (53, 3, "2/5", 0),
    (53, 4, "3/5", 1),
    (53, 5, "4/5", 0),
    (53, 6, "5/5", 0),
    (54, 1, "0/5", 0),
    (54, 2, "1/5", 0),
    (54, 3, "2/5", 0),
    (54, 4, "3/5", 1),
    (54, 5, "4/5", 1),
    (54, 6, "5/5", 0),
    (55, 1, "0/5", 0),
    (55, 2, "1/5", 0),
    (55, 3, "2/5", 3),
    (55, 4, "3/5", 0),
    (55, 5, "4/5", 0),
    (55, 6, "5/5", 0),
    (56, 1, "0/5", 0),
    (56, 2, "1/5", 0),
    (56, 3, "2/5", 0),
    (56, 4, "3/5", 1),
    (56, 5, "4/5", 0),
    (56, 6, "5/5", 1),
    (57, 1, "0/5", 0),
    (57, 2, "1/5", 0),
    (57, 3, "2/5", 0),
    (57, 4, "3/5", 0),
    (57, 5, "4/5", 0),
    (57, 6, "5/5", 1),
    (58, 1, "0/5", 0),
    (58, 2, "1/5", 0),
    (58, 3, "2/5", 0),
    (58, 4, "3/5", 0),
    (58, 5, "4/5", 2),
    (58, 6, "5/5", 0),
    (59, 1, "0/5", 0),
    (59, 2, "1/5", 0),
    (59, 3, "2/5", 0),
    (59, 4, "3/5", 1),
    (59, 5, "4/5", 1),
    (59, 6, "5/5", 0),
    (60, 1, "0/5", 0),
    (60, 2, "1/5", 0),
    (60, 3, "2/5", 1),
    (60, 4, "3/5", 0),
    (60, 5, "4/5", 1),
    (60, 6, "5/5", 0),
    (61, 1, "1/5", 0),
    (61, 2, "2/5", 0),
    (61, 3, "3/5", 0),
    (61, 4, "4/5", 0),
    (61, 5, "5/5", 2),
    (62, 1, "0/5", 0),
    (62, 2, "1/5", 0),
    (62, 3, "2/5", 0),
    (62, 4, "3/5", 1),
    (62, 5, "4/5", 0),
    (62, 6, "5/5", 0),
    (63, 1, "0/5", 0),
    (63, 2, "1/5", 1),
    (63, 3, "2/5", 1),
    (63, 4, "3/5", 0),
    (63, 5, "4/5", 0),
    (63, 6, "5/5", 1),
    (64, 1, "0/5", 0),
    (64, 2, "1/5", 0),
    (64, 3, "2/5", 0),
    (64, 4, "3/5", 1),
    (64, 5, "4/5", 1),
    (64, 6, "5/5", 0),
    (65, 1, "0/5", 0),
    (65, 2, "1/5", 0),
    (65, 3, "2/5", 0),
    (65, 4, "3/5", 1),
    (65, 5, "4/5", 0),
    (65, 6, "5/5", 1),
    (66, 1, "1/5", 0),
    (66, 2, "2/5", 0),
    (66, 3, "3/5", 0),
    (66, 4, "4/5", 1),
    (66, 5, "5/5", 1),
    (67, 1, "0/5", 0),
    (67, 2, "1/5", 0),
    (67, 3, "2/5", 0),
    (67, 4, "3/5", 0),
    (67, 5, "4/5", 2),
    (67, 6, "5/5", 1),
    (68, 1, "", ),
    (69, 1, "", ),
    (70, 1, "1/5", 0),
    (70, 2, "2/5", 1),
    (70, 3, "3/5", 2),
    (70, 4, "4/5", 0),
    (70, 5, "5/5", 2),
    (71, 1, "", ),
    (72, 1, "1/5", 1),
    (72, 2, "2/5", 0),
    (72, 3, "3/5", 1),
    (72, 4, "4/5", 0),
    (72, 5, "5/5", 0),
    (73, 1, "I/V", 0),
    (73, 2, "II/V", 1),
    (73, 3, "III/V", 0),
    (73, 4, "IV/V", 0),
    (73, 5, "V/V", 0),
    (74, 1, "1/5", 0),
    (74, 2, "2/5", 0),
    (74, 3, "3/5", 1),
    (74, 4, "4/5", 0),
    (74, 5, "5/5", 2),
    (75, 1, "1/5", 1),
    (75, 2, "2/5", 1),
    (75, 3, "3/5", 0),
    (75, 4, "4/5", 0),
    (75, 5, "5/5", 0),
    (76, 1, "1/5", 0),
    (76, 2, "2/5", 1),
    (76, 3, "3/5", 0),
    (76, 4, "4/5", 0),
    (76, 5, "5/5", 0),
    (77, 1, "1/5", 1),
    (77, 2, "2/5", 0),
    (77, 3, "3/5", 0),
    (77, 4, "4/5", 1),
    (77, 5, "5/5", 1),
    (78, 1, "", ),
    (79, 1, "5/5", 3),
    (79, 2, "4/5", 4),
    (79, 3, "3/5", 4),
    (79, 4, "2/5", 1),
    (79, 5, "1/5", 0),
    (80, 1, "yes", 2),
    (80, 2, "no", 2),
    (81, 1, "Homer", 0),
    (81, 2, "grampa", 0),
    (81, 3, "selma", 0),
    (81, 4, "patty", 0),
    (81, 5, "maggie", 1),
    (81, 6, "bart", 1),
    (81, 7, "lisa", 0),
    (81, 8, "marge", 0),
    (82, 1, "5/5", 6),
    (82, 2, "4/5", 2),
    (82, 3, "3/5", 0),
    (82, 4, "2/5", 0),
    (82, 5, "1/5", 0),
    (82, 6, "0/5", 0),
    (83, 1, "5/5", 2),
    (83, 2, "4/5", 4),
    (83, 3, "3/5", 3),
    (83, 4, "2/5", 0),
    (83, 5, "1/5", 0),
    (83, 6, "0/5", 0),
    (84, 1, "I'll fly to where ever its shown first and camp out for 3 days to be first in line!", 4),
    (84, 2, "I'll be first in line at my local cinema", 4),
    (84, 3, "I'll See it on the first day. Not gonna drop everything to see it though.", 7),
    (84, 4, "I'll see it with in a week.", 6),
    (84, 5, "I'll see it when I see it.", 9),
    (84, 6, "I'm gonna wait until it comes out on DVD", 1),
    (84, 7, "I'll illegally torrent it so I get it for free.", 1),
    (84, 8, "I'll watch it if it comes on TV", 0),
    (84, 9, "I wont see it.", 1),
    (85, 1, "5/5", 1),
    (85, 2, "4/5", 1),
    (85, 3, "3/5", 1),
    (85, 4, "2/5", 0),
    (85, 5, "1/5", 1),
    (85, 6, "0/5", 0),
    (86, 1, "G", 0),
    (86, 2, "PG", 8),
    (86, 3, "M", 3),
    (86, 4, "MA", 1),
    (86, 5, "R", 2),
    (87, 1, "5/5", 2),
    (87, 2, "4/5", 0),
    (87, 3, "3/5", 2),
    (87, 4, "2/5", 0),
    (87, 5, "1/5", 0),
    (87, 6, "0/5", 0),
    (88, 1, "5/5", 2),
    (88, 2, "4/5", 3),
    (88, 3, "3/5", 1),
    (88, 4, "2/5", 1),
    (88, 5, "1/5", 0),
    (88, 6, "0/5", 0),
    (89, 1, "New Wave Of British Heavy Metal (EG: Iron Maiden)", 2),
    (89, 2, "Death Metal (EG: Death, Napalm Death)", 1),
    (89, 3, "Glam Metal (EG: Motley Crue, Bon Jovi)", 3),
    (89, 4, "Thrash Metal (EG: Metallica, Slayer)", 4),
    (89, 5, "Metalcore (EG: Bleeding Through)", 2),
    (89, 6, "Nu Metal (EG: Korn)", 0),
    (89, 7, "Power Metal (EG: DragonForce)", 1),
    (89, 8, "Progressive Metal (EG: Dream Theater)", 1),
    (89, 9, "Hardcore (EG: Parkway Drive, Atreyu)", 2),
    (89, 10, "Hard Rock (EG: Alter Bridge, Audioslave", 2),
    (89, 11, "Other", 2),
    (90, 1, "PC", 15),
    (90, 2, "Mac", 4),
    (91, 1, "Nintendo Wii", 5),
    (91, 2, "Xbox 360", 1),
    (91, 3, "PS3", 3),
    (92, 1, "3G01 - The Springfield Files (January 12, 1997)", 4),
    (92, 2, "3G02 - Lisa's Sax (October 19, 1997)", 6),
    (92, 3, "3G03 - Simpsoncalifragilisticexplialadohcious (February 7, 1997)", 1),
    (92, 4, "3G04 - Simpson Tide (March 29, 1998)", 2),
    (93, 1, "Homer Simpson", 3),
    (93, 2, "Moe Szyslak", 0),
    (93, 3, "Mr. Burns", 2),
    (93, 4, "Ned Flanders", 1),
    (93, 5, "Abraham Simpson", 0),
    (93, 6, "Comic Book Guy", 1),
    (93, 7, "Krusty The Clown", 0),
    (93, 8, "Lionel Hutz", 1),
    (93, 9, "Ralph Wiggum", 5),
    (94, 1, "A", 2),
    (94, 2, "B", 0),
    (94, 3, "C", 1),
    (94, 4, "D", 0),
    (94, 5, "F (Why do they skip E's in grading rubrics?)", 0),
    (95, 1, "Fruits ", 14),
    (95, 2, "Vegetables", 2),
    (96, 1, "5/5", 3),
    (96, 2, "4/5", 0),
    (96, 3, "3/5", 1),
    (96, 4, "2/5", 0),
    (96, 5, "1/5", 0),
    (96, 6, "0/5", 0),
    (97, 1, "A", 4),
    (97, 2, "B", 2),
    (97, 3, "C", 0),
    (97, 4, "D", 0),
    (97, 5, "E (or F)", 0),
    (98, 1, "5/5", 2),
    (98, 2, "4/5", 0),
    (98, 3, "3/5", 1),
    (98, 4, "2/5", 0),
    (98, 5, "1/5 ", 0),
    (99, 1, "In parts - Rapidshare...", 2),
    (99, 2, "All at once - Megashare...", 14),
    (100, 1, "The Simpsons Movie", 11),
    (100, 2, "Spider-Man 3", 3),
    (101, 1, "5/5", 4),
    (101, 2, "4/5", 0),
    (101, 3, "3/5", 0),
    (101, 4, "2/5", 0),
    (101, 5, "1/5", 0),
    (102, 1, "5/5", 4),
    (102, 2, "4/5", 3),
    (102, 3, "3/5", 0),
    (102, 4, "2/5", 0),
    (102, 5, "1/5", 0);

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 '),
    (2, 1, "", ),
    (3, 1, "", ),
    (4, 1, "PS2", 0),
    ' at line 3

What's wrong here?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on January 31, 2008, 08:48:16 PM
-AW- send me an IM.  I need to look into how IPB 2.3.x handles polls now.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: rodo37 on February 02, 2008, 01:50:04 PM
Hello,

I've the following error

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '12' for key 1
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 03, 2008, 09:27:36 PM
Weird.  Did you try running it again?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: rodo37 on February 04, 2008, 05:42:21 AM
Yes. I've also tried to reinstall SMF but same error.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 04, 2008, 02:46:30 PM
Edit the .sql file.

Code: (find) [Select]
INSERT INTO {$to_prefix}membergroups
Code: (replace) [Select]
INSERT IGNORE INTO {$to_prefix}membergroups
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 17, 2008, 10:04:40 PM
Hello Jay,

I need to convert ipb 2.2.2 to SMF immediately because IPB is easting server CPU even being on dedicated server it is slowing down every other site hosted here.

My question:

Most important of all is my attachments in forum. Is there any document that demonstartes what should I do before and afte running convert.php ? I mean the database is translated to SMF but what about attachments folder, where and how do I move it to make if visible to SMF?

Secondly the basic thing, where do I place convert.php and .sql file to run, in ipb forum folder ?
At the end, do I need SMF already installed before running convert.php? if yes, then which verion of SMF I should install before or after conversion?

At end, I have very large forum with more than 100,000 usres and big number of posts and topics, would it be safe to run convert.php to do al conversion at the same time, isn't there any chance of database corruption with this much extensive use?


Waiting for kind quick response.


regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 18, 2008, 01:46:19 PM
1. The converter transfer attachments as well.

2. Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)

3. The converter should handle 100k posts w/o a problem.  If you do run into a problem let me know and I'll point you to the CLI converter.  Covert via the command line.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 18, 2008, 01:55:48 PM
Your respone is highly apprecited.
Besides if ther anoher option that is more secure to use, le menow about it sir.

regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 18, 2008, 01:57:33 PM
They are both secure.  I've converter plenty of forums bigger than yours w/o a problem.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 18, 2008, 02:01:35 PM
Thanks

Besides, it may not fit the topic, but, do you provide sode paid services for conversion sir ?

regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 18, 2008, 07:09:56 PM
You can just become a Charter Member if you want me to do the conversion for you.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: daveb47 on February 22, 2008, 10:00:37 AM
Tryingto convert ipb 2.2.2  to smf1 .1.4 bot getting following error

Code: [Select]
Converting members... Unsuccessful!
This query:

    SELECT
    id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
    joined AS dateRegistered, posts,
    IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
    last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
    msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(email, 1, 255) AS emailAddress,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(location, 1, 255) AS location,
    SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
    IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
    SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
    SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
    SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
    email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
    '' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt, '' AS memberIP
    FROM `arnoldvo_org`.ibf_members
    WHERE id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'password' in 'field list'
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 27, 2008, 06:08:41 AM
Hello again.

At some post within this topic, you suggest a member to drop index of posts table.
I have same error with users table 'Duplicate key...'

My question is:

1. Is it safe to drop index of topics table of the ipb 2.2.2?
2. HOW to drop index using mysql query?


regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 27, 2008, 11:52:28 AM
Tryingto convert ipb 2.2.2  to smf1 .1.4 bot getting following error

Code: [Select]
Converting members... Unsuccessful!
This query:

    SELECT
    id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
    joined AS dateRegistered, posts,
    IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
    last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
    msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(email, 1, 255) AS emailAddress,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(location, 1, 255) AS location,
    SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
    IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
    SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
    SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
    SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
    email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
    '' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt, '' AS memberIP
    FROM `arnoldvo_org`.ibf_members
    WHERE id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'password' in 'field list'
That's weird.  Check in your IPB members table and see if there is a field for password there.

Hello again.

At some post within this topic, you suggest a member to drop index of posts table.
I have same error with users table 'Duplicate key...'

My question is:

1. Is it safe to drop index of topics table of the ipb 2.2.2?
2. HOW to drop index using mysql query?


regards
What section are you getting duplicate index errors?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 27, 2008, 12:26:02 PM
Am getting 'Duplicate key' error at USERS Table sir.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 27, 2008, 12:56:21 PM
Edit the .sql file.

Code: (find) [Select]
---* {$to_prefix}members
---{

Add after.
Code: [Select]
$ignore = true;
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 28, 2008, 02:47:17 AM
Edit the .sql file.

Code: (find) [Select]
---* {$to_prefix}members
---{

Add after.
Code: [Select]
$ignore = true;

Should I add $ignore = true; for every table under same position that reports same error? because now I have sme thing for TOPICS table.

Converting topics... Duplicate entry '13328' for key 1

regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on February 28, 2008, 04:08:43 AM
Yes.  If no ---{ ---} exists you must add them.  So
Code: [Select]
---* {$to_prefix}topics
becomes
Code: [Select]
--- {$to_prefix}topics
---{
$ignore = true;
---}
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on February 29, 2008, 03:02:42 PM
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '30' for key 1


Now error raised at 'permissions'.

Suggest me please.

regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Mudassar Ahmed on March 06, 2008, 01:27:59 PM
I am getting this error, Please Help Me !
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Mudassar Ahmed on March 08, 2008, 05:58:53 AM
SMF Team Please Help Me !
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on March 08, 2008, 12:19:05 PM
My last post was on "February 29, 2008, 03:02:42 PM" am (too) still waiting for your response guys.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on March 19, 2008, 12:48:19 AM
I am getting this error, Please Help Me !
That is a bug with MySQL.  Open the convert.php file.
Code: (find) [Select]
LENGTH(code) DESC;
Code: (replace) [Select]
code DESC;

Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '30' for key 1


Now error raised at 'permissions'.

Suggest me please.

regards
Open the .sql file.
Code: (find) [Select]
INSERT INTO {$to_prefix}membergroups
Code: (replace) [Select]
INSERT IGNORE INTO {$to_prefix}membergroups
Title: Re: [SMF Converter] IPB 2.2.x
Post by: edwardx on March 21, 2008, 06:50:06 PM
Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(910) : eval()'d code:41) in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(913) : eval()'d code on line 61

How should I proceed? I am using Invision 2.3.3
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Nordoelum on March 22, 2008, 05:51:33 PM
As you might have read, this is for IP.Board 2.2.x.

Birger :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Ali Imran on March 22, 2008, 06:00:59 PM
Exactly, no matter what version he is using I get same error while converting

2.2.2   >   SMF


Quote
Fatal error: Cannot redeclare magicmask() (previously declared in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(910) : eval()'d code:41) in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(913) : eval()'d code on line 61

regards
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on March 22, 2008, 10:14:54 PM
Ok try this.  Open the .sql file.

Code: (find) [Select]
function magicMask(&$group)
{
Code: (replace) [Select]
if (!function_exists('magicMask'))
{
function magicMask(&$group)
{

Code: (find) [Select]
}

function smfGroup(&$group)
{
Code: (replace) [Select]
}
}

if (!function_exists('smfGroup'))
{
function smfGroup(&$group)
{

Code: (find) [Select]
}

while (true)
{
pastTime($substep);

$result = convert_query("
SELECT id AS ID_BOARD, permission_array
Code: (replace) [Select]
}
}

while (true)
{
pastTime($substep);

$result = convert_query("
SELECT id AS ID_BOARD, permission_array
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Mudassar Ahmed on March 27, 2008, 07:47:57 AM
Quote
That is a bug with MySQL.  Open the convert.php file.
Code: (find) [Select]
LENGTH(code) DESC;
Code: (replace) [Select]
code DESC;

I am now getting this error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\smf\convert.php on line 1372
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JayBachatero on April 02, 2008, 10:00:12 AM
Seems like part of the file got corrupted when you made the change.  Download it again and make the changes.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Scruffyman on May 03, 2008, 02:01:33 PM
Hi

Nevermind I fixed it:S
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 04, 2008, 03:25:43 PM
hi guys, there's a problem. i tried to convert ipb 2.2.1 to smf 1.1.5 and after using your tips (i had problem and used ignore in poll logs, permissions and magic)...but now the old posts that were good in ipb (using the wysywyg editor) now are not shown properly in smf. Plz see this for example

http://www.laforgia.medusaworks.it/smf/index.php?topic=2417.msg11711#new

and this is my forum
http://www.laforgia.medusaworks.it/smf/index.php

is there anything i can do to adjust the posts?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JohnH on May 05, 2008, 06:59:15 AM
Gah, Im probably doing it all wrong but I get the following error:

SELECT command denied to user 'user'@'localhost' for table 'ibf_members'

I take it this means I need to do something with the databases but being a noob I have no idea what :(
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 05, 2008, 11:44:41 AM
hi guys, there's a problem. i tried to convert ipb 2.2.1 to smf 1.1.5 and after using your tips (i had problem and used ignore in poll logs, permissions and magic)...but now the old posts that were good in ipb (using the wysywyg editor) now are not shown properly in smf. Plz see this for example

http://www.laforgia.medusaworks.it/smf/index.php?topic=2417.msg11711#new (http://www.laforgia.medusaworks.it/smf/index.php?topic=2417.msg11711#new)

and this is my forum
http://www.laforgia.medusaworks.it/smf/index.php (http://www.laforgia.medusaworks.it/smf/index.php)

is there anything i can do to adjust the posts?

Is there something I am not seeing? They look fine, I see the signatures need to be repaired a little but adding/editing the regex that fixes it shouldn't be to hard to accomplish this.

JohnH,
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: JohnH on May 05, 2008, 04:35:31 PM
Thanks, However it would seem that I need to add the user for the smf database so that it is able to use my IPB database, and my CP is not able to do this, is there any way to do this in phpMyAdmin? or shall I have to contact my host?

Edit: Resolved by installing SMF into IPB database

New error when converting:

Quote
Converting topics...The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 05, 2008, 10:46:00 PM
Open the .sql file and find this:
Code: [Select]
---* {$to_prefix}topics
Replace it with:
Code: [Select]
---* {$to_prefix}topics 200
This will make the converter only do 200 topics at time. This should hopefully help and let you get through the topics conversion.
You may also ask your host about that error, they should know what it means and can tweak the mysql configuration settings to change it.

I am thinking for the 2.0 convert.php script, that I might add some testing to attempt to set the variables to allow it to do big selects if the host allows it to be done.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 06, 2008, 03:31:07 PM
Hi, the problem is the folowing....the html tag is not properly converted.

see this for example

http://www.laforgia.medusaworks.it/smf/index.php?topic=2413.msg11711#new

and the corrispondent one

http://laforgia.medusaworks.de/forum/index.php?showtopic=2413&pid=11514&st=0&#entry11514

do u see the photos? and the links?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 06, 2008, 04:28:11 PM
Does this one prove better results?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 07, 2008, 10:12:18 AM
the problem still persists....this is the output

p.s. i made modification in permissions, log polls and magic function to let the script works...(modification in past page)

Code: [Select]
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1160727449.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1160727603.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1160727704.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1160727746.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1160727793.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160742448.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160742548.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160742686.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160743217.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160743987.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160744078.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1170678276.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160744818.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160744907.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160744998.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745130.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745171.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745265.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745476.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745563.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745739.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745788.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745842.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160745968.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746092.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746138.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746204.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746287.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746358.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-2-1161528603.jpg) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-3-1160746712.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1168639714.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21

Warning: copy(/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/forum/uploads/post-1-1167227708.ipb) [function.copy]: failed to open stream: No such file or directory in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 21
Successful.
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-2.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-3.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-5.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-12.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-15.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-19.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-20.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-30.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-33.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-38.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-41.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-42.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-43.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-54.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-55.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-61.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-66.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-67.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-69.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-72.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-74.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-90.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-89.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-92.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-94.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-96.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-115.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-123.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-124.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-126.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-130.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-134.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-151.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-156.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-160.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-255.jpeg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-184.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-214.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-216.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-218.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-243.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-254.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-256.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-261.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-264.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-300.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-308.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-320.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-337.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-338.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-347.gif) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-348.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-365.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-380.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-411.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 58

Warning: copy() [function.copy]: open_basedir restriction in effect. File(/av-424.jpg) is not within the allowed path(s): (/srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs:/tmp) in /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/convert.php(1075) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 07, 2008, 12:07:23 PM
Well I do see an error in the avatars part.

The attachments are first failing because the upload directory defined in IPB is invalid. Make sure that you have the correct path defined in your IPB settings.

The avatars where using the wrong variable though. This one should fix that.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 07, 2008, 04:55:52 PM
Nothing sorry, the html tags are not corectly interpreted :( ...the errors in avatar and attachment were due to the fact that in the uploads dir there aren't the old ipb files...i still have warning but i don't think they cause the failing in the html tags in posts.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 07, 2008, 08:01:38 PM
Can you attach in a text file the original post from IPB that has this issue?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 08, 2008, 01:39:40 AM
all the posts having html tag inside are bad read.

here is a post from ipb (i attached this from a fast edit, so i can attach it in bbcode and not in wysywyg)

Code: [Select]
[url=http://www.mapchannels.com/DualMaps.aspx]Dual Maps </b>[/url]è il nuovissimo servizio lanciato da [url=http://www.mapchannels.com/]MapChannel[/url] (sito-tool meritevole di un apposito post dedicato che arriverà a breve).


Con [b]Dual Maps[/b] puoi creare molto facilmente una mappa
(embeddabile in qualsiasi blog/sito) in cui la stessa località viene
visualizzata contemporaneamente, fianco a fianco, in [b]Google Maps[/b] e [b]Microsoft Virtual Earth[/b].


La cosa è particolarmente interessante per quelle città già coperte dal servizio [b]Bird’s Eye View[/b], cioè le foto aeree scattate a distanza ravvicinata e a volo d’uccello, cioè con un’inclinazione di 45 gradi.


Qui nell’esempio, la zona del Porto di [b]Napoli[/b], con il dettaglio del [b]Maschio Angioino[/b]:


[url=http://data.mapchannels.com/mm/dual/map.htm?x=14.25309&y=40.83827&z=17&xb=14.25309&yb=40.83827&bar=1&mw=1&gm=2&ve=3&mi=0&mt=Maschio%20Angionino%20-%20Napoli&md=][img]http://www.dynamick.it/wp-content/uploads/dual_map.jpg[/img][/url]


In questo caso ho linkato semplicemente l’immagine al permalink, ma si può far funzionare [s]la mappa[/s] le mappe direttamente nel blog, grazie a un iframe di cui ti viene fornito il codice:


[i]<iframe style="width:100%;height:500px;padding:0;border:solid
1px black"
src="http://data.mapchannels.com/mm/dual/map.htm?x=14.25309&y=40.83827&z=17&gm=2&ve=3&xb=14.25309&yb=40.83827&zb=0&db=0&bar=1&mw=1&mi=0&mt=Maschio
Angionino - Napoli" marginwidth="0" marginheight="0" frameborder="0"
scrolling="no"></iframe>[/i]


Tra l’altro, se vuoi modificare qualche settaggio dopo avere già inserito l’iframe nel tuo [b]blog[/b], non devi per forza ritornare in [url=http://www.mapchannels.com/DualMaps.aspx]MapChannel[/url] e ricreare la mappa, ma puoi anche modificare i parametri direttamente nell’[b]iframe[/b], grazie alla istruzioni veramente for dummies contenute nella stessa pagina.


Altra caratteristica interessante è la possibilità di includere
nella mappa anche le foto a 360 gradi di Google Streetview, ovviamente
per le città già coperte dal servizio (al momento quindi solo le più
importanti città degli Stati Uniti).


Volendo, infine, è possibile anche massimizare sia l’una che l’altra mappa, cliccando sul divisorio centrale.


here is the converted post in smf

Code: [Select]
[url=http://www.mapchannels.com/DualMaps.aspx]Dual Maps </b>[/url]è il nuovissimo servizio lanciato da [url=http://www.mapchannels.com/]MapChannel[/url] (sito-tool meritevole di un apposito post dedicato che arriverà a breve).


Con [b]Dual Maps[/b] puoi creare molto facilmente una mappa
(embeddabile in qualsiasi blog/sito) in cui la stessa località viene
visualizzata contemporaneamente, fianco a fianco, in [b]Google Maps[/b] e [b]Microsoft Virtual Earth[/b].


La cosa è particolarmente interessante per quelle città già coperte dal servizio [b]Bird’s Eye View[/b], cioè le foto aeree scattate a distanza ravvicinata e a volo d’uccello, cioè con un’inclinazione di 45 gradi.


Qui nell’esempio, la zona del Porto di [b]Napoli[/b], con il dettaglio del [b]Maschio Angioino[/b]:


[url=http://data.mapchannels.com/mm/dual/map.htm?x=14.25309&y=40.83827&z=17&xb=14.25309&yb=40.83827&bar=1&mw=1&gm=2&ve=3&mi=0&mt=Maschio%20Angionino%20-%20Napoli&md=][img]http://www.dynamick.it/wp-content/uploads/dual_map.jpg[/img][/url]


In questo caso ho linkato semplicemente l’immagine al permalink, ma si può far funzionare  le mappe direttamente nel blog, grazie a un iframe di cui ti viene fornito il codice:


[i]<iframe style="width:100%;height:500px;padding:0;border:solid
1px black"
src="http://data.mapchannels.com/mm/dual/map.htm?x=14.25309&y=40.83827&z=17&gm=2&ve=3&xb=14.25309&yb=40.83827&zb=0&db=0&bar=1&mw=1&mi=0&mt=Maschio
Angionino - Napoli" marginwidth="0" marginheight="0" frameborder="0"
scrolling="no"></iframe>[/i]


Tra l’altro, se vuoi modificare qualche settaggio dopo avere già inserito l’iframe nel tuo [b]blog[/b], non devi per forza ritornare in [url=http://www.mapchannels.com/DualMaps.aspx]MapChannel[/url] e ricreare la mappa, ma puoi anche modificare i parametri direttamente nell’[b]iframe[/b], grazie alla istruzioni veramente for dummies contenute nella stessa pagina.


Altra caratteristica interessante è la possibilità di includere
nella mappa anche le foto a 360 gradi di Google Streetview, ovviamente
per le città già coperte dal servizio (al momento quindi solo le più
importanti città degli Stati Uniti).


Volendo, infine, è possibile anche massimizare sia l’una che l’altra mappa, cliccando sul divisorio centrale.



the right post is the following

http://laforgia.medusaworks.de/forum/index.php?showtopic=2330 (http://laforgia.medusaworks.de/forum/index.php?showtopic=2330)

and here is the converted in smf 1.1.5

http://www.laforgia.medusaworks.it/smf/index.php?topic=2330.0 (http://www.laforgia.medusaworks.it/smf/index.php?topic=2330.0)

it seems that i purely read html tags as normal text.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 08, 2008, 02:31:47 AM
besides a stranded </b> the only other html I see is the iframe.

Is this correct?

The stranded </b> I could fix. the iFrame does not have a valid bbc in SMF and since you must be an admin to post html, well you can't really get around that. I could have it attempt to the the html tags around the iframe but not much else could be done.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 08, 2008, 03:07:56 AM
No slepy if u see, for example the row

Code: [Select]
[url=http://www.mapchannels.com/DualMaps.aspx]Dual Maps </b>[/url]è il nuovissimo servizio lanciato da [url=http://www.mapchannels.com/]MapChannel[/url] (sito-tool meritevole di un apposito post dedicato che arriverà a breve).

when i see the post i exactly see the rows, and not the right link.

so for example if i have a post showing an image, i don't see the image, but only the (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2F.....tag&hash=1fd917c2bdf5c68895ea93804873e3b6)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 08, 2008, 11:54:51 AM
When I copied it into a test install of SMF I had it worked fine. Images showed and everything. The only issue was the </b>

Do you have image width and height restrictions being set? That could possibly be the issue here.
I can't even get that page to load :|
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 09, 2008, 07:42:32 AM
if u want i can give to u mymsql database in order to let u make a try...
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 09, 2008, 09:26:02 PM
Are you sure you are running the converter again with the new SQL file I gave you?
It should be fixing the </b> into its proper format.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 10, 2008, 07:46:40 PM
yes i tried..are u interested in my db?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 10, 2008, 10:11:13 PM
You can send me your details and see if I can't get it to convert.
I will be busy the next few days but hopefully will find time to look at this.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 11, 2008, 07:47:06 AM
You can send me your details and see if I can't get it to convert.
I will be busy the next few days but hopefully will find time to look at this.

No problem, do u have a msn to send the database ? tnx a lot for your interest :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 11, 2008, 10:56:01 AM
You can just send it to my simplemachines email address.
Hopefully this posts right as its all html entities: sleepy@simplemachines.org
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 11, 2008, 03:26:49 PM
the db zipped is 11 mb, is it ok for your mail? i use gmail.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 11, 2008, 11:16:23 PM
It will be fine. I got it on my computer. So I will try to look at this possibly monday night (just to tired to work tonight).
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 12, 2008, 10:20:53 PM
I see why its happening.
 In the database it has it as "&lt;/b&gt;" instead of "</b>".
 This is why the convert file isn't

That is simple enough. This one should force it to parse that above string as a bbc code.

 If there is any others let me know of them. Most of them can be added (Only ones with bbc code translations as SMF doesn't allow html in posts for security reasons).

The iframe wouldn't be fixable without comprising security. I could detect it and add the [html][/html] around it (only admins can use those tags in posts, since the conversion converts it, it can be inserted into the database with the html tags and wouldn't go through the security parser that occurs when you post). But then if anyone had posted something in IPB that was a bad site, it would be usable on the SMF forum.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 13, 2008, 11:41:04 AM
wow now it seems alla correct. Tnx sleep u were very gentle, tnx a lot :) if i'll found some bugs i'll comunicate them to you.

p.s. only one question...this sql will be ok also to smf 2.0 final?

edit: i have a problem in personal messages. if i try to read them i have this error

Code: [Select]
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
File: /srv/www/vhosts/medusaworks.it/subdomains/www.laforgia/httpdocs/smf/Sources/PersonalMessage.php
Linea: 381
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 13, 2008, 11:53:00 AM
The 2.0 converters are not ready yet.

I wouldn't expect to see them either until after the 2.0 Final release :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 13, 2008, 01:08:38 PM
tnx sleepy, plz see the errore reported in my previous post.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 13, 2008, 01:12:34 PM
That error is saying for some reason there is a table or column in the database that is not set to utf-8.

In your Admin -> Forum Maintenance do you have the option to convert to UTF-8?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 13, 2008, 01:26:50 PM
yes
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on May 13, 2008, 01:34:34 PM
but it doesn't work
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 13, 2008, 04:39:55 PM
Ok, well the second way to fix it is a little harder and requires some work then :|

The reason you get that error is one of the table or a column in it does not match another table or column that is being used i the same query.

To fix it. You will need to use something such as phpMyAdmin What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
First go to your database and look at all your tables. They should all say "utf8_general_ci" for the character type.
Now for each of those tables (which is where this takes time) you will need to go in and click on the structure tab.
Then you can view each column and make sure it says "utf8_general_ci" for the character type.

If any of those doesn't say "utf8_general_ci" then you will need to click the edit icon and change it to be "utf8_general_ci"
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Elkaz on May 29, 2008, 03:59:37 PM
Hello all.
I have a problem - I need to convert IPB 2.2.2 => SMF 2.0 Beta 3.1. Can I do this?
If no - when it will be available?
Thanks.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on May 30, 2008, 12:27:23 AM
At this time and point the 2.0 converters are not released (and I don't think they will be until after 2.0 is final.

You can convert to 1.1 and then just perform a large upgrade to 2.0 :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Elkaz on May 30, 2008, 05:03:05 PM
Wow, thanks a lot. I will try it soon.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: MaNaRa on June 12, 2008, 12:12:27 PM
error in the converter:

Code: [Select]
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Recalculating forum statistics...
Notice: Undefined index: latestMember in /home/usuarios/foro/convert.php on line 1344

Notice: Undefined index: latestRealName in /home/usuarios/foro/convert.php on line 1345
Successful.

Help me, please
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on June 12, 2008, 12:16:21 PM
Do all your members, posts, etc convert?

If they did just go to Admin -> Forum Maintenance
Do a recount totals and Stats as well as Find and repair Errors :)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: alado on July 03, 2008, 03:10:03 AM
Good day. Download a Converters for SMF 1.1 (http://www.simplemachines.org/download/?converters)
SMF version 1.1.5
IPB version 2.2.2

Two forum put into one database! Run convert.php

Code: [Select]
Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Unsuccessful!
This query:
SELECT
SUBSTRING(title, 1, 30) AS title,
CONCAT(year, '-', month, '-', mday) AS eventDate
FROM `z58416_ipb`.ibf_calendar_events
WHERE event_repeat = 1
AND repeat_unit = 'y'
LIMIT 0, 500;
Caused the error:

Table 'z58416_ipb.ibf_calendar_events' doesn't exist



What could be wrong?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: ThorstenE on July 03, 2008, 03:29:32 AM
i think you are using the invision2_to_smf.sql from the download-page. Download the new version from the first post attached in this topic (http://www.simplemachines.org/community/index.php?topic=145284.msg925365#msg925365) and the convert.php from this topic (http://www.simplemachines.org/community/index.php?topic=140741.0)

don't forget to delete the old  invision2_to_smf.sql and convert.php first..
Title: Re: [SMF Converter] IPB 2.2.x
Post by: alado on July 03, 2008, 03:32:49 AM
i think you are using the invision2_to_smf.sql from the download-page. Download the new version from the first post attached in this topic (http://www.simplemachines.org/community/index.php?topic=145284.msg925365#msg925365) and the convert.php from this topic (http://www.simplemachines.org/community/index.php?topic=140741.0)

don't forget to delete the old  invision2_to_smf.sql and convert.php first..

Thanks
Title: Re: [SMF Converter] IPB 2.2.x
Post by: mikungfu on July 27, 2008, 02:12:58 AM
I have posted this post elsewhere, but I was advised to post it here.

Using several "invision22_to_smf" files that I downloaded from several sections of this topic, I have tried to convert my IPB 2.2.2 into my SMF 1.1.5. The best results I got so far was with a "invision22_to_smf" I found was in page 9 of this topic, and using it I got the following error:

Converting...

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars...
Warning: copy(/home/thanatos/public_html/forun/attachments/av-896.jpg) [function.copy]: failed to open stream: No such file or directory in /home/thanatos/public_html/forun/convert.php(827) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.

Conversion Complete
Apart from what it says here about Avatars (which I don't know what it means, specially since there were no avatars in my IPB), what I noticed is that although there is a link to Private Messages and although it even says I have 7 PMs, the truth is that when I click on the link, it shows no PMs at all.

Also, although all categories, posts, members and even attachments were converted, I noticed that once I click on a title of a category or a board, it changes from bold into regular font... Which is not nice, since I'd like them to keep bold. Why is that? It didn't use to be that way in IPB...

Thanks. 
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on July 27, 2008, 02:30:26 AM
Run this query via phpMyAdmin:
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
 
Code: [Select]
UPDATE smf_pm_recipients
SET labels = '-1';
Title: Re: [SMF Converter] IPB 2.2.x
Post by: mikungfu on July 27, 2008, 05:56:04 AM
Thank you very much!.. :D

It seems to have solved the PMs problem. About the bold/regular font problem in the boards categories and titles, it seems to be a bug of the Blazev1 Theme I'm using. I'll try to fix that in the css or something.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: MrRundog on September 06, 2008, 09:32:39 PM
What are the definitive sql and convert.php files for 2.2 to smf please - I seem to be going round in circles attempting to use the correct ones (convert.php in the link above just sends me back & forth from post to post. Could someone please attach.

Cheers
Title: Re: [SMF Converter] IPB 2.2.x
Post by: ThorstenE on September 07, 2008, 02:27:53 AM
use the ipb22_to _smf.sql from the first post of this topic (attached) and the convert.php from the first post of this (http://www.simplemachines.org/community/index.php?topic=140741.0) (attached, scroll down)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: rsk on September 15, 2008, 11:51:52 AM
Hi,

I have been attempting to convert a  fairly large forum, but kept having issues with duplicate keys when converting the members.

I finally had some time to take a proper look today, and running the sql  below before running the script seems to have sorted it.
Code: [Select]
ALTER TABLE {$invision_prefix}_members ORDER BY id ASC
I don't know if this is a common problem with conversions or not as I guess we are going the other way to a lot of people who have this much data to deal with, but I thought I'd leave a quick note here incase others are having a similar problem.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on September 19, 2008, 01:53:41 AM
Thanks for the information.

Just want to ask. Where you by chance clicking the continue button?
I have seen duplicate errors happen when people click the continue button even though the auto-continue has already reached zero. Which results in a double submission.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: scimmiotto on September 21, 2008, 06:29:16 PM
nothing to add to help/request here. I just only wanted to say tnx to sleepy for support, now my board is fully operative and working from ipb 2.2.1.

http://laforgia.nsn3.net

Tnx a lot sleepy, SMF simply rocks, it is speedy and highly configurable, another world compared to ipb, tnx a lot :)

p.s. only one question...when 2.0 will be released, i'll be able to upgrade from my actual 1.1.6 to 2.0?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on September 22, 2008, 12:22:15 AM
Well 2.0 is released as beta :P (Currently 2.0 Beta 4 Public)

But yes, you can upgrade to 2.0 by using the Large upgrade package.
Our Doc site has more information about upgrading SMF though :)
http://docs.simplemachines.org/index.php?board=3.0
Title: Re: [SMF Converter] IPB 2.2.x
Post by: rsk on September 25, 2008, 09:54:30 AM
Just want to ask. Where you by chance clicking the continue button?

No, it was being run in a shell, 2.3millions posts to convert, takes an hour in a shell, hate to think how long it would take with the delays using the HTTP method
Title: Re: [SMF Converter] IPB 2.2.x
Post by: collst on January 08, 2009, 02:12:49 PM
I convert 2.2.2 IPB to SMF 1.1.7
Using files http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-7_invision22_converter.zip

1. Instead of tags (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2F&hash=b9c0ac6f345ba4312769fc20001b8e65) i've got
[img]http://s58.radikal.ru/i159/0811/49/1ef1b4d32785.jpg\" border=\"0\" class=\"linked-image\" /]

2. When I trying to "fiand and fix all errors" in admin panel - i lost all users - they transformes to guests
Title: Re: [SMF Converter] IPB 2.2.x
Post by: ThorstenE on January 08, 2009, 02:26:18 PM
Any errors during the conversion (please post them here) or was it successful?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: collst on January 08, 2009, 02:41:16 PM
Any errors during the conversion (please post them here) or was it successful?
there were no any errors during to conversions
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on January 10, 2009, 06:16:34 PM
Can you give us the raw data of such a post from IPB?
To do this you need the message id of the post (For IPB I would have to look this up, but usually its sent to output somewhere on the page). Then just load up phpMyAdmin to find the message.

This way I have the contents of how they are stored in the IPB database before SMF, IPB or the converter is getting to play with it :D
Title: Re: [SMF Converter] IPB 2.2.x
Post by: 88pathoffroad on March 05, 2009, 09:00:42 PM
Hi all. I'm in the midst of trying to export a large IPB 2.2 DB (280 MB) from one server/domain and get it imported on a different server/domain. Problem is, I can't import a DB over 50 MB or so via phpMyAdmin and I'm honestly not all that well versed on SQL to begin with.

I have a copy of the DB in question on my local computer and on the destination server. I uploaded it via FTP to the base directory that SMF is running in.

When I run the converter it just gives me "Unable to find the settings for Invision Power Board 2.2. Please double check the path and try again." Both paths are the same because that's where I uploaded the DB. Can someone straighten me out? Thanks for your time.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: 88pathoffroad on March 05, 2009, 11:12:21 PM
Well, this is different. I attempted it again using the same exact parameters and got this:

Quote
ERRORS

Ouch.

I checked the SMF install, nothing changed. No users, no posts, etc.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: ThorstenE on March 06, 2009, 03:52:41 AM
this means the session was broken during conversion. try to restart the conversion from the beginning...
Title: Re: [SMF Converter] IPB 2.2.x
Post by: 88pathoffroad on March 06, 2009, 02:29:33 PM
Tried: same result. Over and over.

Also tried creating a conf_global.php file with the appropriate data as suggested in the main forum. That gave me an error because the current user wasn't allowed access to the IPB DB.

Quote
Notice: Use of undefined constant sql_database - assumed 'sql_database' in /home/damaged/public_html/nporabeta/conf_global.php on line 2

Notice: Use of undefined constant sql_tbl_prefix - assumed 'sql_tbl_prefix' in /home/damaged/public_html/nporabeta/conf_global.php on line 3

Quote
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'damaged'@'localhost' for table 'ibf_members'


I then set permissions for the IPB DB to 777...still doesn't work. What am I missing here?
Title: Re: [SMF Converter] IPB 2.2.x
Post by: ThorstenE on March 06, 2009, 02:52:56 PM
the mysql user from SMF (specified in Settings.php) must be allowed to read the IPB database or the converter won't work..

Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] IPB 2.2.x
Post by: Luigibnu on May 27, 2009, 08:26:16 PM
1. Instead of tags (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2F&hash=b9c0ac6f345ba4312769fc20001b8e65) i've got
[img]http://s58.radikal.ru/i159/0811/49/1ef1b4d32785.jpg\" border=\"0\" class=\"linked-image\" /]

I'm getting the same error, and no error on the convertion!
Title: Re: [SMF Converter] IPB 2.2.x
Post by: SleePy on June 09, 2009, 06:02:22 PM
IPB only started using that sort of html in version 2.3. You are using the wrong version of the converter.
Title: Re: [SMF Converter] IPB 2.2.x
Post by: knightofdoom on June 11, 2010, 06:56:22 AM
I had the same problem.. but now its resolved
thx
SMF FTW
Title: Re: [SMF Converter] IPB 2.2.x
Post by: aradzish on September 26, 2011, 05:06:42 PM
Dear members,

I'm trying to migrate from IPB 2.2.1 to SMF 2.0.1. Conversion of my existing IPB database gives error:

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

I tried all existing converters (all versions). I also tried some suggestions that I could found in different topics, for example, tried to add this code

---{
/* Fix for invalid birthdays */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
   $row['birthdate'] = '0001-01-01';
---}

just after this:

---* {$to_prefix}members

However, no luck at all so far.
My forum is in CP1251.
Is there any chance that someone can try to convert the database for me? I can provide full DB dump.
I count on your kind help.


Title: Re: [SMF Converter] IPB 2.2.x
Post by: paddysmith on March 14, 2012, 04:56:51 AM
I Updated!!!



Thanks to sharing........






Title: Re: [SMF Converter] IPB 2.2.x
Post by: Craw on September 28, 2017, 08:55:02 PM
Hi. I can't seem to find the info I need. All I'm seeing on the previous posts are SMF 1.x forums. Will this converter work for SMF 2.0.x?