Back in Gold!!! The blog upgrade is nearly complete! But it wasn't a cakewalk...

Posted By: Brian Meloche; Posted At : October 22, 2006 10:54 PM

Related Categories: Blogging, About Me

After some grueling times at work over the last several months, I have been needing to upgrade my blog for a long time. This weekend, I was finally able to do it.

My RSS feeds have been disabled for some time. CrystalTech, my web host, noticed a problem that I hadn't been able to get to. I wanted to fix it, but it seemed that an upgrade of BlogCFC was also necessary, from the 3.9 version I had been running to the new 5.5.002. I was really surprised that I couldn't find any documentation about upgrading the blog, and I suppose it would have been easier if I hadn't tried to do it all at once...

I had to make some custom changes to the code to make it work on my hosting account, since the "org" conflicted with another site on the server. The first time I tried to upload the code, I botched it up pretty good, but my second attempt (by separating the old blog from the new) was a success.

Then, there was the data transfer... not such a resounding success!

I needed to upgrade from Access (yes... I know... it was quick to get it up when I needed to!) to MySQL. The hosting problems were being caused by the Access... yes, again, I know. I'm not proud of sticking with Access that long. What can I say? I've been busy... and it wasn't a priority to upgrade.

It probably would have been easier to go with SQL Server, and I could have, but I figured MySQL was easier to isolate from my other apps. There is also something I need to do as a separate project with my SQL Server hosted database to upgrade, so I figured MySQL was a good alternative.

As is often the case when switching databases, there were issues with dates and boolean fields. I had to make custom updates to the records... one at a time. There are also new fields in the new version that didn't get turned on. It didn't automatically publish the entries. Once I figured that out, and published the old articles... everything came back.

It took a substantial portion of the weekend, but this post signifies that the transfer is now complete.

I still have to customize the look and feel... but I'll get to that later.

Related Blog Entries

Comments
well done... I've still not dared to upgrade my BlogCFC install - I think it's about as old as yours was. I have changed so much CF code that I'm really scared... maybe it'll be best to copy the entire site and work on the copy first of all. Argh, not looking forward to it.
# Posted By Stefan Richter | 10/23/06 8:25 AM

Hosting provided by...

Hosting provided by hostmysite.com

Calendar

<< February 2012 >>

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29      

Archives By Subject

  • About Me (44) [RSS]
  • ActionScript (1) [RSS]
  • Actuate (1) [RSS]
  • Adobe (18) [RSS]
  • Adobe Community Professionals (3) [RSS]
  • AIR (1) [RSS]
  • AJAX (1) [RSS]
  • Animals (11) [RSS]
  • Articles (2) [RSS]
  • ASP (1) [RSS]
  • Blogging (14) [RSS]
  • BlueDragon (2) [RSS]
  • Canadian-American (1) [RSS]
  • CFConversations (16) [RSS]
  • Cleveland (3) [RSS]
  • Cleveland AUG (21) [RSS]
  • Cleveland CFUG (24) [RSS]
  • ColdFusion (81) [RSS]
  • Conferences (33) [RSS]
  • Design (3) [RSS]
  • Dreamweaver (1) [RSS]
  • Eclipse (1) [RSS]
  • Flash (2) [RSS]
  • Flex (10) [RSS]
  • Frameworks (7) [RSS]
  • Fusebox (1) [RSS]
  • J2EE (1) [RSS]
  • JavaScript (1) [RSS]
  • Jobs (2) [RSS]
  • LightFront (6) [RSS]
  • Linux (2) [RSS]
  • Mac (3) [RSS]
  • Mach-ii (9) [RSS]
  • Macromedia (9) [RSS]
  • MAX (34) [RSS]
  • Notes to Self (1) [RSS]
  • Open Source (7) [RSS]
  • Personal (17) [RSS]
  • Podcasts (23) [RSS]
  • Politics (1) [RSS]
  • Railo (0) [RSS]
  • Random Musings (10) [RSS]
  • Reality TV (1) [RSS]
  • Social Networking (1) [RSS]
  • Speaking (7) [RSS]
  • Subversion (2) [RSS]
  • Tech News (2) [RSS]
  • Technology (2) [RSS]
  • The Event (1) [RSS]
  • Tutorials (1) [RSS]
  • User Groups (23) [RSS]
  • Videos (1) [RSS]
  • Weight Loss (4) [RSS]
  • Windows (0) [RSS]
  • Work (8) [RSS]
  • Search

    Twitter Updates
    Follow me!

      RSS

      Subscribe

      Enter your email address to subscribe to this blog.

      Tags

      about me adobe animals blogging cfconversations cleveland aug cleveland cfug coldfusion conferences flex max personal podcasts random musings user groups

      Recent Comments

      Change a comment in an SVN log (or fixing a malformed SVN log file after changing a comment)
      Brian Meloche said: @HippyJim, that's a good point, or at least choose an editor that can write in Unix CR/LF format. Do... [More]

      Change a comment in an SVN log (or fixing a malformed SVN log file after changing a comment)
      Ellaine Matthews said: Does the same solution apply to the new problem of SVN? Thanks a lot for this post! [More]

      Change a comment in an SVN log (or fixing a malformed SVN log file after changing a comment)
      freelance writing jobs said: That is great! I first hear about it! [More]

      Change a comment in an SVN log (or fixing a malformed SVN log file after changing a comment)
      Hippyjim said: Thanks for the tip - it's also worth noting that if your SVN repo is stored on a linux / unix server... [More]

      End of Another Era: Changes at the ColdFusion Helm
      Brian Meloche said: Tim Cunningham makes a couple of points on the subject worth reading over on his blog: http://cfmum... [More]

      Podcasts I Listen To...

      Active Podcasts
      CFConversations (My Podcast)
      CFPanel (technically not a podcast, but close enough!)
      RIA Podcast
      CFHour()
      The Flex Show
      Non-active CF/Flex Podcasts (still worth a listen)
      ColdFusion Weekly
      The ColdFusion Podcast
      Helms and Peters Out Loud
      Other Podcasts
      This Week in Tech (TWiT)
      Windows Weekly with Paul Thurotte
      MacBreak Weekly
      Net @ Nite
      Slashdot Review
      Ruby on Rails Podcast (I'm not a Rails developer, but it's always a good idea to stay in touch with the competition!)
      Web Design Podcast from boagworld.com
      Practical Web Design Magazine