So...I tried deleting cache, turning off cache locally before exporting my site to the production server and everything I can think of.

At the moment if I upload fresh to my server the front page works but none other, I try and login to admin and on first try I get an exception and then the site is reduced to this..

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [-32000: Cache write error] in CacheExecute(/usr/home/gwilym/public_html/amd/files/cache/2e/adodb_2e42e38b2ebe0d19604c599a38039d6a.cache, select ctID from PageTypes) ' in /usr/www/users/gwilym/amd/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /usr/www/users/gwilym/amd/concrete/libraries/3rdparty/adodb/adodb.inc.php(1819): adodb_throw('mysql', 'CacheExecute', -32000, 'Cache write err...', '/usr/home/gwily...', 'select ctID fro...', Object(ADODB_mysql)) #1 /usr/www/users/gwilym/amd/concrete/libraries/database.php(34): ADOConnection->CacheExecute(10, 'select ctID fro...') #2 /usr/www/users/gwilym/amd/concrete/models/permissions.php(461): Database->querycache(10, 'select ctID fro...') #3 /usr/www/users/gwilym/amd/concrete/models/permissions.php(72): CollectionPermissions->CollectionPermissions(Object(Page)) #4 /usr/www/users/gwilym/amd/concrete/models/permissions.php(116): PermissionsProxy::getNewOrCached(Object(Page), in /usr/www/users/gwilym/amd/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

This looks as if the permissions in one or both directories are set that your webserver cannot write to them:

/usr/home/gwilym/public_html/amd/files
/usr/home/gwilym/public_html/amd/files/cache

Check user and group ownership and try to set them as required (i.e. so that the webserver process can write to them).

I've run into this issue when moving a site from one host to another. Making sure your permissions are set correctly is easy to forget.