Re: [mythtv-users] LIRC serial help

2005-11-09 Thread Mickey Chandler

At 04:55 PM 11/9/2005, MacNean Tyrrell wrote:
I just bought one of those packard bell remote cheap off ebay. I'm 
having a problem getting it to work.  Here is the output if i run irw:


[EMAIL PROTECTED]:~# lircd --nodaemon
lircd 0.7.2: lircd(serial) ready
lircd 0.7.2: accepted new client on /dev/lircd
lircd 0.7.2: could not get hardware features
lircd 0.7.2: this device driver does not support the new LIRC interface
lircd 0.7.2: major number of /dev/lirc is 4
lircd 0.7.2: LIRC major number is 61
lircd 0.7.2: check if /dev/lirc is a LIRC device
lircd 0.7.2: caught signal
Terminated

(I have also install lirc with the packard bell option so the second 
line has that instead of (serial) but both do the same thing)

I do have ln /dev/ttyS0 /dev/lirc
I also have linked S1 to lirc0 and ran lircd with the device option 
to lirc0.  Can anyone help?


First, get rid of the symbolic links.  Then try using:

lircd --device=/dev/ttyS0 --nodaemon


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Guide disappeared and errors with mythfilldatabase

2005-11-08 Thread Mickey Chandler

At 11:10 PM 11/7/2005, Chris Cantrell wrote:
I am running FedoraCore 4, got everything working, including the
guide.  I was recording my first show in the Mac frontend and when I
was on the guide, suddenly all the information when to Unknown
(Unknown).  I tried to run mythfilldatabase and received the
following errors (pages of these).  I tried rebooting to clear up any
potential issues there and that did not help.  Any thoughts?  Thanks
in advance.

Which version of MySQL are you running?

The error, obviously, is saying that a temporary table can't be 
created.  In order to know more, we need better information on what 
you're running.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[mythtv-users] 2 DTV questions

2005-10-28 Thread Mickey Chandler
1)  Is anyone got something that will let me see the PPV listings?  I 
know there used to be a script, but it never worked for me and I'm 
pretty sure that I've seen here that its no longer maintained.


2)  Far more importantly to me, every once in a while my D10-200 
locks up.  This means that channels won't change, no picture is 
displayed, etc.  I can't even turn it off using the power button.  I 
have to actually unplug it from the wall and wait 30 seconds.  This 
doesn't happen very often, maybe twice in the last six or nine 
months, but when it happens I start looking for a problem with my 
normally very reliable Myth setup instead of the STB where I should 
be looking.  Am I alone in this or have others had this trouble too?


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] logfiles: where?

2005-10-25 Thread Mickey Chandler

At 02:24 PM 10/25/2005, [EMAIL PROTECTED] wrote:
1. I created a directory called /var/log/mythtv, and made sure that
mythtv has write permissions to it, and restarted several times, but
still there are no logs there.  Sorry if this is a dumb question but:
where are the mythtv logs supposed to be?

They're wherever you put them in the startup command using the -l option.

For example: /usr/local/bin/mythbackend -d -l /var/log/mythtv/mythbackend.log

2. live tv is not working ... I get a blank screen for a few seconds
and it returns to the menu.  This process seems to break the
connection between the frontend and backend (i.e., If I try to do
other things after attempting livetv, mythtv informs me that the
backend is not running or is improperly configured ).   Everything
else works great.  I've searched for other posts about this, but they
seem to address much earlier versions of myth or are otherwise
inapplicable (whole system crashes, for example).

Try to do a brief (1 minute) recording.  That seems to have fixed 
this annoyance for some people: 
http://www.gossamer-threads.com/lists/mythtv/users/126743


I think that this was something that cleared up for me after I 
started using the svn.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Mickey Chandler

At 04:54 AM 10/23/2005, Nick Rosier wrote:
What version of MySQL are you running?

I'm running 5.0.4-beta-standard

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Backend loses the database

2005-10-24 Thread Mickey Chandler

At 02:39 PM 10/24/2005, Lee Koloszyc wrote:
I didn't catch the beginning of this thread, but mythfilldatabase from
0.18.1 doesn't seem to work with MySQL 5.0.  It has something to do with
repeat being a keyword in the MySQL 5 I think.  I reverted back to 4
and everything worked again. Not sure if this is your problem.

My problem is that the backend loses touch with the database, not 
that it's not filling.


My fix is documented here: 
http://mythtv.org/pipermail/mythtv-users/2005-May/088738.html .  I 
basically escape the reserved word using `.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[mythtv-users] Backend loses the database

2005-10-21 Thread Mickey Chandler
I've had a peculiar problem pop up lately.  About once a day, my 
recorded programs listing goes away and starts reading No recorded 
programs available.  Restarting the back end gets the listing back.


The only error I'm seeing in the log is this:

2005-10-21 11:00:00.082 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Of course, the MySQL server hasn't gone away since restarting the 
backend (not the MySQL server) re-establishes that connection.


Any ideas?

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] directv d10-300 ... impossible?

2005-09-22 Thread Mickey Chandler

At 06:43 PM 9/21/2005, [EMAIL PROTECTED] wrote:
I've been using this script on my D10-200 box at least since
July.  There is an occasional snafu where the channel doesn't change
for some reason I haven't yet been able to track down, but I'm
recording Stargate SG-1, NFL Football, and the odd Buffy episode from
our OTA channels which DTV stuck  100.

Are you still seeing it with the Version 1.4 8/14/05?  That has a fix for
the above problem.

I just installed the new version yesterday (I noticed it when I 
retrieved the URL and went to check that the page was still live), so 
it will be some days before I can give an answer on this one.  I was 
noticing that it would happen on about 1 show in 150.


Does you D10-200 box lock up occasionally and need the power plug pulled
to get it working again?  I see it with both the box I am using with
mythtv and boxes that are on TV's.  Front panel power button won't do
anything when trying to turn it on.

No, I don't.  My Myth box locks up more often than the D10-200 does 
-- which is to say rarely to never.  My last Myth reboot because it 
locked up happened about a week ago and I go back a month and a half 
for the time before that.  I'm pretty sure that it was at least June 
since I last had to restart the D10-200 due to freezing.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Free debt reduction plans: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Various questions

2005-09-22 Thread Mickey Chandler

At 02:10 PM 9/22/2005, Kevin Kuphal wrote:
Video card.  Highly recommend nVidia card of some kind since ATI has
poor linux support.

Your mileage may vary on this one.  I'm using an ATI 9200 card in my 
Myth box and have had excellent results with livna keeping the ATI 
fglrx rpm package up to date with the kernel.  I'm running 
2.6.12-1.1447_FC4 and have a current fglrx build in place.


On the other hand, if you insist on compiling from source, then yes, 
I also thought that ATI was a bit slow off the blocks to start 
supporting the 2.6 kernels (although I think this was more of a 
problem with the changing to the newer GCC version than the kernel 
itself).  I will also note that if you're trying to go completely OSS 
with your Myth box then the ATI drivers aren't for you (as witnessed 
by the fglrx: module license 'Proprietary. (C) 2002 - ATI 
Technologies, Starnberg, GERMANY' taints kernel. line you'll find in 
dmesg after boot up).


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] directv d10-300 ... impossible?

2005-09-21 Thread Mickey Chandler

At 12:03 PM 9/21/2005, Erik Pettersen wrote:
Furthermore, has the whole D10 (regardless of 100/200/300) fixed the
unable to use serial cable for channels under 100 issue brought upon
by a recent DirecTV firmware update still an issue? (it even snared
the series 2 TiVo STB owners with that snafu/issue)

The issue has been fixed if you're using the script found at 
http://www.pdp8.net/directv/directv.shtml


I've been using this script on my D10-200 box at least since 
July.  There is an occasional snafu where the channel doesn't change 
for some reason I haven't yet been able to track down, but I'm 
recording Stargate SG-1, NFL Football, and the odd Buffy episode from 
our OTA channels which DTV stuck  100.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] about to take the plunge

2005-09-21 Thread Mickey Chandler

At 02:46 PM 9/21/2005, Erik Pettersen wrote:
I know this will probably get me boo'd  off the list... but are you
sure your stability problems stem from the software/OS?  Although I
think you'll find knoppmyth/MythTV to be very cool, but if you're
issue is really ends up to be heat related, or power related, or
something of that ilk... the symptom *may* follow you to linux/mythtv.

Not only that but it will get worse as time goes on.  If it's heat 
related the cost to fix it won't top $50 in most cases, and even 
getting a new huge power supply won't likely run you more than $150.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[mythtv-users] Backend losing the DB

2005-09-08 Thread Mickey Chandler
(All of the following, plus a screenshot are available at 
http://mickc.whizardries.com/index.cfm?objectID=3890A411-B571-2DD8-CFB0E84F47440305)


Sometimes when I finish watching a show on my MythTV box (running SVN 
r7200) I get what I can only describe as an error. It shows the 
titles of that are in the database along with Sorry, No Recordings 
Available.  I think I recall this happening all the way back to 
1.18.0, but not prior to that.


It seems to be that Myth's backend has lost touch with the database:

2005-09-08 20:57:26.171 Database not open while trying to load 
setting: JobQueueMaxSimultaneousJobs

2005-09-08 20:57:26.173 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2005-09-08 20:57:26.225 DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2005-09-08 20:57:26.283 DB Error (Error in JobQueue::GetJobs(), 
Unable to query list of Jobs in Queue.):

Query was:
SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, 
j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, 
j.comment, r.endtime FROM jobqueue j, recorded r WHERE j.chanid = 
r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime, j.chanid, j.id;

Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

Although why this would be is beyond me since the database is still up.

I would appreciate any insight that anyone would have about what is 
happening and how I might fix it.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Logical Volume (LVM) - question

2005-08-27 Thread Mickey Chandler

At 06:31 PM 8/27/2005, A JM wrote:
I need some help mounting this logical volume. The LVM existed prior 
to recent re-install of the OS, now I can't mount it? When doing the 
reinstall I left the LVM partition alone and am guessing that's 
where the problem lays. Does something need to be running in FC3 in 
order to recognize the the system has a LVM?


I think the problem is that you just left it alone during the 
reinstall.  I seem to recall that I had to edit it just to the extent 
of making sure that the mountpoint was declared, even though I told 
it not to reformat the partition.  If you just zipped through that 
part and made sure that / was declared it might be the source of your trouble.



--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[mythtv-users] Network control?

2005-08-25 Thread Mickey Chandler
I had a brainstorm the other day, and didn't notice any mention of it 
in the archives.


Has anyone thought of controlling a tv over the network, like through Mythweb?

My wife and I have 3 kids and we both work at home.  The Myth box is 
in our bedroom.  The kids are constantly interrupting us asking us to 
let them watch some show or another.  While we don't mind them 
watching Dora the Explorer or Tom  Jerry, it's a bit of a pain 
getting up and going to the bedroom to start the show. (They aren't 
allowed access to the keyboard or the [currently non-working] remote 
control after almost breaking them about a month ago.)  So I got to 
wondering if there was some way for us to start the show from our 
desks, or if we're kind of stuck getting up and running to the 
bedroom every couple of hours or so.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Network control?

2005-08-25 Thread Mickey Chandler

At 09:25 PM 8/25/2005, Andrew Ziobro wrote:
I use VNC to connect to the machine from my laptop.

Right.  I have VNC as well, but will that send output to the TV or 
does it ultimately act as an independent XWindows session.  Perhaps 
that's my answer and I'm just unclear on what VNC actually 
does.  Frankly, I'd love to be wrong this once and have the answer 
sitting at my fingertips.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Network control?

2005-08-25 Thread Mickey Chandler

At 09:27 PM 8/25/2005, Phill Edwards wrote:
Could take a look at MythWiFi.

I think that looks perfect for what I'm wanting.  I don't think I 
ever would have gotten to it without someone pointing it out.


Thanks!

--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
Our new site: http://www.my-debt-reduction-plan.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Zap2it question.

2005-08-22 Thread Mickey Chandler

At 12:52 PM 8/22/2005, Mark Gordon wrote:
 From what I have gathered Zap2it provides all the tv listings for the
US users of MythTV?

Not all of them.  I have DirecTV and they don't provide the PPV 
listings for us (even though they have them) because DTV has asked 
them not to.  That's not a complaint, just a clarification.


Is there is no cost of this service?

The only cost is a survey that you have to take every three 
months.  I think it's a pretty good trade-off for the amount of 
information we get in return.


I have heard that Zap2it includes some kind of advertising with the
data, is this true and if so is it obtrusive in anyway?

That might be the survey.  If they include any advertising it's so 
unobtrusive that I have never seen it.


--
Mickey Chandler
Chief Operating Whizard
Whizardries, Inc.: http://www.whizardries.com
My Blog: http://mickc.whizardries.com/blog 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Remove recordings that don't exist from database

2005-07-08 Thread Mickey Chandler

[EMAIL PROTECTED] wrote:


Hello everyone,
I was just wondering how I can truncate the database which holds the recordings
that myth ahs done. I removed the file by mistake and now the recordings screen
shows the recordings but the file does not exist thus being like a dead link.
any help would be appreciated.


touch /path/to/missing/filename

Then delete as usual.
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] PVR2000

2005-07-05 Thread Mickey Chandler

ian swanson wrote:

Does Mythtv work with Leadtek PVR2000- it has hardware mpeg2 encoding? 
It uses the cx88xx chips. Thanks. Ian


I thought that it should, but after trying to get it to work for a 
couple of weeks I gave up and got a Hauppauge 250.  I think I remembered 
seeing that it was on a list of cards that would not work with ivtv.

___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] Re: changechannel support for DirecTV tuner

2005-07-04 Thread Mickey Chandler

At 07:39 AM 7/4/2005, [EMAIL PROTECTED] wrote:
Is there a changechannel for DirecTV tuner anywhere?

http://www.pdp8.net/directv/directv.shtml

Let me add that this script works really well.  I got hit by the DTV 
firmware upgrade.  It took us a couple of weeks to figure out what 
went wrong as we only record 3 shows off of the local stations.


After moving to this script, I've only had a handful of channel 
change issues (for some reason it doesn't want to record one show off 
of RFD, although I can type the channel in from the keyboard and get 
there correctly).


If you're using DTV in your setup I highly recommend this script for your use.

--
Mickey Chandler
http://mickc.whizardries.com/blog
http://www.reproductivegeology.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


[mythtv-users] ...brought to you by the letter I

2005-07-03 Thread Mickey Chandler

This is a piece of oddity that I can't seem to figure out.

I recently got lirc working on my Myth box (cvs on an FC4 box) and 
have been trying to set up the lircrc file.  Things start just fine, 
but when I press any of the arrow keys while browsing the list of 
recorded programs I get a listing of all upcoming episodes and when 
I'm watching something (including LiveTV) pressing almost any button 
results in the OSD popping up instead of the desired action.


I know that I have lircd.conf right as irw shows what it 
should.  Adding quit to the end of a key configuration doesn't help either.


Here's an example key binding from lircrc:

# Arrow Up
begin
remote = MythTV
button = up
repeat = 20
prog = mythtv
config = Up
quit
end

(min_repeat is 18 according to irrecord, so I figured to go with 
20).  Any one have any ideas on what I'm doing wrong?


--
Mickey Chandler
http://mickc.whizardries.com/blog
http://www.reproductivegeology.com/ 



___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] TV won't play unless you run mythbackend manually from a console

2005-06-22 Thread Mickey Chandler
quote who=Michael Jones
 If I open a console window as root and run it manually:


 #mythbackend 


 everything works.  If I run it as a service and start live tv, the live
 tv screen shows up runs for about 1-2 sec and then freezes,  the system
 then waits about 60sec and then returns to the main menu by itself.

 Any ideas?

I hadn't thought about it with this difference, but it has been noted
before that sometimes you have to let a program record before you can
watch live tv.  I wouldn't think that starting it either as a service or
from the console should make a difference there, but your description of
1-2 sec viewing followed by freezing and a return to the menu sounds
awfully familiar.

When you start it as a service, are you creating a log file that might
tell you what error is there?


___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


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

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

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

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