[mythtv] DB Errors

Oscar Carlsson webmaster at trekotor.se
Wed Nov 16 12:47:39 EST 2005


ons 2005-11-16 klockan 17:24 +0000 skrev John Pullan:
> On 16/11/05, Carl Reynolds <mythtv-dev at hyperbole-software.com> 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



More information about the mythtv-dev mailing list