Author Topic: [SMF Converter] MyBB 1.6 (Read 64013 times)

Bruno36 · « **Reply #40 on:** December 08, 2010, 05:27:38 AM »

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

N. N. · « **Reply #41 on:** December 08, 2010, 05:42:26 AM »

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:

Code: [Select]

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

Bruno36 · « **Reply #42 on:** December 08, 2010, 05:55:01 AM »

still not working

TE · « **Reply #43 on:** December 11, 2010, 01:53:58 AM »

Bruno36,
in mybb16_to_smf.sql find:

Code: [Select]

---* {$to_prefix}members
add after:

Code: [Select]

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

then restart the conversion.

Bruno36 · « **Reply #44 on:** December 11, 2010, 03:51:28 AM »

thank you its works

I have another problem I have a new error message

Converting topics... Incomplete.

TE · « **Reply #45 on:** December 11, 2010, 03:55:01 AM »

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 · « **Reply #46 on:** December 11, 2010, 04:09:32 AM »

yes thank you I'll wait

Bruno36 · « **Reply #47 on:** December 11, 2010, 04:16:34 AM »

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

TE · « **Reply #48 on:** December 11, 2010, 04:45:28 AM »

ok, next trial..
in mybb16_to_smf.sql
find:

Code: [Select]

SUBSTRING(IF(p.edituid > 0, edit_u.username, ''), 1, 255) AS modified_name,replace with:

Code: [Select]

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

Code: [Select]

UPDATE smf_messages SET modified_name = '' WHERE modified_name = 0;

Bruno36 · « **Reply #49 on:** December 11, 2010, 06:18:41 AM »

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

TE · « **Reply #50 on:** December 11, 2010, 08:19:15 AM »

mhh, that's really weird.. ok, let's try the following:
find

Code: [Select]

---* {$to_prefix}messages 200
---{
$ignore_slashes = true;
---}

replace with:

Code: [Select]

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

Bruno36 · « **Reply #51 on:** December 11, 2010, 09:45:45 AM »

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

TE · « **Reply #52 on:** December 11, 2010, 02:09:01 PM »

find:

Code: [Select]

---* {$to_prefix}personal_messagesadd after:

Code: [Select]

---{
if(empty($row['from_name']))
	$row['from_name'] = 'Guest';
---}

Bruno36 · « **Reply #53 on:** December 12, 2010, 06:11:28 AM »

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'

TE · « **Reply #54 on:** December 12, 2010, 08:18:20 AM »

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 · « **Reply #55 on:** December 12, 2010, 11:00:48 AM »

thank you very much all works

Bruno36 · « **Reply #56 on:** December 12, 2010, 11:01:39 AM »

Avatars and BBcode are not converted

TE · « **Reply #57 on:** December 12, 2010, 01:32:06 PM »

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?

Nibogo · « **Reply #58 on:** December 15, 2010, 03:25:01 PM »

Those aren't part of the converter at the moment, sorry about that, I'll try to do it.

Chrisburgin2 · « **Reply #59 on:** December 20, 2010, 11:45:43 AM »

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.

News:

Author Topic: [SMF Converter] MyBB 1.6 (Read 64013 times)