[mythtv] DB Errors

[Carl Reynolds]

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
>
>------------------------------------------------------------------------
>
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.



.