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 :P).
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
What converter are you using?
Good question, when i edit convert.php i see :
Quote/**
* 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
*/
:P
Where did you get it from? From the download page or from the topic in this board for 1.3.x converter?
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...
Exactly i start about this topic : http://www.simplemachines.org/community/index.php?topic=146211.160
When in doubt, if you tell me a version (link), I can try, as we are sure that I speak the correct file
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)
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.
Thank you, I will try in time.
This is actually a very old version, and I expect to make the transition will be tough. :-\
Try replacing:
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:
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,
Thanks a lot, its ok for the step but i have another bug
I retry
QuoteOne 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)
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:
$row['signature'] = substr(strtr(strtr($row['signature'], '<>', '[]'), array('[br /]' => '<br />')), 0, 65534);
And after that, add:
$row['hide_email'] = (int) $row['hide_email'];
[/code]