[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