Ticket #3848: bug.txt

File bug.txt, 5.3 KB (added by redchops@…, 13 years ago)

Backtrace

Line 
1Backtrace:
2
3    datetime:  2007-08-19 10:55:22 (EDT)
4    errornum:  256
5  error type:  User Error
6error string:  SQL Error: Column 'endtime' cannot be null [#1048]
7    filename:  /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
8  error line:  73
9
10==========================================================================
11
12Backtrace:
13
14    file:  /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
15    line:  73
16   class: 
17function:  trigger_error
18    type: 
19    args:  Array
20(
21    [0] => SQL Error: Column 'endtime' cannot be null [#1048]
22    [1] => 256
23)
24
25    file:  /usr/share/mythtv/mythweb/includes/objects/Database.php
26    line:  220
27   class:  Database_Query_mysql
28function:  execute
29    type:  ->
30    args:  Array
31(
32    [0] => Array ( )
33)
34
35    file:  /usr/share/mythtv/mythweb/includes/programs.php
36    line:  155
37   class:  Database
38function:  query
39    type:  ->
40    args:  Array
41(
42    [0] => SELECT program.*,
43                         UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
44                         UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
45                         IFNULL(programrating.system, "") AS rater,
46                         IFNULL(programrating.rating, "") AS rating,
47                         channel.callsign,
48                         channel.channum
49                  FROM program
50                       LEFT JOIN programrating USING (chanid, starttime)
51                       LEFT JOIN channel ON program.chanid = channel.chanid
52                 WHERE program.chanid='1005' AND (program.endtime > FROM_UNIXTIME('-68400') AND program.starttime < FROM_UNIXTIME('18000') AND program.starttime != program.endtime)
53GROUP BY program.chanid, program.starttime, channel.callsign ORDER BY program.starttime
54)
55
56    file:  /usr/share/mythtv/mythweb/modules/tv/channel.php
57    line:  44
58   class: 
59function:  load_all_program_data
60    type: 
61    args:  Array
62(
63    [0] => -68400
64    [1] => 18000
65    [2] => 1005
66)
67
68    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
69    line:  64
70   class: 
71function:  require_once
72    type: 
73    args:  Array
74(
75    [0] => /usr/share/mythtv/mythweb/modules/tv/channel.php
76)
77
78    file:  /usr/share/mythtv/mythweb/mythweb.php
79    line:  24
80   class: 
81function:  require_once
82    type: 
83    args:  Array
84(
85    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
86)
87
88
89==========================================================================
90
91$_GET: Array
92(
93    [chanid] => 1005
94    [date] => 1187533800
95)
96
97==========================================================================
98
99$_SESSION: Array
100(
101    [language] => English
102    [tmpl] => default
103    [skin] => default
104    [prefer_channum] => 1
105    [date_statusbar] => %a %b %e, %Y, %I:%M %p
106    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
107    [date_scheduled_popup] => %a %b %e, %Y
108    [date_recorded] => %a %b %e, %Y<br />(%I:%M %p)
109    [date_search] => %a %b %e, %Y, %I:%M %p
110    [date_listing_key] => %a %b %e, %Y, %I:%M %p
111    [date_listing_jump] => %a %b %e, %Y
112    [date_channel_jump] => %a %b %e, %Y
113    [time_format] => %I:%M %p
114    [recorded_pixmaps] => 1
115    [guide_favonly] =>
116    [timeslot_size] => 300
117    [num_time_slots] => 36
118    [timeslot_blocks] => 3
119    [timeslotbar_skip] => 20
120    [max_stars] => 4
121    [star_character] => &diams;
122    [list_time] =>
123)
124
125==========================================================================
126
127$_SERVER: Array
128(
129    [REDIRECT_STATUS] => 200
130    [HTTP_HOST] => base.redchops.com:8080
131    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
132    [HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
133    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
134    [HTTP_ACCEPT_ENCODING] => gzip,deflate
135    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
136    [HTTP_KEEP_ALIVE] => 300
137    [HTTP_CONNECTION] => keep-alive
138    [HTTP_REFERER] => http://base.redchops.com:8080/mythweb/tv/detail/1005/1187533800
139    [HTTP_COOKIE] => mythweb_id=d88360fc53b5344fc7419bd03d4e4f12
140    [PATH] => /usr/local/bin:/usr/bin:/bin
141    [SERVER_SIGNATURE] => <address>Apache/2.2.3 (Ubuntu) DAV/2 SVN/1.4.3 PHP/5.2.1 Server at base.redchops.com Port 80</address>
142
143    [SERVER_SOFTWARE] => Apache/2.2.3 (Ubuntu) DAV/2 SVN/1.4.3 PHP/5.2.1
144    [SERVER_NAME] => base.redchops.com
145    [SERVER_ADDR] => 192.168.1.100
146    [SERVER_PORT] => 80
147    [REMOTE_ADDR] => 65.43.181.77
148    [DOCUMENT_ROOT] => /var/www
149    [SERVER_ADMIN] => redchops@gmail.com
150    [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
151    [REMOTE_PORT] => 3270
152    [REDIRECT_URL] => /mythweb/tv/channel/1005/1187533800
153    [GATEWAY_INTERFACE] => CGI/1.1
154    [SERVER_PROTOCOL] => HTTP/1.1
155    [REQUEST_METHOD] => GET
156    [QUERY_STRING] =>
157    [REQUEST_URI] => /mythweb/tv/channel/1005/1187533800
158    [SCRIPT_NAME] => /mythweb/mythweb.php
159    [PATH_INFO] => /tv/channel/1005/1187533800
160    [PATH_TRANSLATED] => /var/www/tv/channel/1005/1187533800
161    [PHP_SELF] => /mythweb/mythweb.php/tv/channel/1005/1187533800
162    [PHP_AUTH_USER] => chops
163    [PHP_AUTH_PW] => doublehelix
164    [REQUEST_TIME] => 1187535322
165    [argv] => Array ( )
166    [argc] => 0
167    [STATUS] => 200
168    [URL] => /mythweb/tv/channel/1005/1187533800
169)
170
171