[mythtv-users] mysql error with mythweb

David Kyle 4of11 at comcast.net
Thu Mar 3 07:52:20 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.

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050303/68f5d7c3/attachment.htm


More information about the mythtv-users mailing list