Ticket #13161: crash.txt

File crash.txt, 10.5 KB (added by anonymous, 8 years ago)
Line 
1 datetime: 2017-10-28 20:10:22 (EDT)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055]!!
5 filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
6 error line: 98
7
8==========================================================================
9
10Backtrace:
11
12 file: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
13 line: 98
14 class:
15function: trigger_error
16 type:
17 args: Array
18(
19 [0] => SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [#1055]
20 [1] => 256
21)
22
23 file: /usr/share/mythtv/mythweb/classes/Database.php
24 line: 261
25 class: Database_Query_mysqlicompat
26function: execute
27 type: ->
28 args: Array
29(
30 [0] => Array
31 (
32 [0] => 1052
33 [1] => 1509163200
34 )
35
36)
37
38 file: /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
39 line: 789
40 class: Database
41function: query
42 type: ->
43 args: Array
44(
45 [0] => SELECT recordedmarkup.type,
46 recordedmarkup.data
47 FROM recordedmarkup
48 WHERE recordedmarkup.chanid = ?
49 AND recordedmarkup.starttime = FROM_UNIXTIME(?)
50 AND recordedmarkup.type IN (10, 11, 12, 13, 14)
51 GROUP BY recordedmarkup.type
52 ORDER BY SUM((SELECT IFNULL(rm.mark, recordedmarkup.mark)
53 FROM recordedmarkup AS rm
54 WHERE rm.chanid = recordedmarkup.chanid
55 AND rm.starttime = recordedmarkup.starttime
56 AND rm.type IN (10, 11, 12, 13, 14)
57 AND rm.mark > recordedmarkup.mark
58 ORDER BY rm.mark ASC LIMIT 1)- recordedmarkup.mark) DESC
59 LIMIT 1
60 [1] => 1052
61 [2] => 1509163200
62)
63
64 file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
65 line: 150
66 class: Program
67function: getAspect
68 type: ->
69 args: Array ( )
70 file: /usr/share/mythtv/mythweb/modules/tv/recorded.php
71 line: 193
72 class:
73function: require_once
74 type:
75 args: Array
76(
77 [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
78)
79
80 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
81 line: 82
82 class:
83function: require_once
84 type:
85 args: Array
86(
87 [0] => /usr/share/mythtv/mythweb/modules/tv/recorded.php
88)
89
90 file: /usr/share/mythtv/mythweb/mythweb.php
91 line: 35
92 class:
93function: require_once
94 type:
95 args: Array
96(
97 [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
98)
99
100
101==========================================================================
102
103$_GET: Array
104(
105 [recgroup] =>
106 [title] => Baywatch
107 [reverse] =>
108 [sortby] =>
109)
110
111==========================================================================
112
113$_SESSION: Array
114(
115 [cache_engine] => Cache_Null
116 [stream] => Array
117 (
118 [include_user_and_password] =>
119 )
120
121 [prefer_channum] => 1
122 [recorded_pixmaps] => 1
123 [guide_favonly] =>
124 [timeslot_size] => 300
125 [num_time_slots] => 36
126 [timeslot_blocks] => 3
127 [timeslotbar_skip] => 20
128 [max_stars] => 4
129 [star_character] => ★
130 [show_popup_info] => 1
131 [show_channel_icons] => 1
132 [sortby_channum] => 1
133 [recorded_paging] =>
134 [genre_colors] => 1
135 [show_video_covers] => 1
136 [settings] => Array
137 (
138 [screens] => Array
139 (
140 [tv] => Array
141 (
142 [upcoming recordings] => Array
143 (
144 [title] => on
145 [channel] => on
146 [record date] => on
147 [length] => on
148 )
149
150 )
151
152 )
153
154 [last] => Array
155 (
156 [0] => database
157 [1] => settings
158 )
159
160 [host] => mythtv-virtualbox
161 )
162
163 [backend] => Array
164 (
165 [192.168.0.106] => Array
166 (
167 [proto_version] => Array
168 (
169 [last_check_version] => 88
170 [last_check_time] => 1509234309
171 )
172
173 )
174
175 [timezone] => Array
176 (
177 [value] => America/New_York
178 [last_check_time] => 1509234309
179 )
180
181 )
182
183 [language] => English
184 [date_statusbar] => %a %b %e, %Y, %I:%M %p
185 [date_scheduled] => %a %b %e, %Y (%I:%M %p)
186 [date_scheduled_popup] => %a %b %e, %Y
187 [date_recorded] => %a %b %e, %Y (%I:%M %p)
188 [date_search] => %a %b %e, %Y, %I:%M %p
189 [date_listing_key] => %a %b %e, %Y, %I:%M %p
190 [date_listing_jump] => %a %b %e, %Y
191 [date_channel_jump] => %a %b %e, %Y
192 [date_job_status] => %a %b %e, %Y, %I:%M %p
193 [time_format] => %I:%M %p
194 [tv] => Array
195 (
196 [last] => Array
197 (
198 [0] => recorded
199 )
200
201 )
202
203 [scheduled_recordings] => Array
204 (
205 [disp_scheduled] => 1
206 [disp_duplicates] =>
207 [disp_deactivated] =>
208 [disp_conflicts] => 1
209 )
210
211 [scheduled_sortby] => Array
212 (
213 [0] => Array
214 (
215 [field] => airdate
216 [reverse] =>
217 )
218
219 [1] => Array
220 (
221 [field] => title
222 [reverse] =>
223 )
224
225 )
226
227 [recorded_sortby] => Array
228 (
229 [0] => Array
230 (
231 [field] => airdate
232 [reverse] => 1
233 )
234
235 [1] => Array
236 (
237 [field] => title
238 [reverse] =>
239 )
240
241 )
242
243 [schedules_sortby] => Array
244 (
245 [0] => Array
246 (
247 [field] => airdate
248 [reverse] =>
249 )
250
251 [1] => Array
252 (
253 [field] => title
254 [reverse] =>
255 )
256
257 )
258
259 [list_time] => 1509235200
260 [recorded_title] => Baywatch
261 [recorded_recgroup] =>
262)
263
264==========================================================================
265
266$_SERVER: Array
267(
268 [REDIRECT_STATUS] => 200
269 [HTTP_HOST] => 192.168.0.106
270 [HTTP_ACCEPT_ENCODING] => gzip, deflate
271 [HTTP_COOKIE] => mythweb_id=8qf5moj1l8sb2tj36bmg0pbdg6
272 [HTTP_CONNECTION] => keep-alive
273 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
274 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
275 [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Safari/604.1.38
276 [HTTP_REFERER] => http://192.168.0.106/mythweb/tv/recorded
277 [HTTP_DNT] => 1
278 [HTTP_ACCEPT_LANGUAGE] => en-us
279 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
280 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.0.106 Port 80</address>
281
282 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
283 [SERVER_NAME] => 192.168.0.106
284 [SERVER_ADDR] => 192.168.0.106
285 [SERVER_PORT] => 80
286 [REMOTE_ADDR] => 192.168.0.103
287 [DOCUMENT_ROOT] => /var/www/html
288 [REQUEST_SCHEME] => http
289 [CONTEXT_PREFIX] =>
290 [CONTEXT_DOCUMENT_ROOT] => /var/www/html
291 [SERVER_ADMIN] => webmaster@localhost
292 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
293 [REMOTE_PORT] => 63198
294 [REDIRECT_URL] => /mythweb/tv/recorded
295 [REDIRECT_QUERY_STRING] => recgroup=&title=Baywatch
296 [GATEWAY_INTERFACE] => CGI/1.1
297 [SERVER_PROTOCOL] => HTTP/1.1
298 [REQUEST_METHOD] => GET
299 [QUERY_STRING] => recgroup=&title=Baywatch
300 [REQUEST_URI] => /tv/recorded?recgroup=&title=Baywatch
301 [SCRIPT_NAME] => /mythweb/mythweb.php
302 [PATH_INFO] => /tv/recorded
303 [PATH_TRANSLATED] => /var/www/html/tv/recorded
304 [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
305 [REQUEST_TIME_FLOAT] => 1509235822.06
306 [REQUEST_TIME] => 1509235822
307 [STATUS] => 200
308 [URL] => /mythweb/tv/recorded
309 [HTTP_X_FORWARDED_PROTO] =>
310 [HTTPS] =>
311 [HTTP_PORT] => 80
312)
313
314==========================================================================
315
316$constant_list["user"]: Array
317(
318 [ERROR] => 512
319 [E_ASSERT_ERROR] => 4096
320 [FATAL] => 256
321 [PHP_MIN_VERSION] => 5.3
322 [WARNING] => 1024
323 [WebDBSchemaVer] => 4
324 [disk_size] => 999860912128
325 [disk_used] => 819363397632
326 [dupsin_all] => 15
327 [dupsin_newepisodes] => 16
328 [dupsin_oldrecorded] => 2
329 [dupsin_recorded] => 1
330 [error_email] =>
331 [gb] => 1073741824
332 [hostname] => mythtv-VirtualBox
333 [http_host] => 192.168.0.106
334 [kb] => 1024
335 [max_stars] => 4
336 [mb] => 1048576
337 [module] => tv
338 [modules_path] => /usr/share/mythtv/mythweb/modules
339 [num_time_slots] => 36
340 [prefer_channum] => 1
341 [rectype_always] => 4
342 [rectype_daily] => 2
343 [rectype_dontrec] => 8
344 [rectype_findone] => 6
345 [rectype_once] => 1
346 [rectype_override] => 7
347 [rectype_template] => 11
348 [rectype_weekly] => 5
349 [root] => /mythweb/
350 [root_auth_url] => http://192.168.0.106/mythweb/
351 [root_url] => http://192.168.0.106/mythweb/
352 [searchtype_keyword] => 3
353 [searchtype_manual] => 5
354 [searchtype_people] => 4
355 [searchtype_power] => 1
356 [searchtype_title] => 2
357 [skin] => default
358 [skin_img_url] => http://192.168.0.106/mythweb/skins/default/img/
359 [skin_url] => http://192.168.0.106/mythweb/skins/default/
360 [star_character] => &#9733;
361 [stream_url] => http://192.168.0.106:80//mythweb/
362 [tb] => 1099511627776
363 [timeslot_blocks] => 3
364 [timeslot_size] => 300
365 [timeslotbar_skip] => 20
366 [tmpl] => default
367 [tmpl_dir] => modules/tv/tmpl/default/
368)
369
370