Advertisement:

Author Topic: [SMF Converter] IPB 1.3.x  (Read 276166 times)

Offline lkw888

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 1.3.x
« Reply #140 on: April 24, 2009, 09:02:17 AM »
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

Quote
have 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?
« Last Edit: April 24, 2009, 09:21:55 AM by lkw888 »

Offline lkw888

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 1.3.x
« Reply #141 on: April 24, 2009, 12:31:34 PM »
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

Offline lkw888

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 1.3.x
« Reply #142 on: April 24, 2009, 12:52:59 PM »
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.
« Last Edit: April 24, 2009, 12:59:02 PM by lkw888 »

ThorstenE

  • Guest
Re: [SMF Converter] IPB 1.3.x
« Reply #143 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/).

Offline lkw888

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 1.3.x
« Reply #144 on: April 25, 2009, 12:02:51 AM »
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.  ;)

Offline craccdemo

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 1.3.x
« Reply #145 on: May 05, 2009, 02:48:16 AM »
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

  • Guest
Re: [SMF Converter] IPB 1.3.x
« Reply #146 on: May 05, 2009, 03:06:16 AM »
craccdemo,
any errors during the conversion? please copy & paste them here.

Offline Xeoz

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] IPB 1.3.x
« Reply #147 on: September 01, 2009, 07:23:30 PM »
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.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,528
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 1.3.x
« Reply #148 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 :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Xeoz

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] IPB 1.3.x
« Reply #149 on: September 02, 2009, 03:43:11 PM »
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.

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:

Code: [Select]
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:

Code: [Select]
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:

Code: [Select]
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:

Code: [Select]
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:

Code: [Select]
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.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,528
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 1.3.x
« Reply #150 on: September 16, 2009, 06:22:00 PM »
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

Offline Xeoz

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] IPB 1.3.x
« Reply #151 on: September 22, 2009, 05:53:53 AM »
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.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,528
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 1.3.x
« Reply #152 on: September 29, 2009, 05:09:16 AM »
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

Offline Morphium

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 1.3.x
« Reply #153 on: December 13, 2010, 08:32:55 AM »
Hi! Will you help me with this problem?

IPB 1.3 to SMF 1.1.12



Offline apnart

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Male
    • Le forum de la photo numérique
Re: [SMF Converter] IPB 1.3.x
« Reply #154 on: January 13, 2011, 08:38:17 AM »
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

  • Guest
Re: [SMF Converter] IPB 1.3.x
« Reply #155 on: January 13, 2011, 01:49:59 PM »
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..

Offline apnart

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Male
    • Le forum de la photo numérique
Re: [SMF Converter] IPB 1.3.x
« Reply #156 on: January 13, 2011, 02:12:08 PM »
Many thanks "TE"  8)
La violence est le dernier refuge de l'incompétence. Isaac Asimov

Offline zushiba

  • Jr. Member
  • **
  • Posts: 114
Re: [SMF Converter] IPB 1.3.x
« Reply #157 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?

Offline AUser

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] IPB 1.3.x
« Reply #158 on: February 18, 2012, 03:57:40 AM »
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?

Offline Adrek

  • Sophist Member
  • *****
  • Posts: 1,078
  • Gender: Male
    • pages/smfpl/171860759503032 on Facebook
    • Adrek.pl
Re: [SMF Converter] IPB 1.3.x
« Reply #159 on: February 18, 2012, 08:50:48 AM »
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