Events records disappeared

[stonygate]

I have zoneminder installed under ubuntu server 20.10.
I have a problem with the registration methods.
Any mode used to record videos after a few moments are automatically removed.
To check that the videos are missing, I pointed the directory to an external disk, instead there are all the frames taken!
Can you help me?

[burger]

Events are handled by db, and on filesystem. If events are not on the filesystem (say you have incorrect hdd permissions) then they will not be accessible, but may show up in db. If events are not on db, but are on filesystem it could be a db issue. Check logs.

Any events that are not found on the filesystem will be deleted from db by zmaudit.pl when it runs. There are two ways zmaudit.pl can be run in options. I forget exactly what the difference is, but something to be aware of. The defaults are fine for most users.

And Ubuntu 20 has had some conflicting install talk on this forum. Some people have issues with it... Make sure you installed correctly. Buster doesn't have any such issues.

[stonygate]

hi, this is a log:

Code: Select all

SQL-ERR dbFetchAll no result, statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartDateTime`, date_format( StartDateTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY Id DESC limit 20'params: 1

Can is usefull?

[burger]

Ok, it looks like the query is failing. Have you tried any more troubleshooting to track down why that query failed?

Does the ZM db and the table its referencing exist per the query? https://wiki.zoneminder.com/MySQL Recreate db if necessary. Upgrade it if necessary.

[stonygate]

I have removed and reinstalled zoneminder to the latest version, including the database.
Unfortunately the problem still exists!

[burger]

Are you sure you removed the DB? Just uninstall ZM via apt-get might not remove the DB.

Regardless, you didn't specify which installation guide you followed. A common problem is that users did not install correctly or used an unsupported OS (for some reason, lots of folks want to use proprietary unraid, for example). I'd recommend
https://wiki.zoneminder.com/Ubuntu
and
https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.34.x

20.10 is not on that list so, unless you know what you are doing, you should use 20.04 or 18.04.

[stonygate]

hi and tnxs for you answers.
This is the guide i used to remove it viewtopic.php?t=26129
To install it again I used this https://wiki.zoneminder.com/How_to_Inst ... l_Fossa%29

Only the part concerning mysql I deliberately skipped;

Code: Select all

rm /etc/mysql/my.cnf
cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf

since I use mariadb already configured for other functions.
This is version of my ubuntu:

Code: Select all

 lsb_release -a                                                                                                
No LSB modules are available.                                                                                                      
Distributor ID: Ubuntu                                                                                                             
Description:    Ubuntu 20.04.1 LTS                                                                                                 
Release:        20.04                                                                                                              
Codename:       focal

[burger]

These are the install guides to use:
https://wiki.zoneminder.com/Ubuntu
https://wiki.zoneminder.com/Debian
and
https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.34.x

Not the one you linked.