id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 12908,Saving channel information on mythweb causes fatal error,o.juhl@…,Stuart Auchterlonie,"I saved channel information on mythweb in order to delete 2 channels, when an webpage came up with a error message. The below tekst is a part of that page. It is a new installed mythbuntu 16.4 using a dvb-t usb tuner. {{{ datetime: 2016-10-27 11:44:23 (CEST) 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] => [1] => 25 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 1 [13] => DR1 [14] => DR1 ) [1] => 2001 ) ) 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] => [1] => 25 [2] => [3] => [4] => 32768 [5] => 32768 [6] => 32768 [7] => 32768 [8] => 0 [9] => -1 [10] => 1 [11] => 1 [12] => 1 [13] => DR1 [14] => DR1 ) [2] => 2001 ) 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 ) }}}",Bug Report - General,closed,minor,unknown,Plugin - MythWeb,0.28.0,medium,Duplicate,,,0