Ticket #13422: chrome_backtrace

File chrome_backtrace, 8.7 KB (added by jseagull1, 5 years ago)
Line 
1This was up above the backtrace:
2Warning at /usr/share/mythtv/mythweb/modules/tv/classes/Schedule.php, line 110:
3!!NoTrans: Invalid argument supplied for foreach()!!
4
5
6
7 datetime:  2019-03-07 11:34:11 (EST)
8    errornum:  256
9  error type:  User Error
10error string:  !!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 [#1064]!!
11    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
12  error line:  98
13
14==========================================================================
15
16Backtrace:
17
18    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
19    line:  98
20   class: 
21function:  trigger_error
22    type: 
23    args:  Array
24(
25    [0] => SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 [#1064]
26    [1] => 256
27)
28
29    file:  /usr/share/mythtv/mythweb/classes/Database.php
30    line:  263
31   class:  Database_Query_mysqlicompat
32function:  execute
33    type:  ->
34    args:  Array
35(
36    [0] => Array ( )
37)
38
39    file:  /usr/share/mythtv/mythweb/modules/tv/classes/Schedule.php
40    line:  131
41   class:  Database
42function:  query
43    type:  ->
44    args:  Array
45(
46    [0] =>
47                SELECT    recordid
48                FROM      record
49                LEFT JOIN channel
50                       ON channel.chanid = record.chanid
51                ORDER BY
52)
53
54    file:  /usr/share/mythtv/mythweb/modules/tv/schedules.php
55    line:  24
56   class:  Schedule
57function:  findAll
58    type:  ::
59    args:  Array ( )
60    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
61    line:  82
62   class: 
63function:  require_once
64    type: 
65    args:  Array
66(
67    [0] => /usr/share/mythtv/mythweb/modules/tv/schedules.php
68)
69
70    file:  /usr/share/mythtv/mythweb/mythweb.php
71    line:  35
72   class: 
73function:  require_once
74    type: 
75    args:  Array
76(
77    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
78)
79
80
81==========================================================================
82
83$_SESSION: Array
84(
85    [cache_engine] => Cache_Null
86    [stream] => Array
87        (
88            [include_user_and_password] =>
89        )
90
91    [prefer_channum] => 1
92    [recorded_pixmaps] => 1
93    [guide_favonly] =>
94    [timeslot_size] => 300
95    [num_time_slots] => 36
96    [timeslot_blocks] => 3
97    [timeslotbar_skip] => 20
98    [max_stars] => 4
99    [star_character] => ★
100    [show_popup_info] => 1
101    [show_channel_icons] => 1
102    [sortby_channum] => 1
103    [recorded_paging] =>
104    [genre_colors] => 1
105    [show_video_covers] => 1
106    [settings] => Array
107        (
108            [screens] => Array
109                (
110                    [tv] => Array
111                        (
112                            [upcoming recordings] => Array
113                                (
114                                    [title] => on
115                                    [channel] => on
116                                    [record date] => on
117                                    [length] => on
118                                )
119
120                        )
121
122                )
123
124        )
125
126    [backend] => Array
127        (
128            [192.168.0.102] => Array
129                (
130                    [proto_version] => Array
131                        (
132                            [last_check_version] => 91
133                            [last_check_time] => 1551967788
134                        )
135
136                )
137
138            [timezone] => Array
139                (
140                    [value] => America/New_York
141                    [last_check_time] => 1551942969
142                )
143
144        )
145
146    [language] => English
147    [date_statusbar] => %a %b %e, %Y, %I:%M %p
148    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
149    [date_scheduled_popup] => %a %b %e, %Y
150    [date_recorded] => %a %b %e, %Y (%I:%M %p)
151    [date_search] => %a %b %e, %Y, %I:%M %p
152    [date_listing_key] => %a %b %e, %Y, %I:%M %p
153    [date_listing_jump] => %a %b %e, %Y
154    [date_channel_jump] => %a %b %e, %Y
155    [date_job_status] => %a %b %e, %Y, %I:%M %p
156    [time_format] => %I:%M %p
157    [tv] => Array
158        (
159            [last] => Array
160                (
161                    [0] => schedules
162                )
163
164        )
165
166    [recorded_sortby] => Array
167        (
168            [0] => Array
169                (
170                    [field] => airdate
171                    [reverse] => 1
172                )
173
174            [1] => Array
175                (
176                    [field] => title
177                    [reverse] =>
178                )
179
180        )
181
182    [scheduled_recordings] => Array
183        (
184            [disp_scheduled] => 1
185            [disp_duplicates] =>
186            [disp_deactivated] =>
187            [disp_conflicts] => 1
188        )
189
190    [scheduled_sortby] => Array
191        (
192            [0] => Array
193                (
194                    [field] => airdate
195                    [reverse] =>
196                )
197
198            [1] => Array
199                (
200                    [field] => title
201                    [reverse] =>
202                )
203
204        )
205
206    [list_time] => 1551968100
207    [video_sortby] => Array
208        (
209            [0] => Array
210                (
211                    [field] => title
212                    [reverse] =>
213                )
214
215        )
216
217)
218
219==========================================================================
220
221$_SERVER: Array
222(
223    [REDIRECT_STATUS] => 200
224    [HTTP_HOST] => 192.168.0.102
225    [HTTP_CONNECTION] => keep-alive
226    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
227    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.39 Safari/537.36
228    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
229    [HTTP_REFERER] => http://192.168.0.102/mythweb/
230    [HTTP_ACCEPT_ENCODING] => gzip, deflate
231    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.9
232    [HTTP_COOKIE] => testing=1; mythweb_id=4dm8guluf4rapqnglaeaa2jfv5; sid=98a68bf5de2201635f7a0adf9a3c3339
233    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
234    [SERVER_SIGNATURE] => <address>Apache/2.4.34 (Ubuntu) Server at 192.168.0.102 Port 80</address>
235
236    [SERVER_SOFTWARE] => Apache/2.4.34 (Ubuntu)
237    [SERVER_NAME] => 192.168.0.102
238    [SERVER_ADDR] => 192.168.0.102
239    [SERVER_PORT] => 80
240    [REMOTE_ADDR] => 192.168.0.101
241    [DOCUMENT_ROOT] => /var/www/html
242    [REQUEST_SCHEME] => http
243    [CONTEXT_PREFIX] =>
244    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
245    [SERVER_ADMIN] => webmaster@localhost
246    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
247    [REMOTE_PORT] => 40388
248    [REDIRECT_URL] => /mythweb/tv/schedules
249    [GATEWAY_INTERFACE] => CGI/1.1
250    [SERVER_PROTOCOL] => HTTP/1.1
251    [REQUEST_METHOD] => GET
252    [QUERY_STRING] =>
253    [REQUEST_URI] => /tv/schedules
254    [SCRIPT_NAME] => /mythweb/mythweb.php
255    [PATH_INFO] => /tv/schedules
256    [PATH_TRANSLATED] => /var/www/html/tv/schedules
257    [PHP_SELF] => /mythweb/mythweb.php/tv/schedules
258    [REQUEST_TIME_FLOAT] => 1551976451.274
259    [REQUEST_TIME] => 1551976451
260    [STATUS] => 200
261    [URL] => /mythweb/tv/schedules
262    [HTTP_X_FORWARDED_PROTO] =>
263    [HTTPS] =>
264    [HTTP_PORT] => 80
265)
266
267==========================================================================
268
269$constant_list["user"]: Array
270(
271    [ERROR] => 512
272    [E_ASSERT_ERROR] => 4096
273    [FATAL] => 256
274    [PHP_MIN_VERSION] => 5.3
275    [WARNING] => 1024
276    [WebDBSchemaVer] => 5
277    [dupsin_all] => 15
278    [dupsin_newepisodes] => 16
279    [dupsin_oldrecorded] => 2
280    [dupsin_recorded] => 1
281    [error_email] =>
282    [gb] => 1073741824
283    [hostname] => nasserver
284    [http_host] => 192.168.0.102
285    [kb] => 1024
286    [max_stars] => 4
287    [mb] => 1048576
288    [module] => tv
289    [modules_path] => /usr/share/mythtv/mythweb/modules
290    [num_time_slots] => 36
291    [prefer_channum] => 1
292    [rectype_always] => 4
293    [rectype_daily] => 2
294    [rectype_dontrec] => 8
295    [rectype_findone] => 6
296    [rectype_once] => 1
297    [rectype_override] => 7
298    [rectype_template] => 11
299    [rectype_weekly] => 5
300    [root] => /mythweb/
301    [root_auth_url] => http://192.168.0.102/mythweb/
302    [root_url] => http://192.168.0.102/mythweb/
303    [searchtype_keyword] => 3
304    [searchtype_manual] => 5
305    [searchtype_people] => 4
306    [searchtype_power] => 1
307    [searchtype_title] => 2
308    [skin] => default
309    [skin_img_url] => http://192.168.0.102/mythweb/skins/default/img/
310    [skin_url] => http://192.168.0.102/mythweb/skins/default/
311    [star_character] => &#9733;
312    [stream_url] => http://192.168.0.102:80//mythweb/
313    [tb] => 1099511627776
314    [timeslot_blocks] => 3
315    [timeslot_size] => 300
316    [timeslotbar_skip] => 20
317    [tmpl] => default
318    [tmpl_dir] => modules/tv/tmpl/default/
319)
320
321