zm_create.sql problem
Posted: Fri Oct 13, 2017 6:34 pm
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
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