Ticket #3848: bug.txt

File bug.txt, 5.3 KB (added by redchops@…, 18 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