Ticket #13422: chrome_backtrace

File chrome_backtrace, 8.7 KB (added by jseagull1, 7 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