Ticket #12875: Myth0-28 SQL Error.txt

File Myth0-28 SQL Error.txt, 12.0 KB (added by steveg19@…, 9 years ago)

SQL error text when clicking on Myth Web Listings tab

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