Category: Development

Google analytics: fix unsteady site speed charts

Some people wonder why their google analytics speed chart looks like  this although the server speed should be pretty continuous. Well, there is an easy explanation and a very easy fix for this.

Tagged with: , , ,

[solved] fancybox: Problems displaying jpe images

I noticed a weird problem when displaying jpe images using fancybox v1.3.4. Zooming in an image looks like this: Here is how to fix this: 

Tagged with: , , ,

Upgrade fancybox to version 2 (fancyBox2)

Because fancybox v1.3.4 seems to have problems with displaying jpe images and to keep things up to date I decided to update a website of one of my clients from fancybox v1.3.4 to v2.1.5. Here is what I needed to

Tagged with: , , , ,

MySQL: Duplicate record

Today I had to duplicate a record in a MySQL database. Of course the primary key  (which is AUTO_INCREMENT in my case) has to be unique. This is what I came up with:

Tagged with: ,

Import SQL data to MySQL database via console

Today I had to import a large amount of SQL data into an existing database. In detail I needed to import the latest ip2nation data into my wordpress database. Because the file has a lot of records managing the import

Tagged with: , , ,