Microlau's Blog

OneNote Mobile

For those of you who're using a Windows Mobile, have OneNote 2007 installed and use ActiveSync or Windows Mobile Device Center, you can get OneNote capabilities on your PDA. Although it's a stripped down version for note taking, what's important to be is the ability to be able to synchronise Notes taken on my laptop to my pda (and vice versa).

Upgrading Community Server 2.0 to 2008

Thanks to Telligent, I was able to get a license of Community Server 2008 for our user group. Over the weekend, I tried to upgrade our installation and here's a detailed walkthrough of the migration process, as it's not apparent (by googling), the exact steps to bring an installation from 2.X up to 2008.

To prepare for the upgrade, make sure that you have downloaded

1. Community Server 2007.1 Upgrade
2. Community Server 2008 Upgrade

Here's the breakdown of the steps taken for migration:

1. Backup Community Server database and Community Server 2.X application folder (check your IIS to find out where is your CS)
2. To prepare for migration to Community Server 2007.1, unzip the CS 2007.1 upgrade file and copy ALL the files from the web folder to the location which you intend to host your community server.
3. Copy files from your CS 2.X folder over the the folder which you've copied all the files in Step 2
   • Subfolders inside blogs (don't copy the files and the folders files and sample_weblog)
   • All files and folders inside blogs\files
   • All files and folders inside files\storage
   • All files and folders inside forums\storage
   • Subfolders inside photos (don't copy the files and the folders sample). Make sure that the subfolders photos\cache and photos\storage are copied over
   • All files inside Utility\RankIcons
   • All files inside Utility\RoleIcons
4. Execute the SQL script cs_2.x_to_3.0_upgrade.sql on your Community Server database
5. Configure your IIS to point to the location specified in Step 2, making sure that the account has modify access to the folders. Ensure that the account has full access to the following folders:
   • blogs\Files
   • files\Storage
   • forums\Storage
   • photos\Cache
   • photos\Storage
   • utility\RankIcons
   • utility\RoleIcons
6. Make sure that your application pool is configured to Classic managed pipeline. Make sure that connectionStrings.config is setup correctly. At this stage, you will have Community Server 2007.1 setup successfully. Test it.
7. [New Step] Here are some common errors which you might encounter:
   Procedure or Function 'aspnet_Membership_GetUserByName' expects parameter '@TimeZoneAdjustment', which was not supplied. Inside the SqlScript folder, run the script cs_ASPNET2_Membership_Schema_Update.sql - This is because your ASP.NET membership information is still in ASP.NET 1.1 and not upgrade to ASP.NET 2.0.
   
8. If your testing in Step 6 is successfully, BACK UP THE DATABASE AND APPLICATION FOLDER! I cannot stress how important this step is.
9. Extract Community Server 2008 to a folder and copy all the files in web folder over to the location in Step 2.
10. Run the upgrader tool Community.Upgrader.exe and follow all the steps specified inside. Here's a few points to take note if you encounter errors:
    • EXCEPTION: Violation of PRIMARY KEY constraint 'PK_cs_ProductPermissions'. Cannot insert duplicate key in object 'dbo.cs_ProductPermissions'. Just re-run the upgrader tool again. The error should go away.
    • EXCEPTION: Object reference not set to an instance of an object.
         at CommunityServer.Upgrader.FileUpgrader.UpgradeStorageType(ApplicationType type, String filePath)
         at CommunityServer.Upgrader.Part4.MoveFilesToCfs()
      This means that you didn't follow Step 8.
11. Go to IIS and change the application pool to use Integrated managed pipeline.
12. Test it!
    • Missing Avator
      Make sure that the managed pipeline @application pool is changed to Integrated (CS 2.1 & 2007 uses classic) 
    • Unable to add / reply to post
      If you used 2007.01 upgrader, you might encounter this problem. Make sure that you copy CookComputing.XmlRpcV2.dll over to the bin folder of your CS.

That's it!