Advertisement:

Author Topic: [SMF Converter] IPB 3.0  (Read 104347 times)

Offline Kaelhy

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 3.0
« Reply #40 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:

Code: [Select]
                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.
« Last Edit: April 07, 2011, 10:01:20 PM by Kaelhy »

Offline osamabinmusic

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 3.0
« Reply #41 on: April 19, 2011, 09:11:25 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:

Code: [Select]
                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.

Offline The 12th Doctor

  • Semi-Newbie
  • *
  • Posts: 40
  • Gender: Male
  • Forum Timelord
    • Doctors Companion
Re: [SMF Converter] IPB 3.0
« Reply #42 on: May 10, 2011, 11:44:39 AM »
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

Offline cam177

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 3.0
« Reply #43 on: June 22, 2011, 05:47:14 PM »
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

Offline bros

  • Full Member
  • ***
  • Posts: 644
Re: [SMF Converter] IPB 3.0
« Reply #44 on: June 25, 2011, 12:32:52 AM »
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

Offline DieWacht

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 3.0
« Reply #45 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

Offline VanKlomp

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 3.0
« Reply #46 on: August 25, 2011, 04:46:39 PM »
Doesn't seem to work for IPB 3.2.X

Offline nerix

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 3.0
« Reply #47 on: September 04, 2011, 01:59:37 PM »
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.

Offline HAMBONE0

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] IPB 3.0
« Reply #48 on: October 23, 2011, 01:41:11 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:


Code: [Select]
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!

Offline eddie1973

  • Semi-Newbie
  • *
  • Posts: 23
Re: [SMF Converter] IPB 3.0
« Reply #49 on: January 13, 2012, 01:56:36 PM »
I get this error. IPB 3.2

Code: [Select]
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'

Offline phantomm

  • Sophist Member
  • *****
  • Posts: 1,063
  • Gender: Male
    • pages/smfpl/171860759503032 on Facebook
    • Polish ElkArte community
Re: [SMF Converter] IPB 3.0
« Reply #50 on: January 25, 2012, 09:36:33 AM »
Anyone knows how to fix this converter for IPB 3.2?
Polskie wsparcie SMF na simplemachines.org

My mods

Offline Sefket

  • Jr. Member
  • **
  • Posts: 223
Re: [SMF Converter] IPB 3.0
« Reply #51 on: May 05, 2012, 11:38:31 AM »
This is for IPB 3.0.

3.2 is a different version.

Offline z_0

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 3.0
« Reply #52 on: May 13, 2012, 03:19:40 PM »
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.

Offline fhsds

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 3.0
« Reply #53 on: May 17, 2012, 03:58:06 AM »
does not work your converter

Offline x1337

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 3.0
« Reply #54 on: May 26, 2014, 01:20:31 AM »
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'

Offline maav

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 3.0
« Reply #55 on: August 06, 2014, 04:06:49 PM »
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

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] IPB 3.0
« Reply #56 on: August 06, 2014, 04:18:44 PM »
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

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

Offline maav

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 3.0
« Reply #57 on: August 07, 2014, 07:03:56 AM »
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

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] IPB 3.0
« Reply #58 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?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

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

Offline maav

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] IPB 3.0
« Reply #59 on: August 07, 2014, 08:10:44 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