Ooooh, am I looking forward to the release of this. I set up phpBB a long time ago for a client and have been jonesing to replace it with something better for quite some time now.
heh I started working on something like this last night, and now I find that some ppl already started it.
Mine is very specific though, as I just want to transfer topics and posts - already got the users and categories in, just have a little array that maps the userIDs and categoryIDs correctly.
Last night I got as far as creating all the discussions - they had 0 posts, but at least the topics were there in the right categories, but not showing up in the right order.
I saw some discussion earlier in this thread about passwords, not sure if that got resolved but I just copied over the encrypted passwords in the vanilla database and it works :)
yeah patrix - thats cause vanilla used to use mysql's password function till mark realised it wasnt designed for passwords - now it uses the same as phpBB (md5)
My migrator does all the data sets seperately so you could use it to transfer only the discussions and comments if you wanted to. You would have to use a link between the users though, so its probably easier to just do it your own way.
>epohs - if i still have the file you're more than welcome to a copy of it but depending how desperate you are its probably worth waiting for mark to release.
Oops, sorry minisweeper I didn't see this. I think I'll just wait until this becomes an extension. Thanks for the offer though.
Ugh I just converted my board from Invision to phpBB a few months ago. Now this comes up and I'm already cheating on phpBB. Vanilla is awesome. Anyway, I had password problems before too. I think it's best to leave it off. Generate random passwords for people to retrieve or reset by email. I can't wait till the convertor really works. I would help except that I'm crap at programming.
Here's my rudimentary use-at-your-own-risks converter!
convert.php: It only converts discussions, not categories or users. Notice there's 2 little arrays at the beginning that map the phpbb users to lum users. Lame, bad programming practice, whatever. Only 8 users and 4 categories means it wasn't bad for me lol.
fix_discussions.php: I wrote as an afterthought cuz I noticed the FirstCommentID in the discussions wasn't being set properly so atom feeds and a bunch of other things didn't work right.
Me and Chris seem to have ironed out the problems he had and i've picked up a bit of stuff that needs sorting in the code. If anyone else [jerm] is using it in the meantime just give me a shout and i'll tell you what needs doing.
um. thats an interesting question actually, my servers down for the moment while we get it production ready. You could ask Chris or Jerm to mail you it if they can do that before i get home on monday and can mail you a copy myself. If chris sends you his version it should work fine, jerms might need a bit of fixing - it ran fine on my copy of the database but it appears that user_total_logon isnt a default install column of the user table and therefore it was causing errors. If your install doesnt have this you'll probably need to remove all references to it in the script and then it should work fine.
In any case, try running the copy one of these guys has if you can get it before monday; otherwise i'll mail you an updated copy myself.
There isnt a readme at the moment because its extremely beta untill mark can be bothered fixing it... If you're having problems just post them here (whisper them to me if you like) and i'm happy to talk you through it. Basically it goes like this: Put the right details in the mysqldetails.php file so it can connect to your database Upload all php files to a directory on your server and browse to that over http. index.php should be the page you see - click each of the links in turn (Users, Categories, Discussions, Comments) Stuff should now be transferred. As i say if somethings going wrong just post it up here and i'll help you out.
Sorry for not reporting back for a long time, I've been swamped. I couldn't get the users to convert then I came here a few days ago and grabbed the updated migrator.zip and it worked!! I converted http://jermexpress.com/bb/ offline and everything converted except these few problems:
1. I had 7 forums (categories) and one of them didn't convert, instead it was replaced by "General" which came with Vanilla installation.
2. Discussions were all converted except for the tags within the discussions, so although you get every single text some of them may look jumbled.
Everything else seems fine (I don't care about converting PMs and such) but for those two issues up there I decided to wait a little before converting my bb for online production.
Ahh, i wondered where you'd got to! 1, interesting, did the contents of the category migrate and its name just got replaced? I dont see any reason as such why it should do this, i'd expect it just to make 8 categories with the last 7 being yours. Did you have any similar problems Chris?
2, Yeah, any formatting within the discussions would be ignored because there's nothing in the script to work out what format they are and treat them properly; this is something that needs thinking about.
[3,] I would like to be able to convert pm's -> whispers at some point. Perhaps i'll look into it a little more when i get round to writing another converter.
[1] I don't actually know :). I chose to only import the posts and not the categories (as I was putting all discussions under an archive category), so I'm not sure whether it works correctly or not. But I don't see any reason for it to not work as all other categories were imported for you.
[2] This is a problem I've faced too, and haven't done anything about. There's a lot of jumbled up crap if your post contains BBCodes, something for now, you'll have to live with.
Out of interest, has anyone used the bbcode converter? In which case does it store the comments in the database in bbcode or html or what? If it stores them in bbcode and interprets them on the output (which i highly doubt) just installing that should fix it.
Otherwise i'll probably have to build the bbcode thing into the migrator. Hum.
i dont think he's got round to making a list yet. I imagine he will if he implements the phone-home type technology but otherwise you could always start one on the wiki?
Only on the basis that as far as i know its the only script, mine is probably best. You can grab it from http://gez.int0rw3b.com/migrator.zip upload it to any dir on your server and browse to it. Run through the scripts in order just by clicking the links. Its not fancy and is very raw, but it does the job. Hopefully one day someone with a bit of design skill *glances at mark* will take it and either rewrite it or atleast make it friendlier.
In any case it should work fine as far as data transfer goes. Let me know if you have any problems (or even if you dont!)
minisweeper which version of your phpbb? I try to use your migrator but failed. First it said i don't have "totallogin" column in "phpbb_users" table, so I changed that to a fixed number "0" . Scond it did convert the discusses topics, but not the text .
thats interesting, i based it on the database that i was given by someone on here since i dont use phpBB myself. I think they're similar errors to those that either Chris or Jerms. I assume you ran the 'comments' migration script? If so did it bring up any errors?
Can you grab the new version from my site and run through it, i've just changed it so it doesnt go straight back to the index so we can see all the errors it produces. Clear your database and run through it again and see if it brings anything up.
here is the same err msg when I run "users" for the first time: -------- Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wanpeng/public_html/vanilla/migrator/migrator/users.php on line 20
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wanpeng/public_html/vanilla/migrator/migrator/users.php on line 21 ----------------- so i did the changes: #20 delete "totallogin" from the SQL query #32 $CountVisit = 0;
yeah, i think thats pretty much the same changes i made for chris. Perhaps i should make them permanant, i wonder why theyre not there anymore (or wernt origionally, whichever) and whats replaced them.
Brand new to Vanilla but I must say it is looking very nice.
Using the above method to migrate from phpbb gives me an error message every time...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/os42shad/public_html/shadows/ph4rum/migrator/users.php on line 20
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/os42shad/public_html/shadows/ph4rum/migrator/users.php on line 21
So, I tried to fix it following wanpeng's suggestion, but I am either doing this incorrectly or it just isn't working for some reason.
Does anyone have any advice as to how I might be able to fix this?
Since everyone seems to be having the problem its probably best if i just change the script. If anyone knows how phpBB now handles counting the number of visits i'd like to hear it. Grab the latest version from my site and try that, Shadow,
yeah, bbscript conversion is something that needs adding. I've been meaning to do it but i'm very lazy. When i do i'll work in the option to move all data into 1 category too.
it doesnt get affected as such, it just doesnt get formatted. The bbcode extension doesnt help because that formats the text on its way into the database not on its way out. Basically i just need to apply that extension mid-migration. Which wont take very long but i keep getting sidetracked. What does confuse me a little is why the data is stored into phpBB's database in bbcode not html. That means that phpBB would have to format every page - surely this is a significant performance hit?
ok i finally got round to giving this migration a go and unfortunately i can't get it to work.
i get the same errors as previously mentioned by others:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\vanilla\migrator\users.php on line 20 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\vanilla\migrator\users.php on line 21
i've tried the fixes wanpeng posted and they made no difference :-( one question i did have as well was in which folder should i have my phpbb db when carrying out the migration?
folder? Your phpbb tables should be in the same database as the one you wish your lum tables to be in. It wont work just using the .sql file if thats what you're talking about.
Are you using the latest version from my site here? http://gez.int0rw3b.com/migrator.zip I'm 99% certain that should fix all total logon / mysql_num_rows related issues.
Otherwise hook me up with all the information you can get about the problem to gerrard@ifa-ltd.co.uk or on here
ok i've got to be up early tomorrow so i wont look at vanilla again til after work tomorrow. so if you could post any info that may help me out to paulsturgess@gmail.com that would be fantastic!
i've justed twigged that i probably need to export the db in phpmyadmin, is that right?
Yeah, though technically youre importing - but thats besides the point. Whether you can do it in phpmyadmin might depend on the size of the .sql file - in any case you will need to reconstruct the tableset in your new database where you wish your vanilla forum to operate from - given that, the migrator should run fine.