[mythtv-users] Mythfilldatabase error

Karsten Jeppesen karsten at jeppesens.com
Tue May 17 20:44:03 UTC 2005


Did you remember to initialize the database?

mysql < /usr/share/doc/mythtv*/database/mc.sql

Karsten




Mickey Chandler wrote:

> I'm trying to build a .18.1 box from sources and have gotten 
> everything in place, I think.
>
> Unfortunately for me, mythfilldatabase is giving an error and 5 hours 
> of scouring the web hasn't turned up any answers for me regarding this:
>
> 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, closecaptio
>
>
> Since mythtv-setup worked perfectly for me I don't think it's that I'm 
> using MySQL 5.0.4-beta-standard for the database.  So, that leaves 
> syntax, but this looks right to me.
>
> Does anyone have any clues here?
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>



More information about the mythtv-users mailing list