Ticket #12878: Error.txt

File Error.txt, 13.1 KB (added by anonymous, 10 years ago)
Line 
1 datetime: 2016-09-14 19:41:07 (CDT)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Incorrect datetime value: '1473904800' for column 'starttime' 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: '1473904800' for column 'starttime' 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] => 1473904800
33 [1] => 2747
34 )
35
36)
37
38 file: /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
39 line: 705
40 class: Database
41function: query
42 type: ->
43 args: Array
44(
45 [0] => UPDATE oldrecorded
46 SET oldrecorded.reactivate = 1
47 WHERE oldrecorded.starttime = ?
48 AND oldrecorded.chanid = ?
49 [1] => 1473904800
50 [2] => 2747
51)
52
53 file: /usr/share/mythtv/mythweb/modules/tv/upcoming.php
54 line: 47
55 class: Program
56function: activate
57 type: ->
58 args: Array ( )
59 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
60 line: 82
61 class:
62function: require_once
63 type:
64 args: Array
65(
66 [0] => /usr/share/mythtv/mythweb/modules/tv/upcoming.php
67)
68
69 file: /usr/share/mythtv/mythweb/mythweb.php
70 line: 35
71 class:
72function: require_once
73 type:
74 args: Array
75(
76 [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
77)
78
79
80==========================================================================
81
82$_GET: Array
83(
84 [activate] => yes
85 [chanid] => 2747
86 [starttime] => 1473904800
87 [manualid] => 0
88)
89
90==========================================================================
91
92$_SESSION: Array
93(
94 [cache_engine] => Cache_Null
95 [stream] => Array
96 (
97 [include_user_and_password] =>
98 )
99
100 [prefer_channum] => 1
101 [recorded_pixmaps] => 1
102 [guide_favonly] =>
103 [timeslot_size] => 300
104 [num_time_slots] => 36
105 [timeslot_blocks] => 3
106 [timeslotbar_skip] => 20
107 [max_stars] => 4
108 [star_character] => ★
109 [show_popup_info] => 1
110 [show_channel_icons] => 1
111 [sortby_channum] => 1
112 [recorded_paging] =>
113 [genre_colors] => 1
114 [show_video_covers] => 1
115 [settings] => Array
116 (
117 [screens] => Array
118 (
119 [tv] => Array
120 (
121 [upcoming recordings] => Array
122 (
123 [title] => on
124 [channel] => on
125 [record date] => on
126 [length] => on
127 )
128
129 )
130
131 )
132
133 [last] => Array
134 (
135 [0] => database
136 [1] => settings
137 )
138
139 )
140
141 [backend] => Array
142 (
143 [timezone] => Array
144 (
145 [value] => America/Chicago
146 [last_check_time] => 1473899300
147 )
148
149 [192.168.0.40] => Array
150 (
151 [proto_version] => Array
152 (
153 [last_check_version] => 88
154 [last_check_time] => 1473899300
155 )
156
157 )
158
159 )
160
161 [language] => English
162 [date_statusbar] => %a %b %e, %Y, %I:%M %p
163 [date_scheduled] => %a %b %e, %Y (%I:%M %p)
164 [date_scheduled_popup] => %a %b %e, %Y
165 [date_recorded] => %a %b %e, %Y (%I:%M %p)
166 [date_search] => %a %b %e, %Y, %I:%M %p
167 [date_listing_key] => %a %b %e, %Y, %I:%M %p
168 [date_listing_jump] => %a %b %e, %Y
169 [date_channel_jump] => %a %b %e, %Y
170 [date_job_status] => %a %b %e, %Y, %I:%M %p
171 [time_format] => %I:%M %p
172 [tv] => Array
173 (
174 [last] => Array
175 (
176 [0] => upcoming
177 [1] => 2747
178 [2] => 1473904800
179 )
180
181 [show_advanced_schedule] => 1
182 )
183
184 [schedules_sortby] => Array
185 (
186 [0] => Array
187 (
188 [field] => airdate
189 [reverse] =>
190 )
191
192 [1] => Array
193 (
194 [field] => title
195 [reverse] =>
196 )
197
198 )
199
200 [scheduled_recordings] => Array
201 (
202 [disp_scheduled] => 1
203 [disp_duplicates] => 1
204 [disp_deactivated] =>
205 [disp_conflicts] => 1
206 [disp_recgroup] =>
207 [disp_title] => South Park
208 )
209
210 [] => Array ( )
211 [recorded_sortby] => Array
212 (
213 [0] => Array
214 (
215 [field] => originalairdate
216 [reverse] =>
217 )
218
219 [1] => Array
220 (
221 [field] => airdate
222 [reverse] => 1
223 )
224
225 [2] => Array
226 (
227 [field] => title
228 [reverse] =>
229 )
230
231 )
232
233 [list_time] => 1473899400
234 [search] => Array
235 (
236 [type] => q
237 [s] => ^South Park$
238 [ctype] => Array
239 (
240 [0] => movie
241 [1] => series
242 [2] => sports
243 [3] => tvshow
244 )
245
246 [categories] => Array ( )
247 [stars_gt] => 0
248 [stars_lt] => 1
249 [starttime] => now
250 [endtime] => + 2 weeks
251 [as] => Array
252 (
253 [0] => Geeks who drink
254 [1] => Once Upon a Time
255 [2] => Scream Queens
256 [3] => Sleepy Hollow
257 [4] => Stitchers
258 [5] => The Librarians
259 [6] => Elementry
260 [7] => Gotham
261 [8] => iZombie
262 [9] => The Americans
263 )
264
265 [af] => Array
266 (
267 [0] => Array
268 (
269 [0] => title
270 )
271
272 [1] => Array
273 (
274 [0] => title
275 )
276
277 [2] => Array
278 (
279 [0] => title
280 )
281
282 [3] => Array
283 (
284 [0] => title
285 )
286
287 [4] => Array
288 (
289 [0] => title
290 )
291
292 [5] => Array
293 (
294 [0] => title
295 )
296
297 [6] => Array
298 (
299 [0] => title
300 )
301
302 [7] => Array
303 (
304 [0] => title
305 )
306
307 [8] => Array
308 (
309 [0] => title
310 )
311
312 [9] => Array
313 (
314 [0] => title
315 )
316
317 )
318
319 [aj] => Array
320 (
321 [0] => AND
322 [1] => OR
323 [2] => OR
324 [3] => OR
325 [4] => OR
326 [5] => OR
327 [6] => OR
328 [7] => OR
329 [8] => OR
330 [9] => OR
331 )
332
333 [hd] =>
334 [commfree] =>
335 [unwatched] =>
336 [scheduled] =>
337 [generic] =>
338 [distinctTitle] =>
339 [airdate_start] =>
340 [airdate_end] =>
341 )
342
343 [search_sortby] => Array
344 (
345 [0] => Array
346 (
347 [field] => airdate
348 [reverse] =>
349 )
350
351 [1] => Array
352 (
353 [field] => title
354 [reverse] =>
355 )
356
357 )
358
359 [recording_details] => Array
360 (
361 [show_Conflict] => 1
362 [show_PreviousRecording] => 1
363 [show_EarlierShowing] => 1
364 [show_CurrentRecording] => 1
365 [show_WillRecord] => 1
366 )
367
368 [scheduled_sortby] => Array
369 (
370 [0] => Array
371 (
372 [field] => airdate
373 [reverse] =>
374 )
375
376 [1] => Array
377 (
378 [field] => title
379 [reverse] =>
380 )
381
382 )
383
384)
385
386==========================================================================
387
388$_SERVER: Array
389(
390 [REDIRECT_STATUS] => 200
391 [HTTP_HOST] => 192.168.0.40
392 [HTTP_CONNECTION] => keep-alive
393 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
394 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
395 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
396 [HTTP_REFERER] => http://192.168.0.40/mythweb/tv/upcoming
397 [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
398 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
399 [HTTP_COOKIE] => mythweb_id=4389kigoqqmppoo9nlgkr1f3r3
400 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
401 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.0.40 Port 80</address>
402
403 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
404 [SERVER_NAME] => 192.168.0.40
405 [SERVER_ADDR] => 192.168.0.40
406 [SERVER_PORT] => 80
407 [REMOTE_ADDR] => 192.168.0.103
408 [DOCUMENT_ROOT] => /var/www/html
409 [REQUEST_SCHEME] => http
410 [CONTEXT_PREFIX] =>
411 [CONTEXT_DOCUMENT_ROOT] => /var/www/html
412 [SERVER_ADMIN] => webmaster@localhost
413 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
414 [REMOTE_PORT] => 59814
415 [REDIRECT_URL] => /mythweb/tv/upcoming/2747/1473904800
416 [REDIRECT_QUERY_STRING] => activate=yes
417 [GATEWAY_INTERFACE] => CGI/1.1
418 [SERVER_PROTOCOL] => HTTP/1.1
419 [REQUEST_METHOD] => GET
420 [QUERY_STRING] => activate=yes
421 [REQUEST_URI] => /tv/upcoming/2747/1473904800?activate=yes
422 [SCRIPT_NAME] => /mythweb/mythweb.php
423 [PATH_INFO] => /tv/upcoming/2747/1473904800
424 [PATH_TRANSLATED] => /var/www/html/tv/upcoming/2747/1473904800
425 [PHP_SELF] => /mythweb/mythweb.php/tv/upcoming/2747/1473904800
426 [REQUEST_TIME_FLOAT] => 1473900067.364
427 [REQUEST_TIME] => 1473900067
428 [STATUS] => 200
429 [URL] => /mythweb/tv/upcoming/2747/1473904800
430 [HTTP_X_FORWARDED_PROTO] =>
431 [HTTPS] =>
432 [HTTP_PORT] => 80
433)
434
435==========================================================================
436
437$constant_list["user"]: Array
438(
439 [ERROR] => 512
440 [E_ASSERT_ERROR] => 4096
441 [FATAL] => 256
442 [PHP_MIN_VERSION] => 5.3
443 [WARNING] => 1024
444 [WebDBSchemaVer] => 4
445 [dupsin_all] => 15
446 [dupsin_newepisodes] => 16
447 [dupsin_oldrecorded] => 2
448 [dupsin_recorded] => 1
449 [error_email] =>
450 [gb] => 1073741824
451 [hostname] => mythbuntu-be
452 [http_host] => 192.168.0.40
453 [kb] => 1024
454 [max_stars] => 4
455 [mb] => 1048576
456 [module] => tv
457 [modules_path] => /usr/share/mythtv/mythweb/modules
458 [num_time_slots] => 36
459 [prefer_channum] => 1
460 [rectype_always] => 4
461 [rectype_daily] => 2
462 [rectype_dontrec] => 8
463 [rectype_findone] => 6
464 [rectype_once] => 1
465 [rectype_override] => 7
466 [rectype_template] => 11
467 [rectype_weekly] => 5
468 [root] => /mythweb/
469 [root_auth_url] => http://192.168.0.40/mythweb/
470 [root_url] => http://192.168.0.40/mythweb/
471 [searchtype_keyword] => 3
472 [searchtype_manual] => 5
473 [searchtype_people] => 4
474 [searchtype_power] => 1
475 [searchtype_title] => 2
476 [skin] => default
477 [skin_img_url] => http://192.168.0.40/mythweb/skins/default/img/
478 [skin_url] => http://192.168.0.40/mythweb/skins/default/
479 [star_character] => &#9733;
480 [stream_url] => http://192.168.0.40:80//mythweb/
481 [tb] => 1099511627776
482 [timeslot_blocks] => 3
483 [timeslot_size] => 300
484 [timeslotbar_skip] => 20
485 [tmpl] => default
486 [tmpl_dir] => modules/tv/tmpl/default/
487)