I'm migrating from another server. I have all of these options to check for my exported database--which ones should I select?
Structure only Structure and data Data only Export to XML format Add 'drop table' Complete inserts Extended inserts Enclose table and field names with backquotes
As far as i'm aware all you need is 'Structure and Data' and then phpbb_users, topics, categories, forums, posts, and posts_text. You can easily see which tables are used in the mysqldetails file (the variables for table pointers are all set there). I'd suggest you keep the whole copy of data till you're happy with the vanilla setup though. And i'm afraid since it's all heirarchical you cant skip steps. If you start at the top (users) you can stop wherever you like but you cant start lower down otherwise you'll end up with mismapped posts and it'l get confused.
SELECT forum_id,forum_name,forum_desc,forum_order FROM phpbb_forums ORDER BY forum_id ASC INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '1' , 'Where are we riding? / What's going on?', 'Who's riding where and when; General discussions chit chat.', '10' )
ERROR ROW 0 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '4' , 'Memorial Park', 'News and information about the trails at Memorial Park', '10' )
ERROR ROW 1 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '5' , 'Terry Hershey Park (Anthills)', 'News and Information about the trails at Terry Hershey Park', '20' )
ERROR ROW 2 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '6' , 'Cypresswood', 'News and information about the trails at Cypresswood', '30' )
ERROR ROW 3 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '7' , 'Huntsville State Park', 'News and information about Huntsville State Park', '40' )
ERROR ROW 4 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '8' , 'Double Lake Recreation Area', 'News and information about the trails at Double Lake Rec Area', '50' )
ERROR ROW 5 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '9' , 'Jack Brooks Park', 'News and information about the trails at Jack Brooks Park', '60' )
ERROR ROW 6 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '10' , 'Directors', 'A forum for the GHORBA Board of Directors', '10' )
ERROR ROW 7 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '11' , 'Stuff For Sale / WTB', 'Items for sale, exchange or wanted. Not for Commercial Use.', '40' )
ERROR ROW 8 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '12' , 'The Swamp', 'News and information about the trails at the Swamp', '70' )
ERROR ROW 9 INSERT INTO `LUM_Category` ( `phpBBforumid` , `Name` , `Description` , `Order` ) VALUES ( '16' , 'Stephen F Austin State Park', 'News and information about Stephen F Austin State Park', '90' )
What if you try putting those queries directly into phpMyAdmin (or alternative)? I'm assuming in some cases it's due to ' 's and )'s but not all of them...
Hey, where's the latest version of the migrator? I've tried few links, only one worked and I'm not sure if it's the latest one. I'd really like to test it!
Some suggestions I have are to support multiple databases, i.e. if you have phpbb and vanilla on different databases, and to support prefixes for the phpbb table names, i.e. the name "phpbb_users" might be "myforum_users" - the prefix "phpbb_" is variable, and the same across all tables, in phpbb.
Well in the mysqldetails file there are variables which set the phpbb table name references so if you're using a different prefix you've only for 4 lines to edit.
As for supporting multiple databases, yeah, i know. Truth be told when i was writing it i didnt know how to do that since i've never had to before and i didnt bother working it out. I purely made it to do a job which it (usually) does. There are a *lot* of improvements which could be made though. Maybe i'll make it my summer project once i've got my head round OO a bit more. If you want to help (or takeover!) you're very welcome. :)
Ha, yeah I might do some work on it. Here is a code and regexp that I used to get rid of the ugly IDs in phpbb's BBcode. Needs to be applied to the post text.
Even the better bbcode? I assume to use your snippet I insert it as such: $body = mysql_fetch_array(mysql_query("SELECT post_text FROM $phpbb_posts_text WHERE `post_id` = '$phpBBpostid'")); $body = $body['post_text']; $bodyr1 = preg_replace("/\[(\/?)(.*):[\w\d]{10}(.*)\]/U", "[\\1\\2\\3]", $body); $bodyr2 = preg_replace("/\[\/list:.\]/", "[/list]", $bodyr1); $Body = addslashes($bodyr2); ?
so this phpBB migrator, how does it convert to Vanilla's database format? everything? so it converts to Vanilla version what? then how do i update it to the latest Vanilla? say v1? sry but i'm new to vanilla and am excited abt making the transtion.
It converts the users (users), forums (categories), topics (discussions), and posts (comments). That's all (but that's all that's necessary - extracting and migrating useful stuff out of the remaining tables into the remaining tables would need a lot more thought. Roles are not migrated so you'll need to do that yourself i'm afraid (i think, anyway, it's been a long time since i wrote it!)
It will convert to vanilla 0.9.2.6. Then you can run the upgrade script which comes with vanilla 0.9.3 to upgrade it if you so wish.
uh, i thought Vanilla 1 that is available for download is stable? why are you guys still talking abt 0.9.3, etc? sry i read the Documentation but it doesn't help answer this...
The vanilla 1 pre release download which is floating round this board and is a previous revision of the vanilla 0.9.3 available by svn trunk but with a vanilla 1 badge on. Both are beta forms. The pre-release was only made because some people cant work svn and we needed to get 0.9.3 out to a few more people to get more bugs in to fix them. Any version of 0.9.3 from the v1 pre-release onwards is pretty stable but still not quite perfect.
For the sake of it for the time being, consider 0.9.3==v1.
Just one thing I think should be edited. I noticed that in categories.php, the migrator wants to insert data into the 'Order' field in LUM_Category table, however, in the Vanilla 1-pre3 I installed, there is no field called that, there is a 'Priority' though.
I see. The migrator was designed for 0.9.2.6 and hasnt been updated for v1 so I'm actually quite surprised it worked at all (I'm assuming it did?) In which case did swapping order for priority work for you? If so i can do that easily enough - otherwise you'd be best migrating to 0.9.2.6 then upgrading with the script until a decent migration tool is out.
Well, I have to admit I made an error myself first, during the process, so I did a few steps twice. I should do it again with a "clean" vanilla, to see if everything really works if you do things like you're supposed to. But for me everything looks fine.
Okay, well, it does seem to work nicely, except that it gives an error for each category it imports (something about affected row not being a valid source), hmm, I should have written it down. Actually, it looked very much like tsuma's problem (earlier on this page), but the categories imported just fine.
And of course the Order/Priority thing. One thing about the priority though, if you've split your phpBB forum into several category groups, say Serious with the categories Very Serious and Also Serious, and a second group called Silly with the categories Very Silly and Also Silly, the migrator will sort them like this: Very Serious, Very Silly, Also Serious, Also Silly (so it's ignoring the groupings).
Oh, I was thinking you'd actually change the Priority values during the migration. So you'd make a list of all phpbb categories, sorted by group and order, and then number them and put them into the Vanilla table. It's been a while since I did something with PHP, but I could take a look and see if I can come up with something decent.
Hmm. Sorting by group could work actually. Theyre just in whatever order they were created in at the moment i think. The whole system needs a ton of work on it in fairness.
For any new people around, I used the phpBB migrator, and this is what happened: When migrating categories, I got an error for each category, however they were all migrated fine.
Secondly, I noticed all users were admins, so I ran a query on the lussumo user tables, making them normal members. Also, I had some troubles in that my phpBB admin didn't have total administative powers, I'm not really sure what is causing it, and I haven't been able to figure out how to fix it either (the only power I can find lacking is editing the discussion title and category of other people's discussions).
And lastly, phpBB's list syntax is [list][*]item[*]item[/list], but the Better BBCode extension uses [list][li]item[/li][li]item[/li][/list]. This won't be converted by the migrator, so you might want to run an SQL query fixing this (unless you like checking and editing discussions by hand).
That's it really, other than that it worked just fine for me, however, it should be noted that the migrator (while very nice, thanks Mini) is quite basic, and really made for 0.9.x and not v1. So please make backups and look around a bit at your migrated forum before unleashing it on the public.
Hi I have changed the source to allow for the phpbb and the vanilla databases to be different. ie same mysql server, but on different databases, as this was how ours is set up. you can grab it from http://lighternetworks.com/~buf/migrator.zip
hope it helps you, it still spits a few errors, im gonna clean it up if i get around to it, but its working grouse.
In theory yes, but it's not really an addon, and as you may have noticed it's very raw and very basic. I really just made it to do a job for someone months back and it's kinda grown since then. It still has a long way to go really.
Readme is probably a good idea, but it goes somewhat like this: Backup existing phpBB tables, install vanilla into same database, run migration script in the order it's listed (after setting up any config stuff in mysqldetails.php)
Ok migration went without a hitch. It's important to note that your phpbb_categories shouldn't have any ' symbols or the migrator script will error out.
So, I upgraded the 0.9.2.6 install to v1 without an issue or so I thought. I have BetterBBCode and HTMLFormatter extensions installed and I seem to have an issue with my french speaking forum not displaying accent characters. I think that's the correct term. See here..
I'm pretty sure the accent character issue is something to do with the charset of the forum and not the migrator so that doesnt worry me too much. Perhaps someone else can shed some light on it though - it's probably a simple case of changing the headers but i'm not sure. (do new posts with those characters in do the same?)
Those html tags are somewhat strange. I'm not sure if that's some phpBB behaviour - i dont have the code on this pc but i'm 99% sure the migrator doesnt add anything like that and wouldnt do it by accident - which makes me think that perhaps phpBB encloses html formatted posts in those tags? That's a guess though.
Hi there Vanilla-ers, I'm a newbie here and just trying to quickly customize an installation of Vanilla and transfer over all of our sections, posts, members, etc... from phpBB. I had a friend translate this thread for me into laymen’s terms and he stated that it'd be best for me to Install Vanilla 0.9.2.6, then the migrator, then upgrade to version 1 and hope for the best.
And to be honest, my clue as to how to do this is just shy of the slightest. So my questions:
1) Where can I find Vanilla 0.9.2.6? 2) Any directions or prayers for a designer who's programming knowledge involves CSS and dozens of acronyms from other languages? 3) Has anyone tried to do what I think I'm going to try to do, and how'd it go?
We are months and months behind schedule with thousands of dollars blown on an inexperienced developer and lost time and energy that we'll never get to see again. And I have to try and get this installation of Vanilla, along with the rest of our site, live in the next 48 hours so we don't lose the slight remainder of interest we have left for this project. So if anyone has a third arm, or a few moments to spare, any direction or hand-holding assistance would be infinitely appreciated. (You can't get more appreciative than infinite). Thanks.
Hah. I didnt think about the hurdle of finding 0.9.2.6. I know Mark has it online but i dont know if he wants people to know about it. In the meantime I'll let you use this which i believe is a working version. You shouldnt need much or any programming knowledge, installing vanilla is always easy enough (hopefully!), and then you just need to upload the migrator to your server, edit the details (mysql connection etc) in mysqldetails.php, browse to it in a web browser, and then just click the links in order. Then you need to wipe out your vanilla 0926 files, replace them with the v1 files, and run the upgrade script. You should be set to go after that. Davediamond appears to have done roughly what you are and as you can see he didnt have any major problems (just some funkyness with his forum)
Thanks Mini. Sorry for the delayed response, but we are going to give that a try today and see what happens. I'll let you know how it goes, and document the process for anyone else trying to do what I am.
Everything worked like a charm for us Mini. Seemed to freeze a few times with our big database, but in the end it all transferred fine, and with the bbcode extension enabled, all of the imported tags from phpBB converted perfectly. Thanks again.
I'm pretty sure the accent character issue is something to do with the charset of the forum and not the migrator
yes, that's true. i migrated from phpbb to vanilla with 0.9.x, and had no problems, but after upgrading to vanilla 1, all ä, ö, ü and ß turned into ?
Hi, i have not much knowledge of php and sql syntax but i managed to migrate my phpbb sql dump to vanilla v1 on my win xampp testbox. Minisweeper script: getting the users: no problem, 0 errors
import categories: omg that was .... no comment on that but i managed it. It just took me 5 hours to find out that i had to change something in Minisweepers categories.php on line 31. I think somebody changed `phpBBforumid` , `Name` , `Description` , `Order` in vanilla 0.9.x.x to `phpBBforumid` , `Name` , `Description` , `Priority` in vanilla v1. After i changed this finally some values where written in lum_categories. I don´t know if this workaround is acceptable as the script was still spitting errors but it seems to work on my install.
import of discussions and comments: 0 errors
Now i just have got only one problem to solve before i can go live with vanilla v1. It is impossible to edit the imported comments title, i don´t know if it is a bug or if i have to adjust some userrights. I log in with my admin account and all i can edit is the comments text.
i just created a new user, called him newadmin, i logged in as "Admin" and set his role to "Administrator". Logged in as newadmin, wrote a test comment, logged in as Admin and could edit newadmins comment title and text. I also installed the memberlist add-on and realized that every phpbb user is "Administrator" Could somebody give me a line of sql code to alter all users to "member" role but keep user id 1 "Admin" as "Administrator"?
UPDATE `LUM_User` SET `RoleID`='3' WHERE `Name`!='Admin' ok,now i have got one Admin, exactly how it should be. But i still can´t rename imported phpbb comment titles. Just to be sure because i´m still new at vanilla, if i want to alter a comment titel i have to edit the very first post, right?
Yeah. It seems that you can't do it with your imported admin though. I'm not sure why. Someone else reported this... If anyone can work out how i'd be interested.
Can you edit non-imported discussions? i.e. new ones?