I tried using the original SQL code to no avail hence the reason that I copied it from the site.

I just ran it from phpMyAdmin and success.

For the life of me I can't understand why it was happening, but all is now good.

Thanks for your help DarkAngel.