Technology Insights

WordPress Image Upload Error: Unable To Create Directory, Is Its Parent Directory Writeable By The Server?

I haven’t posted to my personal WordPress blog in months because I have been busy writing QD articles and working on the QD Tools section. So I got a comment posted to my personal blog tonight that inspired me to finally get back to making a blog post on the WordPress site that houses my personal blog. During the post I wanted to upload an image of my daughter which I typically do using the “Add an Image” button located in the WordPress admin “Add New” post interface. The “Add an Image” button by default allows two different methods of uploading images via your web browser which include the Flash Uploader and the Browser Uploader. On Question Defense I use a modified version of the Browser Uploader however on my personal WordPress blog I always have used the Flash Uploader. Tonight when I attempted to add a post I received an error which I initially thought to be related to permissions however that was not the case as I explain below along with steps to resolve the issue.

Technology Insights

Disable All WordPress Plugins From MySQL CLI Or PhpMyAdmin

I was creating a mirror copy of one of my WordPress installations recently and needed a way to disable all plugins. During the process of creating the development WordPress mirror there were issues so I needed to disable all WordPress plugins via MySQL since at the time I could not login to the WordPress admin. Below I will describe listing all of the active plugins with one MySQL command and then disabling all of the plugins with another MySQL command.

Technology Insights

WordPress mysqldump Backup Corrupted Because of Blob Fields in Angsuman’s Translator Plugin Pro MySQL Tables

During a recent WordPress upgrade I was performing I noticed an issue with the mysqldump of the WordPress database which was causing the actual .sql file backup of the database to not read properly. After investigating I noticed that the atpp_page_cache table from Angsuman’s Translator Plugin Pro included Blob columns that were not dumping properly with the default mysqldump syntax as shown below.

bash

  1. mysqldump -u root -p databasename > db_backup_file.sql

Technology Insights

Upgrade PHP Version 5.1 to PHP Version 5.2 With Yum On a CentOS Server Running ISPConfig

I ran into some errors with my PHP modules on a CentOS server running ISPConfig to host web sites. I decided instead of in depth troubleshooting that it might be easier to go ahead and upgrade PHP since by default the yum package manager will limit you to PHP version 5.1 yet I knew that PHP version 5.2 had been out for a long time. What I needed to do was locate a yum repository that would allow me to upgrade PHP to version 5.2 using yum. The catch was to make sure that every necessary PHP module had an updated package available via the new yum repository. Below I describe upgrading PHP version 5.1 to PHP version 5.2 on CentOS running ISPConfig.