Advertisement:
NameCheap

Author Topic: [SMF Converter] IPB 2.3.x  (Read 153994 times)

Offline Domi5

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.3.x
« Reply #100 on: April 19, 2010, 05:24:22 PM »
Code: [Select]
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

Code: [Select]
دينا باب حجرة داليا بمرح و اعتياد قائلة: دولي..انا.. فوجدتها تقرأ القرآن these were arabic characters :D

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] IPB 2.3.x
« Reply #101 on: April 19, 2010, 05:26:37 PM »
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?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Domi5

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.3.x
« Reply #102 on: April 19, 2010, 05:46:13 PM »
Code: [Select]
Caused the error:

    MySQL server has gone away

that's all .. b4 that there were also some
Code: [Select]
لمشاركاتك معانا في المواضيع المختلف&#1577
and mails / IPs of the posters

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] IPB 2.3.x
« Reply #103 on: April 19, 2010, 06:07:22 PM »
Code: [Select]
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
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Domi5

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.3.x
« Reply #104 on: April 20, 2010, 07:54:55 AM »
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

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] IPB 2.3.x
« Reply #105 on: April 26, 2010, 09:57:12 AM »
Sorry for the delay.
Please, try: (invision23_to_smf.sql)
Code: (find) [Select]
---* {$to_prefix}messages 200
Code: (replace) [Select]
---* {$to_prefix}messages 100
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline xblazenx

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #106 on: October 02, 2010, 10:42:39 AM »
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:)

Offline savrip

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #107 on: February 01, 2011, 06:19:00 AM »
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.

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #108 on: February 01, 2011, 04:42:28 PM »
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

Offline Flamekebab

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #109 on: April 08, 2011, 07:37:51 PM »
I'm trying to convert IPB 2.3.1 to SMF (either version) using the relevant converters 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
Quote
Converting...
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:

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

Offline Aeolus

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] IPB 2.3.x
« Reply #110 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

Get these errors.
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic, but no help.
Thanks. :)

Offline Quexinos

  • Semi-Newbie
  • *
  • Posts: 99
Re: [SMF Converter] IPB 2.3.x
« Reply #111 on: April 24, 2012, 03:05:02 AM »
IPB 2.3.6
smf 2.0.2

Use the convert
Invision 2.3 to SMF 2-0 from here

Get these errors.
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic, but no help.
Thanks. :)

same problem.... anyone?

Offline fhsds

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #112 on: May 06, 2012, 08:08:44 PM »
IPB 2.3.6
smf 2.0.2

Use the convert
Invision 2.3 to SMF 2-0 from here

Get these errors.
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Search the topic, but no help.
Thanks. :)

same problem.... anyone?
Yes, I have the same problem

Offline fhsds

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #113 on: May 07, 2012, 11:46:06 PM »
is anybody here????? heeeeeeeeeeelp!!!!!

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 2.3.x
« Reply #114 on: September 01, 2012, 12:13:08 PM »
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?).

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #115 on: September 02, 2012, 01:48:32 AM »
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

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 2.3.x
« Reply #116 on: September 02, 2012, 06:00:31 AM »
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?

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #117 on: September 02, 2012, 01:23:57 PM »
in invision23_to_smf.sql find:
Code: (find) [Select]
$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);

add after
Code: (add after) [Select]
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';

Hope it helps..

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 2.3.x
« Reply #118 on: September 03, 2012, 09:28:43 AM »
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)

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #119 on: September 03, 2012, 11:01:25 AM »
This "new" bug can be fixed, find:

Code: [Select]
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
add after:
Code: [Select]
$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..