28 Dec

Unable to post message to http://googleads.g.doubleclick.net. Recipient has origin xxxx

Had this issue on one site when running Chrome and after much hunting did not find a documented solution. However I did manage to find and correct the issue after a little playing with my code.

The issue ended up being a totally unrelated

tag with a float left (it was a div around the breadcrumbs). This tag was used on other pages with ads with no issues, just one page had this problem. Unfortunately it was the template for the main part of the site so the ‘unable to post message’ issue had to be fixed.

To track down if a ‘float left’ is the cause of your problem try removing all CSS style sheets and see if the ads now start working.

Read the rest
15 Dec

WordPress How To Convert Tables to Innodb

Innodb tables are tables within MySQL that should be used instead of MyISAM for numerous reasons, the very least is that their transactional nature means they will not corrupt if you system has to reboot or lose power.

One of the problems is to change your tables from MyISAM to Innodb you need to run the following command:
ALTER TABLE YourDB.wp_posts ENGINE=InnoDB;
Once per table and that means lots of manual typing

I found a script that will create the list of tables for you:
SELECT CONCAT( 'ALTER TABLE `', table_schema, '`.`', table_name, '` ENGINE=InnoDB;' )
FROM information_schema.tables
WHERE ENGINE = 'MyISAM'
AND table_schema NOT
IN (
'information_schema', 'mysql'
)

Which outputs something like:
ALTER TABLE YourDB.wp_bad_behaviorRead the rest

02 Dec

DropBox High I/O Issue

DropBox is a miracle, allowing you to share files and keeping all your files up to date without the need to install a file server. This problem happened when I tried to install DropBox on a Windows Vista laptop – an old Dell Inspiration 620. The symptoms reported by the user were slow application response times since DropBox was installed.

I had a look and the machine had a few gigs of disk space but DropBox was stuck reporting ‘Downloading 10 files….’ though it never seemed to do anything.

I had a look at the Resource Monitor application and sure enough DropBox had really high read/writes and the hard disk was running at 100%.… Read the rest