[mythtv-users] mysql error with mythweb
Ryan Kremser
ryan.kremser at gmail.com
Thu Mar 3 06:56:07 UTC 2005
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.
More information about the mythtv-users
mailing list