[SMF Converter] IPB 2.1.x

Started by JayBachatero, February 10, 2007, 02:03:49 PM

Previous topic - Next topic

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

GDVS

Give or take a few minor bobbles I managed to convert an IPB 2.1.7 database to SMF 1.1.5 using the SQL file  in the post above, however I'm finding a lot of
Quote[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
in the posts.
As far as I can tell it's everywhere someone has just done what I did here, quote something random from off site using just
Quotestuff
without the quote=someone.  Any ideas?

GDVS

To answer my own question, I ran the following SQL query on the database and while the result is still not 100% it's only a few very complex (nested lists and font changes) posts that have issues.

UPDATE smf_messages SET body = replace(body, "[!--quoteo--][div class=\\'quotetop\\']QUOTE[/div][div class=\\'quotemain\\'][!--quotec--]", "[quote]");

DistantJ

#123
Doesn't wanna work AT ALL for me :( I feel about ready to explode.

The database for the IPB forum is on a different server, something I don't have access to, so I backed up the database and then imported it into the PHPMyAdmin for my SMF forum which I want to move the posts to and then tried to run the attached sql file by copy pasting the information in it into a query.

But all it wants to say is:

Error

SQL query:

/* ATTENTION: You don't need to run or use this file! The convert.php script does everything for you! *//******************************************************************************/ ---~ name : "Invision Power Board 2.1"/******************************************************************************/ ---~ version : "SMF 1.1 RC3" ---~ settings : "/conf_global.php" ---~ globals : INFO ---~ from_prefix : "`$INFO[sql_database]`.$INFO[sql_tbl_prefix]" ---~ table_test : "{$from_prefix}members"/******************************************************************************/ - -- Converting members...
/******************************************************************************/ TRUNCATE {$to_prefix}members;

MySQL said: Documentation
#1064 - 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 '---~ name: "Invision Power Board 2.1"

---~ version: "SMF 1.1 RC3"
---~ setti' at line 1


I'm trying to convert IPB 2.1.4 to SMF 1.1.5

ThorstenE

QuoteYou don't need to run or use this file!
you need the convert.php from this topic.. upload it to SMF directory (and also the invision21_to_smf.sql).. then start convert.php with a browser..

Our docs should also help: Converting to SMF



DistantJ

That method won't work, I tried, because the two SQL databases are on different servers.

ThorstenE

All our converters here will only work with the database on the same server..  The only way would be making a dump of the database and import into SMF's database..

DistantJ

That's what I did. I stated that in my post. I created a backup of the IPB database and imported it into the SMF one, but the convert.php won't do it since the IPB install points to a database on a different server to the actual forum, so I tried running the .sql file as a query and that didn't work.

SleePy

Change the config.php then So it knows which database to use

The converter will not alter any of the IPB data. It will only be looking at it during the conversion.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

DistantJ

#129
How would I do this?

The error I get, by the way, is:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.1. 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 'ukpcoforum'@'213.171.218.168' for table 'ibf_members'

DistantJ

Well, I'm going to attempt to move the IPB database to the same server first... Wish me luck.

DistantJ

Well, that method is working, but it comes across an error when converting Permissions (that's fine, I can do that manually), and the Boards don't seem to appear. It successfully converts the boards according to the converter, but when I load up the page there are no boards there at all.

ThorstenE

can you restart conversion and post the error message?

DistantJ

Converting permissions... Unsuccessful!
This query:

    INSERT INTO `ukpcoforum`.smf_membergroups
    (ID_GROUP, groupName, maxMessages, onlineColor, stars)
    VALUES
    (6 + 3, SUBSTRING('Administrators', 1, 255), 50, '', '');

Caused the error:

    Duplicate entry '9' for key 1

ThorstenE

please try the attached version..

DistantJ

#135
Still says the same...

I'm more concerned about the fact that the boards and posts don't appear.

ThorstenE

#136
ok, give this one a try..

(Edit: wrong version attached, updated)

DistantJ

Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in /home/fhlinux168/u/ukpcoforum.co.uk/user/htdocs/smf/convert.php(911) : eval()'d code:41) in /home/fhlinux168/u/ukpcoforum.co.uk/user/htdocs/smf/convert.php(914) : eval()'d code on line 61



Boards and posts still won't show up either.

DistantJ

As for the boards/posts not appearing, in smf_boards, it looks like it has gotten ID_CAT and ID_PARENT confused with each other. I manually switched the values around in each board and now they appear along with the posts!

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: