[mythtv-users] SQL Error: scheduling recordings

[Trey Thompson]

> 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(?),
>                                               ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Can you record from the frontend?