Category: Problems


Anyone who subscribes to my feed may notice old posts being updated. It is because I need to re-tag everything.

I decided to completely start over with the UTW plugin to see if it would fix the problems I have been having with my tags.

To start over, I deactivated the plugin and deleted the plugin folder.
Then I went into the MySQL database and deleted the tables that UTW makes along with some other entries that I noticed in one of the WordPress tables.

UTW Tables I deleted were:

  • wp_tags
  • wp_post2tag
  • wp_tag_synonyms

Since I had exported the tags to custom fields in WordPress, I had to delete those entries which resided in the “wp_postmeta” table.

So, cross your fingers and wish me luck. Here we go….

I really hope this fixes everything.

 

I installed the original Free IT management software, Spiceworks (version 1.0 i think) a few months ago. But I had trouble getting it to start up at first. Then, after some troubleshooting, I got it running (sorry for the lack of details, I did this a while ago). Then at some point it wouldn’t load anymore (once again, sorry for the lack of information. I wasn’t watching close enough to know what caused this). So then, I thought, if I upgraded to the newest version, it should fix any possible bugs and/or modify any services that might be affecting my computer.

 

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.

 

One of my clients had a power disruption to some mission-critical hardware the other day; things including the entire phone system and internet connection.

I guess the UPS that the telephone system and router are plugged into decided to crap out. The good thing was that it wasn’t during business hours. The bad thing was that the phone system was plugged in to the same UPS, which means that if anyone tried to fax something to the office, and it wouldn’t have gone through. Did I mention they get about 600 important faxes a week?

The weird part about this whole thing was, I didn’t know that anything happened, but, for some reason I decided to go to the office to check on things at about 11:00pm EST (I am using Eastern Time because that is the time-zone that is showing in the screen shot below). After fixing the problem (I just bypassed the UPS until we can get a replacement), I checked the logs from the Line Monitor that I set up at Broadband Reports and it was unreachable from 2007-02-08 22:52:46 EST – 2007-02-09 00:02:55 EST (70 minutes). Here is a screen shot of one of the graphs:

Server uptime graph

If I didn’t happen to come to the office, no one would have found out until someone tried to make a call out, or even worse, realized that there were 100+ faxes that didn’t come through. If I was using the paid monitoring service at the time, I would have received an email telling me that the connection was down. Their line monitoring service is a very useful tool to have in situations like this.