ZoneMinder Forums

I have tried to install ( fresh installation ) the latest release of Zoneminder master 1.35.26~20210413091429-focal & found the following mysql error





Detected db service is mysql.service
Checking for db
Creating zm db
ERROR 1136 (21S01) at line 793: Column count doesn't match value count at row 1
Error creating db.
dpkg: error processing package zoneminder (--configure):
installed zoneminder package post-installation script subprocess returned error
exit status 1
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
Processing triggers for systemd (245.4-4ubuntu3.5) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
Errors were encountered while processing:
zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

If you did a clean install then disregard the following:

My upgrade was fine Linux Mint 20.1 ZM 1.35.26~20210413091429-focal from previous version
also installed a kernel update

Jimmy

DVB Hardware wrote: ↑Tue Apr 13, 2021 7:30 pm If you did a clean install then disregard the following:

My upgrade was fine Linux Mint 20.1 ZM 1.35.26~20210413091429-focal from previous version
also installed a kernel update

Jimmy

The problem is in the fresh installation..There is no problem in upgrading from previous version.

Just pushed a fix.

iconnor wrote: ↑Wed Apr 14, 2021 5:07 pm Just pushed a fix.

Thank you Sir !.
Installation problem solved , after using your fix ( fix at the following link ) on the /usr/share/zoneminder/db/zm_create.sql ,

https://github.com/ZoneMinder/zoneminde ... e6c99192d0

I have just run into this myself: I'm afraid its not clear to me how to apply the fix. Do I edit zm_create_sql.in and retry the install, or can I pick up the change via git somehow?
Thanks,
Michael

mhamel wrote: ↑Sat Apr 17, 2021 3:54 am I have just run into this myself: I'm afraid its not clear to me how to apply the fix. Do I edit zm_create_sql.in and retry the install, or can I pick up the change via git somehow?
Thanks,
Michael

sudo su

add-apt-repository ppa:iconnor/zoneminder-master

apt update

apt -y install zoneminder

( Now you will see some error message ie Error: Process completed with exit code 100. )

Then go to the following Issac Connor's web link

https://github.com/ZoneMinder/zoneminde ... e6c99192d0

You can see the corrected lines within the green color block .

Open the file at /usr/share/zoneminder/db/zm_create.sql

sudo gedit /usr/share/zoneminder/db/zm_create.sql

Delete the 793 line of the opened file zm_create.sql .

Then copy Issac Connor's fix at above link marked in green color block and paste at line 793 and save.

Then configure zoneminder and apache as usual.

Please refer the following link for get more details

https://bkjaya.wordpress.com/2020/11/16 ... cal-fossa/

But now:

1.35.26~20210417163214-focal

- db upgrade fails.
Ran zmupdate manually failed.
Got it to work with the suggested mysql work-around.

mhamel wrote: ↑Sat Apr 17, 2021 3:54 am I have just run into this myself: I'm afraid its not clear to me how to apply the fix. Do I edit zm_create_sql.in and retry the install, or can I pick up the change via git somehow?
Thanks,
Michael

It is apparent that the Isaac Cooor's fix has already being included in the latest Zoneminder master 1.35.26~20210417163214-focal
Therefore it is not necessary to apply the fix manually

It is apparent that the Isaac Cooor's fix has already being included in the latest Zoneminder master 1.35.26~20210417163214-focal
Therefore it is not necessary to apply the fix manually

May be ok on fresh install, but upgrade fails now. At least for me.

dougmccrary wrote: ↑Sun Apr 18, 2021 8:03 am

It is apparent that the Isaac Cooor's fix has already being included in the latest Zoneminder master 1.35.26~20210417163214-focal
Therefore it is not necessary to apply the fix manually

May be ok on fresh install, but upgrade fails now. At least for me.

Hi dougmccrary,

Even for a fresh install of the above version, ZM will not work unless you drop the zm database & re create