Software: Invision Power Board (IPB)
Version: 3.0
NOTE: You should test the converted forum before delete your IPB installation, if you need to do it.
Here's the converter from IPB 3.0 to SMF 2.0 RC3, this was tested under an small database so if you have any issues please report them here, data that will be converted:
- Members
- Administrators
- Categories
- Topics
- Boards
- Posts
- Polls
- Poll Votes
- Personal Messages (Conversations)
- Topic Notifications
- Board Notifications
- Censored Words
- Moderators
- Calendar Events
- Smileys
- Attachments
- Avatars
- Settings
I'll try this converter with IPB 3.1. Hope it works :)
Edit: Is there any guidance for this converter? For example, should i use the same DB for IPB and SMF? Coz I got that error:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power 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 'onderim_smf'@'localhost' for table 'members'
Not work convert.php, please upload now.
Quote from: Sirandilas on November 04, 2010, 01:31:07 PM
Not work convert.php, please upload now.
It works actually. If you browse with IE you'll get 404 error. Try with Mozilla Firefox.
Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why :(
I had this problem too change the date structure in the SQL file provided.
mine hangs on coverting topics when it gets to topic 26546 it hangs talking about a duplicate key.
Fatal error: Call to undefined function loadDatabase() in /home/acropoli/public_html/domain.com/forum/convert.php on line 414
i get this after enthering the pats
Please make sure you're using the converter to SMF 1.1.x on a SMF 1.1.12 installation, and the converter to SMF 2.0 RC4 on a SMF 2.0 RC4 installation.
Quote from: Sirandilas on November 04, 2010, 01:50:38 PM
Converting members...Wrong value type sent to the database. Date expected. (birthdate) ? why :(
I've got this problem too. Please help ASAP!
My IPB version is 3.1.2
DeWo,
in ipb3_to_smf.sql find:
---* {$to_prefix}members
add after:
---{
/* Fix for invalid birthdays */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
$row['birthdate'] = '0001-01-01';
---}
then restart the conversion.
Thanks TE!
I tried do it by myself but I only deleted converting members.
And I see next problem - SMF doesn't have subforum functions and converted subforums are on main page.
Maybe time to add this function? ;)
DeWo
Quote from: DeWo on December 11, 2010, 02:41:45 AM
I tried do it by myself but I only deleted converting members.
huh, could you please test the attached version?
for the subforums: sure, SMF has subforum functionality.. AFAIK the converter skips the board order (parent & childs) because the structure in IPB is completely different (can't test it though, because IPB is paid software and I don't have a copy from an IPB database anymore)
/* The converter will set id_cat for us based on id_parent being wrong. */
but you could re-arrange the boards after the conversion.
Quote from: TE on December 11, 2010, 02:56:55 AM
for the subforums: sure, SMF has subforum functionality.. AFAIK the converter skips the board order (parent & childs) because the structure in IPB is completely different (can't test it though, because IPB is paid software and I don't have a copy from an IPB database anymore)
Oh c'mon :D For these purposes you can use nulled informally ;)
I think it'll be useful for all of us :)
PS: I'll test attached file tonight (my timezone :))
I am (unfortunately) using ipb 3_0_5, and trying to convert to SMF 2.0 RC4 (RC3 wasn't available) and I'm getting this error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (id_board)
Looks like it's hanging up on the posts after a certain amount as the conversion script gets around 3K posts and dies.
Jan
hiredgunz,
in ipb3_to_smf.sql find:
---* {$to_prefix}messages 200
---{
add after:
if(empty($row['id_board']))
$row['id_board'] = 1;
then restart the converter.
Thank you TE, that worked for getting thru step 1, but at step 2 the converter says,
"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)...Duplicate entry '1-1' for key 1"
Change TE code to:
if(empty($row['id_board']))
$row['id_board'] = rand(99, 900);
Then restart the converter. Should works :)
Oh no.. My error :P I didn't finish reading your post and i wrote aswer :P
Take a while, I'll try to help you :)
OK, I think I know :D
Go to phpMyAdmin and exec this SQL query:
TRUNCATE smf_personal_messages
(if you have diffrent prefix replace "smf_" to other)
And then run converter :)
Thank you kindly for your help, but still got
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)...Duplicate entry '1-1' for key 1
after a retry...
hopefully that works, in ipb3_to_smf.sql find:
---* {$to_prefix}pm_recipients
---{
$no_add = true;
replace with:
---* {$to_prefix}pm_recipients
---{
$no_add = true;
$ignore = true;
So close to finishing .. but,
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 calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Converting settings...
Fatal error: Call to undefined function updateSettingsFile() in /forums/convert.php(1099) : eval()'d code on line 57
Please make a little more modification, to convert.php:
require($sourcedir . '/Security.php');
require($sourcedir . '/Subs-Admin.php');
i have a problem and i don't know what to do :(
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `fanart_azpire`.members AS m
LEFT JOIN `fanart_azpire`.pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `fanart_azpire`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pc.field_1' in 'field list'
I made your suggested change Norv and got:
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 calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /****/****/****/forums/Sources/Subs-Admin.php on line 260
Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /***/***/***/forums/Sources/Subs-Admin.php on line 263
Successful.
Recalculating forum statistics... Duplicate key name 'ip_index'
Still, the conversion got even closer to the end!
QuoteRecalculating forum statistics... Duplicate key name 'ip_index'
please check http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944
Converting moderators...Wrong value type sent to the database. Integer expected. (id_board)
How can this be solved?
in invision30_to_smf.sql find:
if (empty($row['id_member']))
replace with:
if (empty($row['id_member']) || empty($row['id_board']))
then restart the converter.
Actually I have ipb3_to_smf.sql ..did what you said and it's the same error...
Other solutions?
ok, let's try this instead..
if (empty($row['id_member']) || !is_int($row['id_board']))
Now I get this:
Notice: Undefined variable: row in /***/****/*****/smf/convert.php on line 1284
Warning: Invalid argument supplied for foreach() in /***/****/*****/smf/convert.php on line 1284
Warning: array_combine() [function.array-combine]: Both parameters should have at least 1 element in /*****/****/******/smf/Sources/Subs-Db-mysql.php on line 635
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
ok, I believe it might be better to completely remove the moderators block..
/******************************************************************************/
--- Converting moderators...
/******************************************************************************/
TRUNCATE {$to_prefix}moderators;
---* {$to_prefix}moderators
---{
$ignore = true;
if (empty($row['id_member']))
unset($row);
---}
SELECT member_id AS id_member, forum_id AS id_board
FROM {$from_prefix}moderators
WHERE member_id != -1;
---*
After removing this code the converter should finish without errors.
I'd be interested in the result of this query:
SELECT member_id AS id_member, forum_id AS id_board
FROM ipb_moderators
WHERE member_id != -1;
maybe you can execute it via phpMyAdmin and post the result.
I managed to convert something,but all users have 0 posts altough the posts appear on the forums.
I also got an error while converting
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /****/****/****/smf/Sources/Subs-Admin.php on line 260
Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /****/*****/*****/smf/Sources/Subs-Admin.php on line 263
Successful.
the error in covert.php:
http://www.simplemachines.org/community/index.php?topic=404732.msg2879776#msg2879776
the post counter is fixable via modification:
http://custom.simplemachines.org/mods/index.php?mod=2324
Quote from: silabsoft on November 05, 2010, 01:40:32 PM
I had this problem too change the date structure in the SQL file provided.
mine hangs on coverting topics when it gets to topic 26546 it hangs talking about a duplicate key.
same error here: "Duplicate entry '1454' for key 1", I tried deleting the topic with that ID and re-run the converter, but the same error appeared but with different number.
Edit: Full log from the converter:
Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '1454' for key 1
kR105!,
in ipb3_to_smf.sql find:
---* {$to_prefix}topics 250
add after
---{
$ignore = true;
---}
Worked! Thank you!
The convertion ended with some warnings, but the topics and users was converted sucessfully. The problem now is that my board is mostly spanish text and in the convertion process some characters now appear weird, for example:
IPB: Preséntate
Converted SMF: Preséntate
I tried changing the charset of my new board to ISO-8859-1 but more weird characters appeared so I reverted it to UTF-8.
Can you please help me? Maybe I'm missing something..
Convertion log:
Quote
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 calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars...
Warning: copy(/home/kr105/public_html/foro/uploads/av-1247.txt) [function.copy]: failed to open stream: No such file or directory in /home/kr105/public_html/foro2/convert.php(1263) : eval()'d code on line 59
Successful.
Converting settings...
Warning: filemtime() [function.filemtime]: stat failed for /Settings.php in /home/kr105/public_html/foro2/Sources/Subs-Admin.php on line 260
Warning: file_get_contents(/Settings.php) [function.file-get-contents]: failed to open stream: No such file or directory in /home/kr105/public_html/foro2/Sources/Subs-Admin.php on line 263
Successful.
Recalculating forum statistics... Successful.
the warning is a missing avatar file, nothing to worry about.
the charset issue:
I believe your IPB is UTF-8? you should install SMF with UTF-8 as character set (there should be an option list in install.php) and re-convert the forum.
Has anyone tried this with IPB 3.1? I need to do a 3.1 conversion to SMF 2.0 RC4, but I'm hesitant to get into it if it's gonna turn into a major pain in the arse.
EDIT: Okay, I see that it has been attempted, though it does look like it will be a pain. ;)
Can this be used to convert from IPB 3.0.x to SMF 1.1.12, or only to SMF 2.0 RC?
Only SMF 2.0
I get this error. :(
Converting members...
Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `banksy_ipb`.members AS m
LEFT JOIN `banksy_ipb`.pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `banksy_ipb`.profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'
I have same problem that Banksy. Any Idea what can I do?
OK I could convert from 3.1.4 to SMF 2.0 RC5 but It had 2 BUT
First: I commented one of last part of convert, this is the code that I commented, I don't know what do that part:
if (!isset($indexes['showPosts']))
$smcFunc['db_add_index']($to_prefix . 'messages', array(
'type' => 'INDEX', // no key
'name' => 'show_posts',
'columns' => array('id_member', 'id_member')),
array('no_prefix' => true));
Second: I use bio to fill user_title.
USE THIS FILES OVER YOUR OWN RISK.
Quote from: Kaelhy on April 07, 2011, 07:19:30 PM
I have same problem that Banksy. Any Idea what can I do?
OK I could convert from 3.1.4 to SMF 2.0 RC5 but It had 2 BUT
First: I commented one of last part of convert, this is the code that I commented, I don't know what do that part:
if (!isset($indexes['showPosts']))
$smcFunc['db_add_index']($to_prefix . 'messages', array(
'type' => 'INDEX', // no key
'name' => 'show_posts',
'columns' => array('id_member', 'id_member')),
array('no_prefix' => true));
Second: I use bio to fill user_title.
USE THIS FILES OVER YOUR OWN RISK.
Ouch ... Converting moderators...Wrong value type sent to the database. Integer expected. (id_board)
The IPB version is 3.1.0
I will check it. If anyone has the solution, tell us.
Just tried converting from 3.1.4 to 2 RC5 and i got this error... Anyone know if theres a fix, nothing came up for me in search...
Quote
Converting members... Unsuccessful!
This query:<blockquote>SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `doctor`.ipb_members AS m
LEFT JOIN `doctor`.ipb_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `doctor`.ipb_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;</blockquote> Caused the error:
<blockquote>Unknown column 'pp.pp_bio_content' in 'field list'
</blockquote>
Okay major problem the converter doesnt seem to want to work it isnt detecting my file is there any certain way it is suppose to be uploaded (the IPB) board im using 3.1.4 I need help ASAP
So i'm running a conversion for a guy and he was only able to get the database from his old host and he doesn't have a backup of the files. What modifications do I need to make to convert.php to make it so it doesn't need any of the files? I know less things will convert, but the person is alright with that
I've done all the Fixes here in the Thread and have update the two files.
Use it on Your own Risk please.
Kind regards, Andy
Doesn't seem to work for IPB 3.2.X
When i try to convert to smf it shows this error:
"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power 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 'dono91_diskusije'@'localhost' for table 'ipforum_members'"
i have installed ipboard 3.1.4 and smf 2.0 version. Can you help me pls.
Quote from: DieWacht on August 04, 2011, 04:19:13 PM
I've done all the Fixes here in the Thread and have update the two files.
Use it on Your own Risk please.
Kind regards, Andy
I have tried using these files and I still get the same error:
Converting members...
Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `kiss-clan_com_-_kissmain1`.ibf_members AS m
LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'
IPB version 3.2.3
Any help would be greatly appreciated!
I get this error. IPB 3.2
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `flyakaco_myaka`.ibp_members AS m
LEFT JOIN `flyakaco_myaka`.ibp_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `flyakaco_myaka`.ibp_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'
Anyone knows how to fix this converter for IPB 3.2?
This is for IPB 3.0.
3.2 is a different version.
well, I made some fixes and seems like it was converted fine from IPB 3.1.2 to the latest SMF (2.0.2).
please check it and use as you want, it worked for me, but seems like I'll not make any changes anymore.
does not work your converter
Im getting this any solution please suggest me ?
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power 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 'xnonymo2_smf1'@'localhost' for table 'members'
Hello,
I need to convert from the forum from IP.Board 3.1.4.
Looking converter is, but I can not find it anywhere.
Can you please advise.
thank you
Maav
You can find the "official" converters in our download page
You can also try this one from emanuele
http://www.simplemachines.org/community/index.php?topic=477019.0
Hello,
so I got further, but still writes me an error:
The converter detected that your host has open_basedir enabled on this server. Please ask your host to disable this setting or try moving the contents of your Invision Power Board 3.0 to the public html folder of your site.
I have only a backup of the database (.sql).
What this The converted after me really wants?
Thank you
That's a problem... The converter needs to read your IPB's config files to get the database details.
In which folder have you installed SMF?
Quote from: margarett on August 07, 2014, 07:44:19 AM
That's a problem... The converter needs to read your IPB's config files to get the database details.
In which folder have you installed SMF?
Since it via forum was too lengthy, so I took the liberty to send a PM.
Thanks
That's not what I meant ;)
Since we only have the database available, we need to "trick" the converter and create a fake "conf_global.php".
What I asked you is what is the folder (on the server) where SMF is installed (eg: /home/user123/public_html)
Also, is your IPB database already imported into phpmyadmin?
Hello,
I replied to the PM.
Thank you
Converting...
Converting members... Unsuccessful!
This query:
SELECT
id AS id_member, SUBSTRING(name, 1, 80) AS member_name,
joined AS date_registered, posts,
IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS id_group,
last_visit AS last_login, SUBSTRING(name, 1, 255) AS real_name,
IFNULL(msg_total, 0) AS instant_messages,
SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS email_address,
SUBSTRING(website, 1, 255) AS website_title,
SUBSTRING(website, 1, 255) AS website_url,
SUBSTRING(location, 1, 255) AS location,
SUBSTRING(icq_number, 1, 255) AS icq, signature,
IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
SUBSTRING(aim_name, 1, 16) AS aim, SUBSTRING(yahoo, 1, 32) AS yim,
SUBSTRING(msnname, 1, 255) AS msn, hide_email AS hide_email,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
IFNULL(email_pm, 0) AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS message_labels, '' AS personal_text,
'' AS time_format, '' AS usertitle, '' AS member_ip, '' AS secret_question,
'' AS secret_answer, '' AS validation_code, '' AS additional_groups,
'' AS smiley_set, '' AS password_salt, '' AS member_ip
FROM `hoi_vara`.ipb_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'
Any ideas? :-\
edit. This works http://www.simplemachines.org/community/index.php?topic=477019.0