Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Previous development branch now released as 1.36
Locked
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by bkjaya1952 »

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)
Attachments
zoneminder -master -error.txt
(762 Bytes) Downloaded 97 times
Last edited by bkjaya1952 on Thu Apr 15, 2021 11:42 am, edited 2 times in total.
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal

Post by DVB Hardware »

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
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal

Post by bkjaya1952 »

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

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal

Post by iconnor »

Just pushed a fix.
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by bkjaya1952 »

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



Screenshot from 2021-04-15 17-14-19.png
Screenshot from 2021-04-15 17-14-19.png (390.55 KiB) Viewed 3210 times
Attachments
zm_create.txt
(224.92 KiB) Downloaded 101 times
mhamel
Posts: 15
Joined: Thu Aug 10, 2006 8:37 am
Location: New Zealand

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by mhamel »

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
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by bkjaya1952 »

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/
dougmccrary
Posts: 1172
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by dougmccrary »

But now:

1.35.26~20210417163214-focal

- db upgrade fails.
Ran zmupdate manually failed.
Got it to work with the suggested mysql work-around.
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by bkjaya1952 »

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
dougmccrary
Posts: 1172
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by dougmccrary »

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.
User avatar
bkjaya1952
Posts: 282
Joined: Sat Aug 25, 2018 3:24 pm
Location: Sri Lanka

Re: Installation error in Zoneminder matser 1.35.26~20210413091429-focal [Solved ]

Post by bkjaya1952 »

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
Locked