Posts Tagged ‘MySQL’


I have been trying to organize my categories in WordPress a little better so that you can find things easier and so I have less trouble trying to figure out which ones to use when I write new posts.

I originally started using my name (Jason Stone) as a category, thinking that it would help me rank higher for my name. At first, it worked. I used to be on the first page when you would type “Jason Stone”. I think Google’s filter decided it didn’t like that idea because my rank dropped to 99. The other categories I deleted were:

  • Web Server
  • Hot
  • Funny
  • Blogging

If you have trouble trying to find something, try looking in “Cluttered Thoughts
I Added the “Cluttered Thoughts” for when I am in a hurry or if I post some random stuff that doesn’t relate to my main topics. I have also added the “Coding” category to organize articles that contain full scripts or source code snippets in any coding language that I end up needing to use (examples: ASP, PHP, HTML, etc…)

I moved the Databases Category from:
Root > Computer > Software > Databases
to:
Root > Databases

(This is the new location for “Databases“)

I moved the PHP category from:
Root > Computer > Software > PHP
to:
Root > Coding > PHP

(This is the new location for “PHP“)

 

I just downloaded the Simple Tagging 1.6 Plugin today and I got errors when I tried to convert the categories to tags on the import tags section. The following will explain the error, and how I fixed it. (I didn’t bother to do a search on this problem so someone else may have already posted a fix for it)
To be safe, I downloaded and installed the WordPress Database Backup Plugin and did a backup of the database before running the import tags function like it suggested.
So, once I got Simple Tagging installed, I clicked on the new “Tags” section then I clicked the tab labeled “Import Tags” and checked the “I’ve backed up my database” checkbox and clicked “Convert Categories to Tags.”
When I did that, it returned the follow error:

WordPress database error: [Unknown column ‘p2c.category_id’ in ‘on clause’]
SELECT cats.cat_name, p2c.post_id FROM wp_posts posts INNER JOIN wp_categories cats ON (p2c.category_id = cats.cat_id) LEFT JOIN wp_post2cat p2c ON (posts.ID = p2c.post_id) WHERE posts.post_status IN (‘publish’) AND posts.post_type <> ‘page’

To fix it, go to your simple-tagging folder (should be in the plugins folder) and look for “simpletagging.admin.php”