zm_create.sql problem

Forum for questions and support relating to the 1.31.x releases only.
Locked
Alec
Posts: 52
Joined: Thu Aug 17, 2017 3:55 am

zm_create.sql problem

Post 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
DFU
Toasty
Posts: 5
Joined: Mon Mar 21, 2016 12:55 pm

Re: zm_create.sql problem

Post 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.
Locked