[mythtv-users] A few MythTV issues

[Michael T. Dean]

On 08/01/2006 08:39 AM, morten.ronseth at webfx.no wrote:

>>I'm trying to set up MythTV with my Hauppauge PVR-150, but I'm having
>>a couple of problems:
>>
...

>>3.  The mythfilldatabase command fails spectacularly for me.  It
>>downloads the files without any issue, but then the terminal is
>>flooded with messages like this:
>>
>>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('SH7400760000','46172','2006-08-02T00:00:00','01:00:00',0,0,0,0,0,NULL,0,0,'2006-08-02T01: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
>>    
>>
>
>REPEAT is a reserved MySQL
>
5

> keyword. Bad DB design :-)
>  
>
because it didn't anticipate MySQL's adding a new keyword a year after 
the DB was designed.

(Note, MythTV developers are currently looking for a good quality 
crystal ball to replace their tea leaves.  Tarot cards will be 
considered if a crystal ball is not available.  Please let the list know 
if you have these or other similar-quality prognastication devices you 
would like to donate to the cause.)

>http://dev.mysql.com/doc/refman/5.1/en/repeat-statement.html
>

MySQL 5 is /only/ supported on 0.19-fixes and above.

Mike