Hi SCstreaming,
Many thanks for the SQL file it worked a treat, now the odd thing is we upgraded to PHP 5.3 sometime ago as part of the ASL 2.0 daily updates from the Atomic repo.
Now having the CLI interface error fixed I seem to have hit another one regarding my licence.
ERR This installation of Centova Cast is using an expired license key. Please contact an administrator for assistance. .
I had tried the re-issue license which works for a few hours so used the licenseupdate.php script and entered my license key and run the appropriate SSH command given which seems to have sorted it all out.
This must be something to do with me trying Beta V3 and somehow screwing up my license when I reissued it to try out V3, thought I would just mention it encase other find they are in the same position as I was.
Many thanks again for your swift reply and great support.