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 ? -- John _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
