[mythtv-users] SQL Error: scheduling recordings

MythTV EMail bubber-mythtv at bubber.com
Fri Nov 10 04:31:10 UTC 2006


When I try to schedule recordings from Myth Web, I get the error below. I've tried different channels at random and get the same (type of) error. Trying to record from Myth doesn't work, but I can't find an error in the logs (yet).

I'm running the latest RPMs as of tonight.

Any Ideas?

Thanks
Dan Mount

<---------->

Backtrace:
    datetime:  2006-11-09 23:18:12 (EST)
    errornum:  256
  error type:  User Error
error string:  SQL Error: Data truncated for column 'findid' at row 1 [#1265]
    filename:  /var/www/html/mythweb/includes/objects/Database_Query_mysql.php
  error line:  73

==========================================================================

Backtrace: 

    file:  /var/www/html/mythweb/includes/objects/Database_Query_mysql.php
    line:  73
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => SQL Error: Data truncated for column 'findid' at row 1 [#1265]
    [1] => 256
)

    file:  /var/www/html/mythweb/includes/objects/Database.php
    line:  220
   class:  Database_Query_mysql
function:  execute
    type:  ->
    args:  Array
(
    [0] => Array
        (
            [0] => 0
            [1] => 3
            [2] => 1078
            [3] => 1163133000
            [4] => 1163133000
            [5] => 1163134800
            [6] => 1163134800
            [7] => 0
            [8] => Trick My Truck
            [9] => 
            [10] => The Mafia turns a man's truck into a memorial to his son who was killed in a car accident.
            [11] => Default
            [12] => -99
            [13] => Reality
            [14] => 1
            [15] => 0
            [16] => 4
            [17] => 1
            [18] => 0
            [19] => 0
            [20] => Default
            [21] => 6
            [22] => 15
            [23] => CMTV
            [24] => SH808736
            [25] => EP8087360017
            [26] => 1
            [27] => 5
            [28] => 23:30:00
            [29] => 732990.1875
            [30] => 0
            [31] => 0
            [32] => 0
            [33] => 1.00
            [34] => 0
            [35] => 0
            [36] => 0
            [37] => 0
        )

)

    file:  /var/www/html/mythweb/includes/recording_schedules.php
    line:  296
   class:  Database_mysql
function:  query
    type:  ->
    args:  Array
(
    [0] => REPLACE INTO record (recordid,type,chanid,starttime,startdate,endtime,enddate,search,title,subtitle,description,profile,recpriority,category,maxnewest,inactive,maxepisodes,autoexpire,startoffset,endoffset,recgroup,dupmethod,dupin,station,seriesid,programid,autocommflag,findday,findtime,findid,autotranscode,transcoder,parentid,tsdefault,autouserjob1,autouserjob2,autouserjob3,autouserjob4)
                                       VALUES (?,?,?,
                                               FROM_UNIXTIME(?),FROM_UNIXTIME(?),FROM_UNIXTIME(?),FROM_UNIXTIME(?),
                                               ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)



More information about the mythtv-users mailing list