Bogus Error upgrading DB

[apbb2]

Hi All,

Pulling my hair out trying to upgrade to 1.28 from 1.25.

Running the update, I am stuck on updating the mysql DB, but I should not even get this error as I have purged zone minder and rename the zm db to zmold.

When I run the install, it created a new DB called zm but still tried to upgrade it using zmupdate.pl

Below is my error:

sudo apt-get install -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 15 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up zoneminder (1.28.0-trusty) ...
Stopping ZoneMinder: Zoneminder already stopped

Bareword found in conditional at /usr/local/bin/zmupdate.pl line 159.
Bareword found in conditional at /usr/local/bin/zmupdate.pl line 348.

Initiating database upgrade to version 1.28.0 from version ZM_DYN_DB_VERSION

Upgrading database to version 1.28.0
Loading config from DB
Saving config to DB
Can't find upgrade from version 'ZM_DYN_DB_VERSION' at /usr/local/bin/zmupdate.pl line 968.
dpkg: error processing package zoneminder (--configure):
subprocess installed post-installation script returned error exit status 255
Errors were encountered while processing:
zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

I have run fixes galore including reset ZM_DYN_DB_VERSION to 1.28.0 thinking it will not bother trying an upgrade if it knows the db is correct.

Any help would be appreciated.

Thanks.

[knight-of-ni]

Try running zmupdate manually this way:
sudo zmupdate.pl --user=root --pass=<mysql_root_pwd> --version=1.25

and report back whether or not that worked

[knight-of-ni]

okay, wait.... I didn't see that you purged the database until now.

If the old zm 1.25 was installed from source, before you updated to 1.28, did you:
- run "make uninstall" from the original zm 1.25 source files?
- verify the old zm.conf file was deleted (check under /usr/local/etc)?
- verify there are no other stale files lying around under /usr/local?

Also, newer versions of zoneminder have different database permission requirements. Make sure your zmuser has the permissions: select,insert,update,delete,lock tables, and alter

[apbb2]

Thank you for all your help.

It seemed I got a little closer to fixing my issue but in the end I had to reinstall from scratch. There something definitely wrong because I started from source and then tried to switch to repository.

After all these years with ZM I am still a Ubuntu noob.

In the end this is probably the best solution, this way I know we are all set.

Thanks again.