• Welcome to Simple Machines Community Forum. Please login or sign up.

from phpbb2 +category hierarchy TO SMF 1.1 RC3 until 1.1.10

Started by romaruss, October 06, 2006, 01:58:24 PM

Previous topic - Next topic

romaruss


GravuTrad

March 09, 2007, 05:35:56 PM #41 Last Edit: March 09, 2007, 05:41:34 PM by GravuTrad
Hi oldies.

Could it be possible to update the converter for phpbb 2.0.22 with category hierarchy 2.1.6d please? (that's the last stable version available...)

you can find a preinstalled version here to test:

http://ptifo.clanmckeen.com/download/cat-categories_hierarchy_v2.1.6/cat-_installation/mod-CH_216_installed.zip

it will be a great thing for me, thanks for advance if you can...
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Oldiesmann

Sure, I can update it for you. Can you send me a database dump?
Michael Eshom
Cincy Space - now open!

GravuTrad

On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

GravuTrad

hi oldiesmann. ;)

could we look this together please? to can update your converter script for this version?

Big thanks

GravuTrad
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

UncleChewie

May 09, 2007, 08:24:09 AM #45 Last Edit: May 09, 2007, 08:35:28 AM by UncleChewie
Quote from: Oldiesmann on October 18, 2006, 11:50:52 AM
Try this one. I fixed the "f.auth_read" issue, and I think I've fixed the other one as well, although I'm not sure.

I'm running phpbb 2.0.21 with categories hierarchy 2.1.6   I installed smf 1.1.2 and tried running the converter from the quoted post.  This resulted in a quite a lengthy list of errors (attached).  The end result was no transfer of any information.  Any advice would be greatly appreciated!  Thank you.

GravuTrad

On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

UncleChewie

I don't understand, I'm trying to upgrade my forums to SMF...

GravuTrad

yes, but last version of phpbb premodded ch is phpbb 2.0.22 with ch 2.1.6d, not 2.0.21....

it will be better to oldiesmann to work on the last version...
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Oldiesmann

That's not going to make any difference GravuTrad - there were no database changes from 2.0.21 to 2.0.22 (or at least nothing significant enough that it would break the converter).

Let me go download the latest version of that hack and see what I can come up with.
Michael Eshom
Cincy Space - now open!

Oldiesmann

May 11, 2007, 05:16:53 PM #50 Last Edit: May 15, 2007, 10:29:33 AM by Oldiesmann
Can you try this one to see if it works at all?

This was the most recent version of the converter, except I changed something that (I think) will make the part that updates ID_PARENT, ID_CAT, etc. work properly.

As far as I can tell, the structure and setup of the "forums" table in phpBB hasn't changed at all in this version of the categories hierarchy mod.

EDIT: Keep reading for the current version of this converter...
Michael Eshom
Cincy Space - now open!

GravuTrad

QuoteConverting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards (part 1)... Successful.
Converting boards (part 2)... Successful.
Fixing IDs... Unsuccessful!
This query:

    UPDATE `testsmf`.smf_boards
    SET ID_PARENT = 7, ID_CAT = 22, childLevel = 1
    WHERE ID_BOARD =;

Caused the error:

    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
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Oldiesmann

Michael Eshom
Cincy Space - now open!

GravuTrad

May 11, 2007, 07:58:20 PM #53 Last Edit: May 11, 2007, 08:03:48 PM by GravuTrad
seems to be good, only some permissions sections are not well ok (not well configured, some sections are seen instead of they were not to be seen by certains groups and the inverse, maybe it's adjustable in your script? i don't know...) but if we reconfiguring it, it will be ok.

you can retire the term "older" of your version script lol....
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

UncleChewie

May 12, 2007, 01:29:54 AM #54 Last Edit: May 12, 2007, 09:33:19 AM by UncleChewie
Quote from: Oldiesmann on May 11, 2007, 07:19:23 PM
Try this.

Yay!  Appears to have worked perfectly!  My hero!

Hmm, one question though.  Does my forums database now require BOTH the SMF tables AND the phpbb tables, or can I safely delete one set or the other?

marcozambi

Quote from: Oldiesmann on May 11, 2007, 07:19:23 PM
Try this.
Worked just WONDERFUL!

Everything seems perfect to me with just one exception: Attachments.

My PhpBB + CH 2.1.6d has Attachments Mod installed (the one adapted by ptirhiik for using on CH mod - Link here http://ptifo.clanmckeen.com/download.php?pack=6 ), the conversion programs says it's all ok, Attachments have been ported, but checking in the posts or in Administrative interface, I have NO attachments transferred to my SMF board.

Can you help me to adapt your script to manage Attach mod for CH?
Have I miss to do something in my conversion?

Oldiesmann

I will look at it in a bit and see what I can find. That converter is based on the one for SMF 1.1 RC3, so I will compare it with the current phpBB converter and see what I can find. I'll also modify the current phpBB converter to include the changes in this one and add it to the downloads page so other people can find it easier. Glad to know it worked properly though :)
Michael Eshom
Cincy Space - now open!

marcozambi

Quote from: Oldiesmann on May 15, 2007, 10:28:31 AM
I will look at it in a bit and see what I can find. That converter is based on the one for SMF 1.1 RC3, so I will compare it with the current phpBB converter and see what I can find. I'll also modify the current phpBB converter to include the changes in this one and add it to the downloads page so other people can find it easier. Glad to know it worked properly though :)
While waiting for replies, I tried to work out with something by myself.
I have no experience with SMF (I am currently using a heavily modded phpbb+CH2.1.6d on my board, but I'm writing here 'cause I WILL pass to SMF), but I tried to understand how the conversion script works.
So I opened yours and tried to modify.
I succeeded to transfer attachments but I have no idea on how create thumbnails of attached images (I NEED to do this).

Anyway, here's the code. Please feel free to comment and/or delete :D
/* MARCO */

$result = convert_query("
SHOW TABLES FROM " . preg_replace('~`\..*$~', '', $from_prefix) . "`
LIKE '%_att_%'");
list ($tableExists) = mysql_fetch_row($result);
mysql_free_result($result);

// Doesn't exist?
if (!$tableExists)
return;


if (!isset($ID_ATTACH))
{
$result = convert_query("
SELECT MAX(ID_ATTACH) + 1
FROM {$to_prefix}attachments");
list ($ID_ATTACH) = mysql_fetch_row($result);
mysql_free_result($result);

$result = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1");
list ($attachmentUploadDir) = mysql_fetch_row($result);
mysql_free_result($result);

// Get the original path... we'll copy it over for them!
$result = convert_query("
SELECT config_value
FROM {$from_prefix}att_config
WHERE config_name = 'upload_dir'
LIMIT 1");
list ($oldAttachmentDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (substr($oldAttachmentDir, 0, 2) == '..')
$oldAttachmentDir = $_POST['path_from'] . '/' . $oldAttachmentDir;
elseif (substr($oldAttachmentDir, 0, 1) != '/')
$oldAttachmentDir = $_POST['path_from'] . '/' . $oldAttachmentDir;
if (empty($oldAttachmentDir) || !file_exists($oldAttachmentDir))
$oldAttachmentDir = $_POST['path_from'] . '/files';
}

if (empty($ID_ATTACH))
$ID_ATTACH = 1;

while (true)
{
pastTime($substep);


There is only one thing left: in phpbb it is possible to comment any attachments using a specific field in db table. I use it to enter Copyright notices. I have no idea how to migrate that infos.

Any ideas?

GravuTrad

May 20, 2007, 09:00:43 PM #58 Last Edit: May 20, 2007, 09:02:24 PM by GravuTrad
i didn't see this, well saw marco, i will test too...

if you need something like structure export of a forum up to date in production oldiesmann, tell me. ;)
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

GravuTrad

to all people, well look for images to your ftp between the two after conversion, to keep well all the images, like smilies, avatars etc...
On a toujours besoin d'un plus petit que soi! (Petit!Petit!)


Think about Search function before posting.
Pensez à la fonction Recherche avant de poster.

Advertisement: