Myybb 1.4 to SMF 2.0 convertion problem

[apking]

Hi Friends,

Iam trying to convert mybb to smf2.0 .in step1 i got below msg.

Converting...
Converting members...Field 'message_labels' doesn't have a default value


means its converting or not.how [nofollow] can i know its process or not.please help me?


apking

[Oldiesmann]

Try this file. The problem is that MySQL is running in strict mode, so it will complain if SMF doesn't try to insert data into fields that don't have a default value.

[apking]

yea i replace sql file. now iam getting this error

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

what can id o now?


Thanks in advance
apking

[apking]

hi Oldiesmann,

any sollution for above problem. please help me?


Thanks
apking

[Oldiesmann]

Can you give me some sample data from MyBB's "birthday" column? I'm trying to figure out what's going on here. Either SMF is reversing the month and the date, or MySQL isn't interpreting the result as a date.

[apking]

date format in mybb is   DD/mm/year

[Oldiesmann]

Does this one work better?

I replaced the ridiculously complex string concatenation code with MySQL's DATE_FORMAT function.

[apking]

hi

now iam getting this error


Converting...
Converting members... Unsuccessful!
This query:

    LIMIT 500;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 500' at line 1


thanks

[Norv]

Please, try the attached file, instead.

[apking]

hi norv,


iam replace that file.then it works fine. but it will automatically stop processing in conversion of topics. what i will do now?

i will get this

Converting...
Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...

but there is no process

Thanks
apking

[apking]

need help please

[Oldiesmann]

Please wait at least 24 hours before bumping your topics. We are all volunteers here and can't always respond immediately.

[apking]

ok i will wait.

Thank you
Apking

[Norv]

Sorry for the delay, I don't seem able to replicate the problem. Can you please try re-running the converter as: http://your_smf_site/convert.php?debug=1
Then, a file (named "convert_error_log") should be created in your SMF directory. Please, attach it here.

Also, perhaps if you could post all messages on that page where conversion stops, might help.

[apking]

hi

here is iam attached error log,

i got this msg again

i will get this

Converting...
Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...



Thanks
Apking

[apking]

hi norv,


i was attached error log. please check.

[apking]

hi norv,

please give any suggestions regarding conversion.

Thanks
apking

[apking]

hi friends,
please help me?


Apking

[Norv]

Sorry for the delay. I can't tell where the problem is, and I am unable to replicate it.
Do you use a shared server only, or can you make the conversion on your local computer, or perhaps on a server where you have access to MySQL log and settings?

[mrl586]

This file works: http://www.simplemachines.org/community/index.php?topic=256073.msg2409397#msg2409397
But polls seems convert incorrectly.

[Lich_king2]

I'm sorry for bumping old thread, I've edited mybb14x_to_smf.sql and fixed the birthdays table issue.
If anyone has the same problem, feel free to use attached SQL file. Converted from MyBB 1.4.11 to SMF 2.0 RC3

[Norv]

Thank you for sharing, Lich_king2.

[fantom01]

Hello,

Been trying to convert mybb 1.4.x to smf 2.0 rc3 and I  keep getting stuck at: "Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)". Did a search on the forum and it looks like no ones has run into this problem before for mybb.

Any help would be greatly appreciated.

[Norv]

Can you please, if you tried using the last file posted here by Lich_king2?
http://www.simplemachines.org/community/index.php?topic=368769.msg2575944#msg2575944

[apking]

Hi norv,

iam trying that. iam getting this error now


Converting members...Field 'message_labels' doesn't have a default value


Thanks
APking

[Lich_king2]

Hmm try to add this:    

Code Select Expand

'' AS message_labels, '' AS openid_uri, '' AS location, '' AS avatar, '' AS personal_text,
'' AS secret_question, '' AS ignore_boards, '' AS additional_groups
Add it before FROM {$from_prefix}users;

[apking]

hi

it struck  at conversion of topics. what i will do now?

i will get this

Converting...
Converting members...
Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...

but there is no process.

Thanks
apking

[Norv]

I can't replicate this...
It does not seem to go further at all?
Are there errors on the page? (In Firefox, Tools menu, please see the Javascript error console)
Do you have javascript enabled?