Ticket #12824: recorded-programs-backtrace

File recorded-programs-backtrace, 10.0 KB (added by mythtv.mark.khsecure@…, 3 years ago)
Line 
1    datetime:  2016-07-04 22:56:40 (BST)
2    errornum:  256
3  error type:  User Error
4error string:  !!NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' 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 #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' 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            [0] => 1001
33            [1] => 1467667800
34        )
35
36)
37
38    file:  /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
39    line:  789
40   class:  Database
41function:  query
42    type:  ->
43    args:  Array
44(
45    [0] => SELECT recordedmarkup.type,
46                                 recordedmarkup.data
47                            FROM recordedmarkup
48                           WHERE recordedmarkup.chanid    = ?
49                             AND recordedmarkup.starttime = FROM_UNIXTIME(?)
50                             AND recordedmarkup.type      IN (10, 11, 12, 13, 14)
51                        GROUP BY recordedmarkup.type
52                        ORDER BY SUM((SELECT IFNULL(rm.mark, recordedmarkup.mark)
53                                        FROM recordedmarkup AS rm
54                                       WHERE rm.chanid = recordedmarkup.chanid
55                                         AND rm.starttime = recordedmarkup.starttime
56                                         AND rm.type IN (10, 11, 12, 13, 14)
57                                         AND rm.mark > recordedmarkup.mark
58                                ORDER BY rm.mark ASC LIMIT 1)- recordedmarkup.mark) DESC
59                           LIMIT 1
60    [1] => 1001
61    [2] => 1467667800
62)
63
64    file:  /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
65    line:  150
66   class:  Program
67function:  getAspect
68    type:  ->
69    args:  Array ( )
70    file:  /usr/share/mythtv/mythweb/modules/tv/recorded.php
71    line:  193
72   class: 
73function:  require_once
74    type: 
75    args:  Array
76(
77    [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
78)
79
80    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
81    line:  82
82   class: 
83function:  require_once
84    type: 
85    args:  Array
86(
87    [0] => /usr/share/mythtv/mythweb/modules/tv/recorded.php
88)
89
90    file:  /usr/share/mythtv/mythweb/mythweb.php
91    line:  35
92   class: 
93function:  require_once
94    type: 
95    args:  Array
96(
97    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
98)
99
100
101==========================================================================
102
103$_GET: Array
104(
105    [reverse] =>
106    [sortby] =>
107)
108
109==========================================================================
110
111$_SESSION: Array
112(
113    [cache_engine] => Cache_Null
114    [stream] => Array
115        (
116            [include_user_and_password] =>
117        )
118
119    [prefer_channum] => 1
120    [recorded_pixmaps] => 1
121    [guide_favonly] =>
122    [timeslot_size] => 300
123    [num_time_slots] => 36
124    [timeslot_blocks] => 3
125    [timeslotbar_skip] => 20
126    [max_stars] => 4
127    [star_character] => ★
128    [show_popup_info] => 1
129    [show_channel_icons] => 1
130    [sortby_channum] => 1
131    [recorded_paging] =>
132    [genre_colors] => 1
133    [show_video_covers] => 1
134    [settings] => Array
135        (
136            [screens] => Array
137                (
138                    [tv] => Array
139                        (
140                            [upcoming recordings] => Array
141                                (
142                                    [title] => on
143                                    [channel] => on
144                                    [record date] => on
145                                    [length] => on
146                                )
147
148                        )
149
150                )
151
152        )
153
154    [backend] => Array
155        (
156            [timezone] => Array
157                (
158                    [value] => Europe/London
159                    [last_check_time] => 1467669075
160                )
161
162            [192.168.2.107] => Array
163                (
164                    [proto_version] => Array
165                        (
166                            [last_check_version] => 88
167                            [last_check_time] => 1467669108
168                        )
169
170                )
171
172        )
173
174    [language] => English
175    [date_statusbar] => %a %b %e, %Y, %I:%M %p
176    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
177    [date_scheduled_popup] => %a %b %e, %Y
178    [date_recorded] => %a %b %e, %Y (%I:%M %p)
179    [date_search] => %a %b %e, %Y, %I:%M %p
180    [date_listing_key] => %a %b %e, %Y, %I:%M %p
181    [date_listing_jump] => %a %b %e, %Y
182    [date_channel_jump] => %a %b %e, %Y
183    [date_job_status] => %a %b %e, %Y, %I:%M %p
184    [time_format] => %I:%M %p
185    [tv] => Array
186        (
187            [last] => Array
188                (
189                    [0] => recorded
190                )
191
192        )
193
194    [list_time] => 1467668700
195    [schedules_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    [recorded_sortby] => Array
212        (
213            [0] => Array
214                (
215                    [field] => airdate
216                    [reverse] => 1
217                )
218
219            [1] => Array
220                (
221                    [field] => title
222                    [reverse] =>
223                )
224
225        )
226
227    [scheduled_recordings] => Array
228        (
229            [disp_scheduled] => 1
230            [disp_duplicates] =>
231            [disp_deactivated] =>
232            [disp_conflicts] => 1
233        )
234
235    [scheduled_sortby] => Array
236        (
237            [0] => Array
238                (
239                    [field] => airdate
240                    [reverse] =>
241                )
242
243            [1] => Array
244                (
245                    [field] => title
246                    [reverse] =>
247                )
248
249        )
250
251)
252
253==========================================================================
254
255$_SERVER: Array
256(
257    [REDIRECT_STATUS] => 200
258    [HTTP_HOST] => 192.168.2.107
259    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0
260    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
261    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
262    [HTTP_ACCEPT_ENCODING] => gzip, deflate
263    [HTTP_REFERER] => http://192.168.2.107/mythweb/status
264    [HTTP_COOKIE] => mythweb_id=717e88rii77ntq9e1sk2cpa4n7
265    [HTTP_CONNECTION] => keep-alive
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 192.168.2.107 Port 80</address>
268
269    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
270    [SERVER_NAME] => 192.168.2.107
271    [SERVER_ADDR] => 192.168.2.107
272    [SERVER_PORT] => 80
273    [REMOTE_ADDR] => 192.168.2.101
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] => 58142
281    [REDIRECT_URL] => /mythweb/tv/recorded
282    [GATEWAY_INTERFACE] => CGI/1.1
283    [SERVER_PROTOCOL] => HTTP/1.1
284    [REQUEST_METHOD] => GET
285    [QUERY_STRING] =>
286    [REQUEST_URI] => /tv/recorded
287    [SCRIPT_NAME] => /mythweb/mythweb.php
288    [PATH_INFO] => /tv/recorded
289    [PATH_TRANSLATED] => /var/www/html/tv/recorded
290    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
291    [REQUEST_TIME_FLOAT] => 1467669400.456
292    [REQUEST_TIME] => 1467669400
293    [STATUS] => 200
294    [URL] => /mythweb/tv/recorded
295    [HTTP_X_FORWARDED_PROTO] =>
296    [HTTPS] =>
297    [HTTP_PORT] => 80
298)
299
300==========================================================================
301
302$constant_list["user"]: Array
303(
304    [ERROR] => 512
305    [E_ASSERT_ERROR] => 4096
306    [FATAL] => 256
307    [PHP_MIN_VERSION] => 5.3
308    [WARNING] => 1024
309    [WebDBSchemaVer] => 4
310    [disk_size] => 128838508544
311    [disk_used] => 8459038720
312    [dupsin_all] => 15
313    [dupsin_newepisodes] => 16
314    [dupsin_oldrecorded] => 2
315    [dupsin_recorded] => 1
316    [error_email] =>
317    [gb] => 1073741824
318    [hostname] => storeroom
319    [http_host] => 192.168.2.107
320    [kb] => 1024
321    [max_stars] => 4
322    [mb] => 1048576
323    [module] => tv
324    [modules_path] => /usr/share/mythtv/mythweb/modules
325    [num_time_slots] => 36
326    [prefer_channum] => 1
327    [rectype_always] => 4
328    [rectype_daily] => 2
329    [rectype_dontrec] => 8
330    [rectype_findone] => 6
331    [rectype_once] => 1
332    [rectype_override] => 7
333    [rectype_template] => 11
334    [rectype_weekly] => 5
335    [root] => /mythweb/
336    [root_auth_url] => http://192.168.2.107/mythweb/
337    [root_url] => http://192.168.2.107/mythweb/
338    [searchtype_keyword] => 3
339    [searchtype_manual] => 5
340    [searchtype_people] => 4
341    [searchtype_power] => 1
342    [searchtype_title] => 2
343    [skin] => default
344    [skin_img_url] => http://192.168.2.107/mythweb/skins/default/img/
345    [skin_url] => http://192.168.2.107/mythweb/skins/default/
346    [star_character] => &#9733;
347    [stream_url] => http://192.168.2.107:80//mythweb/
348    [tb] => 1099511627776
349    [timeslot_blocks] => 3
350    [timeslot_size] => 300
351    [timeslotbar_skip] => 20
352    [tmpl] => default
353    [tmpl_dir] => modules/tv/tmpl/default/
354)
355
356