News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] MyBB 1.6

Started by Nibogo, October 10, 2010, 11:43:34 AM

Previous topic - Next topic

Bruno36

always block with the same message
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Bruno36 the French
SMF 2.0.9

Norv

The cause is a stray date in the MyBB database, which is "1-1-" instead of "" or "1-1-1980" or whatever other proper date. But these changes in the files should address it... :(
Could you eventually try this:
- backup your MyBB database
- then run the following SQL statement on it:

UPDATE `mybb_users`
SET `birthday` = ""
WHERE LENGTH(birthday) < 8

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

Bruno36

Bruno36 the French
SMF 2.0.9

ThorstenE

Bruno36,
in mybb16_to_smf.sql find:
---* {$to_prefix}members

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

then restart the conversion.

Bruno36

thank you its works  ;)
I have another problem I have a new error message

Converting topics... Incomplete.
Bruno36 the French
SMF 2.0.9

ThorstenE

Any specific errors? on boards with many topics the converter stops sometimes to avoid a server overload and should continue automatically after a few seconds.. maybe you need to wait a little bit more?!?

Bruno36

Bruno36 the French
SMF 2.0.9

Bruno36

Converting...
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not
exist: modified_name
Bruno36 the French
SMF 2.0.9

ThorstenE

ok, next trial..
in mybb16_to_smf.sql
find:
SUBSTRING(IF(p.edituid > 0, edit_u.username, ''), 1, 255) AS modified_name,
replace with:
SUBSTRING(IF(p.edituid > 0, edit_u.username, 0), 1, 255) AS modified_name,
this solution is far away from perfect but it should work and we could fix it later with a simple SQL statement
UPDATE smf_messages SET modified_name = '' WHERE modified_name = 0;

Bruno36

#49
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
Bruno36 the French
SMF 2.0.9

ThorstenE

mhh, that's really weird.. ok, let's try the following:
find
---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
---}

replace with:
---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
/* yet another fix for empty rows ... */
if(empty($row['modified_name']))
$row['modified_name'] = 0;
---}

Bruno36

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_name
Bruno36 the French
SMF 2.0.9

ThorstenE

find:
---* {$to_prefix}personal_messages
add after:
---{
if(empty($row['from_name']))
$row['from_name'] = 'Guest';
---}

Bruno36

Converting...
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Duplicate key name 'ip_index'
Bruno36 the French
SMF 2.0.9

ThorstenE

good news at all, this last one is already known and should be fixed soon, a solution is available:
http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944

Bruno36

Bruno36 the French
SMF 2.0.9

Bruno36

Avatars and BBcode are not converted
Bruno36 the French
SMF 2.0.9

ThorstenE

Quote from: Bruno36 on December 12, 2010, 11:01:39 AM
Avatars and BBcode are not converted
that's right, both are not part of mybb16_to_smf.sql.. Maybe a current team member can help here?



Chrisburgin2

I could have used this about a month ago lol. But thanks for the converter i have some freinds that are reluctanct to swich to smf from mybb without a converter now they have no reason to stay on mybb.

Advertisement: