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