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.
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
thanks ;)
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
Ok I updated the converter. I had a type-o causing the attachments step to use the wrong column names.
Hi there,
Using both the updated .sql and php files, I still get the
QuoteDuplicate 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
:)
Where do you get the duplicate entry? What table?
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
Quote from: JayBachatero on January 28, 2007, 01:26:14 PM
Where do you get the duplicate entry? What table?
Hallo, its in the posts table
Quote from: TonyL on January 29, 2007, 04:24:49 PM
Quote from: JayBachatero on January 28, 2007, 01:26:14 PM
Where do you get the duplicate entry? What table?
Hallo, its in the posts table
Try dropping the index in the posts table.
Oeps missed that one thanks m8
The poll that have a multiple questions are converted correctly?
Quote from: Prof on February 03, 2007, 01:08:33 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.
Hi there. I get the following error:
QuoteConverting 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
Quote from: EDivMountie on February 04, 2007, 03:15:12 PM
Hi there. I get the following error:
QuoteConverting 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)
Quote from: JayBachatero on February 05, 2007, 01:27:20 AM
Quote from: EDivMountie on February 04, 2007, 03:15:12 PM
Hi there. I get the following error:
QuoteConverting 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:
QuoteAt 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
What does $mmessage say in Settings.php?
Hmmm... that is kind of screwed up. The message is listed twice, and the line breaks are all messed. I will fix it. Thanks.
I'll fix this for this converter as well. The 2.0.0 had the same problem.
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
What do you mean that they show up as a label?
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?
Try this converter.
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
:(
Try emptying the topics table and messages table.
:( after converting I cant see any posts...
Did any of the steps fail?
Hi, my name is Lars.
I tryed the converter and the last sql-file from this post to convert an IPB 2.2 with latest fixes to SMF 1.1.2. It works nearly good. (about 50.000 posts) Just one error was written out:
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58
Warning: copy(/av-2.gif) [function.copy]: failed to open stream: No such file or directory in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58
Warning: copy(/upload:av-5.jpg) [function.copy]: failed to open stream: No such file or directory in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\xampplite\www\smf\convert.php(829) : eval()'d code on line 58
This is the code from convert.php (Line 829)
<826> while ($row = convert_fetch_assoc($special_result))
<827> {
<828> if ($special_code !== null)
<829> eval($special_code);
But in my opinion it comes out of the sql-file. This is the only file, where something is written about "oldAvatarDir". It seems, that the upload-directory isn't set right.
greetings shadow2004
Try this file.
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'
----
How do we use the attached .sql files?
I mean, do we just import it into a new database? Or..?
Can you get me a database structure for the attachments table?
error in converting:
QuoteConverting attachments... Unsuccessful!
This query:
SELECT
attach_pid AS ID_MSG, attach_location AS oldEncrypt,
attach_hits AS downloads, attach_file AS filename
FROM `annbr_forum`.annbr_attachments
LIMIT 0, 500;
Caused the error:
Unknown column 'attach_pid' in 'field list'
in invision22_to_smf.sql
line 996:
Quoteattach_pid AS ID_MSG, attach_location AS oldEncrypt,
to
Quoteattach_id AS ID_MSG, attach_location AS oldEncrypt,
in the folder of uploads of ipb 2,2 of chmod777 in all archives, so that in the following step the archives are transferred to the folder of smf
JayBachatero, has a problem with the converted signatures it had come with codes HTML and instructions of divs
Can you post the problem with the sig? Also post the before and after effect. Make sure to get them straight from the database.
before
[font=Verdana][right][color=#000080]RPG:[/color] [url=http://www.annbr.com/forum/index.php?showtopic=66][color=#8B0000]Sétimo[/color][/url].[url=http://www.annbr.com/forum/index.php?showtopic=67]Chama da Fênix[/url] ~ [url=http://www.annbr.com/forum/index.php?showtopic=154][color=#2E8B57]Demona[/color][/url].[url=http://www.annbr.com/forum/index.php?showtopic=148&st=0]Badges[/url]
[img]http://i111.photobucket.com/albums/n139/victorvaz/sign_setimo2.jpg[/img]
[color=#000080]Grupos:[/color] [url=http://img340.imageshack.us/img340/4423/agspamqn1.jpg]Spam Team[/url] ~ [url=http://img273.imageshack.us/img273/4801/bannerrpgzc4.jpg] RPG Yeah![/url] ~ [url=http://img60.imageshack.us/img60/8097/pfspartidofloodersocialnk5.png] PFS[/url] ~ [url=http://img297.imageshack.us/img297/9079/xdcopyfg4.jpg]xD[/url]
[url=http://www.annbr.com/forum/index.php?showtopic=2105&st=0#entry33143][img]http://serv2.imagehigh.com/imgss/5493557_Comicbannerspawn.jpg[/img][/url]
[color=#000080]Noivete:[/color] [url=http://www.annbr.com/forum/index.php?showuser=100]Mila-Chan[/url] [color=#000080]Manhê:[/color] [url=http://www.annbr.com/forum/index.php?showuser=15]Sakuragome[/url]
[img]http://www.sedentario.org/wp-includes/images/yahoo/winkwink.gif[/img] [url=http://www.annbr.com/forum/index.php?showtopic=2244&hl=][color=#8B0000]Desafio for Seven[/color]... Vote... ou não[/url][/right][/font]
after
[div align=\"right\"]RPG: . ~ .
[img]http://i111.photobucket.com/albums/n139/victorvaz/sign_setimo2.jpg\" border=\"0\" class=\"linked-sig-image\" /]
Grupos: ~ ~ ~ ~
Noivete: Manhê:
[img]http://www.sedentario.org/wp-includes/images/yahoo/winkwink.gif\" border=\"0\" class=\"linked-sig-image\" /] [/div]
That's not directly from the database. IPB stores the bbc tags as html in the database.
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?
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.
Quote from: infonlinebr on April 02, 2007, 01:07:17 PM
What I passed above is as is bbcode direct in the forum ipb and later as it was in smf, does not have as to make this conversao of the HTML of ipb for smf?
You need to go in phpMyAdmin and look directly into the tables for the post. IPB when you edit a post it converts it to BBC tags but when you you save it it converts it back to html.
bundus thanks for the bug fix. I'll update the file to reflect this.
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
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--]
Quote from: 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 !!!
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
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.
thanks
Quote from: 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
You came to the wrong place to ask buddy. Try asking over at IPB ::).
Where can I get the convert.php file? The link you have in the first post does not work.
+1
I can't download convert.php
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
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
Quote from: 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--]
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.
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.
::)
I really would like to use SMF over IPB but so far there has been no support for migrating data and getting set up.
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?
I think we are out of luck here, there is no support for this converter.
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????????
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.
Are you guys using the .sql file from the first post?
excuse me i download the convert.php link but it direct to this link: http://www.simplemachines.org/community/index.php?topic
Seems like your copy and paste messed up. http://www.simplemachines.org/community/index.php?action=dlattach;topic=145284.0;attach=31445
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
update `smf_pm_recipients` set labels = -1
Quote from: 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
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
Need to run that query in phpMyAdmin.
Thank you!
I ran the query and now have all the PM's from IPB showing.
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
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..
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...
Are you using the convert files in this topic?
yes....
Can i convert once again.????
Yes just try running the converter again.
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
Sir ..once plz chk ur inbox to..and help me to solve
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
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,"\\'","'");
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
What version of IPB are you using?
2.3.1
Can I get a database dump of 2.3.x? Seems like there were a few database changes.
plz chk 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:
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:
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.
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 :(
Quote from: 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:
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:
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
samuelpage use the files on this topic.
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.
I am with the same problem of the post above ...
Needs to be done urgently to change ...
Thanks
Use the convert.php in this topic. http://www.simplemachines.org/community/index.php?topic=140741.0
The error continues .. Arrives this part and will not .. Already tried all sql and convert.php ..
Urgent need of this conversion ..
Edit the .sql file and change LENGTH(code) to code
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
Quote from: pdavida on January 04, 2008, 03:22:32 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.
pdavida were you able to convert?
Quote from: 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
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
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.
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
Basically what I need is a routine to strip away all the unwanted tags in the posts, same as was done for the signatures.
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.
OK I have attached a small dump of the posts table from 233 for you.
Bob
Here is data from a topic with photos.
Ok give this one a try.
Sorry still no luck, see attached file.
What is the exact code in SMF right now? Get it from the database.
/me curses IPB's stupid BBC style.
Using the same post this is the line out of the smf db;
QuoteINSERT INTO `smf_messages` VALUES(71175, 9934, 135, 1199873939, 1, 0, 'Line up January '08', 'Powerbob', '[email protected]', '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
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.
No Difference, here is the line from IPB db
QuoteINSERT 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, '');
Heh it would help if I pass over the changes to the right file :P. Here you go.
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
Polls should be converted. What version of IPB are you running?
IPB 2.3.3 but I only had 2/3 polls so no problem for me.
Oh ok. This converter needs its own topic then. I'll create it later.
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?
-AW- send me an IM. I need to look into how IPB 2.3.x handles polls now.
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
Weird. Did you try running it again?
Yes. I've also tried to reinstall SMF but same error.
Edit the .sql file.
INSERT INTO {$to_prefix}membergroups
INSERT IGNORE INTO {$to_prefix}membergroups
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
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.
Your respone is highly apprecited.
Besides if ther anoher option that is more secure to use, le menow about it sir.
regards
They are both secure. I've converter plenty of forums bigger than yours w/o a problem.
Thanks
Besides, it may not fit the topic, but, do you provide sode paid services for conversion sir ?
regards
You can just become a Charter Member if you want me to do the conversion for you.
Tryingto convert ipb 2.2.2 to smf1 .1.4 bot getting following error
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'
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
Quote from: daveb47 on February 22, 2008, 10:00:37 AM
Tryingto convert ipb 2.2.2 to smf1 .1.4 bot getting following error
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.
Quote from: 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
What section are you getting duplicate index errors?
Am getting 'Duplicate key' error at USERS Table sir.
Edit the .sql file.
---* {$to_prefix}members
---{
Add after.
$ignore = true;
Quote from: JayBachatero on February 27, 2008, 12:56:21 PM
Edit the .sql file.
---* {$to_prefix}members
---{
Add after.
$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 1regards
Yes. If no ---{ ---} exists you must add them. So
---* {$to_prefix}topics
becomes
--- {$to_prefix}topics
---{
$ignore = true;
---}
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
I am getting this error, Please Help Me !
SMF Team Please Help Me !
My last post was on "February 29, 2008, 03:02:42 PM" am (too) still waiting for your response guys.
Quote from: Mudassar Ahmed on March 06, 2008, 01:27:59 PM
I am getting this error, Please Help Me !
That is a bug with MySQL. Open the convert.php file.
LENGTH(code) DESC;
code DESC;
Quote from: 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
Open the .sql file.
INSERT INTO {$to_prefix}membergroups
INSERT IGNORE INTO {$to_prefix}membergroups
QuoteConverting 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
As you might have read, this is for IP.Board 2.2.x.
Birger :)
Exactly, no matter what version he is using I get same error while converting
2.2.2 > SMFQuoteFatal 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
Ok try this. Open the .sql file.
function magicMask(&$group)
{
if (!function_exists('magicMask'))
{
function magicMask(&$group)
{
}
function smfGroup(&$group)
{
}
}
if (!function_exists('smfGroup'))
{
function smfGroup(&$group)
{
}
while (true)
{
pastTime($substep);
$result = convert_query("
SELECT id AS ID_BOARD, permission_array
}
}
while (true)
{
pastTime($substep);
$result = convert_query("
SELECT id AS ID_BOARD, permission_array
QuoteThat 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
Seems like part of the file got corrupted when you made the change. Download it again and make the changes.
Hi
Nevermind I fixed it:S
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?
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 :(
Quote from: 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 (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)
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:
QuoteConverting 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
Open the .sql file and find this:
---* {$to_prefix}topics
Replace it with:
---* {$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.
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?
Does this one prove better results?
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)
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.
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.
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.
Can you attach in a text file the original post from IPB that has this issue?
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)
[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
[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.
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.
No slepy if u see, for example the row
[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 (http://)
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 :|
if u want i can give to u mymsql database in order to let u make a try...
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.
yes i tried..are u interested in my db?
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.
Quote from: 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.
No problem, do u have a msn to send the database ? tnx a lot for your interest :)
You can just send it to my simplemachines email address.
Hopefully this posts right as its all html entities: sleepy@simplemachines.org
the db zipped is 11 mb, is it ok for your mail? i use gmail.
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).
I see why its happening.
In the database it has it as "</b>" 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.
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
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
The 2.0 converters are not ready yet.
I wouldn't expect to see them either until after the 2.0 Final release :)
tnx sleepy, plz see the errore reported in my previous post.
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?
yes
but it doesn't work
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"
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.
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 :)
Wow, thanks a lot. I will try it soon.
error in the converter:
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
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 :)
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
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?
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..
Quote from: 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..
Thanks
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.
Run this query via phpMyAdmin:
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
UPDATE smf_pm_recipients
SET labels = '-1';
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.
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
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)
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.
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.
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.
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?
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
Quote from: SleePy on September 19, 2008, 01:53:41 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
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 (//) 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
Any errors during the conversion (please post them here) or was it successful?
Quote from: TE on January 08, 2009, 02:26:18 PM
Any errors during the conversion (please post them here) or was it successful?
there were no any errors during to conversions
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
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.
Well, this is different. I attempted it again using the same exact parameters and got this:
QuoteERRORS
Ouch.
I checked the SMF install, nothing changed. No users, no posts, etc.
this means the session was broken during conversion. try to restart the conversion from the beginning...
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.
QuoteNotice: 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
QuoteSorry, 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?
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)
Quote from: collst on January 08, 2009, 02:12:49 PM
1. Instead of tags (//) 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!
IPB only started using that sort of html in version 2.3. You are using the wrong version of the converter.
I had the same problem.. but now its resolved
thx
SMF FTW
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.
I Updated!!!
Thanks to sharing........
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?