Web Development

WordPress Error: Unknown column ‘post_category’ in ‘field list’

by on Oct.24, 2012, under Linux, Web Development

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:

Share
Leave a Comment :, , , , , more...

Problems during Redmine 2 installation on Debian 6 (Squeeze)

by on Jun.11, 2012, under Web Development

I tried to install Redmine 2.0.2. on a Debian 6 (Squeeze) server and ran into some problems. Especially running the rake command was a bit tricky. Luckiliy I managed to fix it

My first output was:

$ rake generate_secret_token
(in /home/acy/domains/test/redmine)
rake aborted!
uninitialized constant Rake::DSL
/home/acy/domains/test/redmine/Rakefile:8
(See full trace by running task with --trace)

(continue reading…)

Incoming search terms:

Share
Leave a Comment :, , , , , , , , , more...

phpBB 3: How to Disable IP Logging

by on Feb.16, 2012, under Web Development

phpBB is an popular open-source bulletin board software written in PHP. It logs IP’s automatically and stores them in the database. It’s very important for security purposes, but if you have concerns about data privacy you can disable IP logging permanently. Please note that your apache is logging IPs also… (continue reading…)

Incoming search terms:

Share
4 Comments :, , , , , more...

How to Create a (Pretty) Pinterest Facebook Tab

by on Feb.15, 2012, under Web Development

Pinterest is gaining much popularity in the past few month and is growing faster than any other standalone site ever.
The connection between Pinterest and facebook is working pretty well so far, but despite the immense growth they haven’t released an official opportunity to embed your Pinterest profile as a tab on facebook yet. There are already some hacks out there which show how to embed your profile as a tab, but they are pretty ugly and look non-professional because the facebook canvas is narrower than the Pinterest profile. Anyhow a more professional and more appealing solution is to use the mobile version of your Pinterest profile instead of the normal version…

Below is a detailed step by step instruction how to add your Pinterest profile as a tab on facebook.  No coding skills required :) (continue reading…)

Incoming search terms:

Share
Leave a Comment :, , , , more...

How to get ‘Monthly Active Users’ of your Facebook Application

by on Dec.15, 2010, under Web Development

I’ll show you how to get the monthly active users of your Facebook application via FQL with the help of PHP…

Ehh wait, what’s FQL?

“Facebook Query Language, or FQL, enables you to use a SQL-style interface to query the data exposed by the Graph API. It provides for some advanced features not available in the Graph API, including batching multiple queries into a single call.”

More information: Facebook FQL reference
(continue reading…)

Incoming search terms:

Share
1 Comment :, , , , , , , , more...

Make the Tweetmeme Retweet Button (iframe) Transparent

by on Feb.14, 2010, under Web Development, Wordpress

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):

reweet button no transparency (continue reading…)

Incoming search terms:

Share
6 Comments :, , , , , , , more...

How to Use a Double Dash / Hyphen in WordPress

by on Feb.02, 2010, under Web Development, Wordpress

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:

Share
2 Comments :, , , more...

How to Create a MySQL Backup of a big Database

by on Feb.02, 2010, under Linux, Web Development

It’s not possible to create a backup from a MySQL database with phpMyAdmin which is bigger than 2 MB. If you are running MySQL on a Linux based system, try this: (continue reading…)

Incoming search terms:

Share
Leave a Comment :, , , , , , more...

How to Add Multiple Line Breaks in WordPress

by on Feb.02, 2010, under Web Development, Wordpress

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:

Share
1 Comment :, , , , , , , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!