Ticket #12867: Backtrace

File Backtrace, 10.2 KB (added by jmcarron@…, 8 years ago)
Line 
1    datetime:  2016-09-01 18:19:38 (PDT)
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] => 1754
33            [1] => 1472778000
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] => 1754
61    [2] => 1472778000
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            [last] => Array
153                (
154                    [0] => database
155                    [1] => settings
156                )
157
158        )
159
160    [backend] => Array
161        (
162            [timezone] => Array
163                (
164                    [value] => America/Los_Angeles
165                    [last_check_time] => 1472779164
166                )
167
168            [192.168.0.254] => Array
169                (
170                    [proto_version] => Array
171                        (
172                            [last_check_version] => 88
173                            [last_check_time] => 1472779164
174                        )
175
176                )
177
178        )
179
180    [language] => English
181    [date_statusbar] => %a %b %e, %Y, %I:%M %p
182    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
183    [date_scheduled_popup] => %a %b %e, %Y
184    [date_recorded] => %a %b %e, %Y (%I:%M %p)
185    [date_search] => %a %b %e, %Y, %I:%M %p
186    [date_listing_key] => %a %b %e, %Y, %I:%M %p
187    [date_listing_jump] => %a %b %e, %Y
188    [date_channel_jump] => %a %b %e, %Y
189    [date_job_status] => %a %b %e, %Y, %I:%M %p
190    [time_format] => %I:%M %p
191    [tv] => Array
192        (
193            [last] => Array
194                (
195                    [0] => recorded
196                )
197
198        )
199
200    [list_time] => 1472739300
201    [scheduled_recordings] => Array
202        (
203            [disp_scheduled] => 1
204            [disp_duplicates] =>
205            [disp_deactivated] =>
206            [disp_conflicts] => 1
207        )
208
209    [scheduled_sortby] => Array
210        (
211            [0] => Array
212                (
213                    [field] => airdate
214                    [reverse] =>
215                )
216
217            [1] => Array
218                (
219                    [field] => title
220                    [reverse] =>
221                )
222
223        )
224
225    [recorded_sortby] => Array
226        (
227            [0] => Array
228                (
229                    [field] => airdate
230                    [reverse] => 1
231                )
232
233            [1] => Array
234                (
235                    [field] => title
236                    [reverse] =>
237                )
238
239        )
240
241    [schedules_sortby] => Array
242        (
243            [0] => Array
244                (
245                    [field] => airdate
246                    [reverse] =>
247                )
248
249            [1] => Array
250                (
251                    [field] => title
252                    [reverse] =>
253                )
254
255        )
256
257)
258
259==========================================================================
260
261$_SERVER: Array
262(
263    [REDIRECT_STATUS] => 200
264    [HTTP_HOST] => 192.168.0.254
265    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:48.0) Gecko/20100101 Firefox/48.0
266    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
267    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
268    [HTTP_ACCEPT_ENCODING] => gzip, deflate
269    [HTTP_REFERER] => http://192.168.0.254/mythweb/tv/recorded
270    [HTTP_COOKIE] => mythweb_id=usrd3ioh3cmp65hetph5b226s5
271    [HTTP_CONNECTION] => keep-alive
272    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
273    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
274    [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.0.254 Port 80</address>
275
276    [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
277    [SERVER_NAME] => 192.168.0.254
278    [SERVER_ADDR] => 192.168.0.254
279    [SERVER_PORT] => 80
280    [REMOTE_ADDR] => 192.168.0.200
281    [DOCUMENT_ROOT] => /var/www/html
282    [REQUEST_SCHEME] => http
283    [CONTEXT_PREFIX] =>
284    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
285    [SERVER_ADMIN] => webmaster@localhost
286    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
287    [REMOTE_PORT] => 53748
288    [REDIRECT_URL] => /mythweb/tv/recorded
289    [GATEWAY_INTERFACE] => CGI/1.1
290    [SERVER_PROTOCOL] => HTTP/1.1
291    [REQUEST_METHOD] => GET
292    [QUERY_STRING] =>
293    [REQUEST_URI] => /tv/recorded
294    [SCRIPT_NAME] => /mythweb/mythweb.php
295    [PATH_INFO] => /tv/recorded
296    [PATH_TRANSLATED] => /var/www/html/tv/recorded
297    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
298    [REQUEST_TIME_FLOAT] => 1472779178.904
299    [REQUEST_TIME] => 1472779178
300    [STATUS] => 200
301    [URL] => /mythweb/tv/recorded
302    [HTTP_X_FORWARDED_PROTO] =>
303    [HTTPS] =>
304    [HTTP_PORT] => 80
305)
306
307==========================================================================
308
309$constant_list["user"]: Array
310(
311    [ERROR] => 512
312    [E_ASSERT_ERROR] => 4096
313    [FATAL] => 256
314    [PHP_MIN_VERSION] => 5.3
315    [WARNING] => 1024
316    [WebDBSchemaVer] => 4
317    [disk_size] => 3898890313728
318    [disk_used] => 46467186688
319    [dupsin_all] => 15
320    [dupsin_newepisodes] => 16
321    [dupsin_oldrecorded] => 2
322    [dupsin_recorded] => 1
323    [error_email] =>
324    [gb] => 1073741824
325    [hostname] => kitsbe
326    [http_host] => 192.168.0.254
327    [kb] => 1024
328    [max_stars] => 4
329    [mb] => 1048576
330    [module] => tv
331    [modules_path] => /usr/share/mythtv/mythweb/modules
332    [num_time_slots] => 36
333    [prefer_channum] => 1
334    [rectype_always] => 4
335    [rectype_daily] => 2
336    [rectype_dontrec] => 8
337    [rectype_findone] => 6
338    [rectype_once] => 1
339    [rectype_override] => 7
340    [rectype_template] => 11
341    [rectype_weekly] => 5
342    [root] => /mythweb/
343    [root_auth_url] => http://192.168.0.254/mythweb/
344    [root_url] => http://192.168.0.254/mythweb/
345    [searchtype_keyword] => 3
346    [searchtype_manual] => 5
347    [searchtype_people] => 4
348    [searchtype_power] => 1
349    [searchtype_title] => 2
350    [skin] => default
351    [skin_img_url] => http://192.168.0.254/mythweb/skins/default/img/
352    [skin_url] => http://192.168.0.254/mythweb/skins/default/
353    [star_character] => &#9733;
354    [stream_url] => http://192.168.0.254:80//mythweb/
355    [tb] => 1099511627776
356    [timeslot_blocks] => 3
357    [timeslot_size] => 300
358    [timeslotbar_skip] => 20
359    [tmpl] => default
360    [tmpl_dir] => modules/tv/tmpl/default/
361)
362
363
364