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

[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 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

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

[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,
>  >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. 
>

> 
> 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

[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
>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.  

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

[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 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

[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 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

[mythtv-users] Mythfilldatabase error

[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 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