1.31.26 can't delete events

Forum for questions and support relating to the 1.31.x releases only.
Locked
Eradicator
Posts: 41
Joined: Tue Jan 24, 2017 5:58 am

1.31.26 can't delete events

Post 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.
Eradicator
Posts: 41
Joined: Tue Jan 24, 2017 5:58 am

Re: 1.31.26 can't delete events

Post 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
User avatar
iconnor
Posts: 2882
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 1.31.26 can't delete events

Post 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.
Alec
Posts: 52
Joined: Thu Aug 17, 2017 3:55 am

Re: 1.31.26 can't delete events

Post 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.
DFU
Eradicator
Posts: 41
Joined: Tue Jan 24, 2017 5:58 am

Re: 1.31.26 can't delete events

Post by Eradicator »

Thanks for answers! .19.sql update and all subsequent sql updates did solve that problem!
User avatar
iconnor
Posts: 2882
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 1.31.26 can't delete events

Post by iconnor »

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