ERR - Can't insert event

connortechnology / ZoneMinder

ZoneMinder is a free, open source Closed-circuit television software application developed for Linux which supports IP, USB and Analog cameras.

http://www.zoneminder.com/

GNU General Public License v2.0

9 stars 9 forks source link

ERR - Can't insert event #78

Closed shaun-ba closed 5 years ago

shaun-ba commented 6 years ago

Another issue I've run into now with recording in Modect, can't insert events on 1.31.26

Can't insert event: Data truncated for column 'Scheme' at row 1. sql was (INSERT INTO Events ( MonitorId, StorageId, Name, StartTime, Width, Height, Cause, Notes, StateId, Orientation, Videoed, DefaultVideo, SaveJPEGs, Scheme ) values ( 1, 0, 'New Event', from_unixtime( 1516694165 ), 1920, 1080, 'Motion', 'Motion: All', 1, 1, 0, '', 0, '' ))

connortechnology commented 6 years ago

I've pushed a new version which should fix it. Please let me know.

shaun-ba commented 6 years ago

fixed!

connortechnology commented 6 years ago

You need to re-run update 17. mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.31.17.sql

shaun-ba commented 6 years ago

Works, but shouldn't this also check/update the DB in all subsequent versions?