[mythtv-users] mythfilldatabase, Gentoo, Mysql woes

[Marc Tousignant]

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Andy Pflueger
> Sent: Monday, February 06, 2006 8:06 AM
> To: Discussion about mythtv
> Subject: [mythtv-users] mythfilldatabase, Gentoo, Mysql woes
> 
> 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,cl
> osecaptioned,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,cl
> osecaptioned,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,cl
> osecaptioned,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,cl
> osecaptioned,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

Gentoo has not marked MYSQL 5.x as stable yet so you are either running an
unstable system or you wanted the newest MYSQL installed and placed in in
your package.keywords file.

I would recommend using the stable version of MYSQL. On my gentoo system
this is mysql-4.0.25-r2. This will eliminate any issues you are having.
If you have any databases under 5.x that you need I would recommend backing
them up before downgrading as I am not sure what will happen when you
downgrade.