[mythtv-users] mysql error with mythweb

Chris Petersen lists at forevermore.net
Thu Mar 3 16:35:51 UTC 2005


> 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


More information about the mythtv-users mailing list