Upgraded to Wordpress 2.3.2
Well, it’s all done! I finished upgrading to the latest version of Wordpress. I was scared because this blog is running quite a few plugins and I’ve been reading about all sorts of horror stories from different bloggers since 2.3 was released. I wrote the PHP script for the Star Ratings page myself that displayed the post results for each possible star rating generated by the Rate My Stuff Custom Field plugin, but I wasn’t sure if it would become useless in the upgrade.
Thankfully, I upgraded, and everything worked fine including my star ratings page. The only thing that exploded unceremoniously was my “Most Popular Posts in ____ Category” plugin (like on the Fansub category main page). I had coded up an additional function and function call to Dukijev’s CountPosts plugin to adapt it to display different popular posts depending on whether the category of a post was a child of the selected parent category. It had taken me forever in the first place to write the function, and of course it no longer worked with 2.3. Just my luck! I read a lot about the new wp_terms, wp_term_relationships, and wp_term_taxonomy tables and was able to work my old code using the new structure.
I’m still not used to joining MySQL tables with PHP but I’m trying my best with it. I initially learned about the concept on an early date with my boyfriend months before we were dating (I can clearly remember him writing up an impromptu example of the syntax on a napkin at Tim Hortons; what a nerdy couple we are. XD). Since it has been successful here at Sparkle Sparkle, I want to try to optimize my main anime website, Magitek Designs. The series page is terribly unoptimized, using far too many MySQL queries on six different tables. I’m going to use this practice that I’ve been doing from customizing my Wordpress blogs to my advantage on other sites. ^^ I’m excited!
Thank you for giving me the courage to upgrade, Maya! ^_^
January 3rd, 2008 at 10:00 pm
You’re welcome! I’m glad you were able to upgrade with relatively few problems. You know a lot more about PHP and MySQL than I do, so you should have had an easier time upgrading than me. Anyway, glad to see that it works. :)