Category: Databases


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”

 

You know that feeling you get when something goes terribly wrong, but you can’t do anything about the situation? I hate it! I also hate it when I can’t figure out how to do something that is probably really easy.

I have been working alongside Domino servers for as long as I could remember. The one thing I didn’t have was a mentor or even an Administrator to learn anything from. This caused me to focus on other things such as MySQL, MS-SQL, ASP, Visual Basic, etc… So whenever we had a problem, the first thing we would do was call the Domino people.

Well, there are a couple problems with calling on the Domino people.

  • They don’t know how to do the new stuff that I want to try out (Accessing Domino databases using PHP)
  • They are too scared to try something new (Setting up domino on a Virtual Server using VMWARE)
  • They want to charge us $1 million an hour to add a feature to our Domino website (Adding an RSS or XML feed of the same data that is already listed on the website)

I am calling on the power of the blogosphere in hopes that a ping will do its magic and get the attention of someone who can help me to better understand my problems and hopefully offer some pointers.
After doing some searches, here is a little list of a couple Lotus Notes/Lotus Domino blogs that I thought were interesting:

So, if there are any domino developers out there that can help me out, please leave me a comment or send me an e-mail, or send me an IM or anything.

P.S. I am not looking to buy anything, I am just looking for someone who is kind enough to point me in the right direction or maybe an article on how to do create a XML Feed using a domino database.