1.31.26 can't delete events

[Eradicator]

Hi!
There is an error in 1.31.26. When i want to delete any event i get an error:

Code: Select all

Can't execute 'DELETE FROM Events WHERE Id=?': PROCEDURE zm.update_storage_stats does not exist

When filter try to delete event same error.

[Eradicator]

1.31.28 still can't delete events!

Code: Select all

SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1305 PROCEDURE zm.update_storage_stats does not exist', statement was 'DELETE FROM Events WHERE Id = ?' params:248

[iconnor]

Looks like somehow you missed up 19.

do:

mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.31.19.sql

You want to do all the rest after that as well in case you missed something from them as well.

[Alec]

For what it is worth:

I did a fresh install in my test environment, and had the same problem. Re-running the .19.sql update and all subsequent sql updates did solve the problem.

[Eradicator]

Thanks for answers! .19.sql update and all subsequent sql updates did solve that problem!

[iconnor]

I found and fixed the issue in zm_create.sql. Future installs shouldn't have this problem.