Ticket #12874: error.txt

File error.txt, 20.5 KB (added by b.gagne@…, 9 years ago)

Logs

Line 
1 datetime: 2016-09-12 10:02:14 (EDT)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Incorrect integer value: '' for column 'finetune' at row 1 [#1366]!!
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 integer value: '' for column 'finetune' at row 1 [#1366]
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] => Array
33 (
34 [0] => CBFT
35 [1] => 19
36 [2] =>
37 [3] =>
38 [4] => 32768
39 [5] => 32768
40 [6] => 32768
41 [7] => 32768
42 [8] => 0
43 [9] => -1
44 [10] => 1
45 [11] => 1
46 [12] => 2_1
47 [13] => CBFT-DT
48 [14] => MONTREAL CBFT-DT
49 )
50
51 [1] => 1153
52 )
53
54)
55
56 file: /usr/share/mythtv/mythweb/modules/tv/set_channels.php
57 line: 59
58 class: Database
59function: query
60 type: ->
61 args: Array
62(
63 [0] => UPDATE channel SET xmltvid = ?,
64 freqid = ?,
65 finetune = ?,
66 videofilters = ?,
67 brightness = ?,
68 contrast = ?,
69 colour = ?,
70 hue = ?,
71 recpriority = ?,
72 commmethod = ?,
73 useonairguide = ?,
74 visible = ?,channum=?,callsign=?,name=? WHERE chanid=?
75 [1] => Array
76 (
77 [0] => CBFT
78 [1] => 19
79 [2] =>
80 [3] =>
81 [4] => 32768
82 [5] => 32768
83 [6] => 32768
84 [7] => 32768
85 [8] => 0
86 [9] => -1
87 [10] => 1
88 [11] => 1
89 [12] => 2_1
90 [13] => CBFT-DT
91 [14] => MONTREAL CBFT-DT
92 )
93
94 [2] => 1153
95)
96
97 file: /usr/share/mythtv/mythweb/modules/settings/handler.php
98 line: 54
99 class:
100function: require_once
101 type:
102 args: Array
103(
104 [0] => /usr/share/mythtv/mythweb/modules/tv/set_channels.php
105)
106
107 file: /usr/share/mythtv/mythweb/mythweb.php
108 line: 35
109 class:
110function: require_once
111 type:
112 args: Array
113(
114 [0] => /usr/share/mythtv/mythweb/modules/settings/handler.php
115)
116
117
118==========================================================================
119
120$_POST: Array
121(
122 [channel] => Array
123 (
124 [1153] => Array
125 (
126 [xmltvid] => CBFT
127 [channum] => 2_1
128 [callsign] => CBFT-DT
129 [name] => MONTREAL CBFT-DT
130 [freqid] => 19
131 [finetune] =>
132 [videofilters] =>
133 [brightness] => 32768
134 [contrast] => 32768
135 [colour] => 32768
136 [hue] => 32768
137 [recpriority] => 0
138 [visible] => 1
139 [useonairguide] => 1
140 )
141
142 [1031] => Array
143 (
144 [xmltvid] =>
145 [channum] => 3_1
146 [callsign] => WCAX-HD
147 [name] => WCAX-HD
148 [freqid] => 22
149 [finetune] =>
150 [videofilters] =>
151 [brightness] => 32768
152 [contrast] => 32768
153 [colour] => 32768
154 [hue] => 32768
155 [recpriority] => 0
156 [visible] => 1
157 [useonairguide] => 1
158 )
159
160 [1032] => Array
161 (
162 [xmltvid] =>
163 [channum] => 3_2
164 [callsign] => Movies
165 [name] => Movies
166 [freqid] => 22
167 [finetune] =>
168 [videofilters] =>
169 [brightness] => 32768
170 [contrast] => 32768
171 [colour] => 32768
172 [hue] => 32768
173 [recpriority] => 0
174 [visible] => 1
175 [useonairguide] => 1
176 )
177
178 [1041] => Array
179 (
180 [xmltvid] =>
181 [channum] => 4_1
182 [callsign] => CBOT-DT
183 [name] => OTTAWA CBOT-DT
184 [freqid] => 25
185 [finetune] =>
186 [videofilters] =>
187 [brightness] => 32768
188 [contrast] => 32768
189 [colour] => 32768
190 [hue] => 32768
191 [recpriority] => 0
192 [visible] => 1
193 [useonairguide] => 1
194 )
195
196 [1061] => Array
197 (
198 [xmltvid] =>
199 [channum] => 6_1
200 [callsign] => CBMT-DT
201 [name] => MONTREAL CBMT-DT
202 [freqid] => 21
203 [finetune] =>
204 [videofilters] =>
205 [brightness] => 32768
206 [contrast] => 32768
207 [colour] => 32768
208 [hue] => 32768
209 [recpriority] => 0
210 [visible] => 1
211 [useonairguide] => 1
212 )
213
214 [1101] => Array
215 (
216 [xmltvid] =>
217 [channum] => 10_1
218 [callsign] => CFTM-HD
219 [name] => CFTM-HD
220 [freqid] => 10
221 [finetune] =>
222 [videofilters] =>
223 [brightness] => 32768
224 [contrast] => 32768
225 [colour] => 32768
226 [hue] => 32768
227 [recpriority] => 0
228 [visible] => 1
229 [useonairguide] => 1
230 )
231
232 [1121] => Array
233 (
234 [xmltvid] => CFCF
235 [channum] => 12_1
236 [callsign] => CFCF
237 [name] => CFCF
238 [freqid] => 12
239 [finetune] =>
240 [videofilters] =>
241 [brightness] => 32768
242 [contrast] => 32768
243 [colour] => 32768
244 [hue] => 32768
245 [recpriority] => 0
246 [visible] => 1
247 [useonairguide] => 1
248 )
249
250 [1151] => Array
251 (
252 [xmltvid] =>
253 [channum] => 15_1
254 [callsign] => CKMI-HD
255 [name] => CKMI-HD
256 [freqid] => 15
257 [finetune] =>
258 [videofilters] =>
259 [brightness] => 32768
260 [contrast] => 32768
261 [colour] => 32768
262 [hue] => 32768
263 [recpriority] => 0
264 [visible] => 1
265 [useonairguide] => 1
266 )
267
268 [1152] => Array
269 (
270 [xmltvid] =>
271 [channum] => 15_2
272 [callsign] => CKMI-SD
273 [name] => CKMI-SD
274 [freqid] => 15
275 [finetune] =>
276 [videofilters] =>
277 [brightness] => 32768
278 [contrast] => 32768
279 [colour] => 32768
280 [hue] => 32768
281 [recpriority] => 0
282 [visible] => 1
283 [useonairguide] => 1
284 )
285
286 [1171] => Array
287 (
288 [xmltvid] =>
289 [channum] => 17_1
290 [callsign] => CIVM-HD
291 [name] => CIVM-HD
292 [freqid] => 26
293 [finetune] =>
294 [videofilters] =>
295 [brightness] => 32768
296 [contrast] => 32768
297 [colour] => 32768
298 [hue] => 32768
299 [recpriority] => 0
300 [visible] => 1
301 [useonairguide] => 1
302 )
303
304 [1181] => Array
305 (
306 [xmltvid] =>
307 [channum] => 18_1
308 [callsign] => WNPI HD
309 [name] => WNPI HD
310 [freqid] => 23
311 [finetune] =>
312 [videofilters] =>
313 [brightness] => 32768
314 [contrast] => 32768
315 [colour] => 32768
316 [hue] => 32768
317 [recpriority] => 0
318 [visible] => 1
319 [useonairguide] => 1
320 )
321
322 [1182] => Array
323 (
324 [xmltvid] =>
325 [channum] => 18_2
326 [callsign] => WNPI-2
327 [name] => WNPI-2
328 [freqid] => 23
329 [finetune] =>
330 [videofilters] =>
331 [brightness] => 32768
332 [contrast] => 32768
333 [colour] => 32768
334 [hue] => 32768
335 [recpriority] => 0
336 [visible] => 1
337 [useonairguide] => 1
338 )
339
340 [1183] => Array
341 (
342 [xmltvid] => WNPI
343 [channum] => 18_3
344 [callsign] => WNPI
345 [name] => WNPI
346 [freqid] => 23
347 [finetune] =>
348 [videofilters] =>
349 [brightness] => 32768
350 [contrast] => 32768
351 [colour] => 32768
352 [hue] => 32768
353 [recpriority] => 0
354 [visible] => 1
355 [useonairguide] => 1
356 )
357
358 [1351] => Array
359 (
360 [xmltvid] =>
361 [channum] => 35_1
362 [callsign] => CFJP-DT
363 [name] => CFJP-DT
364 [freqid] => 35
365 [finetune] =>
366 [videofilters] =>
367 [brightness] => 32768
368 [contrast] => 32768
369 [colour] => 32768
370 [hue] => 32768
371 [recpriority] => 0
372 [visible] => 1
373 [useonairguide] => 1
374 )
375
376 [1571] => Array
377 (
378 [xmltvid] =>
379 [channum] => 57_1
380 [callsign] => WCFE-HD
381 [name] => WCFE-HD
382 [freqid] => 38
383 [finetune] =>
384 [videofilters] =>
385 [brightness] => 32768
386 [contrast] => 32768
387 [colour] => 32768
388 [hue] => 32768
389 [recpriority] => 0
390 [visible] => 1
391 [useonairguide] => 1
392 )
393
394 [1572] => Array
395 (
396 [xmltvid] =>
397 [channum] => 57_2
398 [callsign] => WCFE-SD
399 [name] => WCFE-SD
400 [freqid] => 38
401 [finetune] =>
402 [videofilters] =>
403 [brightness] => 32768
404 [contrast] => 32768
405 [colour] => 32768
406 [hue] => 32768
407 [recpriority] => 0
408 [visible] => 1
409 [useonairguide] => 1
410 )
411
412 [1573] => Array
413 (
414 [xmltvid] =>
415 [channum] => 57_3
416 [callsign] => WCFE-SD
417 [name] => WCFE-SD
418 [freqid] => 38
419 [finetune] =>
420 [videofilters] =>
421 [brightness] => 32768
422 [contrast] => 32768
423 [colour] => 32768
424 [hue] => 32768
425 [recpriority] => 0
426 [visible] => 1
427 [useonairguide] => 1
428 )
429
430 [1621] => Array
431 (
432 [xmltvid] => CJNT
433 [channum] => 62_1
434 [callsign] => CJNT
435 [name] => CJNT
436 [freqid] => 49
437 [finetune] =>
438 [videofilters] =>
439 [brightness] => 32768
440 [contrast] => 32768
441 [colour] => 32768
442 [hue] => 32768
443 [recpriority] => 0
444 [visible] => 1
445 [useonairguide] => 1
446 )
447
448 [2025] => Array
449 (
450 [xmltvid] =>
451 [channum] => 1025
452 [callsign] => CFHD-DT
453 [name] => K26CV-D Ogallala, NE (PBJ)
454 [freqid] => 47
455 [finetune] =>
456 [videofilters] =>
457 [brightness] => 32768
458 [contrast] => 32768
459 [colour] => 32768
460 [hue] => 32768
461 [recpriority] => 0
462 [visible] => 1
463 )
464
465 )
466
467 [save] => Sauvegarder
468)
469
470==========================================================================
471
472$_SESSION: Array
473(
474 [cache_engine] => Cache_Null
475 [stream] => Array
476 (
477 [include_user_and_password] =>
478 )
479
480 [prefer_channum] => 1
481 [recorded_pixmaps] => 1
482 [guide_favonly] =>
483 [timeslot_size] => 300
484 [num_time_slots] => 36
485 [timeslot_blocks] => 3
486 [timeslotbar_skip] => 20
487 [max_stars] => 4
488 [star_character] => ★
489 [show_popup_info] => 1
490 [show_channel_icons] => 1
491 [sortby_channum] => 1
492 [recorded_paging] =>
493 [genre_colors] => 1
494 [show_video_covers] => 1
495 [settings] => Array
496 (
497 [screens] => Array
498 (
499 [tv] => Array
500 (
501 [upcoming recordings] => Array
502 (
503 [title] => on
504 [channel] => on
505 [record date] => on
506 [length] => on
507 )
508
509 )
510
511 )
512
513 [last] => Array
514 (
515 [0] => tv
516 [1] => channels
517 )
518
519 )
520
521 [backend] => Array
522 (
523 [10.10.10.97] => Array
524 (
525 [proto_version] => Array
526 (
527 [last_check_version] => 88
528 [last_check_time] => 1473688367
529 )
530
531 )
532
533 [timezone] => Array
534 (
535 [value] => America/Toronto
536 [last_check_time] => 1473688367
537 )
538
539 )
540
541 [language] => French
542 [date_statusbar] => %e %b %Y, %H:%M
543 [date_scheduled] => %e %b %Y (%H:%M)
544 [date_scheduled_popup] => %e %b %Y
545 [date_recorded] => %e %b %Y (%H:%M)
546 [date_search] => %e %b %Y, %H:%M
547 [date_listing_key] => %e %b %Y, %H:%M
548 [date_listing_jump] => %e %b %Y
549 [date_channel_jump] => %e %b %Y
550 [date_job_status] => %e %b %Y, %H:%M
551 [time_format] => %H:%M
552 [tv] => Array
553 (
554 [last] => Array
555 (
556 [0] => list
557 )
558
559 )
560
561 [list_time] => 1473687900
562)
563
564==========================================================================
565
566$_SERVER: Array
567(
568 [REDIRECT_STATUS] => 200
569 [HTTP_HOST] => 10.10.10.97
570 [HTTP_CONNECTION] => keep-alive
571 [CONTENT_LENGTH] => 9573
572 [HTTP_CACHE_CONTROL] => max-age=0
573 [HTTP_ORIGIN] => http://10.10.10.97
574 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
575 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
576 [CONTENT_TYPE] => application/x-www-form-urlencoded
577 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
578 [HTTP_REFERER] => http://10.10.10.97/mythweb/settings
579 [HTTP_ACCEPT_ENCODING] => gzip, deflate
580 [HTTP_ACCEPT_LANGUAGE] => fr-FR,fr;q=0.8,en-US;q=0.6,en;q=0.4
581 [HTTP_COOKIE] => mythweb_id=ekv2hhc7d40fsu7pu78odt93h1
582 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
583 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 10.10.10.97 Port 80</address>
584
585 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
586 [SERVER_NAME] => 10.10.10.97
587 [SERVER_ADDR] => 10.10.10.97
588 [SERVER_PORT] => 80
589 [REMOTE_ADDR] => 10.10.10.247
590 [DOCUMENT_ROOT] => /var/www/html
591 [REQUEST_SCHEME] => http
592 [CONTEXT_PREFIX] =>
593 [CONTEXT_DOCUMENT_ROOT] => /var/www/html
594 [SERVER_ADMIN] => webmaster@localhost
595 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
596 [REMOTE_PORT] => 62028
597 [REDIRECT_URL] => /mythweb/settings/tv/channels
598 [GATEWAY_INTERFACE] => CGI/1.1
599 [SERVER_PROTOCOL] => HTTP/1.1
600 [REQUEST_METHOD] => POST
601 [QUERY_STRING] =>
602 [REQUEST_URI] => /settings/tv/channels
603 [SCRIPT_NAME] => /mythweb/mythweb.php
604 [PATH_INFO] => /settings/tv/channels
605 [PATH_TRANSLATED] => /var/www/html/settings/tv/channels
606 [PHP_SELF] => /mythweb/mythweb.php/settings/tv/channels
607 [REQUEST_TIME_FLOAT] => 1473688933.026
608 [REQUEST_TIME] => 1473688933
609 [STATUS] => 200
610 [URL] => /mythweb/settings/tv/channels
611 [HTTP_X_FORWARDED_PROTO] =>
612 [HTTPS] =>
613 [HTTP_PORT] => 80
614)
615
616==========================================================================
617
618$constant_list["user"]: Array
619(
620 [ERROR] => 512
621 [E_ASSERT_ERROR] => 4096
622 [FATAL] => 256
623 [PHP_MIN_VERSION] => 5.3
624 [WARNING] => 1024
625 [WebDBSchemaVer] => 4
626 [error_email] =>
627 [form_action] => http://10.10.10.97/mythweb/settings/tv/channels
628 [gb] => 1073741824
629 [hostname] => HQ-SVR-MYTH
630 [http_host] => 10.10.10.97
631 [kb] => 1024
632 [max_stars] => 4
633 [mb] => 1048576
634 [module] => settings
635 [modules_path] => /usr/share/mythtv/mythweb/modules
636 [num_time_slots] => 36
637 [prefer_channum] => 1
638 [root] => /mythweb/
639 [root_auth_url] => http://10.10.10.97/mythweb/
640 [root_url] => http://10.10.10.97/mythweb/
641 [skin] => default
642 [skin_img_url] => http://10.10.10.97/mythweb/skins/default/img/
643 [skin_url] => http://10.10.10.97/mythweb/skins/default/
644 [star_character] => &#9733;
645 [stream_url] => http://10.10.10.97:80//mythweb/
646 [tb] => 1099511627776
647 [timeslot_blocks] => 3
648 [timeslot_size] => 300
649 [timeslotbar_skip] => 20
650 [tmpl] => default
651 [tmpl_dir] => modules/settings/tmpl/default/
652)
653
654