SQL error? plz help

Puun · Post by **Puun** » Thu Apr 17, 2008 1:12 pm

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?

Lee Sharp · Post by **Lee Sharp** » Thu Apr 17, 2008 5:04 pm

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

Puun · Post by **Puun** » Fri Apr 18, 2008 4:40 am

yes, you are right. they just pulled the plug

thx for the link, going to read it now

Puun · Post by **Puun** » Fri Apr 18, 2008 10:22 am

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

Post by **cordel** » Fri Apr 18, 2008 5:56 pm

Should be in one of your web logs (Apache) /var/log/http/

Lee Sharp · Post by **Lee Sharp** » Fri Apr 18, 2008 6:02 pm

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.

Post by **cordel** » Fri Apr 18, 2008 6:14 pm

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.

Lee Sharp · Post by **Lee Sharp** » Sun Apr 20, 2008 7:30 pm

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.

Puun · Post by **Puun** » Tue May 20, 2008 2:18 pm

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