[mythtv-users] Mythfilldatabase error
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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mythfilldatabase error
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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mythfilldatabase error
At 03:44 PM 5/17/2005, Karsten Jeppesen wrote: Did you remember to initialize the database? Yes. I've even destroyed the database and restarted three different times. This is causing it's own problems since either Myth or Qt-MySQL is using the old mysql password scheme and this necessitates going in manually and resetting the password using the old_password function (something I forgot to do the first time through). ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mythfilldatabase error -- found
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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mythfilldatabase error -- found
--- Mickey Chandler [EMAIL PROTECTED] 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@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 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mythfilldatabase error -- found
At 07:40 PM 5/17/2005, Todd Vazquez wrote: 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. I'm using MySQL 5.0.4-beta-standard installed using RPMs from MySQL. What I ended up doing was using ` around each instance of repeat (`repeat`) that I found in datadirect.cpp (and it took me a very long time to find that this was the file I was looking for). I'm still getting an error: QString::arg(): Argument missing: INSERT INTO dd_v_station (stationid, callsign, stationname, affiliate, fccchannelnumber, channel, channelMinor) SELECT dd_station.stationid, callsign, stationname, affiliate, fccchannelnumber, channel, channelMinor FROM dd_station, dd_lineupmap WHERE ( (dd_station.stationid = dd_lineupmap.stationid) );, DITV625:- but this error isn't causing the database to not fill. Now I only have to deal with the fact that I have sound but only a blue screen for video. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users