Ticket #12865: Myth_backtrace.txt

File Myth_backtrace.txt, 11.7 KB (added by TurnStyle_K12@…, 8 years ago)

Backtrace

Line 
1    datetime:  2016-08-31 10:35:21 (PDT)
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 (1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1036,1037,1076,1077,1085,1087,1090,1103,1104,1108,1109,1116,1164,1168,1169,1170,1171,1172,1173,1174,1175,1180,1186,1187,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1230,1599,1620,1621,1622,1667,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1750,1811,1812,1819,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1962,1989,1999) AND (program.endtime > FROM_UNIXTIME('1472664921') AND program.starttime < FROM_UNIXTIME('1475343321') AND program.starttime != program.endtime) AND (program.title       LIKE '%NCIS%' OR program.subtitle    LIKE '%NCIS%' OR program.description LIKE '%NCIS%' OR program.category    LIKE '%NCIS%' OR people.name         LIKE '%NCIS%') 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] => 1472664921
64    [1] => 1475343321
65    [2] =>
66    [3] =>
67    [4] => (program.title       LIKE '%NCIS%' OR program.subtitle    LIKE '%NCIS%' OR program.description LIKE '%NCIS%' OR program.category    LIKE '%NCIS%' OR people.name         LIKE '%NCIS%') 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] => NCIS
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            [timezone] => Array
149                (
150                    [value] => America/Los_Angeles
151                    [last_check_time] => 1472607034
152                )
153
154            [127.0.0.1] => Array
155                (
156                    [proto_version] => Array
157                        (
158                            [last_check_version] => 88
159                            [last_check_time] => 1472607106
160                        )
161
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        )
185
186    [scheduled_recordings] => Array
187        (
188            [disp_scheduled] => 1
189            [disp_duplicates] =>
190            [disp_deactivated] =>
191            [disp_conflicts] => 1
192        )
193
194    [] => Array ( )
195    [list_time] => 1472664600
196    [recorded_sortby] => Array
197        (
198            [0] => Array
199                (
200                    [field] => airdate
201                    [reverse] => 1
202                )
203
204            [1] => Array
205                (
206                    [field] => title
207                    [reverse] =>
208                )
209
210        )
211
212    [search] => Array
213        (
214            [type] => q
215            [s] => NCIS
216            [ctype] => Array
217                (
218                    [0] => movie
219                    [1] => series
220                    [2] => sports
221                    [3] => tvshow
222                )
223
224            [categories] => Array ( )
225            [stars_gt] => 0
226            [stars_lt] => 1
227            [starttime] => now
228            [endtime] => + 2 weeks
229            [as] => Array
230                (
231                    [0] =>
232                )
233
234            [af] => Array
235                (
236                    [0] => Array
237                        (
238                            [0] => title
239                        )
240
241                )
242
243            [aj] => Array
244                (
245                    [0] => AND
246                )
247
248        )
249
250)
251
252==========================================================================
253
254$_SERVER: Array
255(
256    [REDIRECT_STATUS] => 200
257    [HTTP_HOST] => 10.121.101.181
258    [HTTP_CONNECTION] => keep-alive
259    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
260    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
261    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
262    [HTTP_REFERER] => http://10.121.101.181/mythweb/tv/searches
263    [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
264    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
265    [HTTP_COOKIE] => mythweb_id=5tq97m2pi0rvc133ovp6mgaki2
266    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
267    [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 10.121.101.181 Port 80</address>
268
269    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
270    [SERVER_NAME] => 10.121.101.181
271    [SERVER_ADDR] => 10.121.101.181
272    [SERVER_PORT] => 80
273    [REMOTE_ADDR] => 10.121.101.170
274    [DOCUMENT_ROOT] => /var/www/html
275    [REQUEST_SCHEME] => http
276    [CONTEXT_PREFIX] =>
277    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
278    [SERVER_ADMIN] => webmaster@localhost
279    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
280    [REMOTE_PORT] => 62491
281    [REDIRECT_URL] => /mythweb/tv/search
282    [REDIRECT_QUERY_STRING] => type=q&s=NCIS&search=Search
283    [GATEWAY_INTERFACE] => CGI/1.1
284    [SERVER_PROTOCOL] => HTTP/1.1
285    [REQUEST_METHOD] => GET
286    [QUERY_STRING] => type=q&s=NCIS&search=Search
287    [REQUEST_URI] => /tv/search?type=q&s=NCIS&search=Search
288    [SCRIPT_NAME] => /mythweb/mythweb.php
289    [PATH_INFO] => /tv/search
290    [PATH_TRANSLATED] => /var/www/html/tv/search
291    [PHP_SELF] => /mythweb/mythweb.php/tv/search
292    [REQUEST_TIME_FLOAT] => 1472664921.219
293    [REQUEST_TIME] => 1472664921
294    [STATUS] => 200
295    [URL] => /mythweb/tv/search
296    [HTTP_X_FORWARDED_PROTO] =>
297    [HTTPS] =>
298    [HTTP_PORT] => 80
299)
300
301==========================================================================
302
303$constant_list["user"]: Array
304(
305    [ERROR] => 512
306    [E_ASSERT_ERROR] => 4096
307    [FATAL] => 256
308    [PHP_MIN_VERSION] => 5.3
309    [WARNING] => 1024
310    [WebDBSchemaVer] => 4
311    [dupsin_all] => 15
312    [dupsin_newepisodes] => 16
313    [dupsin_oldrecorded] => 2
314    [dupsin_recorded] => 1
315    [error_email] =>
316    [gb] => 1073741824
317    [hostname] => HyperMyth
318    [http_host] => 10.121.101.181
319    [kb] => 1024
320    [max_stars] => 4
321    [mb] => 1048576
322    [module] => tv
323    [modules_path] => /usr/share/mythtv/mythweb/modules
324    [num_time_slots] => 36
325    [prefer_channum] => 1
326    [rectype_always] => 4
327    [rectype_daily] => 2
328    [rectype_dontrec] => 8
329    [rectype_findone] => 6
330    [rectype_once] => 1
331    [rectype_override] => 7
332    [rectype_template] => 11
333    [rectype_weekly] => 5
334    [root] => /mythweb/
335    [root_auth_url] => http://10.121.101.181/mythweb/
336    [root_url] => http://10.121.101.181/mythweb/
337    [searchtype_keyword] => 3
338    [searchtype_manual] => 5
339    [searchtype_people] => 4
340    [searchtype_power] => 1
341    [searchtype_title] => 2
342    [skin] => default
343    [skin_img_url] => http://10.121.101.181/mythweb/skins/default/img/
344    [skin_url] => http://10.121.101.181/mythweb/skins/default/
345    [star_character] => &#9733;
346    [stream_url] => http://10.121.101.181:80//mythweb/
347    [tb] => 1099511627776
348    [timeslot_blocks] => 3
349    [timeslot_size] => 300
350    [timeslotbar_skip] => 20
351    [tmpl] => default
352    [tmpl_dir] => modules/tv/tmpl/default/
353)
354
355