[mythtv-users] Problems with mythweb since atrpms 183 update.
Richard Shaw
hobbes1069 at gmail.com
Fri Mar 21 15:11:34 UTC 2008
I can't be sure but this seemed to happen after the 183 update from
atrpms (I'm running F8). Mythweb loads but if I try to go to the
listings page it gives me the header where it shows the currently
browsing and jump to but nothing else. Guide data seems fine in the
EPG. Also, when I try to do a search from the main search I get what
looks like a database error because it can't find 'people.name':
Fatal Error at /var/www/html/mythweb/objects/Database/Query/mysql.php, line 83:
SQL Error: Unknown column 'people.name' in 'where clause' [#1054]
Also near the bottom of the backtrace I noticed what looks like http
path problem:
[QUERY_STRING] => type=q&s=Reaper&search=Search
[REQUEST_URI] => /mythweb/tv/search?type=q&s=Reaper&search=Search
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv/search
[PATH_TRANSLATED] => /var/www/html/tv/search <---------
Shouldn't this be "/var/www/html/mythweb/tv/search" ?
[PHP_SELF] => /mythweb/mythweb.php/tv/search
Thanks,
Richard
Full backtrace:
Fatal Error at /var/www/html/mythweb/objects/Database/Query/mysql.php, line 83:
SQL Error: Unknown column 'people.name' in 'where clause' [#1054]
If you choose to submit a bug report, please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don't paste the whole thing into
the ticket).
Backtrace:
datetime: 2008-03-21 09:58:05 (CDT)
errornum: 256
error type: User Error
error string: SQL Error: Unknown column 'people.name' in 'where clause' [#1054]
filename: /var/www/html/mythweb/objects/Database/Query/mysql.php
error line: 83
==========================================================================
Backtrace:
file: /var/www/html/mythweb/objects/Database/Query/mysql.php
line: 83
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Unknown column 'people.name' in 'where clause' [#1054]
[1] => 256
)
file: /var/www/html/mythweb/objects/Database.php
line: 261
class: Database_Query_mysql
function: execute
type: ->
args: Array
(
[0] => Array ( )
)
file: /var/www/html/mythweb/includes/programs.php
line: 155
class: Database
function: query
type: ->
args: Array
(
[0] => SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
channel.callsign,
channel.channum
FROM program
LEFT JOIN programrating USING (chanid, starttime)
LEFT JOIN channel ON program.chanid = channel.chanid
WHERE program.chanid IN
(1031,2031,1032,2032,1051,2051,1052,2052,1053,2053,1101,2101,1102,2102,1131,2131,1141,2141,1241,2241,1301,2301,1302,2302,1405,2405,1501,2501,1502,2502,1503,2503)
AND (program.endtime > FROM_UNIXTIME('1206111485') AND
program.starttime < FROM_UNIXTIME('1208789885') AND program.starttime
!= program.endtime) AND (program.title LIKE '%Reaper%' OR
program.subtitle LIKE '%Reaper%' OR program.description LIKE
'%Reaper%' OR program.category LIKE '%Reaper%' OR people.name
LIKE '%Reaper%') AND (program.endtime >= NOW())
GROUP BY program.chanid, program.starttime, channel.callsign ORDER BY
program.starttime
)
file: /var/www/html/mythweb/modules/tv/search.php
line: 316
class:
function: load_all_program_data
type:
args: Array
(
[0] => 1206111485
[1] => 1208789885
[2] =>
[3] =>
[4] => (program.title LIKE '%Reaper%' OR program.subtitle
LIKE '%Reaper%' OR program.description LIKE '%Reaper%' OR
program.category LIKE '%Reaper%' OR people.name LIKE
'%Reaper%') AND (program.endtime >= NOW())
)
file: /var/www/html/mythweb/modules/tv/handler.php
line: 83
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/search.php
)
file: /var/www/html/mythweb/mythweb.php
line: 28
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/handler.php
)
==========================================================================
$_GET: Array
(
[type] => q
[s] => Reaper
[search] => Search
)
==========================================================================
$_SESSION: Array
(
[language] => English
[tmpl] => default
[skin] => default
[prefer_channum] => 1
[date_statusbar] => %a %b %e, %Y, %I:%M %p
[date_scheduled] => %a %b %e, %Y (%I:%M %p)
[date_scheduled_popup] => %a %b %e, %Y
[date_recorded] => %a %b %e, %Y<br />(%I:%M %p)
[date_search] => %a %b %e, %Y, %I:%M %p
[date_listing_key] => %a %b %e, %Y, %I:%M %p
[date_listing_jump] => %a %b %e, %Y
[date_channel_jump] => %a %b %e, %Y
[time_format] => %I:%M %p
[recorded_pixmaps] => 1
[guide_favonly] =>
[timeslot_size] => 300
[num_time_slots] => 36
[timeslot_blocks] => 3
[timeslotbar_skip] => 20
[max_stars] => 4
[star_character] => ♦
[list_time] => 1206110700
[recorded_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[] => Array ( )
[scheduled_recordings] => Array
(
[disp_scheduled] => 1
[disp_duplicates] => 1
[disp_deactivated] => 1
[disp_conflicts] => 1
)
[schedules_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search] => Array
(
[type] => q
[s] => Reaper
[ctype] => Array
(
[0] => movie
[1] => series
[2] => sports
[3] => tvshow
)
[stars_gt] => 0
[stars_lt] => 1
[starttime] => now
[endtime] => + 2 weeks
[as] => Array
(
[0] => Reaper
)
[af] => Array
(
[0] => Array
(
[0] => title
)
)
[aj] => Array
(
[0] => AND
)
[hd] =>
[commfree] =>
[airdate_start] =>
[airdate_end] =>
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[date_job_status] => %a %b %e, %Y, %I:%M %p
[show_popup_info] => 1
[show_channel_icons] => 1
[sortby_channum] => 1
[show_video_covers] => 1
[settings] => Array
(
[last] => Array
(
[0] => database
[1] => settings
)
)
[tv] => Array
(
[last] => Array
(
[0] => search
)
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => 192.168.0.4
[HTTP_USER_AGENT] => Mozilla/5.0 (X11; U; Linux x86_64; en-US;
rv:1.8.1.12) Gecko/20080208 Fedora/2.0.0.12-1.fc8 Firefox/2.0.0.12
[HTTP_ACCEPT] =>
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://192.168.0.4/mythweb/tv/list
[HTTP_COOKIE] => mythweb_id=pf43r27gibjn7umfpmsg15hac0
[PATH] => /sbin:/usr/sbin:/bin:/usr/bin
[SERVER_SIGNATURE] => <address>Apache/2.2.8 (Fedora) Server at
192.168.0.4 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.2.8 (Fedora)
[SERVER_NAME] => 192.168.0.4
[SERVER_ADDR] => 192.168.0.4
[SERVER_PORT] => 80
[REMOTE_ADDR] => 192.168.0.2
[DOCUMENT_ROOT] => /var/www/html
[SERVER_ADMIN] => root at localhost
[SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
[REMOTE_PORT] => 56922
[REDIRECT_QUERY_STRING] => type=q&s=Reaper&search=Search
[REDIRECT_URL] => /mythweb/tv/search
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] => type=q&s=Reaper&search=Search
[REQUEST_URI] => /mythweb/tv/search?type=q&s=Reaper&search=Search
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv/search
[PATH_TRANSLATED] => /var/www/html/tv/search
[PHP_SELF] => /mythweb/mythweb.php/tv/search
[REQUEST_TIME] => 1206111485
[STATUS] => 200
[URL] => /mythweb/tv/search
)
More information about the mythtv-users
mailing list