[mythtv-users] mysql error with mythweb

[Ryan Kremser]

Yes thats exactly what i did although i don't know how the disk was
actually full.  I did search google but nothing came up so sorry about
reasking an obvious question. As for the free space i'm confused, i
deleted a recording and started mythbackend (the disk space prevented
this as well as I realized afterwords) i went into mythweb and it was
working again but under recorded programs it said that there was onlky
3.7 gigs avaliable with 2 recordings taking up 3.8 gigs.  First of all
doesn't make sense as i have a 200 gig hd.  I actually changed on
thing which could have caused this but it was a work around which
hopefully someone has a better solution for.  Prevously i was trying
to download videos from mythweb onto my windows computer for viewing. 
It resulted in website not there page.  I was told to change the
locations of my recordings through mythtv-setup so i changed it to the
/var/mythtv/www/video_dir/  (close to this not quite exactly sure as
i'm not at home at the moment).  I don't know if this was intended by
the change location of where recordings were stored but it worked and
i was happy.  It was prevously /dev/video which i now think its
actually supposed to be but how can i work around the problem with
downloading from mythweb then.  Thanks in advance.


On Thu, 03 Mar 2005 08:35:51 -0800, Chris Petersen
<lists at forevermore.net> wrote:
> > When I get that error, it means my disk is full.  That's the only time
> > I've gotten that.  If your disk isn't full... I don't know what the
> > problem is.
> 
> could also mean that the disk *was* full (or something else) and the
> table got corrupted.  In any case, googling for the error string will
> produce better/faster results than asking here.
> 
> -Chris
> 
> > Ryan Kremser wrote:
> >
> >> Hello, somewhat of a newbie and was looking for help.  when i go to
> >> mythweb i get an error saying
> >>
> >> Fatal Error at /usr/share/mythtv/mythweb/includes/programs.php, line 138:
> >> SQL Error: Got error 28 from table handler
> >>
> >> The system administrator has been notified and the problem will be
> >> remedied shortly.
> >>
> >> and then at line 138 this is what resides
> >>
> >>
> >>    131                      .' AND program.starttime !=
> >> program.endtime)';
> >>    132     // The extra query, if there is one
> >>    133         if ($extra_query)
> >>    134             $query .= ' AND '.$extra_query;
> >>    135     // Group, sort and query
> >>    136         $query .= ' GROUP BY program.chanid, program.starttime
> >> ORDER BY
> >> program.starttime';
> >>    137         $result = mysql_query($query)
> >>    138             or trigger_error('SQL Error: '.mysql_error(), FATAL);
> >>    139     // No results
> >>    140         if (mysql_num_rows($result) < 1) {
> >>    141             mysql_free_result($result);
> >>    142             return NULL;
> >>    143         }
> >>    144     // Load in all of the programs (if any?)
> >>    145         global $Scheduled_Recordings;
> >>    146         $these_programs = array();
> >>    147         while ($data = mysql_fetch_assoc($result)) {
> >>    148             if (!$data['chanid'])
> >>
> >>
> >> Thanks for any help. I'm still trying to feel my way around this so
> >> thanks in advance.
> >>
> >>
> >> ------------------------------------------------------------------------
> >>
> >> _______________________________________________
> >> mythtv-users mailing list
> >> mythtv-users at mythtv.org
> >> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >>
> >>
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>