Forums

migrating sites help?!

Permalink
after reconfiguring the new server we've got here, and tried to migrate a higher profile site to the new box

i'm getting these errors on _some_ of the pages
mysql error: [-32000: Cache write error] in CacheExecute(/path/to/concrete/files/cache/e7/adodb_e72bf67dc52b9ca5c05c1fa48763f1f9.cache, select cParentID from Pages where cID = '59')


i've disabled caching (before migrating) and clear the caches before migrating

linux box (both, running centOS) and latest stable concrete if that helps...
kutis
 
kutis replied on at Permalink Reply
kutis
seems to be adodb problem

if i try to login i got

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


if i take out the line 78 on /path/to/site/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php which has

throw new $errfn($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection);

the sites work except for the stats, i don't really mind that, but i'd really hate it if later there are other crucial part of the site that doesn't work because of it :(
ryan replied on at Permalink Reply
ryan
The caching system is trying to write to cache files but failing because of a permission problem.

you might as well delete all of the files within:
/files/cache/
Then check the permissions on your entire /files directory. All of the files need to be writable by the web server's user (typically apache or nobody).
kutis replied on at Permalink Reply
kutis
thankx ryan... the server guy fixed it. driving me nuts..
dekelly replied on at Permalink Reply
dekelly
A similiar error has just occurred very suddenly on a clients website. The site has been running without an issue for over a year.

All links from the top page yield this error;

An unexpected error occurred.

mysql error: [-32000: Cache write error] in CacheExecute(D:\Hosting\4503129\html/files/cache/77/adodb_7702f42e1bcdef858dc77018e17b219f.cache, select cParentID from Pages where cID = '58')

I have not yet called the provider. I was wondering what could have caused this to happen suddenly when the client says that no-one has administered the site or accessed the files on the server-side.