• Welcome to Simple Machines Community Forum. Please login or sign up.

[SMF Converter] IPB 1.3.x

Started by JayBachatero, January 28, 2007, 02:56:33 PM

Previous topic - Next topic

lkw888

April 24, 2009, 09:02:17 AM #140 Last Edit: April 24, 2009, 09:21:55 AM by lkw888
Hi, I encounter this error while converting from IPB1.3.1 using the converter, can anyone help?  Many thanks in advance!

Converting members... Unsuccessful!
This query:

Caused the error:

Duplicate entry '731' for key 1

Quotehave you tried to restart the conversion from the beginning?
Sometimes clicking "continue" will cause errors and cause a double submission of the form. try to restart. convert.php should continue it's work without clicking the "continue" button.

This seems like a solution but can someone explains how to restart the conversion w/o clicking on the "continue" button?

lkw888

I managed to resolved the Converting members error by deleting that particular member (seem to be corrupted coz can't trace back to his posts).

Now I got a new error, appreciate if anyone can enlighten me how to resolve it, many thanks in advance.

Converting topics... Unsuccessful!
This query:
INSERT INTO `tyrone_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 ('1084', '0', '13', '5', '5', '', '0', '8', '16201', '16201', '0'),

...

Caused the error:

Duplicate entry '1084' for key 1

lkw888

April 24, 2009, 12:52:59 PM #142 Last Edit: April 24, 2009, 12:59:02 PM by lkw888
I managed to solve the Converting topics... Unsuccessful! error by changing part of the URL and end with step=1084 (since it says duplicate entry "1084").  Now it says conversion completed by it throws out some error msgs.  Can someone enlighten me if it's ok?  If yes, I will do the conversion on the real forum (I'm testing with a test forum).

Million thanks in advance!

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 permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059122411.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059122427.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059653504.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059747800.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059810224.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059822310.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059822703.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061832124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1061522502.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061645338.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061645375.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061704896.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061742834.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6

Warning: copy(/home/tyrone/public_html/forum/uploads/post-12-1066788277.ibf) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Successful.
Converting avatars...
Warning: copy(/home/tyrone/public_html/forum/uploads/av-2.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/img1.imageuploader.net/558/patty_avatar_64.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/www.eng.buffalo.edu/~tinchin/Uploaded/Hyori%201.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/daturax.fireywind.com/uploader/nov/bast_small.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/av-59.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/av-145.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/av-182.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/funimg.pchome.com.tw/img_upload/FUNNY/g/u/20040112_gunxxx_230921.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/server2.uploadit.org/files/chuanxiong-naruto.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7

Warning: copy(/home/tyrone/public_html/forum/uploads/blogs.kpbs.org/images/uploads/WallE04.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
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.

ThorstenE

the warning messages are from avatars and attachments conversion. Our converter can't find those files (directory:  /home/tyrone/public_html/forum/uploads/).

lkw888

Quote from: TE on April 24, 2009, 01:24:42 PM
the warning messages are from avatars and attachments conversion. Our converter can't find those files (directory:  /home/tyrone/public_html/forum/uploads/).

Thanks for answering.

I didn't allow users to upload attachments and avatars in my forum so as to minimise the space used.  If that's the case I guess the conversion is successful.  ;)

craccdemo

Everything works fine till the 7500 entry. Why did that happened? I've used the attached .sql file and the convert.php from the download section.

24 hour call out emergency plumber sydney hxxp:www.emergencyplumbersydney.com [nonactive]

ThorstenE

craccdemo,
any errors during the conversion? please copy & paste them here.

Xeoz

Will this converter work for IPB 1.2? I probably already know the answer because I get the following error:

Converting members... Unsuccessful!
This query:

INSERT INTO `smf_testdb`.smf_members
(ID_MEMBER, memberName, dateRegistered, ...
...
...
Caused the error:

    Field 'memberIP2' doesn't have a default value


I'd appreciate any help or recommendations you guys can offer. I'm trying to convert an IPB 1.2 based board to SMF 1.1.10.

SleePy

Well that is a error related to MySQL strict mode.

Via phpMyAdmin you can fix this.
Simply go into your SMF database, then the members table.  Click the structure tab and scroll down looking for "memberIP2".  Once you find it, click edit. Then change default to as defined and leave the input box for it empty.  Save and then try to run the converter again :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Xeoz

Long post incoming. I'm documenting what I went through here so that I can find it again later, and maybe help someone else lol.

Quote from: SleePy on September 02, 2009, 01:10:00 AM
Well that is a error related to MySQL strict mode.

Via phpMyAdmin you can fix this.
Simply go into your SMF database, then the members table.  Click the structure tab and scroll down looking for "memberIP2".  Once you find it, click edit. Then change default to as defined and leave the input box for it empty.  Save and then try to run the converter again :)
That was it, thank you very much! I don't have phpMyAdmin installed, personal taste, I'd just rather not have it running. So I tried to add a default manually:

mysql> ALTER TABLE smf_members MODIFY memberIP2 tinytext Default '';
ERROR 1101 (42000): BLOB/TEXT column 'memberIP2' can't have a default value


Since that didn't work I just disabled strict mode (removed STRICT_TRANS_TABLES setting) and the process worked. I ran into a couple other little issues along the way.

Are there any concerns that I should be aware of when disabling strict mode? Can I re-enable it after the conversion and not have any issues with SMF?

Apparently I had a duplicate entry in the polls data:

mysql> select count(*) as num, tid, member_id from ibf_voters group by member_id
,tid having count(*) > 1;
+-----+------+-----------+
| num | tid  | member_id |
+-----+------+-----------+
|   2 | 1804 | 2863      |
+-----+------+-----------+
1 row in set (0.01 sec)

mysql> select * from ibf_voters where tid = '1804' and member_id = '2863';
+------+---------------+------------+------+-----------+----------+
| vid  | ip_address    | vote_date  | tid  | member_id | forum_id |
+------+---------------+------------+------+-----------+----------+
| 3434 | 70.115.215.19 | 1230587380 | 1804 | 2863      |        4 |
| 3435 | 70.115.215.19 | 1230587380 | 1804 | 2863      |        4 |
+------+---------------+------------+------+-----------+----------+
2 rows in set (0.00 sec)

mysql> select * from ibf_voters where vid = '3435';
+------+---------------+------------+------+-----------+----------+
| vid  | ip_address    | vote_date  | tid  | member_id | forum_id |
+------+---------------+------------+------+-----------+----------+
| 3435 | 70.115.215.19 | 1230587380 | 1804 | 2863      |        4 |
+------+---------------+------------+------+-----------+----------+
1 row in set (0.00 sec)

mysql> DELETE from ibf_voters where vid = '3435';
Query OK, 1 row affected (0.00 sec)


Deleting the offending record fixed that problem. So FYI to the script developer, apparently dupes can happen in ibf_voters.

The next error I ran into was:

Converting smileys... Unsuccessful!

This query:

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

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(code) DESC' at line 2


After some research I found this topic. Indeed I am on MySQL 5.1 on my test system. I made the appropriate chages and it worked.

Next I got this error:

Converting attachments...
Fatal error: Call to undefined function getAttachmentFilename() in C:\xampp\htdocs\convert.php(1109) : eval()'d code on line 5


I found the getAttachmentFilename reference in invision_to_smf.sql. I am using the second version of this file, found in this thread. When I compared these lines to the original version posted in the original post I found that it was referencing a function call getLegacyAttachmentFilename. I changed both references (found in the attachments and avatars blocks) to the original function name "getLegacyAttachmentFilename" and got it to work.

Lastly I got this error:

Recalculating forum statistics... Successful.

Notice: Undefined variable: to_prefix in C:\xampp\htdocs\convert.php on line 1821
Unsuccessful!
This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1251918779),
    ('conversion_from', 'invision_to_smf.sql');

Caused the error:

    No database selected


At this point I was tired of debugging, since this was the last part of the script and didn't have any real effect on the forum I just commented out the lines in convert.php and ran the query manually.

I'm still testing the results but it looks like the script does work on IBP 1.2.

SleePy

Running without strict mode is fine.  Now that you got things converted you can run queries to give it a default values and try to enable strict mode again.  More information is on mysqls documentation website: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_strict_all_tables

Which sql file where you using? The change to using getLegacyAttachmentFilename() occurred a while back due to a major overhaul of the attachment system to enhance its security.  All of our converters just use the legacy version until we have time to properly update them to use the newer method of creating attachments.

As for the last error, it isn't something important.  It is something we are planning on using in the future and doesn't harm you if you don't have it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Xeoz

Yeah, I've got it all sorted out now. The new forums are running great with a little love. Had some permissions issues with the converted groups and for some reason nearly a quarter of the 3000 members had "http://" in their website url/name. These members didn't have any website in their original profiles.

I used the sql file from here.

What is the plan for the conversion_time and conversion_from values? I can't see this actually being used for anything after data has been converted.

SleePy

At this point there isn't much planned for it.  But we could use it in things like our smfinfo.php support script to know if the forum was converted and when.  We could also possibly use in SMF such as our login page to disable the compatibility login methods, reducing cpu cycles.

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Morphium

Hi! Will you help me with this problem?

IPB 1.3 to SMF 1.1.12



apnart

In addition to Morphium's post, do you know if the converter is updated to 1.1.12 ?

(I have to convert my database from IPB 1.3.1 to SMF 1.1.12)


Is the link to the converter in the 1st post the right link ?
La violence est le dernier refuge de l'incompétence. Isaac Asimov

ThorstenE

SMF 1.1.12 was a security update, the database wasn't touched.. The converter should work for the entire SMF 1.1.x series..

apnart

La violence est le dernier refuge de l'incompétence. Isaac Asimov

zushiba

Ugh, why does the convert.php link in the initial post lead me in a damn circle?

AUser

Quote from: zushiba on November 01, 2011, 06:42:15 PM
Ugh, why does the convert.php link in the initial post lead me in a damn circle?


It's doing the same thing to me - where's the file?

Adrek

convert.php file is added as attachment in this topic (linked in first post): http://www.simplemachines.org/community/index.php?topic=140741.0
Polskie wsparcie SMF na simplemachines.org

the simplest solution is most likely the right one

Advertisement: