Ticket #12719: mythweb_bug.txt

File mythweb_bug.txt, 10.3 KB (added by vidtek99@…, 10 years ago)

backtrace

Line 
1 datetime: 2016-04-10 10:36:54 (BST)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.chanid' 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 #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.chanid' 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
33 file: /usr/share/mythtv/mythweb/modules/tv/classes/Channel.php
34 line: 92
35 class: Database
36function: query
37 type: ->
38 args: Array
39(
40 [0] => SELECT channel.chanid, channel.channum, channel.callsign FROM channel WHERE channel.visible = 1 GROUP BY channel.channum, channel.callsign ORDER BY (channel.channum + 0), channel.channum, channel.chanid
41)
42
43 file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php
44 line: 46
45 class: Channel
46function: getCallsignList
47 type: ::
48 args: Array ( )
49 file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php
50 line: 78
51 class:
52function: require_once
53 type:
54 args: Array
55(
56 [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php
57)
58
59 file: /usr/share/mythtv/mythweb/modules/tv/list.php
60 line: 45
61 class:
62function: require_once
63 type:
64 args: Array
65(
66 [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php
67)
68
69 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
70 line: 82
71 class:
72function: require_once
73 type:
74 args: Array
75(
76 [0] => /usr/share/mythtv/mythweb/modules/tv/list.php
77)
78
79 file: /usr/share/mythtv/mythweb/mythweb.php
80 line: 35
81 class:
82function: require_once
83 type:
84 args: Array
85(
86 [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
87)
88
89
90==========================================================================
91
92$_SESSION: Array
93(
94 [cache_engine] => Cache_Null
95 [stream] => Array
96 (
97 [include_user_and_password] =>
98 )
99
100 [prefer_channum] => 1
101 [recorded_pixmaps] => 1
102 [guide_favonly] =>
103 [timeslot_size] => 300
104 [num_time_slots] => 36
105 [timeslot_blocks] => 3
106 [timeslotbar_skip] => 20
107 [max_stars] => 4
108 [star_character] => ★
109 [show_popup_info] => 1
110 [show_channel_icons] => 1
111 [sortby_channum] => 1
112 [recorded_paging] =>
113 [genre_colors] => 1
114 [show_video_covers] => 1
115 [settings] => Array
116 (
117 [screens] => Array
118 (
119 [tv] => Array
120 (
121 [upcoming recordings] => Array
122 (
123 [title] => on
124 [channel] => on
125 [airdate] => on
126 [record date] => on
127 [length] => on
128 )
129
130 )
131
132 )
133
134 [last] => Array
135 (
136 [0] => tv
137 [1] => channels
138 )
139
140 [host] => kubuntu-virt
141 )
142
143 [backend] => Array
144 (
145 [192.168.0.42] => Array
146 (
147 [proto_version] => Array
148 (
149 [last_check_version] => 88
150 [last_check_time] => 1460216180
151 )
152
153 )
154
155 [timezone] => Array
156 (
157 [value] => Europe/London
158 [last_check_time] => 1460216180
159 )
160
161 )
162
163 [language] => English
164 [date_statusbar] => %a %b %e, %Y, %I:%M %p
165 [date_scheduled] => %a %b %e, %Y (%I:%M %p)
166 [date_scheduled_popup] => %a %b %e, %Y
167 [date_recorded] => %a %b %e, %Y (%I:%M %p)
168 [date_search] => %a %b %e, %Y, %I:%M %p
169 [date_listing_key] => %a %b %e, %Y, %I:%M %p
170 [date_listing_jump] => %a %b %e, %Y
171 [date_channel_jump] => %a %b %e, %Y
172 [date_job_status] => %a %b %e, %Y, %I:%M %p
173 [time_format] => %I:%M %p
174 [tv] => Array
175 (
176 [last] => Array
177 (
178 [0] => list
179 )
180
181 )
182
183 [list_time] => 1460280600
184 [video_sortby] => Array
185 (
186 [0] => Array
187 (
188 [field] => title
189 [reverse] =>
190 )
191
192 )
193
194 [schedules_sortby] => Array
195 (
196 [0] => Array
197 (
198 [field] => airdate
199 [reverse] =>
200 )
201
202 [1] => Array
203 (
204 [field] => title
205 [reverse] =>
206 )
207
208 )
209
210 [video] => Array
211 (
212 [path] => /Music Videos/Blues at the BBC
213 )
214
215 [scheduled_recordings] => Array
216 (
217 [disp_scheduled] => 1
218 [disp_duplicates] =>
219 [disp_deactivated] =>
220 [disp_conflicts] => 1
221 )
222
223 [scheduled_sortby] => Array
224 (
225 [0] => Array
226 (
227 [field] => airdate
228 [reverse] =>
229 )
230
231 [1] => Array
232 (
233 [field] => title
234 [reverse] =>
235 )
236
237 )
238
239 [search] => Array
240 (
241 [s] => canned:Movies
242 [type] => q
243 [ctype] => Array
244 (
245 [0] =>
246 [1] => movie
247 [2] => series
248 )
249
250 [categories] => Array ( )
251 [stars_gt] => 0
252 [stars_lt] => 1
253 [starttime] => now
254 [endtime] => + 2 weeks
255 [as] => Array
256 (
257 [0] =>
258 )
259
260 [af] => Array
261 (
262 [0] => Array
263 (
264 [0] => title
265 )
266
267 )
268
269 [aj] => Array
270 (
271 [0] => AND
272 )
273
274 )
275
276 [recorded_sortby] => Array
277 (
278 [0] => Array
279 (
280 [field] => airdate
281 [reverse] => 1
282 )
283
284 [1] => Array
285 (
286 [field] => title
287 [reverse] =>
288 )
289
290 )
291
292)
293
294==========================================================================
295
296$_SERVER: Array
297(
298 [REDIRECT_STATUS] => 200
299 [HTTP_HOST] => 192.168.0.42
300 [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
301 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
302 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
303 [HTTP_ACCEPT_ENCODING] => gzip, deflate
304 [HTTP_REFERER] => http://192.168.0.42/mythweb/
305 [HTTP_COOKIE] => mythweb_id=g3incgu768jp05p37ttc3n6d70
306 [HTTP_CONNECTION] => keep-alive
307 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
308 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.0.42 Port 80</address>
309
310 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
311 [SERVER_NAME] => 192.168.0.42
312 [SERVER_ADDR] => 192.168.0.42
313 [SERVER_PORT] => 80
314 [REMOTE_ADDR] => 192.168.0.42
315 [DOCUMENT_ROOT] => /var/www/html/mythweb
316 [REQUEST_SCHEME] => http
317 [CONTEXT_PREFIX] =>
318 [CONTEXT_DOCUMENT_ROOT] => /var/www/html/mythweb
319 [SERVER_ADMIN] => webmaster@linuxmint
320 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
321 [REMOTE_PORT] => 35224
322 [REDIRECT_URL] => /tv/list
323 [GATEWAY_INTERFACE] => CGI/1.1
324 [SERVER_PROTOCOL] => HTTP/1.1
325 [REQUEST_METHOD] => GET
326 [QUERY_STRING] =>
327 [REQUEST_URI] => /tv/list
328 [SCRIPT_NAME] => /mythweb.php
329 [PATH_INFO] => /tv/list
330 [PATH_TRANSLATED] => redirect:/mythweb.php/tv/list/list
331 [PHP_SELF] => /mythweb.php/tv/list
332 [REQUEST_TIME_FLOAT] => 1460281014.291
333 [REQUEST_TIME] => 1460281014
334 [STATUS] => 200
335 [URL] => /tv/list
336 [HTTP_X_FORWARDED_PROTO] =>
337 [HTTPS] =>
338 [HTTP_PORT] => 80
339)
340
341==========================================================================
342
343$constant_list["user"]: Array
344(
345 [ERROR] => 512
346 [E_ASSERT_ERROR] => 4096
347 [FATAL] => 256
348 [PHP_MIN_VERSION] => 5.3
349 [WARNING] => 1024
350 [WebDBSchemaVer] => 4
351 [dupsin_all] => 15
352 [dupsin_newepisodes] => 16
353 [dupsin_oldrecorded] => 2
354 [dupsin_recorded] => 1
355 [error_email] =>
356 [gb] => 1073741824
357 [hostname] => linuxmint
358 [http_host] => 192.168.0.42
359 [kb] => 1024
360 [max_stars] => 4
361 [mb] => 1048576
362 [module] => tv
363 [modules_path] => /usr/share/mythtv/mythweb/modules
364 [num_time_slots] => 36
365 [prefer_channum] => 1
366 [rectype_always] => 4
367 [rectype_daily] => 2
368 [rectype_dontrec] => 8
369 [rectype_findone] => 6
370 [rectype_once] => 1
371 [rectype_override] => 7
372 [rectype_template] => 11
373 [rectype_weekly] => 5
374 [root] => /
375 [root_auth_url] => http://192.168.0.42/
376 [root_url] => http://192.168.0.42/
377 [searchtype_keyword] => 3
378 [searchtype_manual] => 5
379 [searchtype_people] => 4
380 [searchtype_power] => 1
381 [searchtype_title] => 2
382 [skin] => default
383 [skin_img_url] => http://192.168.0.42/skins/default/img/
384 [skin_url] => http://192.168.0.42/skins/default/
385 [star_character] => &#9733;
386 [stream_url] => http://192.168.0.42:80//
387 [tb] => 1099511627776
388 [timeslot_blocks] => 3
389 [timeslot_size] => 300
390 [timeslotbar_skip] => 20
391 [tmpl] => default
392 [tmpl_dir] => modules/tv/tmpl/default/
393)
394
395