Cannot view recorded video clips

[snake61]

When selecting events, I do not get the usual list of events with clip. At the top of the page it's says: "An error has occurred and this operation cannot continue. For full details check your web logs for the code 'D56548'."

Don't know where to check web logs or how to resolve this. Help is greatly appreciated.

**NOTE: It appeared this started giving this error when there were a lot of events accumulated.

[cordel]

With out knowing what distro your on the web logs will be in either /var/log/httpd or /var/log/apache or /var/log/apache2

If you have a desktop installed you might very well have a log viewer as well to view and search the logs for that code to see the referenced error.

Beyond that I I know from this is apache sounds like it coughing about something, and that could be anything from a permission, drive issue, or even database problems.

[snake61]

found error.logXXXX in /var/log/apache2 This what it says:


"[Wed May 30 08:22:24 2012] [error] [client 127.0.0.1] SQL-ERROR(E4E601): Table './zm/Frames' is marked as crashed and last (automatic?) repair failed, referer: http://localhost/zm/index.php
[Wed May 30 08:22:50 2012] [error] [client 127.0.0.1] SQL-ERROR(B2002F): select * from Frames where EventId = '138639' and Score = '0' order by FrameId limit 0,1, referer: http://localhost/zm/index.php?view=filt ... xecuteCmd=
[Wed May 30 08:22:50 2012] [error] [client 127.0.0.1] SQL-ERROR(B2002F): Table './zm/Frames' is marked as crashed and last (automatic?) repair failed, referer: http://localhost/zm/index.php?view=filt ... xecuteCmd=
[Wed May 30 08:23:17 2012] [error] [client 127.0.0.1] SQL-ERROR(46E5C5): select * from Frames where EventId = '138639' and Score = '0' order by FrameId limit 0,1, referer: http://localhost/zm/index.php
[Wed May 30 08:23:17 2012] [error] [client 127.0.0.1] SQL-ERROR(46E5C5): Table './zm/Frames' is marked as crashed and last (automatic?) repair failed, referer: http://localhost/zm/index.php
[Wed May 30 08:24:37 2012] [error] [client 127.0.0.1] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /usr/share/zoneminder/includes/database.php on line 125, referer: http://localhost/zm/index.php?view=filt ... xecuteCmd=

Don't know what all that means or how to fix it.

Using Ubuntu 10.4, ZM 1.24.2

[snake61]

Purged all of the video files, but that did nothing, so I assume the DB was overloaded. Re-installed ZM, works fine, but I am sure there is a better way to do this, just haven't found it yet.