Convert phpBB to phorum

Yes, lots and lots! For three reasons:
I don't know the Phorum 3 schema;
I'm fixing the things that break;
I'm not very good at PHP but I'm finding this code very readble, except for the sql! ;-)

I've added a
"WHERE forum_id = $forumdata['forum_id']"
and things seem to be progressing better - it's very slow!

phpbb also has a phpbb_topics relation (in fact I think it's in general more relational than Phorum but seeing as MySQL doesn't really do the relational...) but this only has topic titles. I'll have to see what the results are before I decide whether to include this.

Have to see how things progress tomorrow and will keep you posted.

Charlie




Edited 1 time(s). Last edit at 12/13/2004 05:18PM by charlie.clark.

charlie.clark Wrote:
-------------------------------------------------------
> phpbb also has a phpbb_topics relation (in fact I
> think it's in general more relational than Phorum
> but seeing as MySQL doesn't really do the
> relational...) but this only has topic titles.

What do you mean? Mysql is as relational as any other DB. There are some other things missing, but not relation...

And doesn't phpbb run on mysql too?

But anyway, your work is still appreciated :)

---
-=[ Panu ]=-

phorum5's DB is not as normalized as possible. but thats just for performance. joins aren't as fast as a select from the same table ;).

charlie, I would be very interested in the results.
not sure why it should be that slow though.
I could take a deeper look if I could get a phpbb-database full of data and an explanation of what each data there means.

---

Thomas Seifert

ts77 Wrote:
-------------------------------------------------------
> phorum5's DB is not as normalized as possible. but
> thats just for performance. joins aren't as fast
> as a select from the same table ;).

I knew I shouldn't have mentioned this... Joins are unbearably slow with MySQL MyASM tables because they are basically not relational which is why FOREIGN KEYS are only supported syntactically. I don't want to flame about this so for more on this topic see www.dbdebunk.com

> charlie, I would be very interested in the
> results.
> not sure why it should be that slow though.
> I could take a deeper look if I could get a
> phpbb-database full of data and an explanation of
> what each data there means.

It is very slow because of having to iterate through all messages of a specific forum. I left it processing overnight and checked the results and they were little different from what I get with INSERT INTO ... SELECT so I'm rewriting that part of the import to work directly in the database.

I can make the phpbb schema available - it's not well-documented either - and possibly even a database extract later.

Charlie

My latest efforts.

So, the latest version bypasses phorum functions for updating forum stats and post info.

The forums and messages are now imported generating usable information with just a few errors. For some reason date information is being ignored while time information is being preserved.

eg.
"December , 2004 02:13PM"

meta information is being generated manually and is nearly correct. I'd appreciate someone checking the code for this. If I understand things correctly, meta is only required for the first post in a thread.

who knows, how to do it backwards, from Phorum to phpBB?.. thank you!

you should ask this in the phpbb-forums.

---

Thomas Seifert

Awesome, thank you very much for posting this!!!

Going to try on Phorum 5.2 and PHP 5.3 from a phpBB 3.0 install

___
Skye Nott
Corvus Digital

Quote
Jens
I'd need to convert my bloated phpBB forums to phorum.
I haven't found these on the web, so I thought it could be useful. Especially for me :-)

I did this years ago and posted the manual here, but I can't promise it will work with phorum 5.2. Your easy shortcut would be to install phorum 5.1, follow my instructions, then upgrade to phorum 5.2 taking advantage of its conversion scripts.