Ticket #13098: backtrace.log

File backtrace.log, 16.7 KB (added by anonymous, 9 years ago)
Line 
1 datetime: 2017-08-12 18:57:49 (EDT)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Incorrect datetime value: '00:00:00' for column 'next_record' at row 1 [#1292]!!
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: Incorrect datetime value: '00:00:00' for column 'next_record' at row 1 [#1292]
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] => 0
33 [1] => 1
34 [2] => 9073
35 [3] => 1502577000
36 [4] => 1502577000
37 [5] => 1502578800
38 [6] => 1502578800
39 [7] => 0
40 [8] => College Football Live
41 [9] =>
42 [10] => Breaking news, analysis, features and interviews.
43 [11] => Default
44 [12] => 0
45 [13] => Sports non-event
46 [14] => 1
47 [15] => 0
48 [16] => 5
49 [17] => 1
50 [18] => 0
51 [19] => 0
52 [20] => Default
53 [21] => 6
54 [22] => 15
55 [23] => ESPNU
56 [24] =>
57 [25] => SH009349210000
58 [26] => 1
59 [27] => 0
60 [28] => 18:30:00
61 [29] => 719528
62 [30] => 0
63 [31] => 0
64 [32] => 0
65 [33] => 0
66 [34] => 0
67 [35] => 0
68 [36] => 0
69 [37] => 1
70 [38] => Default
71 [39] => Default
72 [40] => 0
73 [41] => 00:00:00
74 [42] => 00:00:00
75 [43] => 00:00:00
76 [44] =>
77 [45] => 0
78 [46] => 0
79 [47] => 0
80 [48] => 1
81 )
82
83)
84
85 file: /usr/share/mythtv/mythweb/modules/tv/classes/Schedule.php
86 line: 384
87 class: Database
88function: query
89 type: ->
90 args: Array
91(
92 [0] => REPLACE INTO record (recordid,type,chanid,starttime,startdate,endtime,enddate,search,
93 title,subtitle,description,profile,recpriority,category,
94 maxnewest,inactive,maxepisodes,autoexpire,startoffset,endoffset,
95 recgroup,dupmethod,dupin,station,seriesid,programid,autocommflag,
96 findday,findtime,findid,autotranscode,parentid,transcoder,
97 autouserjob1,autouserjob2,autouserjob3,autouserjob4,autometadata,
98 playgroup,storagegroup,prefinput,
99 next_record,last_record,last_delete,inetref,season,episode,filter,recgroupid)
100 VALUES (?,?,?,
101 FROM_UNIXTIME(?),FROM_UNIXTIME(?),FROM_UNIXTIME(?),FROM_UNIXTIME(?),
102 ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
103 [1] => 0
104 [2] => 1
105 [3] => 9073
106 [4] => 1502577000
107 [5] => 1502577000
108 [6] => 1502578800
109 [7] => 1502578800
110 [8] => 0
111 [9] => College Football Live
112 [10] =>
113 [11] => Breaking news, analysis, features and interviews.
114 [12] => Default
115 [13] => 0
116 [14] => Sports non-event
117 [15] => 1
118 [16] => 0
119 [17] => 5
120 [18] => 1
121 [19] => 0
122 [20] => 0
123 [21] => Default
124 [22] => 6
125 [23] => 15
126 [24] => ESPNU
127 [25] =>
128 [26] => SH009349210000
129 [27] => 1
130 [28] => 0
131 [29] => 18:30:00
132 [30] => 719528
133 [31] => 0
134 [32] => 0
135 [33] => 0
136 [34] => 0
137 [35] => 0
138 [36] => 0
139 [37] => 0
140 [38] => 1
141 [39] => Default
142 [40] => Default
143 [41] => 0
144 [42] => 00:00:00
145 [43] => 00:00:00
146 [44] => 00:00:00
147 [45] =>
148 [46] => 0
149 [47] => 0
150 [48] => 0
151 [49] => 1
152)
153
154 file: /usr/share/mythtv/mythweb/modules/tv/detail.php
155 line: 250
156 class: Schedule
157function: save
158 type: ->
159 args: Array
160(
161 [0] => 1
162)
163
164 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
165 line: 82
166 class:
167function: require_once
168 type:
169 args: Array
170(
171 [0] => /usr/share/mythtv/mythweb/modules/tv/detail.php
172)
173
174 file: /usr/share/mythtv/mythweb/mythweb.php
175 line: 35
176 class:
177function: require_once
178 type:
179 args: Array
180(
181 [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
182)
183
184
185==========================================================================
186
187$_GET: Array
188(
189 [chanid] => 9073
190 [starttime] => 1502577000
191 [manualid] => 0
192)
193
194==========================================================================
195
196$_POST: Array
197(
198 [record] => 1
199 [profile] => Default
200 [transcoder] => 0
201 [recgroup] => Default
202 [storagegroup] => Default
203 [playgroup] => Default
204 [recpriority] => 0
205 [dupmethod] => 6
206 [dupin] => 15
207 [prefinput] => 0
208 [inetref] =>
209 [season] =>
210 [episode] =>
211 [autometadata] => 1
212 [autocommflag] => 1
213 [autoexpire] => 1
214 [maxnewest] => 1
215 [maxepisodes] => 5
216 [startoffset] => 0
217 [endoffset] => 0
218 [save] => Update Recording Settings
219)
220
221==========================================================================
222
223$_SESSION: Array
224(
225 [cache_engine] => Cache_Null
226 [stream] => Array
227 (
228 [include_user_and_password] =>
229 )
230
231 [prefer_channum] => 1
232 [recorded_pixmaps] => 1
233 [guide_favonly] =>
234 [timeslot_size] => 300
235 [num_time_slots] => 36
236 [timeslot_blocks] => 3
237 [timeslotbar_skip] => 20
238 [max_stars] => 4
239 [star_character] => ★
240 [show_popup_info] => 1
241 [show_channel_icons] => 1
242 [sortby_channum] => 1
243 [recorded_paging] =>
244 [genre_colors] => 1
245 [show_video_covers] => 1
246 [settings] => Array
247 (
248 [screens] => Array
249 (
250 [tv] => Array
251 (
252 [upcoming recordings] => Array
253 (
254 [title] => on
255 [channel] => on
256 [record date] => on
257 [length] => on
258 )
259
260 )
261
262 )
263
264 [last] => Array
265 (
266 [0] => mythtv
267 [1] => settings
268 )
269
270 [host] =>
271 )
272
273 [backend] => Array
274 (
275 [192.168.1.5] => Array
276 (
277 [proto_version] => Array
278 (
279 [last_check_version] => 88
280 [last_check_time] => 1502575950
281 )
282
283 )
284
285 [timezone] => Array
286 (
287 [value] => America/New_York
288 [last_check_time] => 1502575950
289 )
290
291 )
292
293 [language] => English
294 [date_statusbar] => %a %b %e, %Y, %I:%M %p
295 [date_scheduled] => %a %b %e, %Y (%I:%M %p)
296 [date_scheduled_popup] => %a %b %e, %Y
297 [date_recorded] => %a %b %e, %Y (%I:%M %p)
298 [date_search] => %a %b %e, %Y, %I:%M %p
299 [date_listing_key] => %a %b %e, %Y, %I:%M %p
300 [date_listing_jump] => %a %b %e, %Y
301 [date_channel_jump] => %a %b %e, %Y
302 [date_job_status] => %a %b %e, %Y, %I:%M %p
303 [time_format] => %I:%M %p
304 [tv] => Array
305 (
306 [last] => Array
307 (
308 [0] => detail
309 [1] => 9073
310 [2] => 1502577000
311 )
312
313 [show_advanced_schedule] => 1
314 )
315
316 [search] => Array
317 (
318 [type] => q
319 [s] => ^Hamilton's America$
320 [ctype] => Array
321 (
322 [0] => movie
323 [1] => series
324 [2] => sports
325 [3] => tvshow
326 )
327
328 [categories] => Array ( )
329 [stars_gt] => 0
330 [stars_lt] => 1
331 [starttime] => now
332 [endtime] => + 2 weeks
333 [as] => Array
334 (
335 [0] => tcm
336 )
337
338 [af] => Array
339 (
340 [0] => Array
341 (
342 [0] => callsign
343 )
344
345 )
346
347 [aj] => Array
348 (
349 [0] => AND
350 )
351
352 [hd] =>
353 [commfree] =>
354 [unwatched] =>
355 [scheduled] =>
356 [generic] =>
357 [distinctTitle] =>
358 [airdate_start] =>
359 [airdate_end] =>
360 )
361
362 [search_sortby] => Array
363 (
364 [0] => Array
365 (
366 [field] => airdate
367 [reverse] =>
368 )
369
370 [1] => Array
371 (
372 [field] => title
373 [reverse] =>
374 )
375
376 )
377
378 [recording_details] => Array
379 (
380 [show_Conflict] => 1
381 [show_PreviousRecording] => 1
382 [show_EarlierShowing] => 1
383 [show_CurrentRecording] => 1
384 [show_WillRecord] => 1
385 )
386
387 [scheduled_recordings] => Array
388 (
389 [disp_scheduled] => 1
390 [disp_duplicates] =>
391 [disp_deactivated] =>
392 [disp_conflicts] => 1
393 )
394
395 [scheduled_sortby] => Array
396 (
397 [0] => Array
398 (
399 [field] => airdate
400 [reverse] =>
401 )
402
403 [1] => Array
404 (
405 [field] => title
406 [reverse] =>
407 )
408
409 )
410
411 [list_time] => 1502577900
412 [schedules_sortby] => Array
413 (
414 [0] => Array
415 (
416 [field] => airdate
417 [reverse] =>
418 )
419
420 [1] => Array
421 (
422 [field] => title
423 [reverse] =>
424 )
425
426 )
427
428 [recorded_sortby] => Array
429 (
430 [0] => Array
431 (
432 [field] => airdate
433 [reverse] => 1
434 )
435
436 [1] => Array
437 (
438 [field] => title
439 [reverse] =>
440 )
441
442 )
443
444 [] => Array ( )
445)
446
447==========================================================================
448
449$_SERVER: Array
450(
451 [REDIRECT_HTTPS] => on
452 [REDIRECT_SSL_TLS_SNI] => yardley.us.to
453 [REDIRECT_STATUS] => 200
454 [HTTPS] => on
455 [SSL_TLS_SNI] => yardley.us.to
456 [SSL_SERVER_S_DN_C] => US
457 [SSL_SERVER_S_DN_ST] => Pennsylvania
458 [SSL_SERVER_S_DN_L] => Yardley
459 [SSL_SERVER_S_DN_O] => kmpatel
460 [SSL_SERVER_S_DN_CN] => yardley.us.to
461 [SSL_SERVER_S_DN_Email] => kmpatel@sevina.mooo.com
462 [SSL_SERVER_I_DN_C] => US
463 [SSL_SERVER_I_DN_ST] => Pennsylvania
464 [SSL_SERVER_I_DN_L] => Yardley
465 [SSL_SERVER_I_DN_O] => kmpatel
466 [SSL_SERVER_I_DN_CN] => yardley.us.to
467 [SSL_SERVER_I_DN_Email] => kmpatel@sevina.mooo.com
468 [SSL_VERSION_INTERFACE] => mod_ssl/2.4.18
469 [SSL_VERSION_LIBRARY] => OpenSSL/1.0.2g
470 [SSL_PROTOCOL] => TLSv1.2
471 [SSL_SECURE_RENEG] => true
472 [SSL_COMPRESS_METHOD] => NULL
473 [SSL_CIPHER] => ECDHE-RSA-AES128-GCM-SHA256
474 [SSL_CIPHER_EXPORT] => false
475 [SSL_CIPHER_USEKEYSIZE] => 128
476 [SSL_CIPHER_ALGKEYSIZE] => 128
477 [SSL_CLIENT_VERIFY] => NONE
478 [SSL_SERVER_M_VERSION] => 3
479 [SSL_SERVER_M_SERIAL] => AF3D3757274391BF
480 [SSL_SERVER_V_START] => Jul 31 13:49:27 2014 GMT
481 [SSL_SERVER_V_END] => Apr 25 13:49:27 2017 GMT
482 [SSL_SERVER_S_DN] => emailAddress=kmpatel@sevina.mooo.com,CN=yardley.us.to,O=kmpatel,L=Yardley,ST=Pennsylvania,C=US
483 [SSL_SERVER_I_DN] => emailAddress=kmpatel@sevina.mooo.com,CN=yardley.us.to,O=kmpatel,L=Yardley,ST=Pennsylvania,C=US
484 [SSL_SERVER_A_KEY] => rsaEncryption
485 [SSL_SERVER_A_SIG] => sha1WithRSAEncryption
486 [SSL_SESSION_ID] => e6ef1dcbabf7d34d627bfa949cf81453c6143848b315a18255ad6c3c5af9e98c
487 [SSL_SESSION_RESUMED] => Resumed
488 [HTTP_HOST] => yardley.us.to
489 [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
490 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
491 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
492 [HTTP_ACCEPT_ENCODING] => gzip, deflate, br
493 [CONTENT_TYPE] => application/x-www-form-urlencoded
494 [CONTENT_LENGTH] => 292
495 [HTTP_REFERER] => https://yardley.us.to/mythweb/tv/detail/9073/1502577000
496 [HTTP_COOKIE] => mythweb_id=talur9f6pgj2o104c7ttehojg1
497 [HTTP_CONNECTION] => keep-alive
498 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
499 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
500 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at yardley.us.to Port 443</address>
501
502 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
503 [SERVER_NAME] => yardley.us.to
504 [SERVER_ADDR] => 192.168.1.5
505 [SERVER_PORT] => 443
506 [REMOTE_ADDR] => 104.244.192.59
507 [DOCUMENT_ROOT] => /var/www/html
508 [REQUEST_SCHEME] => https
509 [CONTEXT_PREFIX] =>
510 [CONTEXT_DOCUMENT_ROOT] => /var/www/html/
511 [SERVER_ADMIN] => webmaster@localhost
512 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
513 [REMOTE_PORT] => 13974
514 [REDIRECT_URL] => /mythweb/tv/detail/9073/1502577000
515 [GATEWAY_INTERFACE] => CGI/1.1
516 [SERVER_PROTOCOL] => HTTP/1.1
517 [REQUEST_METHOD] => POST
518 [QUERY_STRING] =>
519 [REQUEST_URI] => /tv/detail/9073/1502577000
520 [SCRIPT_NAME] => /mythweb/mythweb.php
521 [PATH_INFO] => /tv/detail/9073/1502577000
522 [PATH_TRANSLATED] => /var/www/html/tv/detail/9073/1502577000
523 [PHP_SELF] => /mythweb/mythweb.php/tv/detail/9073/1502577000
524 [REQUEST_TIME_FLOAT] => 1502578669.723
525 [REQUEST_TIME] => 1502578669
526 [STATUS] => 200
527 [URL] => /mythweb/tv/detail/9073/1502577000
528 [HTTP_X_FORWARDED_PROTO] =>
529 [HTTP_PORT] => 443
530)
531
532==========================================================================
533
534$constant_list["user"]: Array
535(
536 [ERROR] => 512
537 [E_ASSERT_ERROR] => 4096
538 [FATAL] => 256
539 [JOB_ABORTED] => 288
540 [JOB_ABORTING] => 9
541 [JOB_CANCELLED] => 320
542 [JOB_COMMFLAG] => 2
543 [JOB_DONE] => 256
544 [JOB_ERRORED] => 304
545 [JOB_ERRORING] => 8
546 [JOB_EXTERNAL] => 4
547 [JOB_FINISHED] => 272
548 [JOB_LIST_ALL] => 1
549 [JOB_LIST_DONE] => 2
550 [JOB_LIST_ERROR] => 8
551 [JOB_LIST_NOT_DONE] => 4
552 [JOB_LIST_RECENT] => 16
553 [JOB_LIVE_REC] => 2
554 [JOB_METADATA] => 4
555 [JOB_NONE] => 0
556 [JOB_NO_FLAGS] => 0
557 [JOB_PAUSE] => 1
558 [JOB_PAUSED] => 6
559 [JOB_PENDING] => 2
560 [JOB_QUEUED] => 1
561 [JOB_RESTART] => 8
562 [JOB_RESUME] => 2
563 [JOB_RETRY] => 7
564 [JOB_RUN] => 0
565 [JOB_RUNNING] => 4
566 [JOB_STARTING] => 3
567 [JOB_STOP] => 4
568 [JOB_STOPPING] => 5
569 [JOB_SYSTEMJOB] => 255
570 [JOB_TRANSCODE] => 1
571 [JOB_UNKNOWN] => 0
572 [JOB_USERJOB] => 65280
573 [JOB_USERJOB1] => 256
574 [JOB_USERJOB2] => 512
575 [JOB_USERJOB3] => 1024
576 [JOB_USERJOB4] => 2048
577 [JOB_USE_CUTLIST] => 1
578 [PHP_MIN_VERSION] => 5.3
579 [WARNING] => 1024
580 [WebDBSchemaVer] => 4
581 [dupsin_all] => 15
582 [dupsin_newepisodes] => 16
583 [dupsin_oldrecorded] => 2
584 [dupsin_recorded] => 1
585 [error_email] =>
586 [gb] => 1073741824
587 [hostname] => mythtv-yardley
588 [http_host] => yardley.us.to
589 [kb] => 1024
590 [max_stars] => 4
591 [mb] => 1048576
592 [module] => tv
593 [modules_path] => /usr/share/mythtv/mythweb/modules
594 [num_time_slots] => 36
595 [prefer_channum] => 1
596 [rectype_always] => 4
597 [rectype_daily] => 2
598 [rectype_dontrec] => 8
599 [rectype_findone] => 6
600 [rectype_once] => 1
601 [rectype_override] => 7
602 [rectype_template] => 11
603 [rectype_weekly] => 5
604 [root] => /mythweb/
605 [root_auth_url] => https://yardley.us.to/mythweb/
606 [root_url] => https://yardley.us.to/mythweb/
607 [searchtype_keyword] => 3
608 [searchtype_manual] => 5
609 [searchtype_people] => 4
610 [searchtype_power] => 1
611 [searchtype_title] => 2
612 [skin] => default
613 [skin_img_url] => https://yardley.us.to/mythweb/skins/default/img/
614 [skin_url] => https://yardley.us.to/mythweb/skins/default/
615 [star_character] => &#9733;
616 [stream_url] => https://yardley.us.to:443//mythweb/
617 [tb] => 1099511627776
618 [timeslot_blocks] => 3
619 [timeslot_size] => 300
620 [timeslotbar_skip] => 20
621 [tmpl] => default
622 [tmpl_dir] => modules/tv/tmpl/default/
623)
624
625