[mythtv-users] Mythfilldatabase error -- found

[Todd Vazquez]

--- Mickey Chandler <mickc at whizardries.com> wrote:

> At 02:55 PM 5/17/2005, I wrote:
>  >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
> 
> I think I found it.  I started running the statement
> one part at a time, 
> dropping the table, and then adding a new part.
> 
> mysql> CREATE TEMPORARY TABLE IF NOT EXISTS
> dd_schedule ( programid 
> char(12), stationid char(12), scheduletime datetime,
> duration time, repeat 
> bool);
> ERROR 1064 (42000): 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)' at line 1
> mysql> CREATE TEMPORARY TABLE IF NOT EXISTS
> dd_schedule ( programid 
> char(12), stationid char(12), scheduletime datetime,
> duration time, repeata 
> bool);
> Query OK, 0 rows affected (0.00 sec)
> 
> "repeat" appears to be a reserved 
> word. 
>
<http://dev.mysql.com/doc/mysql/en/reserved-words.html>
> 
> So, does anyone have any clues on how I might fix
> this?
> 
> 
> > _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 

What version of MySql are you running?  If I recall
correctly, temporary tables are not supported in MySql
3.23, the version that Myth has a dependency with.

Someone please correct me if I'm wrong here.

Fix?  Blow off the dependencies and upgrade MySql to
4.x (on my list of things to do) or recode/grab an
earlier version of mythfilldatabase.  Are you running
from CVS?  I haven't hit that problem, yet...

HTH,
-Todd


		
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail