[mythtv] Datadirect error with MySQL 5.0

Nathan J. Robinson nrobins at freethelaplandsix.com
Sat Jan 7 02:01:18 UTC 2006

Is it possible to quote the word "repeat" using backquotes insite the
SQL statements in datadirect.cpp?  "repeat" is a reserved word in MySQL
5 and it's causing me to have to edit libmythtv and recompile everytime
a new version is released.

Here's the diff:

<                        "subtitle, description, year, stars, repeat,
stereo, "
   >                        "subtitle, description, year, stars, `repeat`,
stereo, "
<             "duration time, repeat bool, stereo bool, subtitled bool, "
   >             "duration time, `repeat` bool, stereo bool, subtitled
bool, "
<             "previouslyshown tinyint, repeat bool, stereo bool, "
   >             "previouslyshown tinyint, `repeat` bool, stereo bool, "

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5347 bytes
Desc: S/MIME Cryptographic Signature
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060106/8de27030/smime.bin

More information about the mythtv-dev mailing list