Thread: Re: [phpslash-users] strange error after restoring database from backups
Brought to you by:
joestewart,
nhruby
From: Luis M <le...@ho...> - 2003-05-13 01:22:25
|
My solution for this... connect to mysql and do: drop table CACHEDATA then from command line create a file .sql with just the information on how to build the cachedata table and : mysql -u USER -p DATABASE < cachedata.sql I hope that helps somebody out there > >This is the error I got presented with when doing a regular check on my own >website after restoring the site from a nightly backup: > >Database error: Invalid SQL: delete from CACHEDATA where CACHEKEY LIKE >"%-slashSess-3f74954be3f20e903ae3a1eeb7f7419d%" >MySQL Error: 1016 (Can't open file: 'CACHEDATA.MYD'. (errno: 145)) >Session halted. > > >I fixed it by deleting the cookies from Mozilla 1.3 related to my own site. >Should that error be, say, coming from phpslash.org (or even slashdot.org), >I would never thought that my own cookies had something to do with it. > >Something should be done to jpcache so that it can recover from this type >of errors by itself. And yes, I tried making $cachetimeout=-1 before >deleting the cookies. > >This is the first time I see this error, I just hope no other user who >regularly visits my website ever sees this. > >Any input on this subject? ----)(----- Luis Mondesi System Administrator LatinoMixed.com le...@ho... "...The Mac does this so smoothly, it feels like an extension of your mind." - Paula Speer, MacWorld Magazine 2003-04 Public signature: http://www.latinomixed.com/lems1/public-a.asc _________________________________________________________________ MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp |
From: Luis M <le...@ho...> - 2003-05-14 18:00:55
|
Since this error could happen easily, and the CACHEDATA is not that important, I was thinking we can have a "Repair CACHE table" button in the Admin page somewhere that basically drops the table and creates a new one (in one shot). what do you think ? of course, it would have to check if it has permissions for droping and creating tables first. And if not, then use a different user/password... (a la phpgroupware). >On Mon, May 12, 2003 at 08:48:46PM -0400, Luis M wrote: > > > > This is the error I got presented with when doing a regular check on my >own > > website after restoring the site from a nightly backup: > > > > Database error: Invalid SQL: delete from CACHEDATA where CACHEKEY LIKE > > "%-slashSess-3f74954be3f20e903ae3a1eeb7f7419d%" > > MySQL Error: 1016 (Can't open file: 'CACHEDATA.MYD'. (errno: 145)) > > Session halted. > > > >This indicates a corrupt table I think. ----)(----- Luis Mondesi System Administrator LatinoMixed.com le...@ho... "...The Mac does this so smoothly, it feels like an extension of your mind." - Paula Speer, MacWorld Magazine 2003-04 Public signature: http://www.latinomixed.com/lems1/public-a.asc _________________________________________________________________ MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp |