1.31.26 can't delete events

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

1.31.26 can't delete events

Post by Eradicator » Mon Jan 22, 2018 11:08 am

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: 37
Joined: Tue Jan 24, 2017 5:58 am

Re: 1.31.26 can't delete events

Post by Eradicator » Thu Jan 25, 2018 6:09 am

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: 503
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 1.31.26 can't delete events

Post by iconnor » Thu Jan 25, 2018 2:01 pm

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: 34
Joined: Thu Aug 17, 2017 3:55 am

Re: 1.31.26 can't delete events

Post by Alec » Thu Jan 25, 2018 4:13 pm

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
v 1.31.x on Ubuntu 16.04 server using LAMP
v 1.31.x on Ubuntu 16.04 server VM using LAMP

Eradicator
Posts: 37
Joined: Tue Jan 24, 2017 5:58 am

Re: 1.31.26 can't delete events

Post by Eradicator » Fri Jan 26, 2018 6:21 am

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

User avatar
iconnor
Posts: 503
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 1.31.26 can't delete events

Post by iconnor » Fri Jan 26, 2018 6:11 pm

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

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest