id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13516	Mysql 8.0 added system to reserverd words	jhavens1566	Bill Meek	"Therefore system needs backticks around it.

Github link is here: https://github.com/MythTV/mythtv/pull/188

This commit is for datadirect.cpp in libmythtv

Without it the following error occurs:

2019-11-19 23:06:44.154754 E  DB Error (programrating insert):
Query was:
INSERT IGNORE INTO programrating        ( chanid, starttime, system, rating) VALUES (?, ?,    ?,  ?)                                       
Bindings were:
:CHANID=2007, :RATING=""TV-G"", :START=2019-12-07T11:37:00.000Z, :SYS=""VCHIP""                                                                
No error type from QSqlError?  Strange...
2019-11-19 23:07:06.312067 E  Error preparing query: INSERT IGNORE INTO programrating        ( chanid, starttime, system, rating) VALUES (:CHANID, :START,    :SYS,  :RATING)
2019-11-19 23:07:06.312079 E  Driver error was [2/1064]:
QMYSQL3: Unable to prepare statement
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system, rating) VALUES (?, ?,    ?,  ?)' at line 1
"	Bug Report - General	closed	minor	31.0	MythTV - General	Master Head	medium	fixed	mysql datadirect.cpp		0