Ticket #12923: mythweb_bug_report.txt

File mythweb_bug_report.txt, 12.5 KB (added by rowinggolfer@…, 7 years ago)

mythweb traceback

Line 
1    datetime:  2016-11-12 22:27:21 (GMT)
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 IN (1001,1002,1003,1004,1005,1006,1008,1009,1010,1011,1012,1013,1014,1015,1017,1018,1019,1020,1031,1022,1036,1308,1025,1026,1027,1028,1029,1030,1309,1032,1033,1034,1038,1302,1039,1040,1041,1042,1043,1044,1305,1046,1047,1048,1049,1055,1307,1059,1061,1054,1303,1065,1066,1068,1069,1312,1072,1073,1304,1083,1084,1311,1070,1071,1122,1125,1126,1080,1081,1082,1085,1200,1600,1301,1793) AND (program.endtime > FROM_UNIXTIME('1478989641') AND program.starttime < FROM_UNIXTIME('1481581641') AND program.starttime != program.endtime) AND (program.title       LIKE '%still%game%' OR program.subtitle    LIKE '%still%game%' OR program.description LIKE '%still%game%' OR program.category    LIKE '%still%game%' OR people.name         LIKE '%still%game%') AND (program.endtime >= NOW())
53GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime
54)
55
56    file:  /usr/share/mythtv/mythweb/modules/tv/search.php
57    line:  333
58   class: 
59function:  load_all_program_data
60    type: 
61    args:  Array
62(
63    [0] => 1478989641
64    [1] => 1481581641
65    [2] =>
66    [3] =>
67    [4] => (program.title       LIKE '%still%game%' OR program.subtitle    LIKE '%still%game%' OR program.description LIKE '%still%game%' OR program.category    LIKE '%still%game%' OR people.name         LIKE '%still%game%') AND (program.endtime >= NOW())
68    [5] =>
69)
70
71    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
72    line:  82
73   class: 
74function:  require_once
75    type: 
76    args:  Array
77(
78    [0] => /usr/share/mythtv/mythweb/modules/tv/search.php
79)
80
81    file:  /usr/share/mythtv/mythweb/mythweb.php
82    line:  35
83   class: 
84function:  require_once
85    type: 
86    args:  Array
87(
88    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
89)
90
91
92==========================================================================
93
94$_GET: Array
95(
96    [type] => q
97    [s] => still game
98    [search] => Search
99)
100
101==========================================================================
102
103$_SESSION: Array
104(
105    [cache_engine] => Cache_Null
106    [stream] => Array
107        (
108            [include_user_and_password] =>
109        )
110
111    [prefer_channum] => 1
112    [recorded_pixmaps] => 1
113    [guide_favonly] =>
114    [timeslot_size] => 300
115    [num_time_slots] => 36
116    [timeslot_blocks] => 3
117    [timeslotbar_skip] => 20
118    [max_stars] => 4
119    [star_character] => &#9733;
120    [show_popup_info] => 1
121    [show_channel_icons] => 1
122    [sortby_channum] => 1
123    [recorded_paging] =>
124    [genre_colors] => 1
125    [show_video_covers] => 1
126    [settings] => Array
127        (
128            [screens] => Array
129                (
130                    [tv] => Array
131                        (
132                            [upcoming recordings] => Array
133                                (
134                                    [title] => on
135                                    [channel] => on
136                                    [record date] => on
137                                    [length] => on
138                                )
139
140                        )
141
142                )
143
144        )
145
146    [backend] => Array
147        (
148            [192.168.0.3] => Array
149                (
150                    [proto_version] => Array
151                        (
152                            [last_check_version] => 88
153                            [last_check_time] => 1478988815
154                        )
155
156                )
157
158            [timezone] => Array
159                (
160                    [value] => Europe/London
161                    [last_check_time] => 1478988815
162                )
163
164        )
165
166    [language] => English
167    [date_statusbar] => %a %b %e, %Y, %I:%M %p
168    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
169    [date_scheduled_popup] => %a %b %e, %Y
170    [date_recorded] => %a %b %e, %Y (%I:%M %p)
171    [date_search] => %a %b %e, %Y, %I:%M %p
172    [date_listing_key] => %a %b %e, %Y, %I:%M %p
173    [date_listing_jump] => %a %b %e, %Y
174    [date_channel_jump] => %a %b %e, %Y
175    [date_job_status] => %a %b %e, %Y, %I:%M %p
176    [time_format] => %I:%M %p
177    [tv] => Array
178        (
179            [last] => Array
180                (
181                    [0] => search
182                )
183
184            [show_advanced_schedule] => 1
185        )
186
187    [scheduled_recordings] => Array
188        (
189            [disp_scheduled] => 1
190            [disp_duplicates] =>
191            [disp_deactivated] =>
192            [disp_conflicts] => 1
193        )
194
195    [scheduled_sortby] => Array
196        (
197            [0] => Array
198                (
199                    [field] => airdate
200                    [reverse] =>
201                )
202
203            [1] => Array
204                (
205                    [field] => title
206                    [reverse] =>
207                )
208
209        )
210
211    [schedules_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    [list_time] => 1476810000
228    [search] => Array
229        (
230            [type] => q
231            [s] => still game
232            [ctype] => Array
233                (
234                    [0] => movie
235                    [1] => series
236                    [2] => sports
237                    [3] => tvshow
238                )
239
240            [categories] => Array ( )
241            [stars_gt] => 0
242            [stars_lt] => 1
243            [starttime] => now
244            [endtime] => + 2 weeks
245            [as] => Array
246                (
247                    [0] =>
248                )
249
250            [af] => Array
251                (
252                    [0] => Array
253                        (
254                            [0] => title
255                        )
256
257                )
258
259            [aj] => Array
260                (
261                    [0] => AND
262                )
263
264        )
265
266    [search_sortby] => Array
267        (
268            [0] => Array
269                (
270                    [field] => airdate
271                    [reverse] =>
272                )
273
274            [1] => Array
275                (
276                    [field] => title
277                    [reverse] =>
278                )
279
280        )
281
282    [recording_details] => Array
283        (
284            [show_Conflict] => 1
285            [show_PreviousRecording] => 1
286            [show_EarlierShowing] => 1
287            [show_CurrentRecording] => 1
288            [show_WillRecord] => 1
289        )
290
291    [recorded_sortby] => Array
292        (
293            [0] => Array
294                (
295                    [field] => airdate
296                    [reverse] => 1
297                )
298
299            [1] => Array
300                (
301                    [field] => title
302                    [reverse] =>
303                )
304
305        )
306
307    [recorded_title] => Still Game
308    [recorded_recgroup] =>
309)
310
311==========================================================================
312
313$_SERVER: Array
314(
315    [REDIRECT_STATUS] => 200
316    [HTTP_HOST] => 192.168.0.3
317    [HTTP_CONNECTION] => keep-alive
318    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
319    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36
320    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
321    [HTTP_REFERER] => http://192.168.0.3/mythweb/status
322    [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
323    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
324    [HTTP_COOKIE] => Squeezebox-expandPlayerControl=true; Squeezebox-player=00%3A04%3A20%3A07%3A50%3Ad1; Squeezebox-expanded-MY_MUSIC=1; Squeezebox-expanded-RADIO=0; Squeezebox-expanded-PLUGIN_MY_APPS_MODULE_NAME=0; Squeezebox-expanded-FAVORITES=0; Squeezebox-expanded-PLUGINS=0; mythweb_id=j1361864sbgvrpbv3v5vksgfr4
325    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
326    [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.0.3 Port 80</address>
327
328    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
329    [SERVER_NAME] => 192.168.0.3
330    [SERVER_ADDR] => 192.168.0.3
331    [SERVER_PORT] => 80
332    [REMOTE_ADDR] => 192.168.0.16
333    [DOCUMENT_ROOT] => /var/www/html
334    [REQUEST_SCHEME] => http
335    [CONTEXT_PREFIX] =>
336    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
337    [SERVER_ADMIN] => webmaster@localhost
338    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
339    [REMOTE_PORT] => 41018
340    [REDIRECT_URL] => /mythweb/tv/search
341    [REDIRECT_QUERY_STRING] => type=q&s=still+game&search=Search
342    [GATEWAY_INTERFACE] => CGI/1.1
343    [SERVER_PROTOCOL] => HTTP/1.1
344    [REQUEST_METHOD] => GET
345    [QUERY_STRING] => type=q&s=still+game&search=Search
346    [REQUEST_URI] => /tv/search?type=q&s=still+game&search=Search
347    [SCRIPT_NAME] => /mythweb/mythweb.php
348    [PATH_INFO] => /tv/search
349    [PATH_TRANSLATED] => /var/www/html/tv/search
350    [PHP_SELF] => /mythweb/mythweb.php/tv/search
351    [REQUEST_TIME_FLOAT] => 1478989641.884
352    [REQUEST_TIME] => 1478989641
353    [STATUS] => 200
354    [URL] => /mythweb/tv/search
355    [HTTP_X_FORWARDED_PROTO] =>
356    [HTTPS] =>
357    [HTTP_PORT] => 80
358)
359
360==========================================================================
361
362$constant_list["user"]: Array
363(
364    [ERROR] => 512
365    [E_ASSERT_ERROR] => 4096
366    [FATAL] => 256
367    [PHP_MIN_VERSION] => 5.3
368    [WARNING] => 1024
369    [WebDBSchemaVer] => 4
370    [dupsin_all] => 15
371    [dupsin_newepisodes] => 16
372    [dupsin_oldrecorded] => 2
373    [dupsin_recorded] => 1
374    [error_email] =>
375    [gb] => 1073741824
376    [hostname] => mythbox2
377    [http_host] => 192.168.0.3
378    [kb] => 1024
379    [max_stars] => 4
380    [mb] => 1048576
381    [module] => tv
382    [modules_path] => /usr/share/mythtv/mythweb/modules
383    [num_time_slots] => 36
384    [prefer_channum] => 1
385    [rectype_always] => 4
386    [rectype_daily] => 2
387    [rectype_dontrec] => 8
388    [rectype_findone] => 6
389    [rectype_once] => 1
390    [rectype_override] => 7
391    [rectype_template] => 11
392    [rectype_weekly] => 5
393    [root] => /mythweb/
394    [root_auth_url] => http://192.168.0.3/mythweb/
395    [root_url] => http://192.168.0.3/mythweb/
396    [searchtype_keyword] => 3
397    [searchtype_manual] => 5
398    [searchtype_people] => 4
399    [searchtype_power] => 1
400    [searchtype_title] => 2
401    [skin] => default
402    [skin_img_url] => http://192.168.0.3/mythweb/skins/default/img/
403    [skin_url] => http://192.168.0.3/mythweb/skins/default/
404    [star_character] => &#9733;
405    [stream_url] => http://192.168.0.3:80//mythweb/
406    [tb] => 1099511627776
407    [timeslot_blocks] => 3
408    [timeslot_size] => 300
409    [timeslotbar_skip] => 20
410    [tmpl] => default
411    [tmpl_dir] => modules/tv/tmpl/default/
412)
413
414
415