Page 1 of 1

zm_create.sql problem

Posted: Fri Oct 13, 2017 6:34 pm
by Alec
I am just installing a test 1.31.9 version from: ppa:iconnor/zoneminder-storageareas on Ubuntu 16.04 with MYSQL (default lamp install).
FWIW, I followed the excellent "easy way" instructions exactly.

When I ran zm_create.sql, I got the following error:

ERROR 1136 (21S01) at line 603: Column count doesn't match value count at row 1

I edited the values in line 603 to:

VALUES (NULL, '/var/cache/zoneminder/events', 'Default', 'local')

This seems to have solved the problem, and Zoneminder seems to have installed successfully, but I don't have time right now to proceed with my testing . . .

Thanks,

Alec

Re: zm_create.sql problem

Posted: Sun Nov 19, 2017 1:43 am
by Toasty
That PPA is "bleeding edge" so errors like this are likely to crop up from time to time. I submitted a pull request which fixes this on Oct 15th which has since been merged.