1 | datetime: 2016-08-31 10:35:21 (PDT)
|
---|
2 | errornum: 256
|
---|
3 | error type: User Error
|
---|
4 | error 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 |
|
---|
10 | Backtrace:
|
---|
11 |
|
---|
12 | file: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
|
---|
13 | line: 98
|
---|
14 | class:
|
---|
15 | function: 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
|
---|
26 | function: 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
|
---|
36 | function: 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())
|
---|
53 | GROUP 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:
|
---|
59 | function: 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:
|
---|
74 | function: 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:
|
---|
84 | function: 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] => ★
|
---|
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] => ★
|
---|
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 |
|
---|