id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
12962	Problem programming recording using Mythweb due to SQL error in 'datatime'	kmpatel@…	Stuart Auchterlonie	"Error is occurring when trying to schedule recording via Mythweb.  Specific conditions: distro is Ubuntu 16.04, mythtv is 2:0.28.0+fixes.20160413.15cf421-0ubuntu2, mysql is 5.7.16-0ubuntu0.16.04.1, mythconverg is 1344 migrated/upgraded from mythweb v0.27 (1317?)

In Mythweb, the following error is received:

''SQL Error: Incorrect datetime value: '00:00:00' for column 'next_record'
''


Specifically, line 348 of /usr/share/mythtv/mythweb/modules/tv/classes/Schedule.php has been coded (actually modified as compared to mythweb v0.28 in ubuntu 14.04) to use 00:00:00 as 'datetime' for 'next_record', 'last_record', and 'last_delete'. This produces the error.

When ./Schedule.php is modified to use NULL as datetime instead, Mythweb is able to schedule recording as normal.
"	Bug Report - General	closed	minor	0.28.1	Plugin - MythWeb	0.28.0	medium	Duplicate	mythweb, SQL, datetime, recording, scheduling		0