Software: IPB
Version: 2.3.x
This is the official support topic for IPB 2.3.x converter. Use this topic to ask for support for this converter.
Changelog
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
I get a lot of errors but this I can't solve...
QuoteConverting permissions... Successful.
Converting board permissions...
Notice: unserialize() [function.unserialize]: Error at offset 5 of 194 bytes in /home/galeraon/public_html/forum/convert.php(910) : eval()'d code on line 89
Fatal error: Unsupported operand types in /home/galeraon/public_html/forum/convert.php(910) : eval()'d code on line 89
If you go into your IPB database and look at the ipb_forums table
Can you paste a sample from the permissions_array column?
That column should have a serialized array of the permissions. So that is odd why its happening.
Try opening the ipb23_to_smf.sql
Find:
$row += unserialize(stripslashes($row['permission_array']));
$row = addslashes_recursive($row);
Replace:
$row += @unserialize(stripslashes($row['permission_array']));
$row = addslashes_recursive($row);
This will hopefully tell it to be quiet if it has errors and the rest of it should hopefully quietly give up.
I ran through everything and the conversion seems to have gone 100% successful. Thank you. :)
Good job. ipb 2.3.1 100% successful.
Thank you.
I was trying to convert 2.3.4 to SMF but I just can't from some reason :
QuoteWhich 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.
Try again
I resolve this problem .. it was file extension of invision23_to_smf.sql .. when I download it the file was .html .. Now it works great ! Many 10x
2.3.3 works great... thanks.
Although towards the end of the process I recieved this error, but it didn't make any difference in the end:
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-2.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-3.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-7.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-64.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-13.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-17.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-18.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-20.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-23.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-27.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-46.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-28.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-31.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-32.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-33.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-58.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-61.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-51.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 58
Warning: copy(/av-54.png) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1075) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Conversion Complete
iSplicer,
The avatars path is missing in the IPB settings so it isn't able to copy the avatars over.
If you don't mind that you are missing those, then you can just ignore the user avatar errors and can use SMF fine :)
I keep getting this when I try to convert:
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...
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /home/theglobe/public_html/smf/convert/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `theglobe_smf`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('Should it?', 1, 255), 'Array', 1, 255), 'Array'),
(2, SUBSTRING('Shoult it?', 1, 255), 'Array', 1, 255), 'Array'),
(3, SUBSTRING('Do you think ...', 1, 255), 'Array', 1, 255), 'Array'),
(4, SUBSTRING('Which decade were you born?', 1, 255), 'Array', 1, 255), 'Array'),
(5, SUBSTRING('Pick The Robot You'd Marry.', 1, 255), 'Array', 1, 255), 'Array'),
(6, SUBSTRING('Will Hillary still be a serious presidential contender after today?', 1, 255), 'Array', 1, 255), 'Array'),
(7, SUBSTRING('Should gay marriage be banned?', 1, 255), 'Array', 1, 255), 'Array'),
(8, SUBSTRING('Do you believe your country should use the military draft in times of war?', 1, 255), 'Array', 1, 255), 'Array'),
(9, SUBSTRING('Do you believe in the death penalty?', 1, 255), 'Array', 1, 255), 'Array'),
(10, SUBSTRING('How tall are you?', 1, 255), 'Array', 1, 255), 'Array'),
(11, SUBSTRING('Where do you stand spiritually?', 1, 255), 'Array', 1, 255), 'Array'),
(12, SUBSTRING('Should It Be Allowed??? Ban it or Support it???', 1, 255), 'Array', 1, 255), 'Array'),
(13, SUBSTRING('Has The Time Come For The U.N. To Go?', 1, 255), 'Array', 1, 255), 'Array'),
(14, SUBSTRING('What should the law's stance be on incest?', 1, 255), 'Array', 1, 255), 'Array'),
(15, SUBSTRING('Pick a favorite species', 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('Shoult it?', 1, 255), 'Array', 1, 255), 'Array'' at line 3
Anyone know how I can fix that?
It bears to note that I can see member names as well as some of the threads that have converted, BUT none of the threads are appearing and I can't access the admin panel.
Are you sure you are using the ipb 2.3 converter?
It doesn't add a substring at all and the inserts you show it is :|
where is the convert.php file? O_o
It is linked to in the first post this converter topic :)
I have just tried to do a conversion from ipb2.3.x to smf and all seemed to be going well when I got this error. Do I need to worry about it and if so how can I fix it or should I just forget it and get on with life. My host has just upgraded to these new versions
Apache version 1.3.41 (Unix)
PHP version 4.4.8
MySQL version 5.0.51a-community
also forum_domain has been altered from the original so as not to reveal personal settings.
Converting...
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `forum_domain`.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
it's a MySQL-Bug, a fix is available here: Common conversion errors (http://www.simplemachines.org/community/index.php?topic=146192.0)
took a few minutes to find the text but once I did and changed it I ran the convert.php again and all worked fine so thanks for the help.
Cheers
Razorb
I have an ipb sql database and an smf sql database combined as one. I need to convert the ipb to smf but it seems to cause errors because of duplicate member ids. Is there a way around this?
Are you clicking continue or letting it do its work?
The converter will automatically do the work and refresh as needed.
I found that by not clicking continue it continued to work. However at the end there were a bunch of errors. It said it was successful but it was not.
What errors?
Is this compatible with smf 2.0 ?
I got an error like this when I try to convert ipb 2.3.4 to smf 2.0 beta3.1
-----------------------------------------------
Converting members... Unsuccessful!
.........bla bla bla,,,,,,,
Caused the error:
Unknown column 'memberName' in 'field list'
no, not at this time..
converters for 2.0 are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..
Quote from: ThorstenE on August 01, 2008, 07:08:05 AM
no, not at this time..
converters for 2.0 are still in developement (like SMF 2.0 itself). you have to convert to SMF 1.1.5 first and then upgrade the 1.1.5 to 2.0 Beta 3.1.. But remember: 2.0 is Beta and not recommended for production environments..
Ok thanks a lot, but I got this error with 1.1.5 too
-------------
Converting members... Unsuccessful!
This query:
INSERT INTO `xgsmf`.smf_members
----- bla bla bla-----
Caused the error:
Incorrect date value: '' for column 'birthdate' at row 1
are you using the invision23_to_smf.sql from this topic (attachment in first post) and convert.php from here (http://www.simplemachines.org/community/index.php?topic=140741.0)?
maybe, you are using the wrong conversion file from the download page?
Sure,
I'm using
convert.php from another topic and invision23_to_smf.sql from this topic .
And this is my phpinfo http://bbs.xgaming.in.th/info.php
i have no database-dumb from an ipb2.3 myself so i cannot check it.. there are two possible solutions:
1) remove this block from the invision23_to_smf.sql
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
it is converting the birthdates from your users.. if you delete this block birthdays would not be converted.
2) post a screenshot from ipb's members-table, so that i can see which format the birthdays have and i will modify this block for you..
Dark-Master,
I think MySQL is running in strict mode here. Though I am not to sure why you still receive that error. It would only occur if it was empty or not used during part of the conversion. Which is odd as it is being used right there.
THANKS you both, I removed the error thing from invision23_to_smf.sql.
There were
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate, */
p.edit_time AS modifiedTime
p.pid AS ID_POLL
.
After I removed those 3s, the conversion can be done. Thanks to smf and you all.
And here is the result.
http://bbs.xgaming.in.th/
IPB date tables.
http://img.xgaming.in.th/temp/2008-08-02_093410.png
I get this message when trying to convert from 2.3.4 to SMF 1.1.5
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.3. 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 'username'@'localhost' for table 'ibf_members'
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Hello,
for me, Converter was OK from IPB 2.3.1 to SMF 1.1.
all is fine but just BBCode not run good since i do converter
now where i read all topics where we have photos, color code and quote i have this kind of line on all my messages
[img src=\"http://farm2.static.flickr.com/1076/527942244_324d8f3580_o.jpg\" border=\"0\" class=\"linked-image\" /]
when i was on IPB the code was [img][/img]
do know how i can resolv this problem, i use the Panel Admin for check errors en problems : SMF is ok
thanks a lot for your answer
Can you provide us a raw message from the IPB database that has this issue?
You will need to use phpMyAdmin or similar to get ahold of this, but this will provide us the message in its raw format so we know what it is looking like before any bbc code work is done on it.
how i do that fort give you a Raw
i have 65100 messages (photos on the forum)
my forum it's a photo-forum
Do you know the message id of a post that has this issue?
If you link me to a post I could most likely figured out its message id.
We then go look at just that message body in the database.
well i have 1567 topics and 65129 messages
this is the typical bug that i have on all my message
[!--coloro:#4169E1--][span style=\"color:#4169E1\"][!--/coloro--]Merci Nikolas pour cette info.
Je passerai à la FNAC évaluer le contenu des 2 livres.[!--colorc--][/span][!--/colorc--]
Ci-joint 2 des clichés tout juste pris à Lyon ce week-end sans réelle prise en main du K20
[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon05-07-08.jpg\" border=\"0\" class=\"linked-image\" /]
[img src=\"http://jpoilleux.neuf.fr/Photos/Partage/Lyon02.jpg\" border=\"0\" class=\"linked-image\" /]
How does this one work?
well i have this message of the end
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `db214843381`.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
but for images all is fine now
thanks a lot
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
I have a problem, when i was converting i got this error:
Converting...
Converting poll logs... Unsuccessful!
This query:
INSERT INTO `bgforum`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('1', '31'),
('1', '50'),
('1', '188'),
('1', '517'),
('2', '2'),
('2', '5'),
('2', '7'),
('2', '12'),
('2', '14'),
('2', '15'),
('2', '16'),
('2', '31'),
('2', '43'),
('2', '50'),
('2', '56'),
('2', '68'),
('2', '73'),
('2', '79'),
('2', '80'),
('2', '156'),
('2', '208'),
('2', '224'),
('2', '312'),
('2', '503'),
('2', '520'),
('3', '3'),
('3', '5'),
('3', '7'),
('3', '9'),
('3', '10'),
('3', '12'),
('3', '14'),
('3', '16'),
('3', '31'),
('3', '68'),
('3', '312'),
('3', '503'),
('', '3'),
('', '5'),
('', '7'),
('', '9'),
('', '10'),
('', '12'),
('', '14'),
('', '16'),
('', '31'),
('', '68'),
('', '312'),
('', '503'),
('1', '31'),
('1', '50'),
('1', '188'),
('1', '517'),
('2', '2'),
('2', '5'),
('2', '7'),
('2', '12'),
('2', '14'),
('2', '15'),
('2', '16'),
('2', '31'),
('2', '43'),
('2', '50'),
('2', '56'),
('2', '68'),
('2', '73'),
('2', '79'),
('2', '80'),
('2', '156'),
('2', '208'),
('2', '224'),
('2', '312'),
('2', '503'),
('2', '520'),
('3', '3'),
('3', '5'),
('3', '7'),
('3', '9'),
('3', '10'),
('3', '12'),
('3', '14'),
('3', '16'),
('3', '31'),
('3', '68'),
('3', '312'),
('3', '503'),
('', '3'),
('', '5'),
('', '7'),
('', '9'),
('', '10'),
('', '12'),
('', '14'),
('', '16'),
('', '31'),
('', '68'),
('', '312'),
('', '503'),
('4', '510'),
('4', '503'),
('4', '508'),
('4', '171'),
('5', '171'),
('5', '503'),
('5', '15'),
('5', '508'),
('5', '68'),
('5', '510'),
('5', '80'),
('5', '5'),
('6', '171'),
('6', '508'),
('6', '503'),
('6', '68'),
('7', '171'),
('7', '5'),
('7', '15'),
('7', '80'),
('7', '510'),
('7', '50'),
('7', '593'),
('8', '171'),
('8', '520'),
('8', '5'),
('8', '31'),
('8', '80'),
('8', '7'),
('8', '647'),
('8', '50'),
('8', '545'),
('8', '15'),
('8', '68'),
('8', '16');
Caused the error:
Duplicate entry '1-31-0' for key 1
Can someone help me please? ^^
edit the invision23_to_smf.sql with a text-editor and search for this line:
---* {$to_prefix}log_polls
add after
---{
$ignore = true;
---}
then upload the file via FTP and restart the conversion..
open the .sql file
find:
---* {$to_prefix}log_polls
replace:
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
Thanks for the help! :D
Welcome you!
I'm trying to convert IP.Board v2.3.1 (ID: 23004) to SMF 1.1.5 with smf_1-1-5_invision2_converter.
But I'm getting error.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:
INSERT INTO `seat_club`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (2, SUBSTRING('Какая Ибица вам нравится больше???', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(3, SUBSTRING('Вариант 1', 1, 255), 'Array', 1, 255), 'Array'),
(4, SUBSTRING('А ты что бы выбрал для себя? ', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(5, SUBSTRING('Кто же он?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(6, SUBSTRING('Кто же она?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(7, SUBSTRING('Кто же лучший?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(8, SUBSTRING('Кто же этот красавец?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(9, SUBSTRING('У кого самая улетная тачка?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
(10, SUBSTRING('Кто же больше всех помогает нам?', 1, 255), '1', 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, 255), 'Array'),
(3, SUBSTRING('Вариант 1', 1, 255), 'Array',' at line 3
PLEASE!!! HELP!!!
Well I found resolution for my problem, I think.
I've just delete everything from MySQL field "poll_question" in original table "ibf_polls"
And now I have new problem:
Converting poll logs... Unsuccessful!
This query:
INSERT INTO `seat_club`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '18'),
('', '31'),
('', '55'),
('', '19'),
('', '13'),
('', '70'),
('', '25'),
('', '46'),
('', '16'),
('', '12'),
('', '42'),
('', '23'),
('', '74'),
('', '6'),
('', '67'),
('', '27'),
('', '41'),
('', '12'),
('', '31'),
('', '92'),
('', '13'),
('', '13'),
('', '10'),
('', '9'),
('', '92'),
('', '22'),
('', '5'),
('', '55'),
('', '47'),
('', '77'),
('', '22'),
('', '12'),
('', '69'),
('', '108'),
('', '41'),
('', '108'),
('', '109'),
('', '16'),
('', '100'),
('', '41'),
('', '109'),
('', '25'),
('', '9'),
('', '13'),
('', '92'),
('', '92'),
('', '92'),
('', '41'),
('', '108'),
('', '108'),
('', '13'),
('', '109'),
('', '96'),
('', '96'),
('', '96'),
('', '100'),
('', '16'),
('', '16'),
('', '100'),
('', '13'),
('', '25'),
('', '25'),
('', '31'),
('', '31'),
('', '31'),
('', '5'),
('', '6'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '16'),
('', '108'),
('', '100'),
('', '100'),
('', '92'),
('', '92'),
('', '100'),
('', '92'),
('', '25'),
('', '96'),
('', '109'),
('', '109'),
('', '109'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '13'),
('', '13'),
('', '5'),
('', '5'),
('', '5'),
('', '31'),
('', '5'),
('', '31'),
('', '5'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '6'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '3'),
('', '3'),
('', '3'),
('', '16'),
('', '16'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '31'),
('', '6'),
('', '6'),
('', '6'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '99'),
('', '70'),
('', '70');
Caused the error:
Duplicate entry '0-12-0' for key 1
What should I do? :(
That is most likely due to your previous fix you did :(
Do you have a backup to revert that?
Quote from: SleePy on September 06, 2008, 05:12:45 PM
That is most likely due to your previous fix you did :(
Do you have a backup to revert that?
Well, that is not a problem anymore.
I've just disable (rem'it) poll while converting...
Thank you for your answer.
hi, where I have to put the convert.php file to could convert the BD to the SMF¿?
i'm looking but I can't find
Please only ask your question once.
http://www.simplemachines.org/community/index.php?topic=190907.msg1720839#msg1720839
Hi
I am getting duplicate entry255 error
I tried makinh int value to 4, but its already 4.
What else can be done?
You may need to change this int to 4 in the smf_categories, smf_boards and smf_collapsed_categories board. As well it is supposed to be a "BIGINT" of 4 not int.
If you run this script, http://www.simplemachines.org/community/index.php?topic=246700.0
It will do this for you. Remember to stop after the first step and let the conversion process complete before completing the rest of the steps in that script.
Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:
INSERT INTO `sozbitti_pedigo`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('3', 'Önsöz Edebiyat (SB)', '3'),
('13', '2. Perde', '6'),
('26', '3. Perde', '7'),
('33', '1. Perde', '5'),
('38', 'Ve Bitti .', '8'),
('44', 'Başla..', '1'),
('284', 'Edebiyat Dünyası', '4'),
('335', 'İdari Yönetim Lobisi', '2');
Caused the error:
Duplicate entry '255' for key 1
what does it mean?
what can i do for this error?
I am using IPB 2.3.1 and using true convert files..
Please help me.
http://www.simplemachines.org/community/index.php?topic=274252.0#post_high_category_ids
Quote from: SleePy on July 23, 2008, 11:26:04 PM
It is linked to in the first post this converter topic :)
Please, what am I missing... I look at the first post, there is a link "convert.php", but it just takes me back to this discussion. I just can't find "convert.php"
Thanks in advance for your help
http://www.simplemachines.org/community/index.php?topic=140741.0
convert.php is attached at the end from the first post (scroll down)
Help -
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `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 ('1', '0', '2', '1', '1', '', '3', '84', '1', '9', '0'),
('2', '0', '13', '1', '1', '', '0', '6', '2', '2', '0'),
('3', '0', '3', '1', '1', '', '6', '55', '3', '12', '0'),
('4', '0', '9', '1', '1', '', '0', '10', '13', '13', '0'),
('5', '0', '6', '1', '1', '', '2', '73', '14', '16', '0'),
('6', '0', '6', '1', '1', '', '1', '97', '17', '18', '0');
Caused the error:
Incorrect integer value: '' for column 'ID_POLL' at row 1
Invision 2.3.6
londonms,
I think your MySQL server is in strict mode. edit the invision23_to_smf.sql and find:
---* {$to_prefix}topics 250
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 ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls 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;
replace it with:
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,
IF(pl.pid > 0, pl.pid , 0), 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 ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls 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;
Hello when try to convert a see that msg
thank you
candidosa2,
What is the error message you are receiving at the bottom of that message?
yes did see imagen attach
Your image doesn't show the last half of the error message.
Far as I can tell it may be a duplicate key error or there is something that wasn't escaped properly when SMF converter was trying to insert it into the database.
Got myself an error trying to convert my IPB 2.3 install... any ideas?
Converting...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...
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1125596689.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1129601073.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1129924461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1142453192.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1147019334.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1149789666.ipb) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036020.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036030.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036038.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036046.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036054.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036061.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036071.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036081.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334535.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334560.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334571.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334591.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1163618647.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-7-1164218556.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-1-1170731912.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-17-1173815534.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Warning: copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-7-1175548461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
Successful.
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-1.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-5.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-6.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-7.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-8.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-10.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy() [function.copy]: The first argument to copy() function cannot be a directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-17.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
Conversion Complete Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support. Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the Invision Power Board 2.3 installation.
We hope you had a smooth transition!
Ok, so I did some checking... those attachments it is trying to copy don't exist (for some reason) so those are legit errors that can be ignored.
However the avatars not copying is still very strange....
Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:
if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);
if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}
with:
$oldAvatarDir = $_POST['path_from'] . '/uploads';
Hi.
When mine is in the process of converting posts, it times out. I've tried it in IE and Google Chrome. It appears to have converted successfully up until it times out (members and such are converted). It keeps doing this every time.
Any ideas? Please help.
Any error messages during the conversion (white page, script stops, internal server error) ???
Hi
in my case the conversion procedure has not given problems. When I enter in board, but the part of the forum there isn't, and also part of the area of admin. why?
Punk92,
possibly the Group membership wasn't converted right.. You can restore the Admin privilegues for your Account:
Please check: I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466)
Ok, thanks, now work. But the user avarat there isn't.. how can i resolve?
Thanks TE, looking at it this would indeed have fixed it.. however as it was easy to just tell folks to re-load avatars I had already done that. :)
It would be nice if the converter automatically detected this for older IPB installs.
Quote from: TE on May 23, 2009, 05:12:10 PM
Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:
if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);
if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}
with:
$oldAvatarDir = $_POST['path_from'] . '/uploads';
I've a problem with Attachments.. during the convertition, some files ( img, zip etc ) are to convert correctly, but the greater part Not. the string appears only [attachments: ....].
why?
p.s. also the avatar, but i copy the original img in /avatar,and work.
Hello guys,
I am trying to convert IPB 2.3.6 to SMF 1.1.9 and unfortunately, i get an error mesage :
Converting topics... Unsuccessful!
This query:
INSERT INTO `Christoo_ipb`.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 ('331', '0', '28', '190', '20', '', '2', '342', '4795', '4820', '0'),
('332', '0', '6', '58', '58', '', '14', '853', '4828', '5349', '0'),
('333', '0', '10', '313', '61', '', '33', '2701', '4846', '20202', '0'),
('334', '0', '13', '47', '47', '', '13', '167', '4856', '5283', '0'),
('335', '0', '1', '101', '94', '', '62', '1948', '4858', '7558', '0'),
('336', '0', '1', '4', '0', '', '4', '380', '4890', '5741', '0'),
('338', '0', '13', '113', '113', '', '31', '520', '4912', '5406', '0'),
('339', '0', '28', '151', '334', '', '9', '580', '4958', '6847', '0'),
('340', '0', '95', '269', '37', '', '8', '263', '4978', '6409', '0'),
('341', '0', '1', '9', '19', '', '6', '387', '5003', '5018', '0'),
('342', '0', '2', '47', '2', '', '7', '356', '5013', '5379', '0'),
('343', '0', '6', '65', '88', '', '9', '336', '5028', '5293', '0'),
('344', '0', '1', '319', '309', '', '13', '625', '5066', '6314', '0'),
('345', '0', '10', '27', '309', '', '8', '494', '5071', '6318', '0'),
('346', '0', '1', '98', '0', '', '15', '817', '5090', '5737', '0'),
('347', '0', '1', '167', '99', '', '32', '1373', '5104', '5691', '0'),
('348', '0', '28', '98', '99', '', '5', '404', '5110', '5538', '0'),
('349', '0', '28', '320', '47', '', '13', '476', '5123', '6988', '0'),
('350', '0', '6', '160', '317', '', '4', '352', '5127', '5257', '0'),
('351', '0', '1', '237', '81', '', '17', '890', '5139', '5299', '0'),
('352', '0', '8', '240', '455', '', '6', '1445', '5184', '11309', '0'),
('353', '0', '10', '5', '4', '11', '10', '700', '5218', '5712', '0'),
('354', '0', '95', '25', '25', '', '0', '128', '5221', '5221', '0'),
('356', '0', '28', '324', '90', '', '2', '395', '5230', '5844', '0'),
('357', '0', '10', '274', '150', '', '12', '609', '5260', '6256', '0'),
('358', '0', '8', '167', '603', '', '25', '1802', '5261', '70379', '0'),
('359', '0', '6', '47', '65', '', '6', '330', '5297', '6541', '0'),
('360', '0', '28', '47', '192', '', '20', '2096', '5337', '6439', '0'),
('361', '0', '28', '112', '90', '', '2', '259', '5405', '5846', '0'),
('362', '0', '10', '32', '112', '', '9', '520', '7068', '8243', '0'),
('363', '0', '95', '77', '103', '', '14', '456', '5366', '5991', '0'),
('365', '0', '1', '47', '397', '', '3', '257', '5334', '10205', '0'),
('367', '0', '1', '0', '78', '', '7', '667', '5354', '5468', '0'),
('370', '0', '28', '219', '32', '', '33', '2632', '5374', '8041', '0'),
('375', '0', '6', '81', '644', '', '21', '618', '5386', '4370006', '0'),
('376', '0', '14', '2', '2', '', '150', '1702', '5392', '6019', '0'),
('377', '0', '28', '331', '249', '', '12', '737', '5432', '6145', '0'),
('378', '0', '1', '332', '41', '', '4', '429', '5434', '10914', '0'),
('379', '0', '1', '25', '152', '', '14', '868', '5435', '5701', '0'),
('380', '0', '28', '326', '326', '', '3', '319', '5451', '5651', '0'),
('381', '0', '28', '112', '151', '', '68', '5738', '5476', '8752', '0'),
('383', '0', '10', '78', '78', '', '13', '601', '5487', '6411', '0'),
('384', '0', '17', '208', '208', '', '52', '2421', '5566', '35355', '0'),
('385', '0', '16', '213', '361', '', '3', '661', '5571', '6683', '0'),
('386', '0', '6', '14', '668', '', '12', '688', '5615', '29063', '0'),
('387', '0', '28', '143', '132', '', '18', '1275', '5647', '8051', '0'),
('388', '0', '28', '51', '131', '', '8', '481', '5680', '5974', '0'),
('390', '0', '13', '131', '112', '', '33', '585', '5700', '6285', '0'),
('391', '0', '28', '152', '6', '', '11', '585', '5705', '6121', '0'),
('392', '0', '10', '331', '4', '', '18', '616', '5724', '10166', '0'),
('393', '0', '10', '0', '0', '', '3', '356', '5725', '9208', '0'),
('394', '0', '28', '344', '581', '', '20', '1107', '5750', '15752', '0'),
('395', '0', '8', '74', '41', '', '30', '1922', '5778', '26343', '0'),
('396', '0', '10', '124', '1224', '', '51', '2483', '5812', '4377808', '0'),
('397', '0', '1', '25', '25', '', '1', '262', '5850', '5851', '0'),
('398', '0', '28', '229', '1811', '', '17', '1223', '5857', '4440898', '0'),
('399', '0', '28', '88', '29', '', '14', '596', '5890', '6477', '0'),
('400', '0', '28', '9', '625', '', '21', '757', '5898', '57041', '0'),
('401', '0', '2', '0', '2337', '', '5', '735', '5911', '4370284', '0'),
('402', '0', '28', '277', '277', '', '18', '1384', '5944', '6316', '0'),
('403', '0', '28', '192', '90', '', '5', '378', '5957', '6066', '0'),
('404', '0', '28', '125', '428', '', '39', '1643', '5999', '57423', '0'),
('405', '0', '1', '112', '78', '', '17', '559', '6008', '6325', '0'),
('406', '0', '1', '0', '665', '', '50', '1294', '6064', '62790', '0'),
('407', '0', '28', '241', '241', '', '0', '197', '6076', '6076', '0'),
('408', '0', '10', '259', '151', '', '27', '1028', '6088', '26241', '0'),
('410', '0', '6', '6', '60', '', '49', '2123', '6124', '10527', '0'),
('411', '0', '1', '169', '81', '', '10', '436', '6144', '9158', '0'),
('412', '0', '10', '60', '135', '', '15', '704', '6161', '9278', '0'),
('413', '0', '1', '38', '112', '', '39', '1498', '6166', '8342', '0'),
('414', '0', '2', '14', '14', '', '4', '303', '6174', '7763', '0'),
('415', '0', '28', '353', '440', '', '8', '340', '6199', '4314244', '0'),
('423', '0', '28', '48', '57', '', '1', '289', '6218', '6272', '0'),
('424', '0', '1', '249', '19', '', '19', '765', '6219', '6609', '0'),
('425', '0', '1', '356', '356', '', '19', '530', '6224', '21078', '0'),
('426', '0', '95', '285', '277', '', '15', '792', '6270', '15916', '0'),
('427', '0', '28', '285', '75', '', '42', '3603', '6287', '8184', '0'),
('428', '0', '1', '357', '357', '', '0', '281', '6310', '6310', '0'),
('429', '0', '28', '143', '143', '', '2', '388', '6342', '6594', '0'),
('430', '0', '28', '75', '75', '', '4', '444', '6356', '6420', '0'),
('431', '0', '13', '138', '138', '', '20', '184', '6367', '7585', '0'),
('432', '0', '1', '29', '29', '', '34', '1560', '6393', '9916', '0'),
('433', '0', '13', '361', '112', '', '35', '483', '6395', '8593', '0'),
('434', '0', '1', '13', '13', '', '4', '305', '6400', '6537', '0'),
('435', '0', '8', '167', '240', '', '12', '1356', '6404', '7882', '0'),
('436', '0', '95', '25', '25', '', '2', '230', '6406', '6829', '0'),
('437', '0', '8', '167', '125', '', '2', '794', '6407', '6471', '0'),
('438', '0', '28', '363', '363', '', '2', '357', '6433', '7828', '0'),
('439', '0', '1', '101', '38', '', '14', '634', '6469', '6562', '0'),
('440', '0', '28', '274', '23', '', '11', '479', '6505', '7454', '0'),
('441', '0', '10', '114', '309', '', '1', '208', '6515', '6626', '0'),
('442', '0', '2', '98', '33', '', '11', '624', '6540', '9528', '0'),
('443', '0', '28', '346', '237', '', '1', '253', '6548', '6550', '0'),
('444', '0', '28', '219', '90', '', '7', '344', '6566', '6667', '0'),
('445', '0', '1', '51', '56', '', '14', '667', '6571', '6617', '0'),
('446', '0', '28', '51', '92', '', '1', '229', '6572', '6584', '0'),
('447', '0', '28', '39', '107', '', '21', '733', '6573', '38078', '0'),
('448', '0', '8', '29', '455', '', '30', '2876', '6591', '64344', '0'),
('449', '0', '8', '29', '455', '', '3', '965', '6592', '11495', '0'),
('450', '0', '10', '369', '1023', '', '25', '868', '6610', '50128', '0'),
('451', '0', '28', '143', '61', '', '9', '518', '6616', '7597', '0'),
('452', '0', '28', '249', '377', '', '5', '423', '6622', '8179', '0'),
('457', '0', '95', '61', '508', '', '5', '203', '6640', '12181', '0'),
('458', '0', '1', '355', '355', '', '51', '1757', '6641', '11976', '0'),
('459', '0', '1', '61', '6800', '14', '153', '20097', '6643', '4561475', '0'),
('460', '0', '28', '61', '435', '', '1', '242', '6653', '9742', '0'),
('461', '0', '1', '361', '13', '', '2', '228', '6707', '6720', '0'),
('462', '0', '17', '29', '477', '', '4', '337', '6749', '11476', '0'),
('463', '0', '95', '74', '20', '', '37', '1309', '6701', '10856', '0'),
('464', '0', '17', '259', '231', '', '17', '825', '6706', '4323631', '0'),
('465', '0', '14', '0', '2', '', '38', '615', '6712', '7883', '0'),
('466', '0', '13', '309', '377', '', '4', '93', '6726', '7172', '0'),
('467', '0', '13', '259', '2', '', '5', '52', '6731', '7704', '0'),
('468', '0', '10', '269', '61', '', '1', '317', '6735', '7041', '0'),
('469', '0', '1', '65', '240', '', '9', '592', '6737', '7712', '0'),
('470', '0', '6', '29', '127', '', '28', '742', '6807', '7059', '0'),
('471', '0', '28', '283', '283', '', '0', '213', '6811', '6811', '0'),
('472', '0', '1', '29', '29', '', '31', '1062', '6840', '8176', '0'),
('473', '0', '13', '138', '112', '', '25', '134', '6854', '7604', '0'),
('474', '0', '1', '290', '1218', '', '85', '2268', '6857', '66110', '0'),
('475', '0', '1', '342', '342', '', '5', '405', '6891', '7436', '0'),
('476', '0', '28', '375', '26', '', '16', '918', '6961', '8851', '0'),
('477', '0', '28', '179', '190', '', '2', '262', '6970', '7043', '0'),
('478', '0', '1', '254', '254', '', '5', '344', '6977', '8909', '0'),
('479', '0', '6', '17', '16', '', '1', '177', '6985', '7080', '0'),
('480', '0', '13', '377', '2', '', '38', '308', '7013', '7702', '0'),
('482', '0', '28', '160', '435', '', '2', '362', '7015', '9740', '0'),
('483', '0', '28', '94', '435', '', '27', '1616', '7040', '14403', '0'),
('484', '0', '1', '269', '106', '', '1', '257', '7051', '7132', '0'),
('485', '0', '13', '379', '44', '', '16', '213', '7066', '8854', '0'),
('486', '0', '6', '6', '240', '', '10', '367', '7072', '7708', '0'),
('487', '0', '1', '47', '23', '', '15', '636', '7121', '7652', '0'),
('488', '0', '10', '85', '60', '', '11', '528', '7123', '7459', '0'),
('496', '0', '2', '2', '20', '', '5', '397', '7206', '7836', '0'),
('497', '0', '1', '25', '0', '', '14', '625', '7220', '7410', '0'),
('499', '0', '1', '200', '200', '', '0', '177', '7235', '7235', '0'),
('500', '0', '28', '265', '16', '', '5', '481', '7248', '8017', '0'),
('501', '0', '6', '47', '142', '', '11', '522', '7250', '8281', '0'),
('502', '0', '1', '254', '2', '', '22', '887', '7268', '8294', '0'),
('503', '0', '28', '44', '112', '', '14', '632', '7269', '7458', '0'),
('504', '0', '6', '29', '20', '', '65', '1380', '7280', '42580', '0'),
('505', '0', '2', '237', '90', '', '6', '439', '7287', '51462', '0'),
('506', '0', '2', '7', '160', '', '40', '2872', '7298', '9836', '0'),
('507', '0', '28', '114', '205', '', '6', '387', '7308', '12838', '0'),
('508', '0', '1', '114', '20', '', '41', '2698', '7310', '4389714', '0'),
('511', '0', '10', '112', '112', '', '15', '746', '7390', '8968', '0'),
('512', '0', '1', '269', '16', '', '19', '684', '7409', '8543', '0'),
('513', '0', '95', '269', '4', '', '1', '163', '7416', '8029', '0'),
('514', '0', '95', '269', '58', '', '1', '190', '7418', '7593', '0'),
('515', '0', '1', '29', '361', '', '2', '266', '7425', '7495', '0'),
('516', '0', '28', '60', '60', '', '2', '456', '7460', '7567', '0'),
('517', '0', '1', '2', '361', '', '15', '592', '7469', '7577', '0'),
('518', '0', '8', '167', '140', '', '9', '1065', '7479', '7839', '0'),
('519', '1', '14', '0', '1229', '', '29', '1081', '7483', '62703', '0'),
('520', '0', '1', '385', '13', '', '1', '233', '7496', '7528', '0'),
('521', '0', '1', '224', '966', '', '25', '2887', '7506', '4336232', '0'),
('522', '0', '17', '224', '477', '', '14', '2925', '7516', '11041', '0'),
('523', '0', '1', '219', '1546', '', '11', '1417', '7536', '4323728', '0'),
('524', '0', '1', '60', '60', '', '1', '215', '7563', '7565', '0'),
('525', '0', '28', '60', '2182', '', '14', '722', '7566', '4380730', '0'),
('526', '0', '28', '88', '131', '', '6', '354', '7583', '8979', '0'),
('527', '0', '8', '167', '73', '', '4', '555', '7588', '7770', '0'),
('528', '0', '1', '198', '198', '', '13', '693', '7591', '8301', '0'),
('529', '0', '10', '346', '99', '', '11', '657', '7598', '8984', '0'),
('530', '0', '1', '2', '47', '', '47', '1430', '7608', '8218', '0'),
('531', '0', '28', '297', '297', '', '2', '411', '7612', '7944', '0'),
('532', '0', '1', '29', '361', '', '9', '383', '7628', '8359', '0'),
('533', '0', '1', '0', '19', '', '57', '1731', '7634', '12197', '0'),
('534', '0', '13', '202', '44', '', '14', '158', '7640', '8855', '0'),
('535', '0', '28', '202', '161', '', '13', '461', '7657', '12792', '0'),
('536', '0', '1', '101', '74', '', '3', '264', '7666', '11748', '0'),
('537', '0', '13', '47', '377', '', '12', '316', '7673', '8438', '0'),
('539', '0', '10', '179', '99', '', '25', '1785', '7722', '22617', '0'),
('540', '0', '1', '74', '196', '', '75', '2998', '7724', '9688', '0'),
('541', '0', '1', '205', '140', '', '7', '401', '7750', '7801', '0'),
('542', '0', '6', '47', '17', '', '4', '268', '7756', '7788', '0'),
('543', '0', '1', '205', '47', '', '1', '245', '7765', '7767', '0'),
('544', '0', '6', '143', '143', '', '0', '172', '7777', '7777', '0'),
('545', '0', '28', '236', '125', '', '4', '405', '7794', '8156', '0'),
('546', '0', '13', '389', '79', '', '17', '140', '7798', '8423', '0'),
('547', '0', '28', '219', '219', '', '6', '363', '7841', '32385', '0'),
('548', '0', '10', '51', '202', '', '5', '511', '7843', '10019', '0'),
('549', '0', '10', '85', '88', '', '7', '492', '7854', '8096', '0'),
('550', '0', '1', '61', '16', '16', '41', '1184', '7863', '8417', '0'),
('551', '0', '1', '61', '141', '', '3', '172', '7864', '8412', '0'),
('552', '0', '1', '29', '61', '', '2', '261', '7867', '7937', '0'),
('554', '0', '28', '143', '18', '', '5', '612', '7894', '9563', '0'),
('556', '0', '1', '127', '11', '', '25', '1049', '7911', '8384', '0'),
('557', '0', '28', '393', '343', '', '2', '429', '7943', '8349', '0'),
('558', '0', '28', '25', '25', '', '5', '296', '7958', '8104', '0'),
('559', '0', '1', '0', '72', '', '62', '1672', '7990', '9317', '0'),
('560', '0', '28', '186', '186', '', '4', '437', '7994', '8748', '0'),
('561', '0', '1', '196', '199', '', '22', '794', '8001', '8948', '0'),
('562', '0', '13', '132', '603', '', '25', '207', '8063', '31803', '0'),
('563', '0', '28', '31', '26', '', '10', '470', '8064', '8540', '0'),
('564', '0', '1', '269', '37', '', '7', '432', '8103', '8198', '0'),
('565', '0', '1', '377', '398', '', '34', '1320', '8166', '8931', '0'),
('566', '0', '1', '29', '290', '', '10', '495', '8169', '8368', '0'),
('567', '0', '1', '17', '2', '', '58', '1515', '8229', '4509395', '0'),
('568', '0', '1', '17', '78', '', '31', '642', '8244', '33547', '0'),
('569', '0', '1', '151', '151', '', '12', '511', '8274', '8747', '0'),
('570', '0', '6', '47', '88', '', '1', '170', '8284', '8934', '0'),
('571', '0', '95', '184', '52', '', '11', '450', '8300', '10047', '0'),
('572', '0', '95', '398', '248', '', '2', '167', '8387', '8674', '0'),
('573', '0', '13', '398', '23', '', '19', '276', '8397', '8865', '0'),
('574', '0', '1', '29', '406', '', '23', '964', '8403', '9117', '0'),
('575', '0', '10', '259', '114', '', '8', '506', '8444', '8639', '0'),
('576', '0', '1', '103', '17', '', '2', '199', '8522', '8525', '0'),
('577', '0', '10', '17', '17', '', '14', '743', '8517', '9292', '0'),
('578', '0', '1', '2', '454', '', '20', '642', '8529', '10059', '0'),
('579', '0', '28', '352', '352', '', '43', '1387', '8544', '10676', '0'),
('580', '0', '1', '97', '81', '', '50', '903', '8571', '10957', '0'),
('581', '0', '28', '287', '205', '', '6', '421', '8580', '9199', '0'),
('582', '0', '1', '4', '99', '', '7', '262', '8595', '8764', '0'),
('583', '0', '13', '406', '377', '', '7', '113', '8601', '8663', '0'),
('584', '0', '1', '101', '342', '', '31', '1098', '8608', '9527', '0'),
('585', '0', '28', '143', '6', '', '4', '440', '8619', '8649', '0'),
('586', '0', '28', '407', '407', '', '16', '693', '8620', '9188', '0'),
('587', '0', '8', '6', '151', '', '4', '750', '8621', '8750', '0'),
('588', '0', '28', '6', '6', '', '0', '214', '8632', '8632', '0'),
('589', '0', '13', '407', '112', '', '17', '186', '8641', '9058', '0'),
('590', '0', '1', '125', '125', '', '9', '363', '8681', '9191', '0'),
('591', '0', '28', '248', '237', '', '3', '440', '8683', '8814', '0'),
('592', '0', '10', '68', '498', '', '20', '1049', '8724', '13681', '0'),
('593', '0', '28', '219', '140', '', '10', '476', '8728', '9148', '0'),
('594', '0', '28', '410', '14', '', '14', '646', '8730', '12355', '0'),
('595', '0', '95', '411', '411', '', '0', '154', '8738', '8738', '0'),
('597', '0', '28', '412', '283', '', '5', '402', '8744', '8997', '0'),
('598', '0', '8', '151', '151', '', '5', '826', '8762', '9019', '0'),
('599', '0', '8', '205', '167', '', '3', '582', '8768', '8872', '0'),
('600', '0', '10', '44', '140', '', '3', '340', '8780', '8799', '0'),
('601', '0', '10', '2', '2', '', '41', '1987', '8783', '14864', '0'),
('602', '0', '28', '414', '552', '', '2', '220', '8806', '13566', '0'),
('603', '0', '28', '406', '192', '', '8', '369', '8810', '9542', '0'),
('604', '0', '1', '101', '233', '', '17', '569', '8825', '10640', '0'),
('605', '0', '10', '407', '407', '', '3', '372', '8846', '9189', '0'),
('606', '0', '28', '50', '85', '', '5', '333', '8861', '9013', '0'),
('607', '0', '95', '5', '17', '', '4', '269', '8899', '9290', '0'),
('608', '0', '1', '85', '61', '', '1', '113', '8903', '8905', '0'),
('609', '0', '10', '61', '397', '', '4', '292', '8910', '9492', '0'),
('610', '0', '10', '61', '140', '', '3', '300', '8911', '13268', '0'),
('612', '0', '1', '233', '140', '', '13', '386', '8925', '9415', '0'),
('613', '0', '1', '88', '88', '', '8', '428', '8936', '9765', '0'),
('614', '0', '10', '78', '78', '', '9', '399', '8943', '10209', '0'),
('615', '0', '28', '51', '51', '', '4', '363', '8946', '9088', '0'),
('616', '0', '1', '92', '0', '', '15', '728', '8947', '9315', '0'),
('617', '0', '28', '421', '362', '', '26', '1211', '8978', '12369', '0'),
('618', '0', '1', '4', '75', '', '52', '1142', '8982', '4313467', '0'),
('619', '0', '28', '131', '181', '', '39', '1259', '8986', '4330721', '0'),
('620', '0', '1', '112', '172', '', '30', '892', '9034', '10118', '0');
Caused the error:
Duplicate entry '331' for key 1
Can anyone help me please ?
;)
edit the invision23_to_smf.sql with a text-editor and search for:
---* {$to_prefix}topics 250
replace it with:
---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..
got ths error while converting my forum
plz help
plz gve whole details hw to convert.....
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.3. 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 'forum_smf'@'92.867.546.235' for table 'ibf_members'
see Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Quote from: TE on June 11, 2009, 07:26:08 AM
edit the invision23_to_smf.sql with a text-editor and search for:
---* {$to_prefix}topics 250
replace it with:
---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..
Hello Te,
Thank you for your help, it is ok now using your fix.
;)
I got this error,
Invision Power Board 2.3 to SMF 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...
Fatal error: Call to undefined function getAttachmentFilename() in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 20
IPB v 2.3.6 to SMF 1.1.9
What is the problem? I could not finish the conversion.
please use the converter from our downloads page instead: (direct link)
http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-9_invision23_converter.zip
Thanks.
Managed to convert but came to several errors.
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...
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_01_2008/post-51-1200583554.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202632069.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202633527.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202634247.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202635307.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Successful.
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-2.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-7.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-15.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-40.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-43.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-77.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58
Warning: copy(/av-201.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
I believe you used this path during conversion?:
/home/sbpimnet/public_html/alumni/
please try /home/sbpimnet/public_html/alumni
(without trailing slash)
Quote from: TE on May 30, 2009, 02:02:02 AM
Any error messages during the conversion (white page, script stops, internal server error) ???
My browser says that the page timed out, it is a browser error not a SMF error but I've tried Google Chrome and Internet Explorer and it still happens.
Any ideas?
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.
Do you have any part of the conversion done? That you know of so far?
Quote from: SleePy on July 23, 2009, 09:28:35 PM
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.
Do you have any part of the conversion done? That you know of so far?
Yeah, like I said it finishes about half of the conversion, and I can see it when I browse the new forum (the parts it converted). Then that happens. It converts stuff like members but stops before it converts the
important stuff like posts, boards, and stats!
Anybody? This is getting kind of urgent now.
I don't like my server supports shell access because it wouldn't let me access it. :o
The conversion gets about half way through converting posts when it gives up. The very last number in the URL was 38500 I believe, the number that progresses up as it converts more posts.
please try to decrease the number of concurrent converted messages..
edit the invision23_to_smf.sql
find:
---* {$to_prefix}messages 200
replace it with:
---* {$to_prefix}messages 100
then restart the conversion.
Quote from: TE on July 28, 2009, 03:07:05 PM
please try to decrease the number of concurrent converted messages..
edit the invision23_to_smf.sql
find:
---* {$to_prefix}messages 200
replace it with:
---* {$to_prefix}messages 100
then restart the conversion.
Didn't work, still stops working when "start=39500" (the url). It's always that same number where it stops working... :(
Any chance to convert your forum offline? You could install a local webserver on your PC (XAMPP for example is an easy to install MySQL, PHP, Apache environment), then import your forum and convert it to SMF, then transfer the converted SMF back to your host..
Just did download the that .sql file from this thread the error message does not say "script error in line 23" anymore it just says:
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
http://www.simplemachines.org/community/index.php?topic=325809.0
I get duplicate entry errors because the answers are the same, but not the polls.
That means I have a lot polls that have the answer "yes". Each produces a duplicate entry error :(.
Anyone has an idea how to fix this?
hi,
I want to convert my board from ipb 2.3.6 to smf 1.1.10 but I get this error msg
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... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1250094278),
("conversion_from", "invision23_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1250094278)' at line 1
What can I do?
everything should be fine, that's a minor bug in convert.php (we add a database value after the conversion) and the conversion has already finished.
QuoteRecalculating forum statistics... Successful.
Hello, sorry for this post in this topic, I know the last post is from 12-08, but I need help with my IPB 2.3.6 to SMF 1.1.11 conversion.
I get this error:
Converting members... Unsuccessful!
This query:
SELECT
m.id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
m.joined AS dateRegistered,
IF(m.mgroup = 4, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_total AS instantMessages,
SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
SUBSTRING(m.email, 1, 255) AS emailAddress,
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
SUBSTRING(me.website, 1, 255) AS websiteTitle,
SUBSTRING(me.website, 1, 255) AS websiteUrl, me.signature,
SUBSTRING(me.location, 1, 255) AS location,
SUBSTRING(me.icq_number, 1, 255) AS ICQ,
SUBSTRING(me.msnname, 1, 255) AS MSN, SUBSTRING(me.aim_name, 1, 16) AS AIM,
m.hide_email AS hideEmail, m.email_pm AS pm_email_notify,
SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
'' 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 smileySet, '' AS memberIP2
FROM `fuertota_ctrlz`.ibf_members AS m
LEFT JOIN `fuertota_ctrlz`.ibf_member_extra AS me ON (m.id = me.id)
LEFT JOIN `fuertota_ctrlz`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
WHERE m.id != 0
LIMIT 0, 500;
Caused the error:
Table 'fuertota_ctrlz.ibf_member_extra' doesn't exist
I hope you can help me.
Thanks in advance.
Is there something, an admin option, in IPB, like enabling extra information about members? If yes, please enable it, then try again.
Thank you for your fast reply. It seems my pal forgot to put the SMF forum on the same host; he wanted to do a db conversion "on the fly" from one server to another.
Anyway, it is working now. Thank you for your help :)
Hi,
Happy New Year. I am trying to convert my IPB2.3.6 to SMF1.1.11 and get the following error:
Converting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `db23466_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 ('1410', '0', '1', '419', '115', '', '6', '290', '17065', '17099', '0'),
('1412', '0', '5', '24', '87', '', '10', '246', '17083', '17449', '0'),
('1413', '0', '3', '374', '1144', '', '7', '348', '17117', '17613', '0'),
('1414', '0', '1', '21', '30', '', '17', '820', '17119', '17255', '0'),
('1415', '0', '1', '125', '512', '', '33', '1113', '17153', '17993', '0'),
('1416', '0', '5', '560', '981', '', '1', '139', '17159', '17296', '0'),
('1417', '0', '1', '560', '86', '', '7', '310', '17173', '17623', '0'),
('1418', '0', '4', '974', '974', '', '5', '757', '17179', '17317', '0'),
('1419', '0', '1', '220', '21', '', '4', '221', '17194', '17201', '0'),
('1420', '1', '7', '262', '390', '', '9', '5182', '17226', '17320', '0'),
('1421', '0', '9', '1', '1', '', '0', '10', '17227', '17227', '0'),
('1422', '0', '4', '262', '359', '', '5', '1492', '17230', '17283', '0'),
('1423', '0', '10', '1074', '289', '', '3', '209', '17231', '17437', '0'),
('1424', '0', '3', '501', '151', '', '24', '846', '17236', '56128', '0'),
('1425', '0', '5', '58', '222', '', '171', '2548', '17261', '19186', '0'),
('1426', '0', '1', '512', '512', '', '14', '645', '17273', '18020', '0'),
('1427', '0', '10', '1055', '1511', '', '34', '1448', '17308', '38867', '0'),
('1428', '0', '10', '359', '359', '', '5', '376', '17326', '17528', '0'),
('1429', '0', '1', '657', '335', '', '20', '750', '17343', '17615', '0'),
('1430', '0', '4', '279', '279', '', '6', '803', '17392', '17454', '0'),
('1431', '0', '1', '98', '512', '', '8', '311', '17403', '17484', '0'),
('1432', '0', '5', '262', '156', '', '1', '228', '17419', '17427', '0'),
('1433', '0', '5', '560', '222', '', '14', '270', '17432', '17630', '0'),
('1434', '0', '5', '250', '250', '', '0', '128', '17455', '17455', '0'),
('1435', '0', '1', '284', '257', '', '12', '608', '17463', '17807', '0'),
('1436', '0', '1', '125', '125', '', '0', '300', '17467', '17467', '0'),
('1437', '0', '10', '1137', '1138', '', '18', '644', '17471', '17972', '0'),
('1438', '0', '10', '803', '1137', '', '4', '333', '17479', '19364', '0'),
('1440', '0', '5', '280', '280', '', '2', '118', '17491', '17494', '0'),
('1441', '0', '5', '30', '981', '', '32', '1311', '17498', '18264', '0'),
('1444', '0', '1', '143', '143', '', '0', '273', '17531', '17531', '0'),
('1445', '0', '3', '170', '512', '', '23', '872', '17556', '35398', '0'),
('1446', '0', '5', '222', '222', '', '2', '198', '17560', '17590', '0'),
('1447', '0', '1', '1143', '512', '', '22', '788', '17585', '17747', '0'),
('1448', '0', '10', '1139', '1139', '', '2', '212', '17596', '17854', '0'),
('1449', '0', '5', '222', '222', '', '2', '125', '17598', '17629', '0'),
('1450', '0', '5', '868', '868', '', '6', '230', '17639', '17961', '0'),
('1451', '0', '5', '222', '222', '', '0', '173', '17643', '17643', '0'),
('1452', '0', '3', '170', '256', '', '2', '387', '17644', '18089', '0'),
('1453', '0', '10', '147', '147', '', '0', '109', '17657', '17657', '0'),
('1454', '0', '10', '147', '1138', '', '2', '170', '17658', '17857', '0'),
('1455', '0', '10', '147', '147', '', '16', '1082', '17659', '22636', '0'),
('1456', '0', '1', '30', '512', '', '21', '619', '17660', '18017', '0'),
('1457', '0', '1', '30', '70', '', '17', '795', '17678', '17885', '0'),
('1458', '0', '5', '156', '156', '', '28', '602', '17680', '18448', '0'),
('1459', '0', '1', '501', '501', '', '7', '524', '17688', '18104', '0'),
('1460', '0', '1', '103', '30', '', '7', '336', '17691', '18522', '0'),
('1461', '0', '1', '1', '1', '', '5', '199', '17714', '17958', '1'),
('1462', '0', '10', '25', '25', '', '2', '250', '17715', '18152', '0'),
('1463', '0', '5', '324', '89', '', '14', '273', '17728', '18509', '0'),
('1464', '0', '5', '222', '222', '', '3', '292', '17786', '17793', '0'),
('1465', '0', '5', '24', '228', '', '3', '211', '17792', '17943', '0'),
('1466', '0', '1', '1148', '197', '', '7', '266', '17815', '17924', '0'),
('1467', '0', '1', '21', '175', '', '2', '229', '17818', '17843', '0'),
('1468', '0', '1', '299', '30', '', '7', '282', '17831', '17862', '0'),
('1469', '0', '5', '143', '222', '', '43', '611', '17860', '19191', '0'),
('1470', '0', '10', '547', '547', '', '0', '128', '17864', '17864', '0'),
('1471', '0', '10', '420', '420', '', '0', '141', '17865', '17865', '0'),
('1472', '0', '1', '38', '262', '', '43', '1710', '17879', '18195', '0'),
('1473', '0', '1', '280', '21', '', '1', '177', '17889', '17891', '0'),
('1474', '0', '4', '121', '430', '', '8', '414', '17894', '23965', '0'),
('1476', '0', '1', '439', '30', '', '10', '301', '17911', '17930', '0'),
('1477', '0', '1', '803', '1157', '', '15', '735', '17916', '19507', '0'),
('1478', '0', '3', '574', '574', '', '6', '833', '17908', '18129', '0'),
('1479', '0', '5', '222', '981', '', '7', '498', '17962', '18308', '0'),
('1480', '0', '1', '831', '222', '', '19', '801', '17975', '18955', '0'),
('1481', '0', '1', '371', '30', '', '6', '547', '17979', '18065', '0'),
('1482', '0', '1', '600', '762', '', '2', '220', '17983', '18005', '0'),
('1483', '0', '1', '412', '412', '', '0', '220', '17996', '17996', '0'),
('1484', '0', '4', '297', '297', '', '2', '435', '17999', '18274', '0'),
('1485', '0', '1', '512', '512', '', '15', '573', '18004', '18140', '0'),
('1486', '0', '1', '306', '126', '', '4', '446', '18007', '18063', '0'),
('1487', '0', '10', '483', '483', '', '5', '484', '18012', '20265', '0'),
('1488', '0', '1', '419', '444', '', '20', '652', '18022', '18653', '0'),
('1489', '0', '1', '371', '371', '', '0', '202', '18025', '18025', '0'),
('1490', '0', '1', '512', '262', '', '5', '252', '18027', '18041', '0'),
('1492', '0', '5', '80', '222', '', '25', '348', '18037', '18906', '0'),
('1493', '0', '5', '250', '981', '', '5', '502', '18050', '18338', '0'),
('1494', '0', '5', '45', '353', '', '3', '156', '18052', '18204', '0'),
('1495', '0', '14', '90', '30', '', '38', '1608', '18061', '25874', '0'),
('1496', '0', '5', '981', '981', '', '8', '196', '18064', '18096', '0'),
('1497', '0', '1', '98', '156', '', '5', '338', '18077', '18166', '0'),
('1499', '0', '5', '981', '222', '', '5', '189', '18106', '18118', '0'),
('1500', '0', '10', '323', '323', '', '3', '277', '18120', '18199', '0'),
('1501', '0', '1', '143', '151', '', '7', '304', '18145', '18391', '0'),
('1502', '0', '10', '1127', '1127', '', '1', '302', '18150', '20330', '0'),
('1503', '0', '1', '755', '981', '', '9', '579', '18156', '18335', '0'),
('1504', '0', '1', '444', '444', '', '0', '122', '18159', '18159', '0'),
('1507', '0', '1', '257', '257', '', '0', '195', '18185', '18185', '0'),
('1508', '0', '1', '1153', '11', '', '3', '310', '18193', '18207', '1'),
('1509', '0', '14', '104', '104', '', '4', '774', '18198', '18227', '0'),
('1510', '0', '1', '22', '175', '', '44', '1501', '18217', '18500', '0'),
('1511', '0', '1', '419', '38', '', '17', '758', '18229', '18576', '0'),
('1512', '0', '1', '412', '812', '', '1', '305', '18235', '18253', '0'),
('1513', '0', '1', '1153', '981', '', '8', '271', '18241', '18330', '0'),
('1514', '0', '5', '229', '229', '', '0', '165', '18245', '18245', '0'),
('1515', '0', '4', '27', '100', '', '5', '336', '18257', '18637', '0'),
('1516', '0', '4', '1153', '359', '', '2', '373', '18263', '18282', '0'),
('1517', '0', '1', '77', '250', '', '2', '300', '18287', '18316', '0'),
('1518', '0', '1', '394', '1074', '', '44', '1329', '18299', '18880', '0'),
('1519', '0', '4', '265', '200', '', '10', '564', '18315', '19583', '0'),
('1520', '0', '5', '256', '256', '', '15', '261', '18339', '18567', '0'),
('1521', '0', '4', '803', '803', '', '5', '491', '18355', '18441', '0'),
('1522', '0', '1', '333', '353', '', '28', '872', '18357', '18708', '0'),
('1523', '0', '1', '419', '0', '', '12', '480', '18394', '18491', '0'),
('1524', '0', '5', '1072', '222', '', '23', '481', '18421', '19272', '0'),
('1528', '0', '10', '549', '483', '', '11', '1701', '18458', '23476', '0'),
('1529', '0', '1', '143', '38', '', '2', '233', '18463', '18469', '0'),
('1531', '0', '1', '38', '197', '', '20', '591', '18467', '18895', '0'),
('1532', '0', '1', '1139', '447', '', '1', '283', '18477', '18479', '0'),
('1533', '0', '14', '1153', '1153', '', '5', '1083', '18492', '19590', '0'),
('1534', '0', '1', '175', '333', '', '14', '357', '18497', '18663', '0'),
('1535', '0', '5', '554', '297', '', '6', '165', '18512', '18999', '0'),
('1536', '0', '1', '598', '918', '', '54', '3796', '18515', '20622', '0'),
('1537', '0', '14', '39', '34', '', '18', '658', '18516', '25595', '0'),
('1538', '0', '14', '512', '512', '', '8', '911', '18521', '18964', '0'),
('1539', '0', '1', '325', '447', '', '4', '425', '18523', '18675', '0'),
('1540', '0', '10', '1161', '1055', '', '4', '334', '18536', '19456', '0'),
('1541', '0', '5', '21', '297', '', '2', '132', '18537', '18997', '0'),
('1542', '0', '4', '560', '115', '', '6', '536', '18583', '18731', '0'),
('1543', '0', '3', '1164', '512', '', '3', '340', '18592', '18786', '0'),
('1544', '0', '1', '560', '361', '', '38', '877', '18597', '18831', '0'),
('1545', '0', '1', '263', '222', '', '1', '365', '18598', '18954', '0'),
('1546', '0', '1', '870', '870', '', '0', '127', '18600', '18600', '0'),
('1547', '0', '12', '870', '870', '', '2', '529', '18606', '21640', '0'),
('1548', '0', '12', '870', '1251', '', '3', '704', '18607', '28741', '0'),
('1549', '0', '5', '560', '222', '29', '28', '465', '18610', '19348', '0'),
('1550', '0', '1', '98', '45', '', '24', '756', '18620', '18917', '0'),
('1551', '0', '5', '870', '870', '', '2', '136', '18621', '21650', '0'),
('1552', '0', '5', '374', '374', '', '0', '225', '18625', '18625', '0'),
('1553', '0', '4', '1121', '68', '', '12', '534', '18641', '18755', '0'),
('1554', '0', '1', '444', '444', '', '0', '127', '18662', '18662', '0'),
('1555', '0', '1', '444', '297', '', '5', '342', '18666', '19005', '0'),
('1556', '0', '1', '367', '115', '', '35', '1462', '18671', '19138', '0'),
('1557', '0', '10', '297', '483', '', '1', '218', '18724', '21592', '0'),
('1559', '0', '4', '0', '200', '', '4', '643', '18756', '19024', '0'),
('1560', '0', '5', '297', '297', '', '3', '229', '18769', '18792', '0'),
('1561', '0', '1', '1167', '1167', '', '16', '690', '18788', '19584', '0'),
('1562', '0', '3', '512', '100', '', '7', '438', '18796', '21735', '0'),
('1563', '0', '14', '121', '1', '', '9', '1417', '18845', '19211', '0'),
('1564', '0', '4', '1138', '447', '', '9', '407', '18857', '19758', '0'),
('1566', '0', '14', '39', '323', '', '2', '605', '18876', '18961', '0'),
('1568', '0', '14', '30', '21', '', '22', '1391', '18908', '20005', '0'),
('1569', '0', '1', '439', '419', '', '5', '321', '18909', '19115', '0'),
('1570', '0', '1', '30', '30', '', '1', '273', '18911', '19035', '0'),
('1571', '0', '5', '222', '222', '', '7', '143', '18916', '19289', '0'),
('1574', '0', '3', '554', '126', '', '15', '632', '18948', '19580', '0'),
('1575', '0', '1', '377', '1010', '', '18', '568', '18974', '19216', '0'),
('1576', '0', '5', '80', '222', '', '28', '451', '18975', '19485', '0'),
('1577', '1', '7', '1173', '1284', '', '30', '7359', '18978', '54419', '0'),
('1578', '0', '1', '64', '1', '', '1', '272', '18991', '19214', '0'),
('1579', '0', '1', '654', '1', '', '2', '135', '19009', '19212', '0'),
('1580', '0', '5', '256', '222', '', '1', '123', '19011', '19275', '0'),
('1581', '0', '1', '1176', '657', '', '36', '1209', '19014', '19853', '0'),
('1582', '0', '1', '560', '299', '30', '9', '759', '19036', '19520', '0'),
('1583', '0', '14', '121', '197', '', '1', '591', '19086', '19193', '0'),
('1584', '0', '10', '1176', '1176', '', '0', '205', '19089', '19089', '0'),
('1586', '0', '14', '918', '39', '', '15', '1328', '19128', '19368', '0'),
('1587', '0', '1', '501', '803', '', '23', '762', '19061', '19263', '0'),
('1588', '0', '1', '498', '1010', '', '16', '800', '19145', '19336', '0'),
('1590', '0', '1', '21', '45', '', '30', '1493', '19156', '19612', '0'),
('1591', '0', '1', '321', '321', '', '3', '343', '19165', '19610', '0'),
('1592', '0', '1', '100', '498', '', '9', '398', '19175', '19508', '0'),
('1593', '0', '1', '222', '222', '', '2', '179', '19210', '19345', '0'),
('1596', '0', '13', '177', '115', '', '1', '809', '19238', '19648', '0'),
('1597', '0', '1', '560', '280', '', '2', '191', '19251', '19254', '0'),
('1598', '0', '5', '280', '280', '', '1', '158', '19258', '19259', '0'),
('1599', '0', '5', '498', '13', '', '29', '716', '19269', '19844', '0'),
('1600', '0', '4', '289', '692', '', '9', '334', '19274', '20409', '0'),
('1601', '0', '5', '30', '222', '', '22', '617', '19277', '21464', '0'),
('1602', '0', '3', '170', '605', '', '4', '594', '19304', '19992', '0'),
('1603', '0', '1', '512', '762', '', '12', '448', '19306', '19402', '0'),
('1604', '0', '4', '359', '38', '', '52', '1809', '19307', '23458', '0'),
('1607', '0', '3', '554', '306', '', '15', '716', '19331', '22412', '0'),
('1608', '0', '4', '641', '472', '', '1', '269', '19333', '19361', '0'),
('1610', '0', '10', '483', '483', '', '3', '240', '19343', '20266', '0'),
('1611', '0', '10', '98', '98', '', '0', '178', '19362', '19362', '0'),
('1612', '0', '14', '21', '145', '', '12', '918', '19369', '20087', '0'),
('1613', '0', '5', '263', '222', '', '29', '665', '19370', '23735', '0'),
('1614', '0', '1', '143', '115', '', '26', '1562', '19371', '19596', '0'),
('1616', '0', '1', '289', '27', '', '7', '336', '19386', '19423', '0'),
('1617', '0', '1', '433', '649', '', '7', '413', '19397', '19582', '0'),
('1618', '0', '1', '359', '11', '', '2', '270', '19425', '19502', '0'),
('1619', '0', '14', '39', '39', '', '4', '784', '19432', '19446', '0'),
('1620', '0', '3', '512', '1234', '', '4', '451', '19433', '21599', '0'),
('1621', '0', '5', '560', '222', '31', '27', '476', '19452', '21465', '0'),
('1622', '0', '5', '222', '868', '', '4', '164', '19468', '19708', '0'),
('1623', '0', '10', '238', '238', '', '4', '451', '19474', '21570', '0'),
('1624', '0', '1', '693', '1153', '', '15', '544', '19483', '19667', '0'),
('1625', '0', '1', '758', '444', '', '19', '879', '19495', '19807', '0'),
('1626', '0', '10', '1187', '444', '', '26', '952', '19505', '28858', '0'),
('1627', '0', '10', '657', '395', '', '1', '394', '19506', '19640', '0'),
('1628', '0', '10', '1193', '1193', '', '10', '439', '19514', '20821', '0'),
('1629', '0', '13', '512', '512', '', '4', '1163', '19522', '22070', '0'),
('1630', '0', '10', '1189', '1137', '', '2', '250', '19529', '21862', '0'),
('1631', '0', '4', '299', '301', '', '16', '1124', '19549', '20875', '0'),
('1632', '0', '1', '693', '693', '', '1', '246', '19557', '19558', '0'),
('1633', '0', '4', '27', '27', '', '0', '157', '19572', '19572', '0'),
('1634', '0', '1', '325', '981', '', '50', '1782', '19577', '20370', '0'),
('1635', '0', '1', '79', '447', '', '3', '447', '19585', '19756', '0'),
('1636', '0', '1', '1153', '98', '', '9', '732', '19591', '19687', '0'),
('1637', '0', '5', '38', '38', '', '0', '130', '19592', '19592', '0'),
('1638', '0', '4', '80', '279', '', '8', '884', '19599', '19921', '0'),
('1639', '0', '5', '228', '228', '', '12', '273', '19603', '21745', '0'),
('1640', '0', '5', '45', '228', '', '12', '432', '19618', '21127', '0'),
('1641', '0', '4', '297', '297', '', '0', '189', '19632', '19632', '0'),
('1642', '0', '1', '419', '37', '', '5', '491', '19656', '19866', '0'),
('1643', '0', '1', '115', '115', '', '4', '422', '19678', '19959', '0'),
('1644', '0', '3', '296', '37', '', '4', '534', '19680', '19926', '0'),
('1645', '0', '4', '1153', '692', '', '10', '431', '19698', '20405', '0'),
('1646', '0', '1', '367', '37', '', '21', '589', '19703', '19863', '0'),
('1647', '0', '3', '603', '603', '', '0', '252', '19711', '19711', '0'),
('1648', '0', '4', '1121', '498', '', '36', '2723', '19725', '25354', '0'),
('1649', '0', '5', '419', '222', '', '10', '307', '19731', '20253', '0'),
('1650', '0', '5', '228', '228', '', '9', '680', '19736', '20392', '0'),
('1651', '0', '1', '444', '762', '', '14', '507', '19762', '20629', '0'),
('1654', '0', '10', '115', '115', '', '2', '398', '19784', '19808', '0'),
('1655', '0', '1', '80', '27', '', '3', '341', '19796', '19815', '0'),
('1656', '0', '10', '468', '394', '', '4', '641', '19800', '20788', '0'),
('1657', '0', '1', '803', '419', '', '7', '313', '19817', '19936', '0'),
('1658', '0', '1', '115', '38', '', '3', '214', '19827', '19898', '0'),
('1659', '0', '1', '151', '575', '', '9', '305', '19828', '19909', '0'),
('1660', '0', '1', '151', '1124', '32', '20', '1002', '19838', '21318', '0'),
('1661', '0', '1', '272', '38', '', '2', '297', '19856', '19897', '0'),
('1663', '0', '5', '289', '1138', '', '2', '403', '19867', '20236', '0'),
('1664', '0', '4', '0', '359', '', '2', '205', '19876', '19893', '0'),
('1665', '0', '10', '420', '420', '', '1', '267', '19878', '20106', '0'),
('1666', '0', '1', '447', '222', '', '17', '936', '19881', '20222', '0'),
('1667', '0', '1', '498', '605', '', '9', '308', '19912', '19989', '0'),
('1668', '0', '1', '512', '359', '', '2', '330', '19916', '19988', '0'),
('1669', '0', '1', '145', '125', '', '7', '474', '19931', '20229', '0'),
('1670', '0', '1', '1153', '1153', '', '11', '372', '19932', '20162', '0'),
('1671', '0', '5', '229', '229', '', '0', '243', '19937', '19937', '0'),
('1672', '0', '5', '918', '918', '', '0', '519', '19950', '19950', '0'),
('1673', '0', '4', '560', '344', '', '14', '266', '19952', '20352', '0'),
('1674', '0', '5', '256', '222', '', '204', '3542', '19963', '23397', '0'),
('1675', '0', '10', '262', '297', '', '4', '256', '19974', '20443', '0'),
('1676', '0', '1', '377', '42', '', '124', '4712', '19975', '21863', '0'),
('1677', '0', '1', '560', '27', '', '1', '310', '19995', '20010', '0'),
('1678', '0', '1', '21', '21', '', '0', '180', '19996', '19996', '0'),
('1679', '0', '10', '1203', '1203', '', '3', '687', '20036', '20793', '0'),
('1680', '0', '3', '1203', '1203', '', '2', '516', '20038', '20115', '0'),
('1681', '0', '1', '512', '115', '', '40', '1425', '20040', '20389', '0'),
('1682', '0', '1', '419', '692', '', '81', '3030', '20053', '20810', '0'),
('1684', '0', '5', '297', '211', '', '21', '362', '20096', '21725', '0'),
('1685', '0', '1', '498', '1010', '', '8', '384', '20101', '20281', '0'),
('1686', '0', '10', '78', '78', '', '5', '315', '20148', '20868', '0'),
('1687', '0', '1', '1208', '444', '', '9', '401', '20169', '20640', '0'),
('1688', '0', '4', '981', '981', '', '9', '388', '20194', '21139', '0'),
('1689', '0', '1', '201', '30', '', '9', '559', '20202', '20760', '0');
Caused the error:
Duplicate entry '1410' for key 1
Any idea on what needs to be done?
Thanks
hello! I use the converter in the begin of topic, but have a problem..
I try convert ipb2.3.1 to smf_1-1-11. there is logs:
"Converting...
...
Converting settings...
Notice: unserialize() [function.unserialize]: Error at offset 119 of 216 bytes in E:\WebServers\home\172.**.**.13\www\convert.php(941) : eval()'d code on line 45
...
Successful.
Recalculating forum statistics... Successful.
Conversion Complete"
new forum work normally, but I doubt of correctness of converting
please help, thanks
pioner, the settings aren't converted properly and the converter didn't convert all following steps (attachments, avatars)
I'd recommend to remove this block from invision23_to_smf.sql
/******************************************************************************/
--- Converting settings...
/******************************************************************************/
---# Moving settings...
---{
// We will do all updates once we find them all.
$update_settings = array();
$result = convert_query("
SELECT
conf_key AS config_name,
IF(conf_value = '', conf_default, conf_value) AS config_value
FROM {$from_prefix}conf_settings");
while ($row = mysql_fetch_assoc($result))
{
switch ($row['config_name'])
{
case 'board_name':
$inv_forum_name = $row['config_value'];
break;
case 'offline_msg':
$inv_maintenance_message = str_replace("\n", '<br />', $row['config_value']);
break;
case 'hot_topic':
$update_settings['hotTopicPosts'] = $row['config_value'];
break;
case 'display_max_posts':
$update_settings['defaultMaxMessages'] = $row['config_value'];
break;
case 'display_max_topics':
$update_settings['defaultMaxTopics'] = $row['config_value'];
break;
case 'flood_control':
$update_settings['spamWaitTime'] = $row['config_value'];
break;
case 'allow_online_list':
$update_settings['onlineEnable'] = $row['config_value'];
break;
case 'force_login':
break;
default:
break;
}
}
mysql_free_result($result);
$result = convert_query("
SELECT cs_value
FROM {$from_prefix}cache_store
WHERE cs_key = 'stats'");
list ($inv_stats) = mysql_fetch_row($result);
$inv_stats = unserialize($inv_stats);
if (!empty($inv_stats['most_count']) && !empty($inv_stats['most_date']))
{
$update_settings['mostOnline'] = $inv_stats['most_count'];
$update_settings['mostDate'] = $inv_stats['most_date'];
}
// While we coulddo this in one big batch, lets do it one by one.
foreach ($update_settings as $key => $value)
convert_query("
REPLACE INTO {$to_prefix}settings
(variable, value)
VALUES ('" . addslashes($key) . "', '" . addslashes($value) . "')");
updateSettingsFile(array(
'mbname' => '\'' . addcslashes($inv_forum_name, '\'\\') . '\'',
'mmessage' => '\'' . addcslashes($inv_maintenance_message, '\'\\') . '\''
));
---}
---#
this block only converts some basic settings (forum title and such stuff), therefore you can remove it and all important data such as members, posts, topics and the board structure is still converted. after you removed that block from the conveter file you should restart the conversion from the beginning.
TE, thanks for help! it's work.
Last time when i try to convert ipb2.3.1 to smf1.1.11 I have seen errors about converting avatars, as you say :), but forum is working, just copy avatars to the smf directory... When i try again, and remove that block from invision23_to_smf.sql - but errors has still :( Then I delete avatars at all users, and begin convert again - it's successful done!
Today I tried convert to smf 2.0rc2, and has more errors. Some of them fixed, but one I can't fix, so it was necessary converting to 1.1.11 and upgrade it to 2.0rc2. Thank you for help again! /sorry for my english
things seem to run nicely but it stops when it get to posts i guess its caused by Arabic characters
does the converter support latin1 character set?
when the converter asked me for a char set it had a short list .. i chose cp1256
any ideas what to do
Can you please tell what is the error when it stops or what does it do?
What is the character set in which the original forum database stores posts?
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `smf`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, subject, posterName, posterIP, smileysEnabled, modifiedTime, modifiedName, ID_BOARD, body, posterEmail, icon)
original board used latin1_swedish_ci so when i created another database for smf i chose to use the same charset .. but i don't know what's wrong
i just posted the beginning of the error .. the rest has IPs within but here's a sample for the post/msg body
دينا باب حجرة داليا بمرح و اعتياد قائلة: دولي..انا.. فوجدتها تقرأ القرآن
these were arabic characters :D
Please note that the error message (started as you say above) also should end in something more - more explanation. Can you please paste that one as well?
Caused the error:
MySQL server has gone away
that's all .. b4 that there were also some
لمشاركاتك معانا في المواضيع المختلفة
and mails / IPs of the posters
Quote from: Domi5 on April 19, 2010, 05:46:13 PM
Caused the error:
MySQL server has gone away
Please check out about this error, perhaps it helps:
MySQL has gone away / Lost connection to server during query (http://docs.simplemachines.org/index.php?topic=1501.msg4941#msg4941)
i still can't go around this limitation .. where to change it ? i checked the my.ini nothing there sets any timeout
beside am testing on my pc now using wamp .. but when i try to convert the original board i wont have access to mysql settings
Sorry for the delay.
Please, try: (invision23_to_smf.sql)
---* {$to_prefix}messages 200
---* {$to_prefix}messages 100
Im totally confused :(
I currently have IPB 3.0.1 and i just got a SMF Forum and my users from my previous board would like all their post to be on the new forum we have now which is SMF. I have downloaded the converter file but I started to get lost from that point on. Could anybody help me on how to convert, thanks:)
I'm interested in how the convert works exactly. I'm hesitant to use it on a live board and have been trying to make a duplicate to run the test on. If it only reads and exports from the IPB then I don't see any reason I couldn't use it on the live board. I hope with all the hard work done on this converter that it serves my needs. I've been wanting to get off of IPB for a long time.
you can use your live board for the conversion, the converter makes a copy from the source system's data to SMF. the source system (IPB) will remain untouched.
please check out Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
I'm trying to convert IPB 2.3.1 to SMF (either version) using the relevant converters (http://download.simplemachines.org/?converters;software=invision) locally. I've got my Invision board running on my home server and I've got SMF installed (2.0 RC5) at the moment using the same database.
When I try to run the conversion script it gets to
QuoteConverting...
Successful.
Recalculating forum statistics...
It doesn't go any further or provide any buttons and when I check the SMF forum absolutely nothing has happened. When I view the source code of the page it doesn't finish (there's no end to the body tags/html tags, it just stops at "statistics..."). Observe:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>SMF Converter</title>
<script type="text/javascript" src="Themes/default/scripts/script.js"></script>
<link rel="stylesheet" type="text/css" href="http://simplemachines.org/smf/style.css" />
</head>
<body>
<div id="header">
<div title="Bahamut!">SMF Converter</div>
</div>
<div id="content">
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="padding-top: 1ex;">
<tr>
<td width="250" valign="top" style="padding-right: 10px;">
<table border="0" cellpadding="8" cellspacing="0" class="tborder" width="240">
<tr>
<td class="titlebg">Steps</td>
</tr>
<tr>
<td class="windowbg2">
<span class="stepdone">Select Script</span><br />
<span class="stepdone">Welcome</span><br />
<span class="stepcurrent">Main Conversion</span><br />
<span class="stepwaiting">Recount Totals and Statistics</span><br />
<span class="stepwaiting">Done</span><br />
</td>
</tr>
</table>
</td>
<td width="100%" valign="top">
<div class="panel">
<h2>Converting...</h2> Successful.<br />
Recalculating forum statistics...
I don't know if there are any error logs I should be checking (nowhere seems to document where the converter script logs to). What's going on?
I'd like to add that I had the exact same problem with the 1.x branch of SMF.
What can I do to give you the information you'd need to help me?
Has anyone else encountered something similar?
IPB 2.3.6
smf 2.0.2
Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)
Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)
Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)
Quote from: Aeolus on April 12, 2012, 08:10:44 PM
IPB 2.3.6
smf 2.0.2
Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)
Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)
Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)
same problem.... anyone?
Quote from: Quexinos on April 24, 2012, 03:05:02 AM
Quote from: Aeolus on April 12, 2012, 08:10:44 PM
IPB 2.3.6
smf 2.0.2
Use the convert
Invision 2.3 to SMF 2-0 from here (http://download.simplemachines.org/?converters;software=invision)
Get these errors.
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)
Search the topic (http://www.simplemachines.org/community/index.php?topic=238557.0), but no help.
Thanks. :)
same problem.... anyone?
Yes, I have the same problem
is anybody here????? heeeeeeeeeeelp!!!!!
I have an even more basic problem.
Basically, having read the conversion document I'm not exactly clear where I need to specify the from and to paths within convert.php and what path structure it is expecting (do I need to specify the location of the installed forum software or the sql database itself?).
You need to specify the installed forum software for both SMF and IPB. Just upload the converter files to the same directory as SMF was installed, and the path for SMF is automatically detected..
a sample screenshot, hope it helps: http://www.smfportal.de/wiki/Converter.jpg
Thanks Thorsten. I had read the instructions that appeared to suggest the paths had to be input somewhere into the convert.php file itself, which is what threw me.
I have now got past that and have the same error as the posters above me ("Wrong value type sent to the database. Date expected. (birthdate)")
Any ideas? Is this a specific problem with the IPB 2.3 conversion tool?
in invision23_to_smf.sql find:
$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);
add after
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
Hope it helps..
Thanks. I think this could bea long process. :)
I now have this error:
Converting members...Wrong value type sent to the database. Integer expected. (instant_messages)
This "new" bug can be fixed, find:
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
add after:
$row['instant_messages'] = (int) $row['instant_messages'];
The converter seems to be full of bugs :o Probably it's better to use the SMF 1.1x converter (that one should be free of bugs) and upgrade to SMF 2.0 at a later stage..
Hmm. You may be right, but I have set up a database using SMF 2.0, I suppose I could set one up using SMF 1.1 and upgrade later. Would that be easier? There doesn't seem to be an upgrade from SMF 1.16 to 2.02, the only upgrade I can see is from 2.01 to 2.02.
I have a new error: -
Converting members...Wrong value type sent to the database. Integer expected. (hide_email)
(sorry about this).
Quote from: quercus on September 03, 2012, 01:42:44 PM
Hmm. You may be right, but I have set up a database using SMF 2.0, I suppose I could set one up using SMF 1.1 and upgrade later. Would that be easier? There doesn't seem to be an upgrade from SMF 1.16 to 2.02, the only upgrade I can see is from 2.01 to 2.02.
You could install SMF1.1 with a different table prefix and use the same database.. Upgrading SMF from 1.1 to 2.0.2 is easy, don't worry.. (http://wiki.simplemachines.org/smf/Upgrading)
But we can fix the converter as well, the errors are related to MySQL beeing in strict mode.. Hopefully we've found the most ..
in invision23_to_smf.sql find
m.hide_email AS hide_email
,
replace it wtih
1 AS hide_email,
Thanks again.
Here is the latest error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_poll)
find
---* {$to_prefix}topics 5
replace with
---* {$to_prefix}topics 10
--{
$row['id_poll'] = (int) $row['id_poll'];
--}
Hmm. That string doesn't appear to exist in the convert.php file.
There is an ---* {$to_prefix}topics 250. Is that what you mean?
I believe my ipb23_to_sms.sql is different :o
But yes, that's the related line in your file..
add after
--{
$row['id_poll'] = (int) $row['id_poll'];
--}
Thanks. A new error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
--{
$row['id_poll'] = (int) $row['id_poll']
LIMIT 0, 250;
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 '--{
$row['id_poll'] = (int) $row['id_poll']
LIMIT 0, 250' at line 1
ouch, my mistake..
instead of
--{
$row['id_poll'] = (int) $row['id_poll'];
--}
it needs to be
---{
$row['id_poll'] = (int) $row['id_poll'];
---}
Thanks.
It got further this time:
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Wrong value type sent to the database. Integer expected. (modified_time)
mhh, I'm not sure about the undefined index errors.. does it appear while converting posts?
the second one is easy to fix:
find
$row['body'] = preg_replace("~<img .*?bbc_emoticon' alt='(.+?)' />~ie", '\'$1\'', $row['body']);
add after:
$row['modified_time'] = (int) $row['modified_time'];
That line of code isn't found.
mhh, ok.. would you please attach your modified version pf ipb23_to_smf.sql? my version of ipb23_to_smf.sql seems different..
Sure, here it is.
I've fixed the two bugs, please try the attached version..
Thanks for that. More errors in the conversion I'm afraid.
There were lots of them so I have removed the duplicate entries:
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11
Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11
Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Notice: Use of undefined constant id_poll - assumed 'id_poll' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 31
Notice: Undefined index: question in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 11
Notice: Undefined index: choice in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Warning: Invalid argument supplied for foreach() in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 17
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
Ok, I've fixed another two bugs but it's getting more and more complicated, simply because I don't have an IPB 2.3 database in order to test my fixes :P Hope this version works..
Hmm. Looks like the same sort of errors again.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
Maybe we need to remove some steps from the converter but try this version first...
Thanks Thorsten. New errors:
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events...Error in convert script - line 560!
Error in convert script - line 561!
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Parse error: syntax error, unexpected '{' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 1
Wrong value type sent to the database. Date expected. (start_date)
ok, I've removed the calendar events conversion as well as converting permissions and board permissions. (If permissions are very important for you we can always add it back, later)
please try the attached version :)
Getting there I think:
Converting settings...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/hussars/public_html/forums2/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: variable
ok, let's try it without settings (just the forum name and some general information, nothing special)...
*Sigh*
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments...
Notice: Use of undefined constant attachmentUploadDir - assumed 'attachmentUploadDir' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40
Warning: filesize() [function.filesize]: stat failed for attachmentUploadDir/35_e5a8e6067b12d75363b127c213bc3b2a1e11a16c in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40
Wrong value type sent to the database. Integer expected. (size)
next one, another two bugs fixed ;)
Excellent - that seems to have finally (more or less) cracked it.
The bb code seems a bit messed up and there are lots of custom images and groups that need to be sorted out, but the basic forum has been converted.
Now I just need to figure out how the member groups, permissions and codes within SMF work!
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Quote from: quercus on September 23, 2012, 11:04:51 AM
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube
Quote from: Thorsten Eurich on September 23, 2012, 12:17:58 PM
Quote from: quercus on September 23, 2012, 11:04:51 AM
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube
why when I update 2.3.6 to smf 2.0 users passwords is changed. it is not good
Nakto,
SMF and IPB are using different password encrytions but SMF should be able to read the old IPB passwords. At first time login the password will be updated to SMF's encryption.
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?
Quote from: Nakto on October 19, 2012, 03:42:28 PM
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?
no clue, maybe the password_salt in IPB has more than 5 characters..
added a modified version of the converter, please try the attached file.
Quotemaybe the password_salt in IPB has more than 5 characters..
yes, my pass have more 5 characters.
Quoteadded a modified version of the converter,
without any changes
when i converted forum to smf , converter have a error :
Notice: Undefined variable: oldAvatarDir in /home/user566952/smf/convert.php(1254) : eval()'d code on line 58
Warning: copy(/av-124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/user566952/smf/convert.php(1254) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.
maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt
Quote from: Nakto on October 20, 2012, 09:27:12 AM
without any changes
You'd better checked my file:
ALTER TABLE {$to_prefix}members
CHANGE COLUMN passwd passwd varchar(64) NOT NULL default '',
CHANGE COLUMN password_salt password_salt varchar(64) NOT NULL default '';
Quote from: Nakto on October 20, 2012, 09:39:42 AM
maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt
password_salt is a field in SMF (table smf_members)
Which charset / language is your forum?
Quote from: Thorsten Eurich on October 21, 2012, 03:06:52 AM
Which charset / language is your forum?
IPB and SMF in win-1251 / english
Quote from: Nakto on October 21, 2012, 04:44:09 AM
win-1251 / english
That's most likely the reason.
I'm sorry, but you'll have to use the "forgotten password" link.
hi , where can i download the convert.php file? i tried clicking the link on your first post and i just keep going in circles clicking on links :o
Hi,
i get this error: Unknown system variable 'SQL_MAX_JOIN_SIZE'
What to do? IPB 2.3.6 use XAMPP
Are you using this converter?
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_invision23_converter.zip
In convert.php you should find:
// Attempt to allow big selects, only for mysql so far though.
if ($smcFunc['db_title'] == 'MySQL')
{
$results = $smcFunc['db_query']('', "SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE", 'security_override');
list($big_selects, $sql_max_join) = $smcFunc['db_fetch_row']($results);
// Only waste a query if its worth it.
if (empty($big_selects) || ($big_selects != 1 && $big_selects != '1'))
$smcFunc['db_query']('', "SET @@SQL_BIG_SELECTS = 1", 'security_override');
// Lets set MAX_JOIN_SIZE to something we should
if (empty($sql_max_join) || ($sql_max_join == '18446744073709551615' && $sql_max_join == '18446744073709551615'))
$smcFunc['db_query']('', "SET @@SQL_MAX_JOIN_SIZE = 18446744073709551615", 'security_override');
}
Remove it.
Followed the advice posted earlier in this thread and still getting errors. Converting IP.Board 2.3.5 to SMF 2.0 using the converter available on the site.
the error is:
Converting calendar events...Error in convert script - line 550!
Error in convert script - line 551!
Wrong value type sent to the database. Date expected. (start_date)
I have no way to debug that right now... The easiest way (for now...) is not to convert said calendar events. Are you actively using calendar events in IPB?
unfortunately we are, ill skip them for now and figure out some way to get them over. Thanks though
If you really need it, let's try to fix it instead of skipping it. It will be that much complicated to do after you are already running SMF.
If you want to help me helping you :P I need to see the converter in place. Is it OK to you to send me your cPanel login details? That way I can see what's wrong in the converter (or incompatible with your setup), fix it for you and improve the converter in the process :)
BTW: which converter are you using? The one from the first post in this topic?
unfortunately im not at liberty to give you cpanel access. Its not my server.
I am using the converter from http://download.simplemachines.org/?converters Invision 2.3 to SMF 2.0
I understand that. Can you maybe export your database, zip and password-protect it and upload it somewhere so that I can try it locally?
Its ok, I got past it, we can re-create the calendar events wthout too much hassle. Having another problem though. The conversion completed successfully, however none of the topics have text in them, just the topic title.
Can you check in phpmyadmin, table smf_meessages, and check if the content is really there or not?
I am attempting to use this converter with an IP Board version 2.3.6 forum, and while I was able to get it working after applying several integer cast edits (to catch fields which had NULL values), now I'm stumped.
The entire contents of the smf_messages table has empty body fields, and I can verify that the original ibf_posts table contains valid post bodies, although possibly with some control characters in them? When I select them using the mysql command line tool, they emit control codes that affect the terminal.
I already have a convenient compressed and encrypted copy of the database, which I can share via PM, but beware, it's over 200MB compressed using xz -9, or 1.2GB uncompressed.
E: Disregard the duplicate primary keys error I encountered, it was due to resuming a step in the middle of operating on a given table, I just needed to delete everything converted including and following the specified record to resume, after making further edits to the script.
Somehow the script in this topic expects camelCase field IDs, while the 2.0.11 I have expects underscore separated field names.
E2: Now I am getting this error partway through the conversion if I enable debugging support, which would seem to indicate that the PHP session is expiring. I have no idea why it would do that, since I have set the expiration time to 24 hours for the duration of my conversion process.
Notice: Undefined index: convert_script in /var/www/xx/convert.php on line 66
Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/xx/convert.php on line 70
E3: I fixed the session problem by manually transplanting the session variables from the previous session into the "new" one that was spontaneously created when I added the debug variable to the get parameters.
Now it's on to posts, and actually appears to be converting post bodies this time around.
E4: Yes, that duplicate index error. Perhaps it is a VERY BAD IDEA to try to cram multiple conversions into a single step of the convert page? Or at least advance a page load so you're always starting a new step on each page load? That way, a refresh doesn't result in errors like that, where the target data already exists, but the step thinks it needs to finish the job again.
Never mind, it seems I can't just DELETE ranges willy nilly, as the table items are OUT OF ORDER. Goody.
So, the correct action is to add an $ignore = true; line temporarily to a given step of the sql/php script, and/or start over from substep 0 when making changes to the script.