Upgrade to 1.37.27 fails with error in post body
Posted: Thu Nov 03, 2022 2:34 pm
Hello, all;
There doesn't appear to be a Support topic for 1.37.x, so I'm posting here, let me know if this is the wrong place.
When I attempt to upgrade 1.37.25 to 1.37.27 (more on that confusion later), I receive the following message:
Anyway, does anyone have any suggestions as to how to work around the zm.Groups_Permissions problem?
Many thanks!
Regards,
TL
There doesn't appear to be a Support topic for 1.37.x, so I'm posting here, let me know if this is the wrong place.
When I attempt to upgrade 1.37.25 to 1.37.27 (more on that confusion later), I receive the following message:
My confusion stems from the fact that the first step (upgrade from 1.37.25 to 1.37.26) allegedly succeeds and the second step (1.37.26 to 1.17.27) fails due to the unexpected table; BUT when I attempt the upgrade again, it again starts with 1.37.25, so the first step in the last attempt didn't REALLY succeed? Maybe because the second step fails the whole transaction rolls back?Setting up zoneminder (1.37.27~20221103.0-bullseye) ...
detected systemd
Detected db service is mariadb.service
Checking for db
Db exists.
Updating permissions for user zmuser@localhost
Initiating database upgrade to version 1.37.27 from version 1.37.25
Upgrading database to version 1.37.27
Upgrading DB to 1.37.26 from 1.37.25
Database successfully upgraded to version 1.37.26.
Upgrading DB to 1.37.27 from 1.37.25
ERROR 1051 (42S02) at line 1: Unknown table 'zm.Groups_Permissions'
Output:
Command 'mysql --defaults-file=/etc/mysql/debian.cnf -hlocalhost zm < /usr/share/zoneminder/db/zm_update-1.37.27.sql' exited with status: 1
Error updating db.
Anyway, does anyone have any suggestions as to how to work around the zm.Groups_Permissions problem?
Many thanks!
Regards,
TL