Page 1 of 1
1.31.26 can't delete events
Posted: Mon Jan 22, 2018 11:08 am
by 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.
Re: 1.31.26 can't delete events
Posted: Thu Jan 25, 2018 6:09 am
by 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
Re: 1.31.26 can't delete events
Posted: Thu Jan 25, 2018 2:01 pm
by 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.
Re: 1.31.26 can't delete events
Posted: Thu Jan 25, 2018 4:13 pm
by 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.
Re: 1.31.26 can't delete events
Posted: Fri Jan 26, 2018 6:21 am
by Eradicator
Thanks for answers! .19.sql update and all subsequent sql updates did solve that problem!
Re: 1.31.26 can't delete events
Posted: Fri Jan 26, 2018 6:11 pm
by iconnor
I found and fixed the issue in zm_create.sql. Future installs shouldn't have this problem.