stuff24 blog

A few of my blogs I’m maintaining suffer from a load of senseless one-word comments. I tried to find a simple way to delete all wordpress comments containing only one word at once. This is what I did:

First log into phpmyadmin or login via command line to your mysql database. For safety reasons you should create a backup before you delete anything…
(continue reading…)

I wanted to move one WordPress installation from one server to another. Therefore I began with a clean WordPress and tried to import the wp_posts table via sql:

wordpress@t30700:~/public_html/dev/blog$ mysql -u wordpress -p*PASSWORD* --database=wp_blog < wp_blog.sql

Output:

ERROR 1054 (42S22) at line 2: Unknown column 'post_category' in 'field list'
ERROR 1054 (42S22) at line 2: Unknown column 'robotsmeta' in 'field list'

(continue reading...)

Incoming search terms:

• unknown column \post_category\ in \field list\
• error 1054 (42s22): unknown column \ in \field list\ wordpress
• error 1054 post_category wordpress
• select database error 1054 (42s22): unknown column in \field list\
• unknown column post_category in field list

The Internet Explorer (IE) is acting strange when it comes to transparency, for instance transparent iframes like the retweet button from tweetmeme. I’m using the great Tweetmeme Plugin for WordPress, but the problem with the transparency appears no matter which way of implementation you are using.

In IE 6, 7 and 8 it looks like this (ugly white background):

(continue reading…)

Incoming search terms:

• tweet button iframe
• iframe tweet button
• retweet iframe
• tweet button transparent
• retweet button transparent

This error appeared every time I wanted to install a theme automatically, even in the current version (2.9.1) of WordPress:

Downloading install package from http://wordpress.org/extend/themes/download/sample-theme.zip.
Unpacking the package.
Installing the theme.
Could not create directory. /var/www/html/web999/blog/wp-content/themes/sample-theme/
Theme Install Failed.

(continue reading…)

Incoming search terms:

• the package could not be installed pclzip_err_bad_format (-10) : unable to find end of central dir record signature
• wordpress Theme install failed
• Could not create directory Theme install failed
• Unpacking the package… Could not create directory
• theme install failed

This error appeared every time I wanted to install a plugin automatically, even in the current version (2.9.1) of WordPress:

Downloading install package from http://downloads.wordpress.org/plugin/sample-plugin.zip.
Unpacking the package.
Installing the plugin.
Could not create directory. /var/www/html/web999/blog/wp-content/plugins/sample-plugin/
Plugin Install Failed.

(continue reading…)

Incoming search terms:

• could not create directory
• wordpress Could not create directory
• wordpress plugin install failed
• Plugin install failed
• Could not create directory /wp-content

WordPress is converting two dashes, called double dash, (“–”) into a en dash (“–”) automatically. It’s possible to hack the formatting.php to prevent this, but this is much more easy: (continue reading…)

Incoming search terms:

• use of double dash
• when to use double dash
• how to use a double dash
• wordpress double dash
• when to use a double hyphen

WordPress strips / deletes automatically all <p> and <br> tags. If you want to have more than one line break, paragraph or spacing between two lines you’ll get problems. (continue reading…)

Incoming search terms:

• wordpress multiple line breaks
• wordpress enable line break
• wordpress enable line breaks
• multiple line breaks wordpress
• wordpress multiple breaks