[mythtv-users] mythfilldatabase, Gentoo, Mysql woes

[Andy Pflueger]

Hi,

I've recently just installed mythtv on my Gentoo box which is running
Mysql 5.0.16 and am getting several INSERT INTO SQL errors as follows.
I've Googled for a solution but have yet ot come up with a real
solution to resolve this problem. Anybody else out there run into this
on Mysql 5.x and Mythtv 0.18.1-r2. One solution I've found references
the fact that "repeat" is a reserved word in Mysql and also by
changing all references in DataDirect.cpp to "repeata" but I'm not
sure where DataDirect.cpp is located on the Gentoo ebuild of Mythtv.
Any ideas?

TIA,
Andy

...
DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule
(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
VALUES('SH7749440000','10139','2006-02-06T03:00:00','00:30:00',0,0,0,0,0,NULL,0,0,'2006-02-06T03:30:00');
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
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 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim'
at line 1

DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule
(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
VALUES('SH4241780000','10139','2006-02-06T03:30:00','00:30:00',0,0,0,0,0,NULL,0,0,'2006-02-06T04:00:00');
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
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 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim'
at line 1

DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule
(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
VALUES('SH7980480000','10139','2006-02-06T04:00:00','02:00:00',0,0,0,0,0,NULL,0,0,'2006-02-06T06:00:00');
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
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 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim'
at line 1

DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule
(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
VALUES('SH1598930000','10139','2006-02-06T06:00:00','03:00:00',0,0,0,0,1,NULL,0,0,'2006-02-06T09:00:00');
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
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 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim'
at line 1
...

--
The Linux philosophy is 'Laugh in the face of danger'.
Oops. Wrong One. 'Do it yourself'. Yes, that's it.
Linus Torvalds