[mythtv] DB Errors

[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 ?

--
John