Ticket #12824: listings-backtrace

File listings-backtrace, 9.5 KB (added by mythtv.mark.khsecure@…, 8 years ago)
Line 
1    datetime:  2016-07-04 22:51:48 (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)
228
229==========================================================================
230
231$_SERVER: Array
232(
233    [REDIRECT_STATUS] => 200
234    [HTTP_HOST] => 192.168.2.107
235    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0
236    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
237    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
238    [HTTP_ACCEPT_ENCODING] => gzip, deflate
239    [HTTP_REFERER] => http://192.168.2.107/mythweb/tv/list
240    [HTTP_COOKIE] => mythweb_id=717e88rii77ntq9e1sk2cpa4n7
241    [HTTP_CONNECTION] => keep-alive
242    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
243    [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.2.107 Port 80</address>
244
245    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
246    [SERVER_NAME] => 192.168.2.107
247    [SERVER_ADDR] => 192.168.2.107
248    [SERVER_PORT] => 80
249    [REMOTE_ADDR] => 192.168.2.101
250    [DOCUMENT_ROOT] => /var/www/html
251    [REQUEST_SCHEME] => http
252    [CONTEXT_PREFIX] =>
253    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
254    [SERVER_ADMIN] => webmaster@localhost
255    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
256    [REMOTE_PORT] => 58074
257    [REDIRECT_URL] => /mythweb/tv/recorded
258    [GATEWAY_INTERFACE] => CGI/1.1
259    [SERVER_PROTOCOL] => HTTP/1.1
260    [REQUEST_METHOD] => GET
261    [QUERY_STRING] =>
262    [REQUEST_URI] => /tv/recorded
263    [SCRIPT_NAME] => /mythweb/mythweb.php
264    [PATH_INFO] => /tv/recorded
265    [PATH_TRANSLATED] => /var/www/html/tv/recorded
266    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
267    [REQUEST_TIME_FLOAT] => 1467669108.322
268    [REQUEST_TIME] => 1467669108
269    [STATUS] => 200
270    [URL] => /mythweb/tv/recorded
271    [HTTP_X_FORWARDED_PROTO] =>
272    [HTTPS] =>
273    [HTTP_PORT] => 80
274)
275
276==========================================================================
277
278$constant_list["user"]: Array
279(
280    [ERROR] => 512
281    [E_ASSERT_ERROR] => 4096
282    [FATAL] => 256
283    [PHP_MIN_VERSION] => 5.3
284    [WARNING] => 1024
285    [WebDBSchemaVer] => 4
286    [disk_size] => 128838508544
287    [disk_used] => 8644784128
288    [dupsin_all] => 15
289    [dupsin_newepisodes] => 16
290    [dupsin_oldrecorded] => 2
291    [dupsin_recorded] => 1
292    [error_email] =>
293    [gb] => 1073741824
294    [hostname] => storeroom
295    [http_host] => 192.168.2.107
296    [kb] => 1024
297    [max_stars] => 4
298    [mb] => 1048576
299    [module] => tv
300    [modules_path] => /usr/share/mythtv/mythweb/modules
301    [num_time_slots] => 36
302    [prefer_channum] => 1
303    [rectype_always] => 4
304    [rectype_daily] => 2
305    [rectype_dontrec] => 8
306    [rectype_findone] => 6
307    [rectype_once] => 1
308    [rectype_override] => 7
309    [rectype_template] => 11
310    [rectype_weekly] => 5
311    [root] => /mythweb/
312    [root_auth_url] => http://192.168.2.107/mythweb/
313    [root_url] => http://192.168.2.107/mythweb/
314    [searchtype_keyword] => 3
315    [searchtype_manual] => 5
316    [searchtype_people] => 4
317    [searchtype_power] => 1
318    [searchtype_title] => 2
319    [skin] => default
320    [skin_img_url] => http://192.168.2.107/mythweb/skins/default/img/
321    [skin_url] => http://192.168.2.107/mythweb/skins/default/
322    [star_character] => &#9733;
323    [stream_url] => http://192.168.2.107:80//mythweb/
324    [tb] => 1099511627776
325    [timeslot_blocks] => 3
326    [timeslot_size] => 300
327    [timeslotbar_skip] => 20
328    [tmpl] => default
329    [tmpl_dir] => modules/tv/tmpl/default/
330)
331
332