Hi there! I'm running a phpBB forum, and now, I want to convert it to Vanilla.
I've got everything prepared for the convertion process, I've got the database, Vanilla 0.9.2.2, migration tool (the version that works with two different databases), and I've got the Vanilla 1.0.1.
The plan was this: 1. Instal Vanilla 0.9.2.2 2. Use the migration tool to convert the databse 3. Overwrite old Vanilla files with the ones from 1.0.1 instalation.
So, I installed Vanilla 0.9.2.2., I copied the migrator folder into Vanilla's one, and that was it :( Now, the problems...
The only thing that was succesfully converted were the discussion topics and the users of the forum. No comments (posts), no categories. I also noticed that all users got Moderator status, but, I'll take care of it later, now I just want to transfer my database to Vanilla.
NB: I got the errors, but users were transfered???
Next, the errors from the categories migration: SELECT forum_id,forum_name,forum_desc,forum_order FROM phpbb_forums ORDER BY forum_id ASC INSERT INTO `lum_category` ( `phpBBforumid` , `Name` , `Description` , `Priority` ) VALUES ( '1' , 'Helpdesk, novosti i obavijesti', 'Prijedlozi, kritike, pomo?, novosti...', '20' )
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in f:\wamp\www\vanilla_testing\migrator2\categories.php on line 38
ERROR ROW 0 INSERT INTO `lum_category` ( `phpBBforumid` , `Name` , `Description` , `Priority` ) VALUES ( '2' , 'Pravila ponašanja na forumu', 'Follow the rulz!', '30' )
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in f:\wamp\www\vanilla_testing\migrator2\categories.php on line 38
And finally, the comments migration errors: run: 0 SELECT post_id,topic_id,poster_id,post_time,poster_ip,post_edit_time FROM phpbb_posts ORDER BY post_id ASC LIMIT 0,10000 0, INSERT INTO `lum_comment` ( `phpBBpostid` , `DiscussionID` , `AuthUserID` , `DateCreated` , `EditUserID` , `DateEdited` , `WhisperUserID` , `Body` , `FormatType` , `RemoteIp` ) VALUES ( '8', '1', '4', '2005-12-04 15:53:57' , '4' , '1970-01-01 01:00:00' , '' ,'Samim time što ste registrirani e`lan foruma [b]znae`i da prihva?ate[/b] ova pravila. 1. Zabranjeno je promoviranje svake politie`ke i vjerske ideologije i orijentacije što znae`i sve od uvrijedljivih nickova, potpisa, avatara do samog sadržaja posta, pa makar to bili i najobie`niji vicevi. Ova pravila vrijede do daljnjega, a u slue`aju promjene ?ete biti pravodobno obaviješteni.' , 'BBCode' , '193.198.142.146' ) 1, INSERT INTO `lum_comment` ( `phpBBpostid` , `DiscussionID` , `AuthUserID` , `DateCreated` , `EditUserID` , `DateEdited` , `WhisperUserID` , `Body` , `FormatType` , `RemoteIp` ) VALUES ( '9', '2', '4', '2005-12-04 15:56:48' , '4' , '1970-01-01 01:00:00' , '' ,'Ako želite staviti link od vašeg web site-a ovo je pravo mjesto za to. Molim vas da ukratko opišete i sadržaj svog web site-a.' , 'BBCode' , '193.198.142.146' ) 2, INSERT INTO `lum_comment` ( `phpBBpostid` , `DiscussionID` , `AuthUserID` , `DateCreated` , `EditUserID` , `DateEdited` , `WhisperUserID` , `Body` , `FormatType` , `RemoteIp` ) VALUES ( '10', '3', '4', '2005-12-04 15:58:20' , '4' , '2006-01-27 11:49:42' , '' ,'Forum je pokrenut da bi omogu?io studentima FOI-a da mogu me?usobno razgovarati i razmijenjivati iskustva o fakultetu. Postoje i news grupe, ali meni osobno se nekako više svi?a pisanje na forumu, pa sam ga iz tog razloga odlue`io postaviti. Napomena: Sudjelovanje na forumu je besplatno i anonimno. Kod registracije samo upišite pravu e-mail adresu jer ?ete dobiti mail u kojem ?e biti link na koji trebate kliknuti da biste potvrdili registraciju. Nadam se da ?e vam ovaj forum biti od pomo?i. Za sad bi to bilo sve što imam re?i o forumu. Brane' , 'BBCode' , '193.198.142.146' )
etc...
I am very sorry for this long, too long post, but I really don't know what to do anymore. I just want to migrate to Vanilla to be happy :) And any help would be appriciated!
Oh, yes, one more thing... Somewhere on this forum I found a link to Vanilla 0.9.2.6 version, but when I installed it, I noticed that the version really was 0.9.2.2! Is this of some rellevance or not?
Well, I have to go study now, exams are comming, so I'll drop here later in the afternoon...thanks in advance ;)
I've got very limited pc access from now till tuesday so I dont really have time to look at this. Hopefully someone else can help you out or I'll try and remember to cmoe back here wednesday.