Phpbb to Vanilla

ellin

Hey, as lots of people probably were, I'm still stuck with my phpbb forums (http://wash.org.nz/forums). Is there an easy way to convert to Vanilla?

Has anyone got experiance that could offer step by step instructions?

Thanks

garymardell

oh come on use the search tool! there is a migrator to do the conversion now use your head and use the search tab.

nathan

There is a phpBB migrator that (I think) Mini wrote. The discussion is over here: http://lussumo.com/community/discussion/145/7/v02-phpbb-migrator/

ellin

Oh yea good on you Immersion mate! I've actually used the search tool and found the same topic that I read months ago you dick head. Nathan I just wondered if anyone could make it a little bit more of a simpler process

Thomas Heath

Easy guys, no need for a virtual cockfight. @immersion: no need to be grudgy. @ellin: its okay to post in old threads, so asking for a simplified procedure in (http://lussumo.com/community/discussion/145/7/v02-phpbb-migrator/) would be better. Otherwise the next person who searches will find a lot of short stub discussions which just end up referring to other discussions. And please, refrain from calling people around here #¤ heads even if they piss you off.

Minisweeper

There's also a new wild migrator which the author suggests should migrate any forum (i havent looked at it yet), but i believe you need to write a couple of classes (presumably telling it what to take etc) first so that wouldnt really make it any easier.

I'm curious how much simpler you expect it to get, though. Mine consists of putting some details into a file, uploading it, and then clicking 4 links in sequence. Aside from the bugs which some people have experienced that's pretty darn simple.

pug

I had issues trying to use the Migration Tool. I edited what needed to be edited and still states could not find my database(s). All I want to do is migrate user names and passwords. The topics are a mute point at this time due to time limits.

Minisweeper

What do the first 3 lines of your mysqldetails.php file say? Be careful to block out the password.

pug

<?php $db = poserund_p_bb1 ("localhost", "pug", "XXXXXXXX") 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'); poserund_forum ("vanilla"); This is the error I am getting: Fatal error: Call to undefined function: poserund_p_bb1() in /home/poserund/public_html/Forum/mysqldetails.php on line 2

Minisweeper

That should be: $db = @mysql_connect ("localhost", "pug", "xxxxx") 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 ("vanilla");

pug

Okay i changed what you said needed to be changed and I get this when I just do the users - $db = @mysql_connect ("localhost", "pug", "XXXXXXXXXXX") 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 ("vanilla"); /// Set a series of table references incase of non-default setups of phpbb $phpbb_forums = "phpbb_forums"; $phpbb_posts = "phpbb_posts"; $phpbb_topics = "phpbb_topics"; $phpbb_posts_text = "phpbb_posts_text"; $phpbb_users = "phpbb_users"; /// Attachments add-on for phpbb $phpbb_attachments = "phpbb_attachments"; $phpbb_attachments_desc = "phpbb_attachments_desc"; /// Set a series of table references incase of non-default setups of vanilla $LUM_Category = "LUM_Category"; $LUM_Comment = "LUM_Comment"; $LUM_Discussion = "LUM_Discussion"; $LUM_User = "LUM_User"; /// Attachments add-on for vanilla $LUM_Attachment = "LUM_Attachment"; /// Tags add-on for phpbb $LUM_DiscussionTags = "LUM_DiscussionTags"; $LUM_DiscussionHasTags = "LUM_DiscussionHasTags"; $refreshtime = "0"; function DateTimeFromTimeStamp($TimeStamp) { return date("Y-m-d H:i:s", $TimeStamp); } ?> Warning: mysql_query(): Access denied for user: 'root@localhost' (Using password: NO) in /home/poserund/public_html/Forum/users.php on line 12 Warning: mysql_query(): A link to the server could not be established in /home/poserund/public_html/Forum/users.php on line 12 SELECT user_id,username,user_password,user_email,user_viewemail,user_avatar,user_posts,user_regdate,user_lastvisit FROM ORDER BY user_id ASC Warning: mysql_query(): Access denied for user: 'root@localhost' (Using password: NO) in /home/poserund/public_html/Forum/users.php on line 17 Warning: mysql_query(): A link to the server could not be established in /home/poserund/public_html/Forum/users.php on line 17 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/poserund/public_html/Forum/users.php on line 18 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/poserund/public_html/Forum/users.php on line 20 Number of Errors: 0

pug

Okay did find where my issue was now I am getting this - I cannot connect to the database because: Access denied for user: 'pug@localhost' (Using password: YES), Are you sure you have set your details correctly in the mysqldetails.php file

Minisweeper

Well assuming you are 100% sure your details are correct I'm not sure what to suggest...the function call that script makes is (as far as i know) the only way to connect to a mysql database using PHP and there's not really anything that can go wrong with it...Can you double and triple check your username and password? Any other ideas guys?

WallPhone

I think that is just the standard invalid username/password/permissions message... I would look through your phpbb configuration and copy the settings from there.

pug

Where is says "mysql_select_db ("vanilla");" should I be putting my forum DB name?

WallPhone

yes--name of the phpBB DB

pug

Okay I changed it to the DB I am trying to copy from and to the DB I am trying to copy too Both times I get First error is the forum I am trying to copy Fatal error: Call to undefined function: poserund_p_bb1() in /home/poserund/public_html/Forum/mysqldetails.php on line 3 Second is the one I am trying to copy to Fatal error: Call to undefined function: poserund_forum() in /home/poserund/public_html/Forum/mysqldetails.php on line 3

pug

I am about to give up and manually transfer data from 1 forum to the other. Is there a way to create the users names and passwords as was in my phpbb forum?

WallPhone

The migrator config looks like Minisweepers, but those error messages say its acting like some other migrator I saw but don't remember which one (wildthing?). I have the feeling you are trying to run two different migrators jumbled together.

Is this from here? phpbb migrator # 19
or here? [v0.2] phpBB Migrator # 331
or somewhere else?

pug

Okay this is what I ended up doing: Deleted my vanilla DB and created a new one. Deleted my vanilla forum folder from my server and created a new folder and reloaded vanilla. Ran the first got same error as before. Created a fresh new DB and fresh install ran the second and got a whole lot of errors. So I decided I will try just a fresh DB and try the old way manually copy n paste user names and passwords.... WRONG! I went in to myphp and tried to open my original php DB and nothing there! I mean it was totally wiped out.... Thank fully I have a back up at my desk at home! I will recover the corrupted data then try this again. If the umptenth time does work I will just make them register at the forum.

Minisweeper

Hold on...you're trying to copy the phpBB data out of one database into a seperate database? That doesnt work with my version of the migrator atleast...I dont know if any newer versions out there will do it... Why cant you just install vanilla into your phpBB database? Or import a phpBB dump into your vanilla database? Then the migrator should do its stuff..