Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.
    • CommentAuthorJawi
    • CommentTimeAug 2nd 2006
     # 351
    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.
    •  
      CommentAuthorgarvin
    • CommentTimeAug 13th 2006
     # 352
    OK. Here is a stab in the dark: what if we have a vanilla forum already, upgraded to 1.0. And we want to cross over posts from a phpbb forum. What would have to be done for this dream made of hope and sticks (and duct tape) to work?
  1.  # 353
    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.
    • CommentAuthorguest
    • CommentTimeAug 14th 2006
     # 354
    It works fine thanks. But the the breaks do not convert =S ..

    example:

    - in phpBB

    hi this is a test
    this is a second one.

    - in Vanilla

    hi this is a test this is a second one.

    cheers.
    •  
      CommentAuthorgarvin
    • CommentTimeAug 14th 2006
     # 355
    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?
  2.  # 356
    No idea about that breaks issue unless you're using some funky encoding. I dont recall that problem before? I'm not sure it's possible to downgrade is it?
    •  
      CommentAuthorgarvin
    • CommentTimeAug 15th 2006
     # 357
    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.
  3.  # 358
    Yeah - the having 2 users who are the same real person but not being able to merge them is the only thing which was putting me off suggesting you do it. Course you could just run a query to set all your old posts poster ID's to your new user id.

    Glad something's working for you anyway.
    •  
      CommentAuthorunipus
    • CommentTimeAug 16th 2006
     # 359
    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?
  4.  # 360
    Nope, No plans I'm afraid. Migrating to 0.9.2.6 then upgrading does work though... If you backup your v1 files (I'm assuming it has no data in it), then install 0.9.2.6, then run an upgrade, then put your old v1 files back over the top, it should work and end up in your v1 being the same as it is now.
  5.  # 361
    clever, mini!
    •  
      CommentAuthorunipus
    • CommentTimeAug 17th 2006
     # 362
    Any idea of where I can get 0.9.2.6? I can't find links to anything but the release on the site.
  6.  # 363
    •  
      CommentAuthorunipus
    • CommentTimeAug 17th 2006
     # 364
    Great, thanks.
    •  
      CommentAuthorCreede
    • CommentTimeAug 29th 2006
     # 365
    worked like a charm for me, almost. The categories didn't carry over, but every thing else looks like it did.
    • CommentAuthorjdingman
    • CommentTimeOct 31st 2006
     # 366
    have there been any updates on this for categories carrying over?

    I'm looking to do an export from vBulletin to phpbb and then import from phpbb into vanilla...

    please advise
  7.  # 367
    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.
    • CommentAuthorHerrgeist
    • CommentTimeJul 16th 2007 edited
     # 368
    Not to drag this back to the top but I have some questions. I read the thread but I want to make absolutely sure I'm clear on some things

    If I migrate to Vanilla from phpBB, it will transfer ALL user/login/password information and all the threads and categories, correct?

    Also, my client is using a phpBB board, but it's on myfreeforum.org. Is it still possible to transfer everything from a place like that? Do I need to get some sort of information from them to allow me to do the transfer?

    The forum in question is http://burlesquewomensinstitute.myfreeforum.org/
    • CommentAuthorHerrgeist
    • CommentTimeJul 16th 2007
     # 369
    Also, where can I get a version of 0.9.2.6 to use for the migration?
  8.  # 370
    The new migrator will work fine with v1.1.2 :)
    • CommentAuthorHerrgeist
    • CommentTimeJul 17th 2007
     # 371
    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
    • CommentAuthorHerrgeist
    • CommentTimeJul 17th 2007
     # 372
    Is the new migrator that will work with v1.1.2 the one that is linked at the top of this thread?

    If not, can I have a link?
    •  
      CommentAuthorbjrn
    • CommentTimeJul 17th 2007
     # 373
    As far as I know, the most recent version is the one here.
    • CommentAuthorHerrgeist
    • CommentTimeJul 17th 2007
     # 374
    Thanks!
    • CommentAuthorpeterbp
    • CommentTimeDec 29th 2007
     # 375
    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.
  9.  # 376
    Nice post. Hopefully that will come in useful for a few people. I can't see why your query change makes any difference either but php can be a funny thing sometimes.

    As for the last issue, I'd suggest you check what role all your users have been assigned when compared to the roles in the role table. Chances are they somehow got assigned to a role which doesnt have sign in permission. It may be that the roles have changed since I wrote the migrator so default is now banned or something..
    That said, I thought I'd managed to get it working so users didnt have to reset their passwords? Maybe I'm wrong...
    • CommentAuthorpeterbp
    • CommentTimeDec 29th 2007
     # 377
    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
    • CommentAuthorpeterbp
    • CommentTimeDec 29th 2007
     # 378
    That worked! My test user is in. For others in same boat and as sql-spooked as I am, this command in phpmyadmin did the trick;

    UPDATE `LUM_User` SET `RoleID` = '3' WHERE `UserID` > '2';

    UserID 1 is admin so don't change that
    UserID 2 is 'anonymous' so I'm not sure what to do with that, as anonymous is not a member..?
  10.  # 379
    Must have been a phpBB user for something. Almost certain the migrator wouldn't put that in.
    •  
      CommentAuthorbobthecow
    • CommentTimeFeb 11th 2008 edited
     # 380
    here's the updated script i used to migrate my phpBB forum: linky

    this fixes:
    • handles character entities in post titles, discussion titles, etc.
    • added a grip of backticks to mysql queries
    • set user name as defaut first name (instead of phpbb)
    • added path prefix for user avatar migration, if they were using a locally hosted avatar on the old phpBB forum


    and i've added some more extension support:
    • signatures
    • discussionviews
    • chatstatus
Add your comments
    Username Password
  • Format comments as