Opened 3 years ago

Closed 3 years ago

#12908 closed Bug Report - General (Duplicate)

Saving channel information on mythweb causes fatal error

Reported by: o.juhl@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: unknown
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description (last modified by sphery)

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
)

Change History (2)

comment:1 Changed 3 years ago by sphery

Component: MythTV - GeneralPlugin - MythWeb
Description: modified (diff)
Owner: set to Stuart Auchterlonie

comment:2 Changed 3 years ago by sphery

Resolution: Duplicate
Status: newclosed

Dup of #12811.

Please make sure you're using a sufficiently-new version of 0.28-fixes (past Oct 10, 2016) to support the MySQL database version you're using.

Note: See TracTickets for help on using tickets.