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
zm_create.sql problem
Re: zm_create.sql problem
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.