Page 1 of 1
SQL error? plz help
Posted: Thu Apr 17, 2008 1:12 pm
by Puun
after several days of normal registering of events I got names for all events as "new event" instead of "event %" and duration and so on marked as 0 length.
When I click to see the even I get a messege to check my web logs for a specifical number of an error - another for every event.
I looked up in apache log and what i see is "table .zm/Frames is marked as crashed and should be repaired"
what can/should I do about it and waht is it?
Posted: Thu Apr 17, 2008 5:04 pm
by Lee Sharp
I am betting you had an unplanned reboot. This often results in a broken events table.
http://www.zoneminder.com/wiki/index.ph ... atabase.3F
Posted: Fri Apr 18, 2008 4:40 am
by Puun
yes, you are right. they just pulled the plug
thx for the link, going to read it now
Posted: Fri Apr 18, 2008 10:22 am
by Puun
still after auto repair all tables in MySQL
when trying to see the new event:
An error has occurred and this operation cannot continue.
For full details check your web logs for the code 'CE654E'
in zmaoudith log
04/18/08 12:57:56.245527 zmaudit[3286].FAT [Can't execute: Table './zm/Frames' is marked as crashed and should be repaired]
can any one plz tell me where I should read the relevant error messages at all? as I cant even find that error code in my logs
Posted: Fri Apr 18, 2008 5:56 pm
by cordel
Should be in one of your web logs (Apache) /var/log/http/
Posted: Fri Apr 18, 2008 6:02 pm
by Lee Sharp
I seen this one... Your database is still crashed. Repair all the tables 2 more times. I know it sounds odd, but it has worked for me both times I have seen it.
Posted: Fri Apr 18, 2008 6:14 pm
by cordel
Yes and as Lee states, it some times takes several runs before all the issues in the database are repaired. It well documented as well on MySQLs site.
Posted: Sun Apr 20, 2008 7:30 pm
by Lee Sharp
Yeah... But reading MySQL documentation reminds me of a Andrew Dice Clay line from Ford Fairlane about conversation with Zuzu Petals, and doing something with a cheese grater. (Do not google this line from work! Way non-PC, and NWS) It is less than pleasant.
Posted: Tue May 20, 2008 2:18 pm
by Puun
thx for your help guys,
I could manage it using phpmyadmin
but still I know what I did wrong now: I hadnt stopped mysql before trying to correct the tables. You dont have to stop it using myphpadmin though.
one more question then
as this error appears again and again have you an idea what can I add to cron to check the tables every day?
thx in advance