Some concerns on migration to 1.3 .. smf_2-0-6

[frank30]

Hello to all

I have an old IPB 1.3 I am trying to convert for quite some time, and I fall on SMF.
So I try, download the database from my IPB (280 MB gzip  ).


1/Installation of wampp
2/INSTALLING of two forums on the same basis
3/upload my base IPB in local with myslqdumper
4/je meets some UTF8 / ISO encoding errors but I see you later.
5 / I use the converter locally and it hangs on Birthday, exactly : Converting members...Wrong value type sent to the database. Date expected. (birthdate)

I'll go in phpmyadmin see the members table and i see NULL in BDAY_DAY, BD_MONTH, some members. Perhaps issue ?

Thanks a lot for help me.

PS : sorry for my langage

[margarett]

What converter are you using?

[frank30]

Good question,  when i edit convert.php i see :

/**
* Simple Machines Forum (SMF)
*
* @package SMF
* @author Simple Machines http://www.simplemachines.org
* @copyright 2011 Simple Machines
* @license http://www.simplemachines.org/about/smf/license.php BSD
*
* @version 2.0
*/

[margarett]

Where did you get it from? From the download page or from the topic in this board for 1.3.x converter?

[frank30]

I had a little trouble finding the file    :

http://www.simplemachines.org/community/index.php?topic=140741.0
then

http://www.simplemachines.org/community/index.php?topic=146211.0

Sorry...

[frank30]

Exactly i start about this topic : http://www.simplemachines.org/community/index.php?topic=146211.160

[frank30]

When in doubt, if you tell me a version (link), I can try, as we are sure that I speak the correct file

[frank30]

I'll try to remplace NULL

UPDATE ibf_members SET bday_month=0 WHERE bday_month IS NULL;
UPDATE ibf_members SET bday_year=0 WHERE bday_year IS NULL;
UPDATE ibf_members SET bday_day=0 WHERE bday_day IS NULL;

But is not good :

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

[margarett]

Well, I have no idea, really...
That's a REALLY old version, so I am not even sure how to proceed...

You should probably start with a conversion to 1.1.19 using the files from the first post of this topic:
http://www.simplemachines.org/community/index.php?topic=146211.0

And then use our upgrader to go with 2.0.

[frank30]

Thank you, I will try in time.
This is actually a very old version, and I expect to make the transition will be tough. 

[emanuele]

Try replacing:

Code Select Expand

IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,

with:

Code Select Expand

IF (bday_year IS NULL, '0001-01-01', IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, '0001', bday_year), IF(bday_month = 0, '01', IF(bday_month < 10, CONCAT('0', bday_month), bday_month)), IF(bday_day = 0, '01', IF(bday_day < 10, CONCAT('0', bday_day), bday_day))))) AS birthdate,

[frank30]

Thanks a lot, its ok for the step but i have another bug

I retry

One step
------------------------------------------
Install in local my IPB 1.3
I dump with mysqldumper in UTF8 > OK 30mn

Two
------------------------------------------
Install SMF 2-0-6
Use UTF-8 as default character set ? i don't know, i say YES

Create admin

Database password NO because in local computer
------------------------------------------

Three conversion
------------------------------------------
I choose  UTF8 and no password
Empty the convert error log ? i don't know, coché
------------------------------------------
*********************************************
***************************
------------------------------------------

Converting members...Wrong value type sent to the database. Integer expected. (hide_email)

[emanuele]

In order to easily find again the converter later, should be this one:
http://www.simplemachines.org/community/index.php?topic=146211.0

Open the file with a text editor (usually notepad), find the line:

Code Select Expand

$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);

And after that, add:
$row['hide_email'] = (int) $row['hide_email'];
[/code]