Category Archives: Web Development

Resolving Akismet on large existing Wordpress sites

I recently enabled Akismet on a client’s Wordpress site that had been running, and accumulating spam, for quite awhile.
Apparently there were so many spam messages (over 17,000!) that Akismet would hang with some kind of unreported out-of-memory condition.  There was nothing in the log files to indicate what might be causing the error.
The result was [...]

Scottsdale Wordpress meetup group

I just found the Scottsdale WordPress Meetup Group/ and am hoping to go to the next one… see you there…

phpBB upgrade error: group_skip_auth

Encountered this whilst attempting to upgrade phpBB using svn:
SQL ERROR [ mysql4 ]

Unknown column ‘g.group_skip_auth’ in ‘where clause’ [1054]

SQL

SELECT a.forum_id, a.auth_option_id, a.auth_role_id, a.auth_setting
FROM acl_groups a, user_group ug, groups g
WHERE a.group_id = ug.group_idAND g.group_id = ug.group_id
AND ug.user_pending = 0
AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1)
AND ug.user_id = 22

BACKTRACE
The [...]

Supporting multiple Wordpress installs

Here’s a little Perl script that uses some modules off CPAN to :

Find the names and document-root of each website configured on your server
Find the version of Wordpress (if any) for each website, and the Subversion repository version used (if any).
Sort these by name, owner UID, or Wordpress version

Rename the .pl.txt file to .pl, chmod [...]

Export only a Subset of Wordpress pages

In the process of splitting one existing Wordpress site (comprised mostly of hierarchically arranged Pages, not posts) I needed to export a batch of pages into the new one. Here’s how to modify your wp-admin/includes/export.php to do that.
First we find the ID number of the parent page that we want to export. This process [...]

Some useful Wordpress plugins

podPress – Podcast generator

EasyTube – YouTube Plugin for Wordpress

Subversion on Plesk-controlled subdomain

After much procastination and personal interuptions (you can tell, I haven’t been blogging that often lately) , I’ve managed to install Subversion running as a subdomain with Plesk 8.0 and CentOS 4.3…
rest of the story on Alex Le’s blog

Installing WordPress with Subversion

Source: http://codex.wordpress.org/Installing/Updating_WordPress_with_Subversion
To install a fresh copy of WordPress, type the following at your command prompt, starting from the directory above where you want to install WordPress. These commands will create a directory “blog” for your blog, and then check out (Subversion command “co”), or extract from the repository, the stable version of WordPress you have [...]

HTML 5

After almost eight years, a new version of HTML is in the offing.  HTML 5 promises to bridge much of the problems in writing content-based web pages with just HTML 4 and CSS.
Story at IBM

Arizona Rail site completely revised

I have completed the design and loaded much of the archival content into the new Arizona Rail Passenger Association website.