[mythtv] Re: follow-up to mythfilldatabase/MySQL 5.0 problem

Mickey Chandler mickc at whizardries.com
Fri Sep 9 13:22:50 UTC 2005


At 03:52 PM 9/8/2005, toby cabot wrote:
 >I monkeyed around with it and my hypothesis is that "repeat" is now a
 >mysql keyword so it can no longer be used as a column name.

That is precisely the reason.  The list of reserved words is found here:

<<http://dev.mysql.com/doc/mysql/en/reserved-words.html>http://dev.mysql.com/doc/mysql/en/reserved-words.html> 
and includes "repeat".

My fix is documented 
here:http://mythtv.org/pipermail/mythtv-users/2005-May/088738.html 
.  I basically escape the reserved word using ` but for some reason 
never created a diff.

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: <http://www.whizardries.com>
Our new site: <http://www.my-debt-reduction-plan.com/> 




More information about the mythtv-dev mailing list