Tag Archive: Wordpress


Huge wp_options table

I’ve been having issues with the automatic update of plugins and the WordPress core files for some time now and I could never quite track it down until today.

I was at my wits end with the updater and was contemplating exporting the WordPress MySQL database and installing it on to a new install folder. My best guess was that the issue was related to a core file that wasn’t overwriting correctly from my FTP upload, as it has happened before but with other side effects. After I exported my SQL file I noticed it was 6.3MB, which is huge. I dug into the SQL table and noticed that wp_options was about 6MB alone. Further inspection showed a bunch of RSS files that turn out to be cache files that are supposed to be purged. There were also lots of references to old plugins that I no longer used. My initial thought was to manually delete these entries but there were 300+ of them and that would have taken way too long. It could have also lead to me deleting an entry that was needed. A quick Google search turned up this plugin. I deactivated my current plugins so I could activate the Clean Options Plugin (internal server errors after enabling plugins were another symptom I was seeing) and ended up cleaning up over 350 orphaned entries! The wp_options table is now down to 50KB.

Now my plugin and core updates all work correctly. My dashboard also is able to load more than just a couple widgets and in general the admin interface just works better.

A Time for Change

It has been quite some time since I’ve had a new theme here at the blog. I’ve decided it is time to get up to date on HTML 5 and what you see is a minimalist HTML 5 based theme. I will be styling to my liking as time permits.

Top 5 Features to look forward to

Warning: Highly technical one and a half hour video on HTML 5 goodness.

Post to WordPress from Word 2007…

While poking around Word 2007 today I realized that I could be posting from Word instead of the WYSIWYG/html WordPress editor. What you see here is the 1st post from Word to WordPress on my site.

Setting up the connection info is a snap. You just have to enter in the URL of your site, the info of the user you want to post as and you are on your way.

I’m not sure if I will continue using Word 2007 to post as some of the advanced options for images and post layout are a bit finicky, but it is a great way for average users to use an application they are comfortable with to post to their blogs.

Updates, Updates, Updates…

At 20 Weeks

It has been a long time since I've been able to get myself together to post something of worth here.  Life has been very busy, yet at the same time nothing much of note has happened, tech wise at least.  The baby continues to grow inside mommy, the babies room has been finished and a major overhaul to the basement and driveway has taken place.  So you can see why I have had little time for a tech blog. View full article »

WP Update & A Lonely Boy

Looks like my upgrade of WordPress to the latest & greatest version has gone as smoothly as one can hope for.  I also took the opportunity to see if any of the plugins I use here have had updates.  Some actually did.  It is good to see that there is a thriving community to support WordPress.

On another note, Kris is leaving for Toronto this afternoon and will not be back until next Wednesday.  Our furry lil beasties will be extra needy while she is gone, so I will have my hands full.  I do have a few things planned already so I will not need a honey do list left for me, and I can always waste time playing WoW.

My Facebook community is really growing.  It started very slowly, then yesterday exploded when I was able to find a number of old school mates, some I haven't seen in over a decade.  It was good to catch up on what they have been doing all these years.

WordPress & Comment Spam Filtering

I am very impressed with the Akismet Spam filtering system that WordPress has integrated into their blogging software.  Recently this blog has gotten quite a bit of spam and Akismet has stopped nearly all of it (99.996%).  I moderate the comments before they are posted here and only 2 of 450+ spam comments were in my moderation list.  I'm not sure why they weren't in the spam folder as they were clearly spam, but I am still thoroughly impressed.

I haven't upgraded to WP 2.1 yet, but I hear that there is an updated version of Akismet included in the update.  Akismet is free for personal use, and if you have a WordPress blog, I urgently recommend using it.

WordPress Plugin: Ad-Rotator

Ad-Rotator is simple, yet effective ad rotation plugin for WordPress written by Angsuman Chakraborty .  As is often the case with community written plugins, the technical docs on how to get the plugin to work are limited and somewhat confusing, specifically in regards to Google's Ad-sense program.  I was able to reach Angsuman via email and after a quick flurry of messages he was able to show me how to get Ad-Rotator working with a number of different affiliate programs, including Ad-sense. View full article »

Powered by WordPress | Theme: Motion by 85ideas | © 2006–2012 Dave Hildebrand | 61 queries in 8.832 seconds.