News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

[SMF Converter] IPB 2.2.x

Started by JayBachatero, January 24, 2007, 07:30:01 PM

Previous topic - Next topic

ThorstenE

use the ipb22_to _smf.sql from the first post of this topic (attached) and the convert.php from the first post of this (attached, scroll down)

rsk

Hi,

I have been attempting to convert a  fairly large forum, but kept having issues with duplicate keys when converting the members.

I finally had some time to take a proper look today, and running the sql  below before running the script seems to have sorted it.
ALTER TABLE {$invision_prefix}_members ORDER BY id ASC

I don't know if this is a common problem with conversions or not as I guess we are going the other way to a lot of people who have this much data to deal with, but I thought I'd leave a quick note here incase others are having a similar problem.

SleePy

Thanks for the information.

Just want to ask. Where you by chance clicking the continue button?
I have seen duplicate errors happen when people click the continue button even though the auto-continue has already reached zero. Which results in a double submission.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

scimmiotto

nothing to add to help/request here. I just only wanted to say tnx to sleepy for support, now my board is fully operative and working from ipb 2.2.1.

http://laforgia.nsn3.net

Tnx a lot sleepy, SMF simply rocks, it is speedy and highly configurable, another world compared to ipb, tnx a lot :)

p.s. only one question...when 2.0 will be released, i'll be able to upgrade from my actual 1.1.6 to 2.0?
Loop code example:
The following statement is FALSE
The previous statement is TRUE.

SleePy

Well 2.0 is released as beta :P (Currently 2.0 Beta 4 Public)

But yes, you can upgrade to 2.0 by using the Large upgrade package.
Our Doc site has more information about upgrading SMF though :)
http://docs.simplemachines.org/index.php?board=3.0
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

rsk

Quote from: SleePy on September 19, 2008, 01:53:41 AM
Just want to ask. Where you by chance clicking the continue button?

No, it was being run in a shell, 2.3millions posts to convert, takes an hour in a shell, hate to think how long it would take with the delays using the HTTP method

collst

I convert 2.2.2 IPB to SMF 1.1.7
Using files http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-7_invision22_converter.zip

1. Instead of tags i've got
[img]hxxp:s58.radikal.ru/i159/0811/49/1ef1b4d32785.jpg%5C [nonactive]" border=\"0\" class=\"linked-image\" /]

2. When I trying to "fiand and fix all errors" in admin panel - i lost all users - they transformes to guests

ThorstenE

Any errors during the conversion (please post them here) or was it successful?

collst

Quote from: TE on January 08, 2009, 02:26:18 PM
Any errors during the conversion (please post them here) or was it successful?
there were no any errors during to conversions

SleePy

Can you give us the raw data of such a post from IPB?
To do this you need the message id of the post (For IPB I would have to look this up, but usually its sent to output somewhere on the page). Then just load up phpMyAdmin to find the message.

This way I have the contents of how they are stored in the IPB database before SMF, IPB or the converter is getting to play with it :D
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

88pathoffroad

Hi all. I'm in the midst of trying to export a large IPB 2.2 DB (280 MB) from one server/domain and get it imported on a different server/domain. Problem is, I can't import a DB over 50 MB or so via phpMyAdmin and I'm honestly not all that well versed on SQL to begin with.

I have a copy of the DB in question on my local computer and on the destination server. I uploaded it via FTP to the base directory that SMF is running in.

When I run the converter it just gives me "Unable to find the settings for Invision Power Board 2.2. Please double check the path and try again." Both paths are the same because that's where I uploaded the DB. Can someone straighten me out? Thanks for your time.

88pathoffroad

#191
Well, this is different. I attempted it again using the same exact parameters and got this:

QuoteERRORS

Ouch.

I checked the SMF install, nothing changed. No users, no posts, etc.

ThorstenE

this means the session was broken during conversion. try to restart the conversion from the beginning...

88pathoffroad

#193
Tried: same result. Over and over.

Also tried creating a conf_global.php file with the appropriate data as suggested in the main forum. That gave me an error because the current user wasn't allowed access to the IPB DB.

QuoteNotice: Use of undefined constant sql_database - assumed 'sql_database' in /home/damaged/public_html/nporabeta/conf_global.php on line 2

Notice: Use of undefined constant sql_tbl_prefix - assumed 'sql_tbl_prefix' in /home/damaged/public_html/nporabeta/conf_global.php on line 3

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.2. 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 'damaged'@'localhost' for table 'ibf_members'


I then set permissions for the IPB DB to 777...still doesn't work. What am I missing here?

ThorstenE

the mysql user from SMF (specified in Settings.php) must be allowed to read the IPB database or the converter won't work..

Common conversion errors.

Luigibnu

Quote from: collst on January 08, 2009, 02:12:49 PM
1. Instead of tags i've got
[img]hxxp:s58.radikal.ru/i159/0811/49/1ef1b4d32785.jpg%5C [nonactive]" border=\"0\" class=\"linked-image\" /]

I'm getting the same error, and no error on the convertion!

SleePy

IPB only started using that sort of html in version 2.3. You are using the wrong version of the converter.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

knightofdoom

I had the same problem.. but now its resolved
thx
SMF FTW
Glory is fleeting, but obscurity is forever.
Web Designer Sri Lanka

aradzish

Dear members,

I'm trying to migrate from IPB 2.2.1 to SMF 2.0.1. Conversion of my existing IPB database gives error:

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

I tried all existing converters (all versions). I also tried some suggestions that I could found in different topics, for example, tried to add this code

---{
/* Fix for invalid birthdays */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
   $row['birthdate'] = '0001-01-01';
---}

just after this:

---* {$to_prefix}members

However, no luck at all so far.
My forum is in CP1251.
Is there any chance that someone can try to convert the database for me? I can provide full DB dump.
I count on your kind help.



paddysmith

I Updated!!!



Thanks to sharing........







Advertisement: