ZM does not record.

[RadOD]

ZM does not record when set to record or any other mode.

Logs give following errors:

2017-10-17 12:49:12.543520 zmdc 1256 ERR 'zma -m 2' exited abnormally, exit status 84 zmdc.pl
2017-10-17 12:49:12.530102 zma_m2 21808 ERR Can't insert event: Field 'DefaultVideo' doesn't have a default value. sql was (insert into Events ( MonitorId, Name, StartTime, Width, Height, Cause, Notes, StateId, Videoed ) values ( 2, 'New Event', from_unixtime( 1508258952 ), 800, 600, 'Continuous', '', '1', '0' )) zm_event.cpp 78
2017-10-17 12:49:11.023280 zmdc 1256 ERR 'zma -m 1' exited abnormally, exit status 84 zmdc.pl
2017-10-17 12:49:11.009295 zma_m1 21805 ERR Can't insert event: Field 'DefaultVideo' doesn't have a default value. sql was (insert into Events ( MonitorId, Name, StartTime, Width, Height, Cause, Notes, StateId, Videoed ) values ( 1, 'New Event', from_unixtime( 1508258951 ), 800, 600, 'Continuous', '', '1', '0' )) zm_event.cpp 78


Any advice on what I have setup wrong? Viewing cameras works fine.

[bbunge]

Linux distro and version please.
Version of Zoneminder you are testing...

[RadOD]

ARMBIAN 5.33 stable Ubuntu 16.04.3 LTS 4.4.88-rockchip

ZoneMinder Console - Running - default v1.31.1

[clisthenes]

Hi there,

The issue here is that you need to set the sql-mode to NO_SUBSTITUTION in your MySQL configuration file. Specifically, you will want to add this line to the "[mysqld]" section of your configuration file: sql-mode = NO_ENGINE_SUBSTITUTION
For my installation under Ubuntu, for example, it is /etc/mysql/my.conf (as also per the ZoneMinder installation instructions).

Once you've added the line, make sure to stop ZoneMinder (sudo service zoneminder stop), restart MySQL (sudo service mysql restart), and then start ZoneMinder again (sudo service zoneminder start), and you should be good to go! When you restart MySQL, there should be no errors. If there are, you may need to adjust your config in case there is a typo, and try restarting again.

Hope this helps.

Cheers,
Ben

[rockedge]

I installed zoneminder_1.31.9~20171019175743-xenial_i386.deb and set the storage area and fixed some stray directory permissions and I can stream the cameras and see the them. I can not Force and event at all but when set to Modect the active zone(s) will initiate an event recording. What happened to the "Stills" viewer option in the event playback window?

Distro : Puppy Linux Xenial 7.0.6 (Ubuntu binaries)
Linux Kernel: 4.9.13 (i686)
Kernel Version: #1 SMP PREEMPT Thu Mar 9 09:27:40 GMT 2017
PAE Enabled: No

Database : 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04

[dhenzler]

What affect if any does sql-mode to NO_SUBSTITUTION have on other apps. I'm doing several other that depend on php and mysql. I run wordpress and cloud software

System: Host: Minty-18 Kernel: 4.8.0-53-generic x86_64 (64 bit gcc: 5.4.0)
Desktop: Cinnamon 3.4.6 (Gtk 3.18.9-1ubuntu3.3)
Distro: Linux Mint 18.2 Sonya
Machine: Mobo: ASUSTeK model: M5A78L-M LE/USB3 v: Rev X.0x
Bios: American Megatrends v: 0211 date: 04/16/2015
CPU: Triple core AMD FX-6350 Six-Core (-HT-MCP-) cache: 6144 KB
flags: (lm nx sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3 svm) bmips: 23505
clock speeds: max: 3900 MHz 1: 2000 MHz 2: 1400 MHz 3: 1400 MHz
4: 2000 MHz 5: 1400 MHz 6: 3600 MHz
Graphics: Card: NVIDIA GK208 [GeForce GT 630 Rev. 2] bus-ID: 01:00.0
Display Server: X.Org 1.18.4 drivers: nouveau (unloaded: fbdev,vesa)
Resolution: 1920x1200@59.95hz
GLX Renderer: Gallium 0.4 on NV108
GLX Version: 3.0 Mesa 17.0.7 Direct Rendering: Yes
Audio: Card-1 NVIDIA GK208 HDMI/DP Audio Controller
driver: snd_hda_intel bus-ID: 01:00.1
Card-2 Advanced Micro Devices [AMD/ATI] SBx00 Azalia (Intel HDA)
driver: snd_hda_intel bus-ID: 00:14.2
Sound: Advanced Linux Sound Architecture v: k4.8.0-53-generic
Network: Card-1: Realtek RTL8111/8168/8411 PCI Express Gigabit Ethernet Controller
driver: r8169 v: 2.3LK-NAPI port: e800 bus-ID: 02:00.0
IF: enp2s0 state: up speed: 1000 Mbps duplex: full mac: <filter>
Card-2: Qualcomm Atheros AR5212/5213/2414 Wireless Network Adapter
driver: ath5k bus-ID: 04:05.0
IF: wlp4s5 state: down mac: <filter>
Drives: HDD Total Size: 480.1GB (15.3% used)
ID-1: /dev/sda model: Corsair_Force_LE size: 240.1GB
ID-2: /dev/sdb model: PNY_CS900_240GB size: 240.1GB
Partition: ID-1: / size: 204G used: 54G (28%) fs: ext4 dev: /dev/dm-0
ID-2: /boot size: 472M used: 67M (15%) fs: ext2 dev: /dev/sdb1
ID-3: swap-1 size: 17.16GB used: 0.00GB (0%) fs: swap dev: /dev/dm-1
RAID: No RAID devices: /proc/mdstat, md_mod kernel module present
Sensors: System Temperatures: cpu: 29.0C mobo: 27.0C gpu: 34.0
Fan Speeds (in rpm): cpu: 1790 sys-1: 0
Info: Processes: 229 Uptime: 11:19 Memory: 1433.6/16029.4MB
Init: systemd runlevel: 5 Gcc sys: 5.4.0
Client: Shell (bash 4.3.481) inxi: 2.2.35