datetime: 2017-06-14 19:38:37 (PDT) errornum: 256 error type: User Error error string: !!NoTrans: SQL Error: Incorrect integer value: '' for column 'finetune' at row 1 [#1366]!! filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php error line: 98 ========================================================================== Backtrace: file: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php line: 98 class: function: trigger_error type: args: Array ( [0] => SQL Error: Incorrect integer value: '' for column 'finetune' at row 1 [#1366] [1] => 256 ) file: /usr/share/mythtv/mythweb/classes/Database.php line: 261 class: Database_Query_mysqlicompat function: execute type: -> args: Array ( [0] => Array ( [0] => Array ( [0] => 19629 [1] => 38 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 4_1 [13] => KOMO [14] => KOMO ) [1] => 1041 ) ) file: /usr/share/mythtv/mythweb/modules/tv/set_channels.php line: 59 class: Database function: query type: -> args: Array ( [0] => UPDATE channel SET xmltvid = ?, freqid = ?, finetune = ?, videofilters = ?, brightness = ?, contrast = ?, colour = ?, hue = ?, recpriority = ?, commmethod = ?, useonairguide = ?, visible = ?,channum=?,callsign=?,name=? WHERE chanid=? [1] => Array ( [0] => 19629 [1] => 38 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 4_1 [13] => KOMO [14] => KOMO ) [2] => 1041 ) file: /usr/share/mythtv/mythweb/modules/settings/handler.php line: 54 class: function: require_once type: args: Array ( [0] => /usr/share/mythtv/mythweb/modules/tv/set_channels.php ) file: /usr/share/mythtv/mythweb/mythweb.php line: 35 class: function: require_once type: args: Array ( [0] => /usr/share/mythtv/mythweb/modules/settings/handler.php ) ========================================================================== $_POST: Array ( [channel] => Array ( [1041] => Array ( [xmltvid] => 19629 [channum] => 4_1 [callsign] => KOMO [name] => KOMO [freqid] => 38 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1042] => Array ( [xmltvid] => 63537 [channum] => 4_2 [callsign] => Comet [name] => COMET is a channel dedicated to sci-fi entertainment offering po [freqid] => 38 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1043] => Array ( [xmltvid] => 91578 [channum] => 4_3 [callsign] => Charge [name] => Charge [freqid] => 38 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1051] => Array ( [xmltvid] => 19630 [channum] => 5_1 [callsign] => KING-HD [name] => KING-HD [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1052] => Array ( [xmltvid] => 46081 [channum] => 5_2 [callsign] => KING-SD [name] => KING-SD [freqid] => 48 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1071] => Array ( [xmltvid] => 20290 [channum] => 7_1 [callsign] => KIRO-DT [name] => KIRO-DT [freqid] => 39 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1072] => Array ( [xmltvid] => 49928 [channum] => 7_2 [callsign] => KIRO-SD [name] => KIRO-SD [freqid] => 39 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1073] => Array ( [xmltvid] => 59434 [channum] => 7_3 [callsign] => KIRO 3 [name] => KIRO 3 [freqid] => 39 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1091] => Array ( [xmltvid] => 19631 [channum] => 9_1 [callsign] => KCTS-HD [name] => KCTS-HD [freqid] => 9 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1092] => Array ( [xmltvid] => 20206 [channum] => 9_2 [callsign] => KIDS [name] => KIDS [freqid] => 9 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1093] => Array ( [xmltvid] => 20303 [channum] => 9_3 [callsign] => Create [name] => Create [freqid] => 9 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1111] => Array ( [xmltvid] => 21253 [channum] => 11_1 [callsign] => KSTW-HD [name] => KSTW-HD [freqid] => 11 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1112] => Array ( [xmltvid] => 92434 [channum] => 11_2 [callsign] => KSTW-DT [name] => KSTW-DT [freqid] => 11 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1121] => Array ( [xmltvid] => 35074 [channum] => 12_1 [callsign] => MeTV [name] => MeTV [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1122] => Array ( [xmltvid] => 72996 [channum] => 12_2 [callsign] => MOVIES! [name] => MOVIES! [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1123] => Array ( [xmltvid] => 87102 [channum] => 12_3 [callsign] => H&I [name] => H&I [freqid] => 35 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1131] => Array ( [xmltvid] => 21254 [channum] => 13-3 [callsign] => KCPQ [name] => KCPQ [freqid] => 13 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1132] => Array ( [xmltvid] => 30904 [channum] => 13-4 [callsign] => ThisTV [name] => ThisTV [freqid] => 13 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1133] => Array ( [xmltvid] => 98013 [channum] => 13-5 [callsign] => ESCAPE [name] => ESCAPE [freqid] => 13 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1161] => Array ( [xmltvid] => 31007 [channum] => 16_1 [callsign] => KONG-HD [name] => KONG-HD [freqid] => 31 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1201] => Array ( [delete] => true [xmltvid] => 52292 [channum] => 20_1 [callsign] => TBN [name] => TBN [freqid] => 14 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1202] => Array ( [delete] => true [xmltvid] => 58650 [channum] => 20_2 [callsign] => Hillsng [name] => Hillsng [freqid] => 14 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1203] => Array ( [delete] => true [xmltvid] => 58653 [channum] => 20_3 [callsign] => COMBO [name] => COMBO [freqid] => 14 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1204] => Array ( [delete] => true [xmltvid] => 58655 [channum] => 20_4 [callsign] => Enlace [name] => Enlace [freqid] => 14 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1205] => Array ( [delete] => true [xmltvid] => 58657 [channum] => 20_5 [callsign] => Salsa [name] => Salsa [freqid] => 14 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1001] => Array ( [xmltvid] => 21254 [channum] => 22-3 [callsign] => KCPQ [name] => KCPQ [freqid] => 22 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1002] => Array ( [xmltvid] => 30904 [channum] => 22-4 [callsign] => ThisTV [name] => ThisTV [freqid] => 22 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1003] => Array ( [xmltvid] => 98013 [channum] => 22-5 [callsign] => ESCAPE [name] => ESCAPE [freqid] => 22 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1221] => Array ( [xmltvid] => 30240 [channum] => 22_1 [callsign] => KZJO [name] => KZJO [freqid] => 25 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1222] => Array ( [xmltvid] => 30905 [channum] => 22_2 [callsign] => Q13FOX [name] => Q13FOX [freqid] => 25 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1223] => Array ( [xmltvid] => 70444 [channum] => 22_3 [callsign] => AntTV [name] => KZJO-DT3 [freqid] => 25 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1281] => Array ( [xmltvid] => 34635 [channum] => 28_1 [callsign] => KBTC [name] => KBTC [freqid] => 27 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1282] => Array ( [xmltvid] => 34639 [channum] => 28_2 [callsign] => NHK_WLD [name] => NHK_WLD [freqid] => 27 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1283] => Array ( [xmltvid] => 34641 [channum] => 28_3 [callsign] => MHZ [name] => MHZ [freqid] => 27 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1284] => Array ( [xmltvid] => 34643 [channum] => 28_4 [callsign] => TVW [name] => TVW [freqid] => 27 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1441] => Array ( [xmltvid] => 35232 [channum] => 44_1 [callsign] => EVINE [name] => EVINE [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1442] => Array ( [delete] => true [xmltvid] => 54209 [channum] => 44_2 [callsign] => AZTECA [name] => AZTECA [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1443] => Array ( [xmltvid] => 54189 [channum] => 44_3 [callsign] => AAT TV [name] => AAT TV [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1444] => Array ( [xmltvid] => 54193 [channum] => 44_4 [callsign] => KBS [name] => KBS [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1445] => Array ( [xmltvid] => 60408 [channum] => 44_5 [callsign] => COZITV [name] => COZITV [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1446] => Array ( [xmltvid] => 92026 [channum] => 44_6 [callsign] => METV [name] => METV [freqid] => 44 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1511] => Array ( [delete] => true [xmltvid] => 34830 [channum] => 51_1 [callsign] => KUNS-1 [name] => KUNS-1 [freqid] => 50 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) [1512] => Array ( [xmltvid] => 78607 [channum] => 51_2 [callsign] => TBD [name] => If it’s what’s new or what’s next, it’s on TBD. [freqid] => 50 [finetune] => [videofilters] => [brightness] => 32768 [contrast] => 32768 [colour] => 32768 [hue] => 32768 [recpriority] => 0 [visible] => 1 [useonairguide] => 1 ) ) [save] => Save ) ========================================================================== $_SESSION: Array ( [cache_engine] => Cache_Null [stream] => Array ( [include_user_and_password] => ) [prefer_channum] => 1 [recorded_pixmaps] => 1 [guide_favonly] => [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 20 [max_stars] => 4 [star_character] => ★ [show_popup_info] => 1 [show_channel_icons] => 1 [sortby_channum] => 1 [recorded_paging] => [genre_colors] => 1 [show_video_covers] => 1 [settings] => Array ( [screens] => Array ( [tv] => Array ( [upcoming recordings] => Array ( [title] => on [channel] => on [record date] => on [length] => on ) ) ) [last] => Array ( [0] => tv [1] => channels ) ) [backend] => Array ( [timezone] => Array ( [value] => America/Los_Angeles [last_check_time] => 1497414570 ) [127.0.0.1] => Array ( [proto_version] => Array ( [last_check_version] => 88 [last_check_time] => 1497414570 ) ) ) [language] => English [date_statusbar] => %a %b %e, %Y, %I:%M %p [date_scheduled] => %a %b %e, %Y (%I:%M %p) [date_scheduled_popup] => %a %b %e, %Y [date_recorded] => %a %b %e, %Y (%I:%M %p) [date_search] => %a %b %e, %Y, %I:%M %p [date_listing_key] => %a %b %e, %Y, %I:%M %p [date_listing_jump] => %a %b %e, %Y [date_channel_jump] => %a %b %e, %Y [date_job_status] => %a %b %e, %Y, %I:%M %p [time_format] => %I:%M %p [tv] => Array ( [last] => Array ( [0] => searches ) ) [list_time] => 1497493800 [schedules_sortby] => Array ( [0] => Array ( [field] => airdate [reverse] => ) [1] => Array ( [field] => title [reverse] => ) ) [scheduled_recordings] => Array ( [disp_scheduled] => 1 [disp_duplicates] => [disp_deactivated] => [disp_conflicts] => 1 ) [] => Array ( ) [recorded_sortby] => Array ( [0] => Array ( [field] => airdate [reverse] => 1 ) [1] => Array ( [field] => title [reverse] => ) ) [video_sortby] => Array ( [0] => Array ( [field] => title [reverse] => ) ) ) ========================================================================== $_SERVER: Array ( [REDIRECT_STATUS] => 200 [HTTP_HOST] => 192.168.1.80 [HTTP_CONNECTION] => keep-alive [CONTENT_LENGTH] => 22090 [HTTP_CACHE_CONTROL] => max-age=0 [HTTP_ORIGIN] => http://192.168.1.80 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 [CONTENT_TYPE] => application/x-www-form-urlencoded [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 [HTTP_DNT] => 1 [HTTP_REFERER] => http://192.168.1.80/mythweb/settings/tv/channels [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8 [HTTP_COOKIE] => mythweb_id=1unt5c54pgq7ih07mlpb8bqff3 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] =>
Apache/2.4.18 (Ubuntu) Server at 192.168.1.80 Port 80
[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu) [SERVER_NAME] => 192.168.1.80 [SERVER_ADDR] => 192.168.1.80 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.1.86 [DOCUMENT_ROOT] => /var/www/html [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] => /var/www/html [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php [REMOTE_PORT] => 59236 [REDIRECT_URL] => /mythweb/settings/tv/channels [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /settings/tv/channels [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /settings/tv/channels [PATH_TRANSLATED] => /var/www/html/settings/tv/channels [PHP_SELF] => /mythweb/mythweb.php/settings/tv/channels [REQUEST_TIME_FLOAT] => 1497494317.772 [REQUEST_TIME] => 1497494317 [STATUS] => 200 [URL] => /mythweb/settings/tv/channels [HTTP_X_FORWARDED_PROTO] => [HTTPS] => [HTTP_PORT] => 80 ) ========================================================================== $constant_list["user"]: Array ( [ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024 [WebDBSchemaVer] => 4 [error_email] => [form_action] => http://192.168.1.80/mythweb/settings/tv/channels [gb] => 1073741824 [hostname] => myth [http_host] => 192.168.1.80 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => settings [modules_path] => /usr/share/mythtv/mythweb/modules [num_time_slots] => 36 [prefer_channum] => 1 [root] => /mythweb/ [root_auth_url] => http://192.168.1.80/mythweb/ [root_url] => http://192.168.1.80/mythweb/ [skin] => default [skin_img_url] => http://192.168.1.80/mythweb/skins/default/img/ [skin_url] => http://192.168.1.80/mythweb/skins/default/ [star_character] => ★ [stream_url] => http://192.168.1.80:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/settings/tmpl/default/ )