Advertisement:

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

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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)
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« 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
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #42 on: December 08, 2010, 05:55:01 AM »
still not working
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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.

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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.
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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?!?

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #46 on: December 11, 2010, 04:09:32 AM »
yes thank you I'll wait
Bruno36 the French
SMF 2.0.9

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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;

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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
« Last Edit: December 11, 2010, 06:58:24 AM by Bruno36 »
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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;
---}

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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';
---}

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« 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'
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« 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

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #55 on: December 12, 2010, 11:00:48 AM »
thank you very much all works
Bruno36 the French
SMF 2.0.9

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #56 on: December 12, 2010, 11:01:39 AM »
Avatars and BBcode are not converted
Bruno36 the French
SMF 2.0.9

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.6
« Reply #57 on: December 12, 2010, 01:32:06 PM »
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?



Offline Chrisburgin2

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] MyBB 1.6
« 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.