Was adding a date from a service to MySql using PHP and needed something to convert the PHP string into something MySql could use for a DateTime field. This worked a treat: $reviewDateSql = date(‘Y-m-d H:i:s’,strtotime(“$reviewDate”));

Was looking at a WordPress install today on Windows. We had just installed the nice URL rewriter but new images, when clicked to their full size version were giving an error: HTTP Error 500.50 – URL Rewrite Module Error. Module RewriteModule Notification BeginRequest Handler StaticFile Error Code 0×80070005 At first I thought this was a problem with the URL Rewriter, however a bit of digging around showed it was a problem with Permissions. When WordPress [...]

Was on one of my Windows 2003 Server machines and trying to run Microsoft Update. However when running I was getting an error 0x800A1391 To fix I needed to do the following: Start Internet Explorer. On the Tools menu, click Internet Options. Click the Security tab, and then click Trusted Sites. Click Sites. Click to clear the Require server verification (https:) for all sites in this zone check box. In Add this Web site to [...]

After installing Google Sitemap Generator you might find you can’t log into the interface from your machine, if so Remote Login is probably disabled. To enable it open a bash prompt and enter in the following: /usr/local/google-sitemap-generator/bin/sitemap-daemon remote_admin enable

Had a problem today where a new website in Apache wasn’t showing in Google Sitemap Generator. Simple fix in the end, had to restart the service via the command line and up it came /usr/sbin/google-sitemap-generator-ctl service restart

To mount a Elastic Block Store to your EC2 Instance open up your AWS Console at https://console.aws.amazon.com Click on “Volumes” and right click on an available Volume. Then attach this to the instance you want to use. It will ask you for a device name, you are prob using Linux so choose one you aren’t using from /dev/sdf through to /dev/sdp (we are going to use /dev/sdf for the rest of this article) It will [...]

I was looking for a way to do daily and weekly backups from my EC2 Instances to Amazon’s fantastic S3 service. Finally worked out a way of getting it to all work, works pretty well if I say so myself To do this you will need to have set up a S3 account and got your key and secret handy. Step 1 – Download required Files I am using the S3 PHP class file from [...]

To restart Apache from the command line from a Amazon EC2 Instance simply type: /sbin/service httpd restart

Started having problems on my machine today where opening an application I got an Office 2007 installation window and then the error “Error 1907.Could not register font. Verify that you have sufficient permissions to install fonts, and that the system supports this font”