Re: [mythtv-users] Mythfilldatabase error -- found

2005-05-17 Thread Mickey Chandler
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

Re: [mythtv-users] Mythfilldatabase error -- found

2005-05-17 Thread Todd Vazquez
--- 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, > >ste

Re: [mythtv-users] Mythfilldatabase error -- found

2005-05-17 Thread Mickey Chandler
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 >c

Re: [mythtv-users] Mythfilldatabase error

2005-05-17 Thread Mickey Chandler
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 goin

Re: [mythtv-users] Mythfilldatabase error

2005-05-17 Thread Karsten Jeppesen
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

[mythtv-users] Mythfilldatabase error

2005-05-17 Thread Mickey Chandler
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 TEMPORA