• Welcome to Simple Machines Community Forum. Please login or sign up.
October 17, 2021, 08:29:38 AM

News:

Check out the SMF Function DB!


[SMF Converter] IPB 3.0

Started by Nibogo, October 13, 2010, 07:32:18 PM

Previous topic - Next topic

Kaelhy

April 07, 2011, 07:19:30 PM #40 Last Edit: April 07, 2011, 10:01:20 PM by Kaelhy
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.

osamabinmusic

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.

The 12th Doctor

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>
The Doctors Companion - http://www.doctorscompanion.net

cam177

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

bros

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

DieWacht

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

VanKlomp

Doesn't seem to work for IPB 3.2.X

nerix

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.

HAMBONE0

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!

eddie1973

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'

Adrek

Anyone knows how to fix this converter for IPB 3.2?
Polskie wsparcie SMF na simplemachines.org

the simplest solution is most likely the right one

Sefket

This is for IPB 3.0.

3.2 is a different version.

z_0

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.

fhsds

does not work your converter

x1337

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'

maav

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

margarett

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
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

maav

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

margarett

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?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

maav

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

Advertisement: