PHPBB2 to E107 Conversion script with BBCode

After a fair amount of testing (thanks Rashan) the updated PHPBB2 to E107 conversion script is now available for others to test/use - 2dopey has kindly agreed to host it here: [-link-]

It includes the mods made to the 'distribution' converter in CVS, plus some other tweaks and, most important for some users, bbcodes can now be allowed through, reformatted and even changed.
Most of it is table driven, so should be reasonably easy to adjust to specifc requirements.

Comments good and bad please - either here or by pm to me.

erm ok!

well it didnt work completely im afraid to say

heres what it did do, the script ran but timed out.

it copied the users, and the forum headings, but alas not threads/posts.

one added thing it did do was add the phpbb admins. so thats one more step towards completion

if you want to have a good look please email me and ill show you the site/mysql etc

If you have a large database, you might need to increase the maximum script execution time beyond the typical defaults of 30-60 seconds.

sorry to sound stupid but where can i change that? the script runs on my pc browser for about 5-10 mins,

my database is roughly 45-50mb in size.

when the script is running i have checked its progress in phpadmin and it pretty much instantly copies the users and forum structure, then spends about 3-5 minutes seemingly doing nothing as it doesnt copy any posts.

is there anything else you would like me to test?

Regards

[edit]

also, i have run the script again, it timed out below you can see the time running (453) and the state (copying to tmp table) strangely there is also another (locked) process below it seemingly doing nothing.

i personally dont know much about this stuff, but maybe it will shed more light on the problem

85587 grimire localhost grimire_phpbb1 Query 453 Copying to tmp table SELECT * FROM phpbb_topics\nLEFT JOIN phpbb_posts_text ON (phpbb_topics.topic_title = phpbb_posts_tex

85857 grimire localhost grimire_phpbb1 Sleep 273 NULL

85858 grimire localhost grimire_phpbb1 Query 273 Locked SELECT * FROM phpbb_topics\nLEFT JOIN phpbb_posts_text ON (phpbb_topics.topic_title = phpbb_posts_tex

You'd normally get an error message if script execution timed out, I think. But its probably set in php.ini - worth checking.
It might be an obvious question (so obvious its not in the docs) but had you installed the forum plugin before running the script?

ill get onto my provider asap.



why yes, yes i had installed it prior to the script, should i have not?

You should have had the forums installed, so that's fine. It just never occurred to me that someone wouldn't.
I'll try and digest this lot properly, but might not be for a day or two.

no rush there fella, ill change the timeout and see how i get along with that.

hello there steved.

ok i have asked my provider, but he is unwilling to change the vars in php.ini as its a shared server.

he has offered shell access but im at a bit of a loss as to what i could do with that.

any advice would be greatly appreciated.

I am interested in importing phpBB users - the posts and PMs can stay.

Has anyone ever done this? I'm also on a shared server, and the execution time is not something I will be able to access.

Wouldn't expect any problem with users - that's a relatively quick part of the script (and, I think, the bit that seems to work for everyone)

the users part of it works 100% perfectly and would highly recommend it.

Joe, I hope to have a look at this over the weekend - please PM any info that shouldn't appear in the forum. And if you're giving me the opportunity to break things, please back up!

If its not too big, a copy of your phpbb database might be a good start, then I can play off-line.

Hmm...all I get is this message:
Attempting to connect to phpBB database [ Phpbb2 @ localhost ] ...
Successfully connected to phpBB and e107 databases ...

Nothing else happens - any idea?

Jesper L - you followed the instructions OK about logging in as admin? And you've installed the forum plugin?
And you realised there are two files now? phpbb2_new.php, and import_mapper.php?

Do I have to use the import_mapper as well?

upload mapper to the same folder as the import script

what info would you like steved?

Hehe..forgot that one.

Worked now - thanks

Sorry Joe, missed your post.

Depends a bit what you're willing to do.

If your phpbb database is small enough for me to have a copy , probably first move is for me to try and run that on my own PC to see whether I can replicate the problem.

Otherwise any debugging would have to be done on your actual site (or a test site), for which I'd need an admin access to E107 plus FTP access to the E107 directories and the access information for the phpbb database.

Incidentally, have you tried a different browser in case that's the problem?