ons 2005-11-16 klockan 17:24 +0000 skrev John Pullan: > On 16/11/05, Carl Reynolds <[EMAIL PROTECTED]> wrote: > > Karstyn McCoy wrote: > > > > > This is my first install of MythTV - so be kind! > > > Mandriva2006, > > > MythTV 0.18.2-0.7467.1.1.20060plf > > > PVR-250 > > > DishTV > > > MySQL5 > > > > > > When in mythtv-setup>Video Sources > > > I get this error in the console: > > > DB Error (Creating temporary table): > > > Query was: > > > CREATE TEMPORARY TABLE IF NOT EXISTS dd_schedule ( programid char(12), > > > stationid char(12), scheduletime datetime, duration time, repeat bool, > > > stereo bool, subtitled bool, hdtv bool, closecaptioned bool, tvrating > > > char(5), partnumber int, parttotal int, endtime datetime, INDEX > > > progidx (programid) ); > > > 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 bool, stereo bool, subtitled bool, hdtv bool, > > > closecaptioned bool, tvrati' at line 1 > > > > > > This goes on and on. > > > I have it configured to use a DataDirect connection. The username and > > > password are correct. > > > Obviously mythfilldatabase does not have chance! > > > > > > Any suggestions? > > > --Karstyn > > > > > > > > It looks to me as if you're using an older version of MySQL that doesn't > > recognize the BOOL type. I seem to remember that it was not implemented > > in MySQL until version 4.0 (I could be wrong). Either upgrade your MySQL > > server to a newer version or change the definitions of the BOOL field to > > TINYINT. > > > > Actually, I'd say the other way isn't repeat a keyword under MySql 5 ? >
Looks like it, yes. http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html /Oscar
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
