Brew Basement Site Updates
By jason on Jan 11, 2008 in Messages to Readers
Hello everyone. Hope your holidays went well!
You may have noticed that I’ve been posting a lot of tasting notes lately. If they’re not quite your thing, I’m sorry about that. Even before the holidays the time between me cellaring a beer and getting the notes online had grown to well over a month. I’ve been trying hard to close this gap, and I should be there within a week or so.
On other news, some of you may have been getting an error after you leave a comment. The comment still posts, but you have to hit the back button on your browser to return to the site. Sorry about this. It’s even more annoying to me, as I’m also experiencing a ton of errors whenever I log to administer the site. Over the holidays I upgraded the backend software that powers this site (Wordpress), and the database managed to get a bit corrupted in the process. I’m not losing any of my data, but it’s annoying as hell. Hopefully I’ll have this fixed within the next week or so. Hopefully.
I’m also in the looking at rebuilding the site in such a way that would allow me to have much more functionality built around my tasting notes, while also allowing individual users to log on and add theirs. A key to this functionality would be the ability to track individual beer vintages over time. This would allow us to easily compare and discuss different vintages of the same beer, something I think would be seriously cool. Don’t look for it anytime soon, but it’s something I’m working on.
Other then that, it’s business as usual here at the Brew Basement. I’ll be updating a bunch of my early tasting notes with their six-month tasting results soon, and my second beer cellaring experiment will start as soon as I receive one last piece of equipment (it’s so cool!).
Thanks to everyone for continuing to read!
Jason
Hi Jason,
I’m interested in your thoughts on building your beer vintage tasting notes functionality. I have a bit of experience writing WP plugins and hacking the core code, so I might be able to lend a hand. Shoot me an email and we’ll discuss it a bit offline.
-Jason
Jason Burks | Jan 11, 2008 | Reply
Hey, me again. I just saw the error messages you’re getting when someone tries to comment. It appears to me like you didn’t update all of the files in wp-include. The comment submit (or something that is called thereafter–not sure what plugins you might have in play) seems to be running a SQL query that calls the wp_post2cat table, which doesn’t exist anymore in WP 2.3. In order to support the built-in tagging, WP 2.3 uses what it calls terms and a taxonomy to relate them.
Here are all the files in WP 2.2.3 which reference that table:
wp-admin/admin-db.php
wp-admin/admin-functions.php
wp-admin/export.php
wp-admin/upgrade-functions.php
wp-admin/upgrade-schema.php
wp-includes/category.php
wp-includes/deprecated.php
wp-includes/functions.php
wp-includes/link-template.php
wp-includes/post.php
wp-includes/query.php
wp-includes/wp-db.php
wp-settings.php
I’d check to make sure that all of those were updated to the WP 2.3 versions. I don’t know what version you were using before, but hopefully this will get you started in the right direction.
-Jason
Jason Burks | Jan 11, 2008 | Reply
Okay Jason, a bit more info on the problems you’re seeing. I don’t see that specific SQL query in any of the code from a randomly selected 2.0 and 2.1 release either. I strongly suspect that it’s one of your plugins (outside chance it’s your theme, but I downloaded Zeke 1.0 and took a look through there and don’t see anything suspicious). What version of WP were you using prior to your upgrade?
-Jason
Jason Burks | Jan 11, 2008 | Reply
Thanks for taking a look Jason, I great appreciate your efforts! I want to say I was using 2.2.1, but I’ll have to look at my backup files on my home PC before I’ll know for sure.
I have a plugin called “Ultimate Tag Warrior” still active that was giving me tagging functionality on my posts before this latest Wordpress update included tags natively. I suspect there might be an issue there.
I’ll send you an email this weekend on the other stuff I have in mind, I’ll be happy to pick your brain about that!
Thanks again for the help and suggestions.
jason | Jan 11, 2008 | Reply
Hey Jason,
Just wanted to know if you’d had any luck getting the comments and such fixed. I figured leaving another comment is the best way to find out!
Oh, and I’d still love to hear from you about your vintage tasting notes idea.
-Jason
Jason | Jan 17, 2008 | Reply