[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.
Thanks,
-Nathan
Here's the diff:
libs/libmythtv/datadirect.cpp
177c177
<
"scheduletime,duration,repeat,stereo,subtitled,hdtv,"
---
>
"scheduletime,duration,`repeat`,stereo,subtitled,hdtv,"
417c417
< "subtitle, description, year, stars, repeat,
stereo, "
---
> "subtitle, description, year, stars, `repeat`,
stereo, "
620c620
< "duration time, repeat bool, stereo bool, subtitled bool, "
---
> "duration time, `repeat` bool, stereo bool, subtitled
bool, "
638c638
< "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