Software: MyBB
Version: 1.6
This is the official support topic for MyBB 1.6 converter. Use this topic to ask for support for this converter.
Note: This was tested on MyBB 1.6, but should in theory work on newer versions of MyBB if the database changes have not been to great.
Changelog
convert.php
The convert.php is attached in each package.
I am getting following error while converting:
Converting moderators...
Unsuccessful!
This query:
SELECT id AS id_member, fid AS id_board
FROM `asliind1_mybb`.mybb_moderators
WHERE isgroup = 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'
Try opening the .sql file and search for:
SELECT id AS id_member, fid AS id_board
Replace with:
SELECT uid AS id_member, fid AS id_board
Thanks mayte..Now the following error: :-[
Converting moderators...
Unsuccessful!
This query:
SELECT uid AS id_member, fid AS id_board
FROM `asliind1_mybb`.mybb_moderators
WHERE isgroup = 0
LIMIT 0, 500;
Caused the error:
Unknown column 'isgroup' in 'where clause'
Are you sure you're using MyBB 1.6? Those rows were added in that version. Please try to upgrade.
Sorry Red...!! I As you rightly mentioned..I was using the wrong sql file...Now I got it all right..converted everything successfully but only one thing not working.
FYI,
www.asli-indian.com is my old forum it has around 87 members.
www.asli-indian.com/forum is my converted forum but not showing stats properly. Though all the members are there in the member list of admin panel.
Forum Stats Forum Stats
1 Posts in 1 Topics by 1 Members. Latest Member: chaitanya_gk
Latest Post: "RE: Forum Badge Suggesti..." ( Today at 10:28:07 AM )
View the most recent posts on the forum.
[More Stats]
Try recalculating all the stats from your admin panel, that should do it.
Thanks Red...fixed it !! :D
One last doubt...now the converted forum is under /forum as I have mentioned in my last post. Is it better to keep it as is and point my old domain www.asli-indian.com to www.asli-indian.com/forum or is there any way I can move the files and delete mybb. ?
Sorry if my english is bad..I hope you got what I am trying to say.
You need to move the files of SMF to the other directory, and use the repair_settings to change all the paths, if you can't you can ask for support in the Support Boards as that isn't related anymore with the converter :)
ok no problem Devil ;D thanks for your fantastic support...
Hey mate
I tried to do the convert but it gave me this error:-
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?
Quote from: SkyAttack Madi on November 03, 2010, 12:18:19 PM
Hey mate
I tried to do the convert but it gave me this error:-
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?
I have the same error, anybody could help
fast? It is very important for me.
I got an error here but not sure why, anyone know how to fix it pls?
Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
EDIT: Sorry you already had it that way.
Probably you are not using the correct files or myBB version.
Quote from: Yoshi2889 on November 08, 2010, 01:45:21 PM
EDIT: Sorry you already had it that way.
Probably you are not using the correct files or myBB version.
Hi thank you, but I still have the same error when doing that?
Quote from: AndrewS on November 08, 2010, 01:50:54 PM
Quote from: Yoshi2889 on November 08, 2010, 01:45:21 PM
EDIT: Sorry you already had it that way.
Probably you are not using the correct files or myBB version.
Hi thank you, but I still have the same error when doing that?
Then I'm lost.
Maybe the other convertor package will work...then you can use the upgrade files from the 1.1 series or the 2.0 series to upgrade to the result you want.
I'm using MyBB 1.6 forums then the MyBB 1,6 sql file n converter.php
Could you link me to one that would work with MyBB 1.6 forums.. I tried so many. not sure which is the right n wrong.
Quote from: AndrewS on November 08, 2010, 01:35:46 PM
I got an error here but not sure why, anyone know how to fix it pls?
Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
this one seems to be a bug in mybb16_to_smf.sql...
search in mybb16_to_smf.sql for:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
replace it with
SELECT id AS ID_MEMBER, fid AS ID_BOARD
the restart the conversion process.
Quote from: TE on November 08, 2010, 05:18:30 PM
Quote from: AndrewS on November 08, 2010, 01:35:46 PM
I got an error here but not sure why, anyone know how to fix it pls?
Converting moderators... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
FROM `pshacksc_home`.mybb_moderators
LIMIT 0, 500;
Caused the error:
Unknown column 'uid' in 'field list'
this one seems to be a bug in mybb16_to_smf.sql...
search in mybb16_to_smf.sql for:
SELECT uid AS ID_MEMBER, fid AS ID_BOARD
replace it with
SELECT id AS ID_MEMBER, fid AS ID_BOARD
the restart the conversion process.
Thanks but I fixed it myself, suprised :)
Am I missing something? Where can I find the MyBB 1.6 convert.php + sql files?
Find them attached in the first post please. I will add them to the site's downloads as well.
Quote from: SkyAttack Madi on November 03, 2010, 12:18:19 PM
Hey mate
I tried to do the convert but it gave me this error:-
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?
I am also receiving this error converting:
mybb 1.6
to
smf 2.0 rc4
hello!
same error
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
About:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Can you please login in phpmyadmin, and run the following query:
SELECT birthday from [your_mybb_tables_prefix]users;
(please replace with your actual MyBB tables prefix.)
And attach the result here, or send to me in a PM?
Please note that it will display all the birth dates stored in your MyBB database (with no other user data or anything, only birth dates). If you are not comfortable with that, feel free not to.
SELECT birthday
FROM mybb_users;
LIMIT 0 , 30
When you executed that query, below it, on the page, phpmyadmin must have displayed the result. Could you please tell which are they?
#1064 - 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 '[mybb_users]users LIMIT 0, 30' at line 1
If your prefix is "mybb_", then please replace in the query "mybb_users", that is, please run:
SELECT birthday
FROM mybb_users;
It depends on what your actual prefix is - if you really have a table named "mybb_users" or it is named something else ending with "users".
yes my table is mybb_users
Then please use the query:
SELECT birthday
FROM mybb_users;
there are too many records to display
Affichage des enregistrements 0 - 29 (2 473 total, Traitement en 0.0002 sec.)
Please, use the attached mybb16_to_smf.sql file instead.
Also, please upload the attached file in your Sources/Subs-Db-mysql.php. It would be best if you made a copy of your current Sources/Subs-Db-mysql.php file, and keep it. Then replace your file with the attached one.
Converting members...Wrong value type sent to the database. Date expected. (birthdate) O:)
Oops.
Are you sure the new files are in the right directories? mybb16_to_smf.sql should be uploaded to SMF main directory, overwriting your previous file, and Subs-Db-mysql.php should be uploaded in your Sources directory.
Yes
I can't replicate it anymore. I used your dates in my test forum, got the same error, and have it fixed using these changes.
Can you please make sure that the file Subs-Db-mysql.php was indeed overwritten by your FTP client? Sometimes they may not overwrite all existing files. Same for the other.
Maybe it would be useful if you download them to check.
Also, can you please make sure you restart the conversion process completely, from running convert.php without any parameter in the URL, just http://your_smf_address/convert.php
Yes
Directory smf
Quote from: Bruno36 on November 30, 2010, 09:22:09 AM
Yes
Directory smf
I can sees you has new mailz.
Anyways, I'm gonna try converting my test myBB forum.
I still hold to the conversion
I stuck at the first step. :-\
Can you please try using this file instead then?
always block with the same message
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
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
still not working
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.
thank you its works ;)
I have another problem I have a new error message
Converting topics... Incomplete.
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?!?
yes thank you I'll wait
Converting...
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not
exist: modified_name
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;
Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
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;
---}
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
find:
---* {$to_prefix}personal_messages
add after:
---{
if(empty($row['from_name']))
$row['from_name'] = 'Guest';
---}
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'
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
thank you very much all works
Avatars and BBcode are not converted
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?
Those aren't part of the converter at the moment, sorry about that, I'll try to do it.
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.
Is there a converter for SMF2.0 RC4?
Thanks.
please use the attached files..
always i have an error
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
please check:
http://www.simplemachines.org/community/index.php?topic=404303.msg2877724#msg2877724
Is there a missing attachment on the first post because I can't seem to find any converter for mybb 1.6 and none on the downloads page either! :-[
direct link to the 1.1 Converter:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=404303.0;attach=158899
Brilliant, thanks so much for helping me out (and pointing me in the right direction) :)
Holy sh... Cow. Worked at first try, amazing. Converted everything, topics, members, posts, just as it should. Thank you, so much.
Also, wouldn't make it without Norv's idea for installing both SMF and MyBB in the same database. [I was getting the user table error]
Happy 2011 people.
Glad that it worked at your first try, TheRealCod3r! Not many converters have managed to do that ;)
Hello,
How do I resolve this error?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg534.imageshack.us%2Fimg534%2F6725%2Fpishata.png&hash=658a34832e50c1d1544aed160cef2f4577b85d5f)
in mybb16_to_smf.sql find:
---* {$to_prefix}topics
add after
---{
$ignore = true;
---}
then restart the converter.
Hi
Converter version 1.6.1, please also put
Regards
Sattar Forum
Quote from: sattarforum on January 21, 2011, 03:14:03 PM
Hi
Converter version 1.6.1, please also put
Regards
Sattar Forum
the MyBB 1.6 converter should work, have you tried converting?
This page is going on forever and all is says is:
QuoteConverting members...Wrong value type sent to the database. Date expected. (birthdate)
I am getting this error:
Converting polls...The database value you're trying to insert does not exist: id_member
Please do not bump a topic within 24 hours. Your time between posts was +/- 12 minutes.
Converting poll votes... Unsuccessful!
This query:
INSERT INTO `zeldaet_forums`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
Caused the error: Duplicate entry '12-74-1' for key 'PRIMARY'
the two ` used in your prefix may cause a issue...?
I'm not sure if I'm supposed to add, change or delete anything or not to the current code.
---* {$to_prefix}log_polls
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*
Quote from: Hammer Bro. Mike on February 05, 2011, 03:05:00 PM
I'm not sure if I'm supposed to add, change or delete anything or not to the current code.
---* {$to_prefix}log_polls
SELECT pid AS ID_POLL, uid AS ID_MEMBER, voteoption AS ID_CHOICE
FROM {$from_prefix}pollvotes;
---*
Try adding this:
---{
$ignore = true;
---}
i dont understand why you are changing from mybb to smf
I just tried the script posted in http://www.simplemachines.org/community/index.php?topic=404303.msg2893139#msg2893139 , and I quickly get stuck by that:
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
How frustrating, birth dates are so unimportant in my board... (most likely, almost all of them aren't filled in)
Trying to convert MyBB 1.6.0 to SMF 2.0RC5 (since the older version, 2.0RC4, can't be found).
Edit: Well, nevermind, I just deleted all birth dates from MyBB and then it worked ;)
Forgive me if this has already been addressed somewhere. (I searched to see if this was listed somewhere else on the forum and I couldn't find it.)
I'm converting from MyBB 1.6.2 to SMF 2.0 RC5. I got the birthdate error, which led to me deleting the birthdays to get past it. That worked. When it was importing the topics, it gave me this error:
Converting topics...
Duplicate entry '477' for key 'PRIMARY'
What do I do for it?
Quote from: Evollution on February 12, 2011, 09:27:30 AM
i dont understand why you are changing from mybb to smf
TAPATALK support among other things.
Hello !
First, thanks you very much for this converter, but I'm having some problems using it. I had to fix the birthday bug though.
It's working, at first, because I can see all my members ( 4 659 ) in the member list and in the database, the passwords are working, I even get the Categories/Forum structures with the numbers of Posts and thread inside, but that's all, after letting the script running for one hour I stopped it.
Note: I have +20k of posts inside the forum to convert.
It's freezing at Converting topics.
Can you help me :) ?
On conversion this is what i get....
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
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 column name 'id_member'
Anyway to fix this?
Thanks
Jon
I am getting the following error when I run the script at the poll conversion:
Converting polls...Wrong value type sent to the database. Integer expected.
anyone have a clue what's up?
Well, I managed to fix the above, but now I get this
Converting personal messages (step 1)...The database value you're trying to insert does not exist: from_name
any ideas
A few bugs in the converter reported here should be solved. Please, find the corrected file attached.
hi friend my convert this error
Converting...
Converting members... Successful.
Converting categories...Duplicate entry '255' for key 1
Why does not anyone help
That would interest me too. I try to SMF MyBB 1.6.3 to convert.
as i start the convertor i get this error
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'smf'@'localhost' for table 'users'
pls help me out
it should be on the converter page i agree
Quote from: TE on December 11, 2010, 01:53:58 AM
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.
hi.. when I try this fix,I get the following.. any help appreciated..
Converting members...
Unsuccessful!
This query:
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01'
LIMIT 0, 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 'if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '' at line 1
Hello... How about avatar?
When i convert MyBB 1.6.4 to SMF 2.0, everything is OK. But avatar not shown, and also, in user profile, there is no avatar change options..
How to fix it?
Thanks
Here is the correct, 100% working, file for converting mybb 1.6.x to SMF 2.0
If you have a problem like slash before quotes ie: dog\'s in boards, Use that queries:
UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";
Hi guys. I have few questions about the MyBB to SMF convertion. My problem is that I've followed all the way this topic and digging all the info I was able to find here and with the uncle Google help. Still unable to do the conversion from MyBB 1.6.4a to SMF 2.0. I have already tried to convert even form 1.6.4a to 1.1.14.
No success. In both cases covertion freze doing the topics...
It finish with this:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...
and it freeze
You seems to have all that huge knowledge that I need :) in this case.
Would you be able to give me some hints how can I complete the conversion?
Thanks in advance.
Cheers
I run the converter
It stuck fro ever at converting topic .....
Quote from: katib on September 29, 2011, 10:17:40 AM
I run the converter
It stuck fro ever at converting topic .....
How many topics do you have?
Quote from: Yoshi2889 on October 02, 2011, 02:59:14 PM
Quote from: katib on September 29, 2011, 10:17:40 AM
I run the converter
It stuck fro ever at converting topic .....
How many topics do you have?
Well
I have
8.777 Topics and 43.864 Posts
The problem is that the script converter deosnot show any progress bar so user can monitor progress
After filling informations (paths , BD password...) hitting Continue, it shows nothing for a while, then the above screenshot when it stuck forever
Quote from: webdo on September 01, 2011, 11:50:26 PM
Here is the correct, 100% working, file for converting mybb 1.6.x to SMF 2.0
If you have a problem like slash before quotes ie: dog\'s in boards, Use that queries:
UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";
If you ever have problems doing this, use this. It will work. Thanks a lot, guys. Great work.
I'm extremely frustrated at the moment.
I have been wanting to convert my MyBB 1.6 board to SMF 2.0.1.
Thought, neither converter will allow me.
All i keep receiving, even though the files ARE in the correct locations is;
QuoteThis converter was unable to find SMF in the path you specified.
Please double check the path, and that it is already installed there.
Please help in any way possible! I need to get this done as soon as possible.
Hi, I am attempting to get this to work with mybb 1.6.3.
I had a problem with the birthday, but was able to get past it. But now I am getting this error:
Converting posts (this may take some time)...
Successful.
Converting polls...The database value you're trying to insert does not exist: id_member
I looked in the smf database for polls and poll votes. Both had id_member. Any clues as to where I should head with this?
Hello, I am trying to convert to SMF for fun to see how it goes. There seems to be an issue with birthdays and the data-type. Not fully sure. I got around it by removing the sql statements, but its still a bug.
Wrong value type sent to the database. Date expected. (birthdate)
Now I am getting
* Converting categories...
Duplicate entry '255' for key 'PRIMARY'
I tried adding
ORDER BY id_cat ASC
to
WHERE type = 'c' ORDER BY id_cat ASC;
But no dice.
I keep resetting the auto increase counter too.
Any help.
Hello,
I've been trying to convert my forum as after a ton of issues from my last host and trying to get all the data I'm finally at the stage where I want to run the conversion tool. Unfortunately it keeps timing out after the initial page where it asks you for the information. It doesn't have a chance to get past step1.
At first I thought it was my firewall so I added some exceptions to see if that helped. It didn't and so I decided to use a USB modem which would bypass the firewall entirely (its built in the the network prior to my PC) but it still had the same problem.
At times it will come back saying that it had a Read Timeout.
Anyone able to help or give any suggestions?
EDIT: And or course, as soon as I post it gets past that part but times out when it pauses to stop it overloading. Now its timing out at the:
convert.php?step=1&substep=1&start=13500
section.
I'm getting
Unknown column 'memberName' in 'field list'
help?
i m getting this error while converting
[b]Converting...
[/b]
Converting members...Duplicate entry '16777215' for key 'PRIMARY'
One simple question, i have to delete mybb files before use converter? And sql files?
Quote from: alexandreperei on December 27, 2011, 06:39:45 PM
One simple question, i have to delete mybb files before use converter? And sql files?
no
Birisi Şu Sistemin En Sağlamını Upload Etsin.
:'( i have this mistake
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'prova_smf'@'localhost' for table 'mybb_users'
what does mean?
No converter for SMF 2.0.2?
Quote from: Ashley S on February 25, 2012, 11:49:47 AM
No converter for SMF 2.0.2?
It should work just fine for 2.0.2, if not just convert to 2.0 and upgrade to 2.0.2
Quote from: Norv on November 30, 2010, 03:28:36 AM
About:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Can you please login in phpmyadmin, and run the following query:
SELECT birthday from [your_mybb_tables_prefix]users;
(please replace with your actual MyBB tables prefix.)
And attach the result here, or send to me in a PM?
Please note that it will display all the birth dates stored in your MyBB database (with no other user data or anything, only birth dates). If you are not comfortable with that, feel free not to.
I just ran a query, by the bottom in the top left.
Here's what I got (Same BDay issue)
http://i.imgur.com/waCHj.png
I ran into the same BDay issue. Format was 1-1-1970 for all users with no bday explicitly set. Nulled out all bdays to get past that step. However that lead me directly into the next issue:
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)
Can you give me an example of a poll's expire_time value?
Probably it's not an UNIX timestamp which is all integer.
If it's something like "1-1-1970" I can do something about it.
From the sql
TRUNCATE {$to_prefix}polls;
TRUNCATE {$to_prefix}poll_choices;
TRUNCATE {$to_prefix}log_polls;
---* {$to_prefix}polls
SELECT
p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
t.uid AS id_member,
IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
SUBSTRING(t.username, 1, 255) AS poster_name
FROM {$from_prefix}polls AS p
LEFT JOIN {$from_prefix}threads AS t ON (t.tid = p.tid);
---*
So it's taking timeout and datline coloumns, which are bigint(30) and appear to be unix timestamps. I have no idea why it is failing as the entry's clearly are int's
example dateline
1094083328
example timeout
1094083328
HI, I'm use the suggerst of page 3 but I continue to have tis error
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
how to fix it?
Awesome thread guys, thanks for all the help! Had to go through and find each fix from people and add it to the sql, but in the end it worked! Just successfully converted mybb 1.6.7 to smf 2.0.2!!!
HI All, Getting this error when convertin.
Converting...
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Duplicate column name 'id_member'
I get this error when trying to convert MyBB 1.6.8 to SMF 2 RC3:
Image url: awesomescreenshot.com/0c0cbnb11
Hello. even with the updated .sql file, I keep getting the birthday error. what would the best fix be?
nevermind. everything is fixed.
When I go to convert.php it shows this:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2F7ESgH.png&hash=17296d745ca58b198b006e792fee60236ad0be3c)
And I picked 1.4 and this happend:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FkCA5q.png&hash=7c0deba0651618d542779023821c81bc67f948fd)
Now I can't go back and pick that other. So whats the problem?
Got new problem : http://www.simplemachines.org/community/index.php?topic=487390.msg3413633#msg3413633.
Do i need to upload zip via package manager or? How to use it.
And i have this error
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'lolserbi_stefan'@'localhost' for table 'mybb_users'
bump
Okey I fix problem, now I have this:
Successful.
Recalculating forum statistics...
That mean I need to wait?
is this the right mod where i'm going to upload myBB database to SMF database?
I have a myBB database and I wanted it merge to my existing SMF database. Can someone point me to the right direction? Thanks in advance
I have this error
Unsuccessful!
This query:
SELECT value
FROM `hightech_mybb313`.mybb_settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1;
Caused the error:
Unknown column 'variable' in 'where clause'
I'm geting this error
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'web1-smf-1'@'localhost' for table 'mybb_users'
anyone know the fix, I have seen people post the same error but never get a reply.
Well, the error seems fairly clear: you've set up MyBB in a database and it has a username and a password. SMF has a username and a password but you've put it in a different database and the username and password SMF has can't get to the MyBB database... so there's no way SMF can import it.
Install SMF into the same database with the same user and password as MyBB is currently installed in (using smf_ as the prefix to avoid collision) and then it'll work.
This is the same error everyone else has and is the same error as the very first entry in http://www.simplemachines.org/community/index.php?topic=146192.0 and it's also mentioned in http://wiki.simplemachines.org/smf/Converting
Thanks arantor i sort of did that but did it the other way round and had to set the mybb database config to the smf data base but then i get the birthday error.
Hi,
I am trying to convert from mybb 1.6 to smf and i am facing these issues. Can someone help me here
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Then i did this
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 also i am getting the same error message
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Hola, gracias por el aporte, pero no hay manera de ponerlo... Alguna ayuda? Gracias!
When im Converting
MyBulletinBoard 1.6 to SMF Converter
Converting...
Converting members... Unsuccessful!
This query:
ALTER TABLE `oldschoo_oldsc991_mybb123`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:
Unknown column 'passwordSalt' in 'smf_members'
Problem as Always :(
Converting...
Converting topics...
Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Unsuccessful!
This query:
SELECT
p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
t.uid AS id_member,
IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
SUBSTRING(t.username, 1, 255) AS poster_name
FROM `oldschoo_oldsc991_mybb123`.mybb_polls AS p
LEFT JOIN `**************`.mybb_threads AS t ON (t.tid = p.tid)
LIMIT 0, 500;
Caused the error:
BIGINT value is out of range in '(`*******************`.`p`.`timeout` * 86400)'
hi,
Does anyone convert mybb 1.6.7 to SMF 2.0.x?
thanks
If you go to mybb converters download the bottom one that says mybb to smf 2-0
Here is the link http://download.simplemachines.org/?converters;software=mybb
I have used this several times without errors.
Hi
I have the following error, trying to convert from Mybb 1.6.9:
Converting posts (this may take some time)...The database value you're trying to insert does not exist: poster_email
Is there an updated .sql file that would work better?
Thanks!
Are you using the converter from the downloads page?
Hi
Thanks for your answer.
I'm using the third one (mybb to smf) - with the default .sql file it doesn't detect the database prefix and can't read any table, (error: Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.The error that was received from the Database was: SELECT command denied to user 'dev'@'localhost' for table 'users') - with the latest .sql file given in this thread everything goes fine until I have this error message. "The database value you're trying to insert does not exist: poster_email"...
If I change the .inc/config related line in the .sql file given on the download page, with "---~ from_prefix: "`{$config['database']['database']}`.{$config['database']['table_prefix']}"" I can start the script but then I have several mysql errors.
Attachment is the .sql file that did work for me.
Hope it can help someone :)
Thanks bobmail for the sharing from your mysql convert file ;D
i am getting this error
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
please help me
Which converter are you using? The one from the downloads page or the one from this topic? You should use the one from the downloads page.
Is your MyBB 1.6?
Also, check this tip here:
http://www.simplemachines.org/community/index.php?topic=404303.msg2877724#msg2877724
I am having issues with the birthday field mainly because my myBB version I am converting from had bad birthdays because the conversion from the other board software to myBB botched the birthday data. While some users have them, a lot of users have the field totally blank.
Is there any way to get the conversion script to skip the b-day field or run some sort of SQL query to insert a valid date if the field is blank?
Best way is really to just have no values inserted --> no one has birthdate.
It worked perfect for me :).
kj
I have a mybb 1.6.15 I no longer wish to update or upgrade.
I wish to convert over to smf, I am familiar with smf forums to begin with..
What is the first step, use a test board first then go for the real thing..
I am going to need help on this, because I am not the brainiest guy around..
Ron
You can read: http://wiki.simplemachines.org/smf/Converting
Quote from: Antes on November 30, 2014, 08:02:03 PM
You can read: http://wiki.simplemachines.org/smf/Converting (http://wiki.simplemachines.org/smf/Converting)
Thanks Antes, I opened and bookmark it. I will read it later tonight..
Is there help here with this, paid or other that you know of..
Ron..
Quote from: Oldcrow on November 30, 2014, 08:11:08 PM
Quote from: Antes on November 30, 2014, 08:02:03 PM
You can read: http://wiki.simplemachines.org/smf/Converting (http://wiki.simplemachines.org/smf/Converting)
Thanks Antes, I opened and bookmark it. I will read it later tonight..
Is there help here with this, paid or other that you know of..
Ron..
Hello, I'm glad to help
You can post in http://www.simplemachines.org/community/index.php?board=50.0 if you want to post a paid job (Please mind to give as much as detail possible about the job).
Hi guys,
While trying to convert a really big forum (1.5gb database size) I ran into issues during conversion of threads table. The particular select query in the sql file that was causing problems was this:
SELECT
t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
CASE
WHEN (t.closed = '1') THEN 1
ELSE 0
END AS locked,
MIN(p.pid) AS id_first_msg, MAX(p.pid) AS id_last_msg
FROM {$from_prefix}threads AS t
INNER JOIN {$from_prefix}posts AS p
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
WHERE p.tid = t.tid
GROUP BY t.tid
HAVING id_first_msg != 0
AND id_last_msg != 0;
Turns out the INNER JOIN in this absolutely chokes out on a big table to the point where it can't even return 1 row in a reasonable amount of time. I rewrote the select query for that particular conversion step to the following:
SELECT
t.tid AS id_topic, t.fid AS id_board, t.sticky AS is_sticky,
t.poll AS id_poll, t.views AS num_views, IFNULL(t.uid, 0) AS id_member_started,
IFNULL(ul.uid, 0) AS id_member_updated, t.replies AS num_replies,
IF(t.closed = '1', 1, 0) AS locked,
(SELECT MIN(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_first_msg,
(SELECT MAX(p.pid) FROM {$from_prefix}posts AS p WHERE p.tid = t.tid LIMIT 1) AS id_last_msg
FROM {$from_prefix}threads AS t
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
HAVING id_first_msg != 0 AND id_last_msg != 0;
Time taken to complete this query is reduced by orders of magnitude due to MySQL optimiser now not ignoring the indexes. The BINARY statement on the ul.username made indexes not be used on the users table (which was a big problem), and the INNER JOIN with GROUP BY clause on the posts table ignored indexes as well (which was an even bigger problem). Hope it helps somebody.
Hey,
is there an importer for MyBB 1.8 ?
greets
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Unknown column 'msn' in 'field list'
You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)
Quote from: margarett on December 20, 2015, 07:20:22 PM
Not a dedicated one no. But, as far as we know, the 1.6 converter works fine with minor tweaks. You should get an error like this:
Unknown column 'msn' in 'field list'
You should just remove the mentioned field from the conversion and it should work for the remaining parts ;)
Where can i delet this ? :$
In the .sql file (I'm sorry but I'm typing from my phone...)
I cant find this in the .sql File o.O
you are using the files attached in the first post?
in the sql there is
SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
remove the second part of that line.
Thx. It works.
Now i have an other error :
Converting polls...The database value you're trying to insert does not exist: id_member