Software: Burning Board
Version: 3.0.x
This is the official support topic for Burning Board3 converter. Use this topic to ask for support for this converter.
Note: This was tested on Burning Board 3, but should in theory work on other versions of Woltlab Burning Board 3.x if the database changes have not been to great.
wbb3_migration.phpFor the conversion to be able to complete, the wbb3_migration.php file is required. You will need to modify this file to reflect your Database name and Database prefix and upload to your Burning Board directory.
Does Not Convert
- Permissions (This might not be supported at all so please check permissions before making the board live. Everything will be admin only for board access.)
- Membergroups
Password SupportBurning Board 3 has their own custom password hash so you need to edit LogInOut.php to add support for password conversion. Alternatively, you can used the wbb3_Login_Fix.zip modification (attached below) via Package Manager (http://docs.simplemachines.org/index.php?board=49.0).
How to convertUse this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
I tried to convert from wbb3 and got this info: :(
Converting members... Unsuccessful!
This query:
ALTER TABLE `zeitwortsql5`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(40) NOT NULL default '';
Caused the error:
Unknown column 'passwordSalt' in 'smf_members'
Now I can't login in SMF with my old username.
The converter is for SMF 1.1.x only at the moment. I believe you tried converting to SMF 2.0 RC1 instead?
Thank you for this converter - he works good and fast ( only 1 hour for 150.000 posts) :)
Is it possible to convert also the Links in the quotes?
I give you an example:
SMF
[quote author=krahi link=topic=8616.msg157025#msg157025 date=1243797356]
wbb3
[quote='krahi',index.php?page=Thread&postID=157025#post157025]
in general that's possible, but it requires a lot of developement time.. Internal SMF links use the ID_TOPIC (unique ID from a Topic) whereas WBB3 Links only use the ID_MSG (unique ID from the messages).
I converted from wbb3.0.9 to SMF1.1.9. Worked fine!
The only problem are still the passwords, but it seems the fault is only on my side because I have not set a FTP user to apply the package because I only have a SSH root.
I will check this.
Thanks for the good work!
there is only one line changed in /Sources/LoginOut.php
you can change these line manually, open the LogInOut.php with a text-editor and search for:
// Maybe they are using a hash from before the password fix.
add after:
// BurningBoard3 Login Method (double salted SHA1)
elseif (strlen($user_settings['passwordSalt']) == 40)
$other_passwords[] = sha1($user_settings['passwordSalt'] . sha1($user_settings['passwordSalt'] . sha1($_REQUEST['passwrd'])));
Quote from: TE on June 01, 2009, 10:35:29 AM
in general that's possible, but it requires a lot of developement time.. Internal SMF links use the ID_TOPIC (unique ID from a Topic) whereas WBB3 Links only use the ID_MSG (unique ID from the messages).
Would you help me to design a step by step query?
We have id_msg and id_topic in the same table
UPDATE `smf_messages`
SET `body` = replace(`body`, "[quote='","[quote author=")UPDATE `smf_messages`
SET `body` = replace(`body`, "[#post","#msg")UPDATE `smf_messages`
SET `body` = replace(`body`, "',index.php?page=Thread&postID=","xxxxxxxxx")I don't know how to get the id_topic for xxxxxxxxx
zeitwort, do you still want help with this? :)
Of course - I would be very happy if you could help me. :D
I found a bug: If more than one WBB's board id/category id are > 255 the converter cannot convert.
The converter will complain about "duplicate entry 255" and stops. I'm still trying to figure out how to solve this problem.
*edit*
A dirty fix: Increase all ID_BOARD and ID_Cats to INT(10).
*edit2*
At "Recalculation statistics" the converter stops because of "Undefined variable: to_prefix". But the forum is working as far as I tested.
Thanks Neakro ;)
Our tools "Fix High Category ids" should fix the issues related to high categories.. (not a bug, the ID_CAT column is TINYINT unsigned )
http://www.simplemachines.org/community/index.php?topic=274252.0
Oops, sorry :(
The forum runs very well, thank you guys :D
Hi,
Complete newbie here, trying to help a forum in distress.
I have installed SMF (a breeze) and I am now trying to convert existing Woltlab Burning Board.
First hurdle is, how do I find out which version of Burning Board is current forum using. Forum is currently down, but I do have access to MySQL database and files on the webhost.
I assumed, but could be wrong (see above) that the current forum is using 3.x Burning Board. However, I find instructions a bit lacking.
I downloaded all three files from the opening post and placed them in smf folder, however there is no convert.php file in my smf folder.
I tried using wbb3_migration.php in the url , but I am presented with a blank page with no errors. Same happens if I try renaming wbb3_migration.php to convert.php.
Am I missing a step somewhere? Probably something stupid.
WBB3 is splitted into the board and the community framework.. check your database with phpMyAdmin first. Are there tables named wcf_1_1.yyyy (then it's a WBB3).
Then download convert.php, wbb3_to_smf.sql and wbb3_migration.php. create a folder named wbb3 and place the wbb3_migration.php in this folder (after you have edited that file and changed the variables with your databasename / table prefix).
upload convert.php and wbb3_to_smf.sql to your newly installed SMF and start convert.php with a webbrowser.
Thanks TE. Let me try this and I'll keep you posted.
I was able to get to convert.php, but I run into a new problem(s).
The first problem is within convert.php where it asks for paths to SMF and Burning Board.
It accepts the default entry for SMF (e.g. /public_html/smf) but does not accept Burning Board entry /public_html/forum. I thought I found a workaround and that it was looking for wbb3_migration.php which I placed in /public_html/smf/wbb3 and it started chugging along converting stuff. Everything looked fine until:
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1251418046),
("conversion_from", "wbb3_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1251418046)' at line 1
I thought that this might be just an entry that tells when the conversion was done, and therefore rather uninmportant. So I went and logged into new smf forum but it is empty, although it does accept my username/password from the old forum. There are no posts, no topics, and no boards visible in the new smf forum.
On top of that, my administrator user/password that I created when I installed smf does not exist anymore.
I checked MySQL and tables seem to be populated, but no boards, topics or posts can be seen when I login (remember I login with my username/password from old forum).
SO, how do I declare myself admin again? What happened with boards, topics and posts, why are they not visible?
Your help is truly appreciated.
asadmaloja,
the pathes in convert.php are absolute pathes.. path for SMF is automatically detected right (something like /home/user1/public_html ...)the path from WBB should be slightly different at the end.
maybe the board was fully converted but you don't have the login fix installed?
I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466)
note: the permissions are not converted, everything will be admin only for board access.
Thank you once again TE.
I figured out that everything was converted but hidden.
I resolved the issue of no admin account by running install again, created admin account and I was able to get in.
However, a lot of members are compalining about their passwords not working (old ones), although there are some members for whom old passwords work. I think that (at least) some of them forgot their original passwords.
I will look elsewhere on the forum, but is there an option where a member can enter their registered email address and that a new password gets generated and sent to it. I know that this can be done for the new members, but I would like to give this option to already existing members.
Oh, and ungrateful b^%4stards are complaining about smiley's already, forgetting that for weeks they were not able to login into their (old) forum. >:( Just kidding, I know that would be the case, so I will have to research smileys.
Thanks for your help.
WBB3 is using a new password encryption, this encryption is not supported by default. You should install the burningboard_login_fix.zip (attachment, first post from this topic), then users can login witzh their old passwords.
For the Smileys: enable custom smileys in SMF and set the old Smileys-Code for your smileys.
Smileys and Message Icons (http://docs.simplemachines.org/index.php?board=58.0;sort=subject)
I have resolved the issue with smileys. Due to the fact that I have installed smf in one folder and then reinstalled (over the previous) in the other folder, some of the themes (e.g. deault core SMF) were pointing to the older install.
Once that was rectified and pointed to a correct folder, smileys started working.
I might have mentioned that I have used burningboard_login_fix.zip, but I wonder if the above caused the problem with passwords. I will keep you posted.
you should use repair_settings.php and fix the wrong pathes:
What is repair_settings.php? (http://docs.simplemachines.org/index.php?topic=663)
the login-fix is needed for the old WBB passwords.
you can also manually make these changes. Edit the file Sources/LogInOut.php
find:
// Maybe they are using a hash from before the password fix.
add after:
// BurningBoard3 Login Method (double salted SHA1)
elseif (strlen($user_settings['passwordSalt']) == 40)
$other_passwords[] = sha1($user_settings['passwordSalt'] . sha1($user_settings['passwordSalt'] . sha1($_REQUEST['passwrd'])));
I've tried the "Wbb 3 to SMF 2-0-rc2 converter (http://download.simplemachines.org/?converters;software=wbb)" on a fresh installed SMF 2.0 RC2
QuoteConverting members...Wrong value type sent to the database. Integer expected. (gender)
Please use the attached file.
Thanks, but I've got the same message.
Trying again to fix it: please eventually use this one then.
I got the same message again.
Can you please make this modification (only during the conversion, undo it after):
in your file from SMF ./Sources/Subs-Db-mysql.php (if you're using MySQL):
// Create an array consisting of only the columns.
$indexed_columns = array_keys($columns);
echo "<br>indexed_columns: ";
print_r($indexed_columns);
echo "<br>";
And also:
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
echo "dataRow: ";
print_r($dataRow);
echo ("<br>");
Then, run the conversion again, and you should have lots of messages on the screen. Please copy them here or in a file.
Make sure to keep a copy of your original file and replace it back after the conversion.
Converting members...
indexed_columns: Array ( [0] => id_member [1] => member_name [2] => posts [3] => date_registered [4] => last_login [5] => real_name [6] => passwd [7] => email_address [8] => website_title [9] => website_url [10] => icq [11] => aim [12] => yim [13] => msn [14] => gender [15] => birthdate [16] => show_online [17] => personal_text [18] => id_group [19] => hide_email [20] => time_offset [21] => signature [22] => lngfile [23] => buddy_list [24] => pm_ignore_list [25] => message_labels [26] => location [27] => time_format [28] => avatar [29] => member_ip [30] => secret_question [31] => secret_answer [32] => validation_code [33] => additional_groups [34] => smiley_set [35] => password_salt [36] => member_ip2 )
dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: Array ( [id_member] => 940 [member_name] => B4BYD0LL [posts] => 0 [date_registered] => 1226786175 [last_login] => 1226786429 [real_name] => B4BYD0LL [passwd] => 3bf72ecb84df1a6d41ec6968f7bd2c6423b35d95 [email_address] => [email protected] [website_title] => [website_url] => [icq] => [aim] => [yim] => [msn] => [gender] => 0000-00-00 [birthdate] => 1 [show_online] => [personal_text] => [id_group] => 0 [hide_email] => [time_offset] => [signature] => [lngfile] => [buddy_list] => [pm_ignore_list] => [message_labels] => [location] => 1 [time_format] => [avatar] => [member_ip] => [secret_question] => [secret_answer] => [validation_code] => [additional_groups] => [smiley_set] => [password_salt] => 628274ad05ca00b55fd1df76d38ca1f3d1abc23f [member_ip2] => )
Wrong value type sent to the database. Integer expected. (gender)
Please try using this file instead. (make sure you fully restart the conversion as well)
Converting members...
indexed_columns: Array ( [0] => id_member [1] => member_name [2] => posts [3] => date_registered [4] => last_login [5] => real_name [6] => passwd [7] => email_address [8] => website_title [9] => website_url [10] => icq [11] => aim [12] => yim [13] => msn [14] => gender [15] => birthdate [16] => show_online [17] => personal_text [18] => id_group [19] => hide_email [20] => time_offset [21] => signature [22] => lngfile [23] => buddy_list [24] => pm_ignore_list [25] => message_labels [26] => location [27] => time_format [28] => avatar [29] => member_ip [30] => secret_question [31] => secret_answer [32] => validation_code [33] => additional_groups [34] => smiley_set [35] => password_salt [36] => member_ip2 )
dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: Array ( [id_member] => 940 [member_name] => B4BYD0LL [posts] => 0 [date_registered] => 1226786175 [last_login] => 1226786429 [real_name] => B4BYD0LL [passwd] => 3bf72ecb84df1a6d41ec6968f7bd2c6423b35d95 [email_address] => [email protected] [website_title] => [website_url] => [icq] => [aim] => [yim] => [msn] => [gender] => 0000-00-00 [birthdate] => 1 [show_online] => [personal_text] => [id_group] => 0 [hide_email] => [time_offset] => [signature] => [lngfile] => [buddy_list] => [pm_ignore_list] => [message_labels] => [location] => 1 [time_format] => [avatar] => [member_ip] => [secret_question] => [secret_answer] => [validation_code] => [additional_groups] => [smiley_set] => [password_salt] => 628274ad05ca00b55fd1df76d38ca1f3d1abc23f [member_ip2] => )
Wrong value type sent to the database. Integer expected. (gender)
Are you sure you are using that file? Have you copied it over the others? There must be something little I am missing but not sure what.
Eventually, do this: in the file wbb3_to_smf.sql, find
IF(IFNULL(v.userOption12, '') = '', 0, v.userOption12) AS gender,
0 AS gender,
for the time being.
Yes, I'm using your files. :)
Converting members...
indexed_columns: Array ( [0] => id_member [1] => member_name [2] => posts [3] => date_registered [4] => last_login [5] => real_name [6] => passwd [7] => email_address [8] => website_title [9] => website_url [10] => icq [11] => aim [12] => yim [13] => msn [14] => gender [15] => birthdate [16] => show_online [17] => personal_text [18] => id_group [19] => hide_email [20] => time_offset [21] => signature [22] => lngfile [23] => buddy_list [24] => pm_ignore_list [25] => message_labels [26] => location [27] => time_format [28] => avatar [29] => member_ip [30] => secret_question [31] => secret_answer [32] => validation_code [33] => additional_groups [34] => smiley_set [35] => password_salt [36] => member_ip2 )
dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: dataRow: Array ( [id_member] => 940 [member_name] => B4BYD0LL [posts] => 0 [date_registered] => 1226786175 [last_login] => 1226786429 [real_name] => B4BYD0LL [passwd] => 3bf72ecb84df1a6d41ec6968f7bd2c6423b35d95 [email_address] => [email protected] [website_title] => [website_url] => [icq] => [aim] => [yim] => [msn] => [gender] => 0 [birthdate] => 1 [show_online] => [personal_text] => [id_group] => 0 [hide_email] => [time_offset] => [signature] => [lngfile] => [buddy_list] => [pm_ignore_list] => [message_labels] => [location] => 1 [time_format] => [avatar] => [member_ip] => [secret_question] => [secret_answer] => [validation_code] => [additional_groups] => [smiley_set] => [password_salt] => 628274ad05ca00b55fd1df76d38ca1f3d1abc23f [member_ip2] => )
Wrong value type sent to the database. Date expected. (birthdate)
Clearly, there is more work to do for the 2.0 converter to wbb to work.
I will come back on this, however please note that:
In case you wish, you can send me a raw backup of your database and I will correct these issues, updating our converter properly in the process. I have to note however that I'll be insanely busy for the next few days, so it may take from a couple of hours up to a week or so.
As an alternative that might be quicker for you, you can try installing SMF 1.1.10 and converting to it, as that particular converter should be fully tested and working, and then, you can upgrade your SMF by using the large upgrade package from this site's downloads area.
Thank you but I'm not in hurry. I will wait for the new converter and I wait for a solution for this issue http://www.simplemachines.org/community/index.php?topic=286982.msg2100249#msg2100249
I've made structure backup of my database for you - i hope this is enough. Please tell me, if you need a backup with data.
Thank you, a backup with data would be better indeed, if at all possible.
The database has 36 MB - how we can solve this?
In case you agree, I will PM you an account to use.
That is ok. :)
Are there any converter news?
http://custom.simplemachines.org/converter_request.php?id=22
Hello,
I'm trying to convert how can I fix this:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'websiten_wb'@'localhost' for table 'wbb1_1_user'
Thanks, Roger
Ok,
Got that portion fixed (forget previous post by me), but I get this:
Converting members... Unsuccessful!
This query:
ALTER TABLE `websiten_wb`.smf_members
CHANGE COLUMN password_salt password_salt varchar(40) NOT NULL default '';
Caused the error:
Unknown column 'password_salt' in 'smf_members'
As you said earlier it only works for 1.1.11 Well, Thats the install I used. Would appreciate any guidance. Maybe I missed something?
Thanks, Roger
I believe you're using the wrong wbb3_to_smf.sql (the 2.0 version instead of 1.1.).. the column "password_salt" in SMF 2.0 is named "passwordSalt" in SMF 1.1.x
Ok, Let me get the first one here in this topic and try it.
Thanks, Roger
Got it to convert.
Database is full. I can login as admin.
The problem now is where is all the info. Nothing on the board. The database says something should be there. It's full.
Any ideas? Thanks, Roger
For the life of me I just can't see why the board doesn't have any post. Permissions seem fine. Database has messages (topics).
Guess I need Help... ???
Did you got any errors during the conversion? please also check the table smf_messages via phpMyAdmin. is there any content inside this table?
Hi,
Actually, I did get errors. Although I went into phpadmin and change the numbers around to show the boards and place them into correct categories etc.
Password doesn't work when trying to reset, but otherwise it works. Got to look into that some more. Otherwise thanks as you did help I had the wrong smf file.
One thing to note is this convert only seems to work on the same hosting account. NOT two different ones. At least for me.
Quote from: jrhicks on May 23, 2010, 09:58:35 PM
One thing to note is this convert only seems to work on the same hosting account. NOT two different ones. At least for me.
yes, that's right. The converter needs direct access to the source forums database.
Quote from: jrhicks on May 23, 2010, 09:58:35 PM
Actually, I did get errors.
Can you post these error messages? Maybe we can fix the converter..
Hy!
I get this error:
Converting attachments... Unsuccessful!
This query:
SELECT
attachmentID, messageID AS ID_MSG, downloads AS downloads, attachmentName AS filename
FROM `usr_web2_3`.wcf1_attachment
LIMIT 0, 500;
Caused the error:
Unknown column 'messageID' in 'field list'
What can I do?
Thx a lot!
ich hab das gleiche problem
i got the same problem / error
This query:
SELECT
attachmentID, messageID AS ID_MSG, downloads AS downloads, attachmentName AS filename
FROM `freebeat`.wcf1_attachment
LIMIT 0, 500;
Caused the error:
Unknown column 'messageID' in 'field list'
smf 1.1.12
wbbBurning Board Version 3.1.1 pl 1 (Volcano)
Community Framework Version 1.1.1 pl 2 (Tempest)
Can you please export the structure of the attachment table (wcf1_attachment from freebeat database), structure only, with phpmyadmin, and attach it or send it in a PM?
In order to do that, you can select the database and the table, then go to export tab, and please make sure you select "structure" only, no data. Then save it in a file, and PM me the contents of it, or attach it here. Having no data whatsoever, it wouldn't have anything confidential.
Alternatively, if you wish, I would appreciate if you consider to send me the entire contents of the database, that would help. As you want, of course.
HAs this ever worked for anybody?
-->
SMF 2
WBB 3.07
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Hello,
is with me all over, except for the attachments. The article will appear in, but are not associated with the attachments in the folder.
When clicking to open the image as a download, then the file is probably empty.
I think it's random hash generated from the account of the wbb.
Is there a help to me?
Quote from: jrhicks on May 21, 2010, 05:39:07 AM
Hello,
I'm trying to convert how can I fix this:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'websiten_wb'@'localhost' for table 'wbb1_1_user'
Thanks, Roger
hi i have same problem like this
how to fix this
someone who has done this and can explain
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Unable to find the settings for Burning Board 3.0. Please double check the path and try again.
promlem
/home/airsoftt/public_html/smf
/home/airsoftt/public_html/forum
yes
/public_html
wbb3_to_smf.sql
wbb3_migration.php
convert.php
Promlem:(((
djsami,
the converter you're using is outdated.
please try the converter from my github account (see my signature) or use this link instead:
https://github.com/eurich/smf_converters/zipball/master (wbb3_to_smf.sql is included in the zip file)
Quote from: Thorsten Eurich on September 24, 2012, 02:19:01 AM
djsami,
the converter you're using is outdated.
please try the converter from my github account (see my signature) or use this link instead:
https://github.com/eurich/smf_converters/zipball/master (wbb3_to_smf.sql is included in the zip file)
promlem wbb database airsoftt_smf smf database airsoftt_smf okey
promlem
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3. 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 'airsoftt_smf'@'localhost' for table 'wbb1_1_user'
The cause of this error is that SMF and WBB are in separate databases and the SMF database user does not have access to WBB's database.
Fix: If your host has cPanel you can add the SMF database user to WBB's database. If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as WBB. WBB and SMF use different table prefixes, thus they don't interfere each other.
Quote from: Thorsten Eurich on September 25, 2012, 01:23:01 AM
The cause of this error is that SMF and WBB are in separate databases and the SMF database user does not have access to WBB's database.
Fix: If your host has cPanel you can add the SMF database user to WBB's database. If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as WBB. WBB and SMF use different table prefixes, thus they don't interfere each other.
yes just like in the picture, but the same error persists, you make your cpanel password, you
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fg1209.hizliresim.com%2F11%2Ft%2Fdcr5y.jpg&hash=a075be9f2a1211f03fb9debf49dbf83e3f1470da)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fg1209.hizliresim.com%2F11%2Ft%2Fdcr6b.jpg&hash=1476ebcab1c0a31e414cf65080880a345245ede6)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fg1209.hizliresim.com%2F11%2Ft%2Fdcr6q.jpg&hash=a57b8948c5c7382f81ab007d1cac64c740f7f0a2)
ok, from your screenshots I suspect You've installed SMF AND WBB in the database named airsoft_smf?
If you're using the converter from my github account you shouldn't need migration.php, but you have been asked for a wbb table prefix and for a wcf table prefix. the first one should be filled with wbb1_1_, the second one should be filled with wcf1_.
Quote from: Thorsten Eurich on September 25, 2012, 07:53:22 AM
ok, from your screenshots I suspect You've installed SMF AND WBB in the database named airsoft_smf?
If you're using the converter from my github account you shouldn't need migration.php, but you have been asked for a wbb table prefix and for a wcf table prefix. the first one should be filled with wbb1_1_, the second one should be filled with wcf1_.
http://www.airsoftturk.com/wbb3/convert.php
WCF table prefix (default is wcf1_ ):
WBB table prefix (default is wbb1_1_ ):
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3. 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 'airsoftt_smf'@'localhost' for table 'wbb1_1_user'
please try the following (enter these in the text boxes):
path to SMF: /home/airsoftt/public_html/smf
path to WBB: /home/airsoftt/public_html/forum
wcf table prefix: wcf1_
WBB table prefix_ wbb1_1_
MySQL password: your mysql password used while installing SMF.
Quote from: Thorsten Eurich on September 25, 2012, 10:55:27 AM
please try the following (enter these in the text boxes):
path to SMF: /home/airsoftt/public_html/smf
path to WBB: /home/airsoftt/public_html/forum
wcf table prefix: wcf1_
WBB table prefix_ wbb1_1_
MySQL password: your mysql password used while installing SMF.
error
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fc1209.hizliresim.com%2F11%2Ft%2Fdczd9.jpg&hash=944e6ca92f45e6a88b16726fa0c3ec3f28209916)
ok, please validate the MySQL password.. the password you're typing in that box is the same password located in the file Settings.php from your SMF installation (line 43, the variable is named db_passwd =)?
Quote from: Thorsten Eurich on September 25, 2012, 12:37:56 PM
ok, please validate the MySQL password.. the password you're typing in that box is the same password located in the file Settings.php from your SMF installation (line 43, the variable is named db_passwd =)?
$db_name = 'airsoftt_smf';
$db_user = 'airsoftt_smf';
$db_passwd = 'xxxxxxxxx';
???
Quote from: djsami on September 25, 2012, 12:41:35 PM
Quote from: Thorsten Eurich on September 25, 2012, 12:37:56 PM
ok, please validate the MySQL password.. the password you're typing in that box is the same password located in the file Settings.php from your SMF installation (line 43, the variable is named db_passwd =)?
$db_name = 'airsoftt_smf';
$db_user = 'airsoftt_smf';
$db_passwd = 'xxxxxxxxx';
ok, let's validate these via phpMyAdmin... please login with this credentials and go to the sql window, there you paste this sql query and tick the submit button. Exactly this is what the converter tries to do..
SELECT * from wbb1_1_user LIMIT 10;Do you get the same error?
Quote from: Thorsten Eurich on September 25, 2012, 01:05:30 PM
Quote from: djsami on September 25, 2012, 12:41:35 PM
Quote from: Thorsten Eurich on September 25, 2012, 12:37:56 PM
ok, please validate the MySQL password.. the password you're typing in that box is the same password located in the file Settings.php from your SMF installation (line 43, the variable is named db_passwd =)?
$db_name = 'airsoftt_smf';
$db_user = 'airsoftt_smf';
$db_passwd = 'xxxxxxxxx';
ok, let's validate these via phpMyAdmin... please login with this credentials and go to the sql window, there you paste this sql query and tick the submit button. Exactly this is what the converter tries to do..
SELECT * from wbb1_1_user LIMIT 10;
Do you get the same error?
no no no
Showing rows 0-9 (10 total, Query 0.0301 sec. Took)
SELECT *
FROM wbb1_1_user
LIMIT 10
sql no promlem
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fb1209.hizliresim.com%2F11%2Fu%2Fddgf5.jpg&hash=a0a543a7d4081c9152d0b23e00c8956f23daf626)
ok, and you're loging in to phpMyAdmin with the same credentials (username & password) your SMF was installed? That's really odd and I have no clue about the reason.. My last idea: export your database and import it on localhost, you'd need a local webserver instance (such as XAMPP or vertrigo) for that but it should do the trick. I've used the converter more than 100 times and it's working as expected, thus it must be related to your host.
yes zero smf smf database was installed on the database wbb yes both in the same way works fine, but unfortunately, I give you the information I gave you, or if you try to backup cpanel? ?
www.airsoftturk.com/smf
www.airsoftturk.com/forum
I'm starting from scratch, wipe host
Make sure the wbb installation is pointing to the tables in the SMF database. It appears that's what's causing your problems here.
humm get this error after convert
Parse error: syntax error, unexpected T_ELSEIF in /home/fiskefni/public_html/forum/smf/Sources/LogInOut.php on line 342
what now???
Quote from: hugo2 on September 28, 2012, 04:03:46 AM
humm get this error after convert
Parse error: syntax error, unexpected T_ELSEIF in /home/fiskefni/public_html/forum/smf/Sources/LogInOut.php on line 342
The file Sources/LogInOut.php seems broken, did you install the login fix? You don't need it for SMF 2.0, the fix is build-in.
Fix: Replace the file Sources/LogInOut.php with a new file from the install or upgrade package.
works thanx.......... ;D
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3.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 'gs2043'@'localhost' for table 'wbb1_1_user'
and there are no prefixes... www.puu.sh/1CJy9 see this.. I got wrong convert.php or what ?
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3.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 'gs2043'@'localhost' for table 'wbb1_1_user'
That error means that the "gs2043" user does not have access to the database that the wbb1_1_user table is on.
Quote from: jrhicks on May 21, 2010, 05:39:07 AM
Hello,
I'm trying to convert how can I fix this:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 3.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'websiten_wb'@'localhost' for table 'wbb1_1_user'
Thanks, Roger
Quote from: Oldiesmann on December 19, 2012, 11:20:33 AM
That error means that the "gs2043" user does not have access to the database that the wbb1_1_user table is on.
well it is on gs2043_wbb , ... and smf is on gs2043_smf ... god.. how to edit the mysql username ... as i said it always says gs2043 , and wcf is on gs2043_wbb .. there are no opitions for mysql username in this damn convert.php.. i use wrong convert.php or ?
Quote from: zapex on December 19, 2012, 11:23:02 AM
Quote from: Oldiesmann on December 19, 2012, 11:20:33 AM
That error means that the "gs2043" user does not have access to the database that the wbb1_1_user table is on.
well it is on gs2043_wbb , ... and smf is on gs2043_smf ... god.. how to edit the mysql username ... as i said it always says gs2043 , and wcf is on gs2043_wbb .. there are no opitions for mysql username in this damn convert.php.. i use wrong convert.php or ?
You can't control the MySQL username from convert.php - that information is picked up from SMF's Settings.php file (due to the way the conversion is handled, it is not possible to use separate user accounts for each system - it has to use the username and password from the SMF setup).
As far as how to fix the situation - that really depends on the control panel your host is using. I can give you instructions for cPanel, but for other things you'll either need to ask your host or search Google for appropriate documentation.
If you are using cPanel, it's fairly easy:
Login to cPanel, scroll down to the "Databases" section and click on "MySQL Databases"
Scroll down until you see the section labeled "Add User To Database"
Select the user account that's used for SMF
Select the database for wbb
Click "Add"
On the next page, check the box marked "ALL PRIVELEGES"
Click "Make Changes"
Hi there,
I have a problem regarding the conversation WBB3 > SMF2
I got the latest wbb3_to_smf.sql from you git. But whenever I try to convert it - there is an error:
Converting members...
The database value you're trying to insert does not exist: website_title
How to solve that?
Quote from: Androxyd on February 08, 2013, 04:20:53 PM
Hi there,
I have a problem regarding the conversation WBB3 > SMF2
I got the latest wbb3_to_smf.sql from you git. But whenever I try to convert it - there is an error:
Converting members...
The database value you're trying to insert does not exist: website_title
How to solve that?
Hello; I'm new to SMF, and I've got the same problem, does anyone know how we can solve this ?
Sorry for message above, I've tried again, and it works !
I've done a fresh install using the same database and everything is working nice ! I'm very pleased ! Thank you all !
Hello,
i downloaded the converter from http://download.simplemachines.org/?converters;software=wbb
and got this result after some edits: Someone got an converter, which works 100%?
Converting...
Converting 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 poll votes (part 2 - Fallback for migrated WBB2 boards)... Successful.
Converting attachments...
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 3
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-1) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 3
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-2) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 3
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-3) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 3
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-4) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting avatars...
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 3
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Notice: Undefined variable: ID_ATTACH in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 7
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/10206_2.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/wolfenstein.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-12.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-13.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-22.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/images.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/d-ray.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/Tux-Dupont.png) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/soldat_hauptmann.png) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/left_fuss.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/666_.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: copy(C:\wamp\www\smf/attachments/C:\wamp\www\smf/attachments/av-2.jpg) [function.copy]: failed to open stream: Invalid argument in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 4
Warning: array_keys() expects parameter 1 to be array, string given in C:\wamp\www\smf\convert.php on line 1288
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: in_array() expects parameter 2 to be array, null given in C:\wamp\www\smf\convert.php on line 2612
Warning: Invalid argument supplied for foreach() in C:\wamp\www\smf\convert.php on line 2624
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in C:\wamp\www\smf\Sources\Subs-Db-mysql.php on line 627
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 ')' at line 3
What edits did you make? There is no capitalized "ID_ATTACH" variable in the code (only a lowercase one - $id_attach).
I´m sorry for my late reply but I made a big misstake, i used v 1.1 for 2.0.4 :(
Now i used the right one and get the following messages:
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting poll votes (part 2 - Fallback for migrated WBB2 boards)... Successful.
Converting attachments...
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-1) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-2) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-3) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Warning: copy(C:\wamp\www\wbb/wcf/attachments/attachment-4) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting avatars...
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-12.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-13.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Warning: copy(C:\wamp\www\wbb/wcf/images/avatars/avatar-22.jpg) [function.copy]: failed to open stream: No such file or directory in C:\wamp\www\smf\convert.php(1254) : eval()'d code on line 6
Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in C:\wamp\www\smf\Sources\Subs-Db-mysql.php on line 627
The database value you're trying to insert does not exist: string
My Changes:
converter.php
line 1246
$special_result = convert_query(sprintf($current_data, $_REQUEST['start'], $_REQUEST['start'] + $special_limit - 1) . "\n" . 'LIMIT ' . $special_limit);
to
$special_result = convert_query($current_data, $_REQUEST['start'], $_REQUEST['start'] + $special_limit - 1 . "\n" . 'LIMIT ' . $special_limit);
Please compare the changes on wbb3_to_smf.sql (see attachment), i did so many (especially the members select).
Btw, the script should check, if the colum old_choice already exist in poll_choices (line 268 in wbb3_to_smf.sql).
My environment:
wbb version: 3.0.8 pl 1
smf version: 2.0.4
PHP version 5.2.9-2
Apache: 2.0.63
MySQL-version: 5.5.24-log - MySQL Community Server (GPL)
I hope someone can help me.
Hi,
now I get it!
I used the .sql file from https://github.com/eurich/smf_converters and did 2 Changes:
columnname "containerID" and "containerType" renamed in "messageID" and "messageType".
best regards
Quote from: TE on September 25, 2012, 10:55:27 AM
please try the following (enter these in the text boxes):
path to SMF: /home/airsoftt/public_html/smf
path to WBB: /home/airsoftt/public_html/forum
wcf table prefix: wcf1_
WBB table prefix_ wbb1_1_
MySQL password: your mysql password used while installing SMF.
I tried this but with not success for me...I got error
I hate to dig up old threads but is there already a possibility to convert WBB 3.1 to SMF2? I tried a few times with the existing converter but it does not seem to work.
You need to tell us exactly what errors you get and which converter are you using. The current converter from our downloads should work good enough ;)
Oh sorry, I totally forgot to include the information.
WBB Version: 3.1.8
SMF Version: 2.0.9
I'm using the following converter: http://download.simplemachines.org/?converters;software=wbb
And I'm using the wbb3_migration.php file from the first post of this thread.
Here the first error:
- Converting members...Wrong value type sent to the database. Date expected. (birthdate)
As soon as I delte the part with birthdate from the SQL file, the following error appears:
- Converting members...Wrong value type sent to the database. Integer expected. (show_online)
And this goes on and on.
Furthermore a look at the database reveals that 0 members have been imported and the original admin account got deleted.
Hope you can help there..
I had a look at MySQL and its syntax and tried to change the errors that came up and here are my results:
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Solution: Delete 102 "v.userOption11 AS birthdate,"
Converting members...Wrong value type sent to the database. Integer expected. (show_online)
Solution: Change 102 '' AS show_online, -> '0' AS show_online,
Converting members...Wrong value type sent to the database. Integer expected. (hide_email)
Solution: Change 102 '' AS hide_email, -> '0' AS hide_email,
Converting members...Wrong value type sent to the database. Floating point number expected. (time_offset)
Solution: Change 103 '' AS time_offset, -> '0' AS time_offset,
Unknown column 't.is_sticky' in 'field list'
Solution: Change 175 t.is_sticky AS is_sticky, -> t.isSticky AS is_sticky,
Converting smileys...The database value you're trying to insert does not exist: string
Solution: Delete section
I have only 1 more problem trying to convert the attachments. There the following error appears:
Unknown column 'messageID' in 'field list'
As far as I understand, it has to do with linking the attachments to specific posts but unfortunately WBB changed the table (see image). I tried linking it with postID in "wbb1_1_post" but then it said:
The database value you're trying to insert does not exist: id_msg
Anyone got an idea what to do there?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffs1.directupload.net%2Fimages%2F141224%2Faut5p3yf.png&hash=25d06baafb0ec1ccca104747f62904aaab823c24)
I'm sorry, I still had to chance to pick this (you know, Christmas dinners and everything :P )
I used this converter as a base for a functional converter for WBB4 so I think I should be able to fix those issues ;)
Anyway, I cannot pick it for the next days. You know, Christmas dinners and everything :P
No problem. :D
Nonetheless I'm going to try finding a solution and if I do so, I will post it here right away. I need to improve my coding skills anyway. :D
Merry christmas. :)
So, now I could pick this up. I don't have a functional test board for WBB3 so I can't really debug it but, nevertheless, I could compare the files.
In the converter for WBB3, you have this:
v.userOption11 AS birthdate,
In WBB4 I had to change it to this:
IF(IFNULL(v.userOption2, '') = '', '0001-01-01', v.userOption2) AS birthdate,
So, for WBB3 something like this:
IF(IFNULL(v.userOption11, '') = '', '0001-01-01', v.userOption11) AS birthdate,
Should work ;)
For "show_online" is exactly like you did. With "0" you are configuring your users to NOT show up as online. You can also choose to use "1" (without quotes) so that your users are shown online ;)
For the attachments, I would need to access the forum and the database. I would say that it should be "containerID" but I'm not sure...
Excuse the late reply, just arrived at home after a longer than planned trip. I can give you access to a forum and a database on January 2, but containerID looks right as far as I can see.
Nevertheless I'm going to try the proposed changes (also containerID) and report if it has worked or not today or tomorrow.
Everything worked perfectly with the attachements. Attached to this the final sql (if needed).
Here my changes:
Changed line 102 (which changes every birthdate to 0000-00-00, so users have to edit this after the conversion)
IF(IFNULL(v.userOption11, '') = '', '0001-01-01', v.userOption11) AS birthdate,
Changed line 103 (enables "Show others my online status" and disables "Allow users to email me")
'1' AS show_online, '' AS personal_text, '0' AS id_group, '1' AS hide_email,
Changed line 104 (Sets the time offset for every user to 0)
'0' AS time_offset, SUBSTRING(u.signature, 1, 65534) AS signature, '' AS lngfile,
Changed line 176 (in WBB 3.1 the stickies are saved as t.isSticky and not as t.is_sticky)
t.threadID AS id_topic, t.isSticky AS is_sticky, t.boardID AS id_board,
Changed line 306 (again thanks to margarett for this)
attachmentID, containerID AS id_msg, downloads AS downloads, attachmentName AS filename
Deleted line 498 - 554 (the entire smiley section) (I did not need the smileys of my old WBB installation anymore)
One more thing which is kind of important: Apparently you can not send attachments via PM in SMF, so it would be better to delete every attachment which has the containerType PM pre-conversion because they are not displayed and would just fill up disk space.
Thank you :) It's always interesting to see someone else dealing with the converters :)
About the attachments, I'm on the phone so I can't see the code but I would assume that the SELECT query for the attachments includes a WHERE in order to filter unnecessary attachments, doesn't it? If not, it should :P
Here the part of the SQL-file concerning the attachments:
/******************************************************************************/
--- Converting attachments...
/******************************************************************************/
ALTER TABLE {$to_prefix}poll_choices
DROP old_choice;
---* {$to_prefix}attachments
---{
$no_add = true;
$file_hash = getAttachmentFilename($row['filename'], $id_attach, null, true);
$physical_filename = $id_attach . '_' . $file_hash;
if (strlen($physical_filename) > 255)
return;
if (copy($_POST['path_from'] . '/wcf/attachments/attachment-' . $row['attachmentID'] , $attachmentUploadDir . '/' . $physical_filename))
{
$rows[] = array(
'id_attach' => $id_attach,
'size' => filesize($attachmentUploadDir . '/' . $physical_filename),
'filename' => $row['filename'],
'file_hash' => $file_hash,
'id_msg' => $row['id_msg'],
'downloads' => $row['downloads'],
);
$id_attach++;
}
---}
SELECT
attachmentID, containerID AS id_msg, downloads AS downloads, attachmentName AS filename
FROM {$from_prefix}{$wcf_prefix}attachment;
---*
So no "WHERE containerType ='post'" in the SQL yet, but: As far as I understand the convert.php copies every file in the WBB attachment directory to the new SMF attachment directory, so the PM attachments would be copied as well even if you would include the WHERE clause. Or am I wrong there? (first time really working with SQL files :D )
That's why I thought deleting every attachment with containerType PM pre-conversion would be easier and necessary.
In fact there is no WHERE but it should :(
And no, the converter doesn't copy all files, just the files retrieved by the SELECT query ;)
Ah okay.
Changed it to:
SELECT
attachmentID, containerID AS id_msg, downloads AS downloads, attachmentName AS filename
FROM {$from_prefix}{$wcf_prefix}attachment
WHERE containerType ='post';
Going to test it in 20 or 30 minutes and will report if it has worked.
Attached the fixed .sql with "WHERE containerType ='post';"
It looks like it worked:
PRE fix: 625 attachments
Post fix: 549 attachments
But I noticed something strange:
It only creates some thumbnails. As soon as a post with a thumbnail is called up, a record is created in the database with the filename and _thumb attached as filename and an attachment type of 3. The rest has the following values:
attachment_type = 0
id_thumb = 0
fileext = empty
width = 0
height = 0
mime_type = empty