[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