Archive for November, 2007

Using Flock to Update this Blog

Friday, November 16th, 2007

I’m using flock to update this blog post. Remarkable easy so far…

This is part of a little bit of research on our part, where we are playing with various tools to see if we can make it easier for novices to post on their blogs - we are talking here about people who may not have known what a blog is until we introduced them to it.

PHP Fcgi Woes!

Monday, November 12th, 2007

Just uploaded a new PHP script to our web server and got this:

Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’ in /usr/local/psa/home/vhosts/xxx/httpdocs/xxx on line 37

The new file is PHP5, the web server is running PHP4.xx.

(more…)

SQL2005 Shrink Transaction Logs

Sunday, November 11th, 2007

There are a lot of articles to be found on this subject but here is a condensed procedure:

Your SQL transaction log is too big and you need to shrink it before SQL server explodes through lack of disk space:

  1. Back up your database - optional but a good idea as you are about to invalidate your transaction log backup history (more…)

SQL2005 backup of the file or filegroup is not permitted because it is not online

Sunday, November 11th, 2007

While trying to backup a SQL database using Microsoft SQL server management studio the following error occurs:

Microsoft SQL Server Management Studio
——————————

Backup failed for Server ‘ServerName’. (Microsoft.SqlServer.Smo) (more…)