Yes, i can edit new comments. I asked a friend to register an account. I could edit his comment and also the title of that comment. This might be really a bug, its ok for me because 99% of all imported phpbb titels are fine, i have got only some weird encoding bugs but i can´t tell you why, I´m a htlm/php/sql amateur.

Um. I'm not sure. It might actually work. BACKUP YOUR DATABASE and try it? You might need to apply the fixes some people have talked about in this thread to migrate to v1 though. And i wouldnt suggest it if you're not willing to get your hands a bit dirty.

well, from what i read, people are installing vanilla < 1.0, and running the converter. would i have to downgrade my version to do it?

Ok. Well, I couldn't get it to work with 1. It was just one issue after another. So, I created a new directory and put vanilla .926 in there, installed it, overwrote the main pages with the migrator, then upgraded to version 1. All seemed ok. A few issues: categories transfered over, however the discussions connection to those categories did not transfer for whatever reason. This was ok, though - as I didn't want to have categories anyways and disabled them.

The main issue is that my phpbadmin name transferred over, including all references to the posts that i had made on phpbb. However, vanilla had me setup a new admin name, and even though i named the two the same, figuring that would take care of it, it infact just created two users with the same username, and caused major problems with loggin in, etc. Had to then just chanage the new user to another name, and then make the old user a master admin.

A few headaches and sighs, but the final sigh was the best - a sigh of relief. So, all is well, until the members start populating it and finding problems for me, per the norm : )

Thanks for the script.

I am currently going through the very slow and irritating process of migrating some 110,000 posts from YaBB to phpBB, all simply as the first stage of THEN migrating from phpBB to Vanilla. However, I've got myself a very nice and tidy V1 setup now, just waiting to have its database pumped full of hot data, and now I finally read that the migrator doesn't work with V1! Argh! Awesome work so far, but do you have any plans of updating the migrator for v1? If so, any idea of when?

clever, mini!

about 20 posts up: http://www.int0rw3b.com/v0926.zip

worked like a charm for me, almost. The categories didn't carry over, but every thing else looks like it did.

Categories are meant to carry over...not sure why they didnt for creede. Give it a go is all I can say i'm afraid. It's 7.16am here and i have a 12 hour shift to look forward to.

Also, where can I get a version of 0.9.2.6 to use for the migration?

Ok cool. So it transfers everything I asked about over to v1.1.2? Tremendous!

This is my first time converting.

If anyone wants to throw in some tips, I'd really appreciate it.

I built a Vanilla board before and I'm hooked. I'll never use another system. I'm transferring this one over for someone who has an existing phpBB setup. That has to stop! haha

As far as I know, the most recent version is the one here.

Hi
I'm very much keen to try out a forum on vanilla, but I have to shift it from my 5 year old spam-plagued phpbb2 installation.
I think I have done it all right, though took a fair bit of trial and error - for the benefit of other no-nothings I will sum up what I did. Sorry this is therefore a long post.

1. In phpbb2 land: Set up a couple of fake users so you can test their accounts after the conversion. Backup phpBB database, either from phpbb admin, or phpmyadmin (most webhosts have this - it is a database interface).

2. Install vanilla 1.1.2, which is not current, to same database as phpbb. I found it here: http://lussumo.com/downloads/

3. Get the migrator zip file (see post two above) and extract locally. Replace the values in mysqldetails.php with your database details. - ie:

$db = @mysql_connect ("replace with name of mysql server - not always localhost", "replace with username", "replace with password") or die ('I cannot connect to the database because: ' . mysql_error() .', Are you sure you have set your details correctly in the mysqldetails.php file'); mysql_select_db ("replace with database name");

Don't miss that last one with the database name... like I did. Your webhost should be able to help you with these, or have a look around your webhost admin panel.
Upload migrator folder to somewhere away from vanilla (do not overwrite vanilla files with identically named migrator files like I did..)

4. Browse to the migrator folder and run each script - save any error outputs for later pondering.

5. See if it the data has transferred to your vanilla forum by accessingthe forum, and also by browsing the tables in phpmyadmin.

6. you'll probably see a bit of this error: Fatal error: Call to undefined function: bcsub() It just relates to processing time and isn't important (I think).

I encountered a problem which others have too:

Discussion body disappearance
Everything transferred happily for me EXCEPT that the body of the discussions wasn't appearing, only the titles.
I had a look at the LUM_comments table in the database (using phpmyadmin) and noticed that discussions were there but that all the discussionIDs in each row were set to zero. The errors from my migrator script comments.php were like this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /[path]/migrator/comments.php on line 56

I emptied the LUM_Comments table in phpmyadmin and tried the script again. The errors had gone, but still no DiscussionID values were coming through.

That line 56 in the error above, and the line before it are to do with assigning the discussionID values. I altered the code a little to try to get more info on the error.

FOUND:
$dID = mysql_fetch_array(mysql_query("SELECT DiscussionID FROM $LUM_Discussion WHERE `phpBBtopicid` = '$tID'"));

CHANGED TO:
// PJ test dec 07
$pjresult = mysql_query("SELECT DiscussionID FROM $LUM_Discussion WHERE `phpBBtopicid` = '$tID'") or die(mysql_error());
$dID = mysql_fetch_array($pjresult);

I emptied the table again in phpmyadmin, and tried again. This time it worked and I have all my posts back! Phew. Not quite sure why though..

Next issue - formatting.

Eeek, all the phpbb img tags and quote tags are not working. I tried using Better BBCode extension from the Vanilla addons page ( http://lussumo.com/addons/index.php?PostBackAction=AddOn&AddOnID=31 ) but this didn't seem to have an effect. Had more luck with BBCodeParser, so now the forum is starting to look like it used to - even the avatar icons are showing up. Odd thing for a first time user of these extensions is that they can take a while to show up in the extensions tab (for my setup at least). Like up to 20 minutes. OK once you know.

Next problem - users.
I knew that all the user passwords would be kaput in vanilla and that users would need to use the forgotten password facility to replace their passwords. I have been testing this with some test users I set up in phpbb2 before the conversion. It all seems to work until the final part where the user puts in their new password to access the forum. This is bringing up the error: "Some problems were encountered. You do not have permission to sign in to the site." Still puzzling over this one.. any tips most welcome.

You are bang on! Thank you. All the role IDs other than admin's are set to 10, which doesn't exist in the RoleID table. I will try to work out how to change the 500 or so to roleID=3 (member) and report back. What should anonymous be set to though?
Peter

Must have been a phpBB user for something. Almost certain the migrator wouldn't put that in.