id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked
2366 MythWeb Fatal Error adding new program to record anonymous Isaac Richards "I updated from svn head shortly after .20 was released. I did notice there were a couple post .20 commits (e.g. the ""has been watched flag""). Perhaps I got half of something. I can do more digging around tomorrow if you need. It's late and I'm too tired to be of much use at the moment.
{{{
***************
Fatal Error at /var/www/localhost/htdocs/mythweb-svn/includes/objects/Database_Query_mysql.php, line 73:
SQL Error: Column 'parentid' cannot be null [#1048]
***************
Backtrace:
datetime: 2006-09-11 03:07:07 (PDT)
errornum: 256
error type: User Error
error string: SQL Error: Column 'parentid' cannot be null [#1048]
filename: /var/www/localhost/htdocs/mythweb-svn/includes/objects/Database_Query_mysql.php
error line: 73
==========================================================================
Backtrace:
file: /var/www/localhost/htdocs/mythweb-svn/includes/objects/Database_Query_mysql.php
line: 73
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Column 'parentid' cannot be null [#1048]
[1] => 256
)
file: /var/www/localhost/htdocs/mythweb-svn/includes/objects/Database.php
line: 220
class: database_query_mysql
function: execute
type: ->
args: Array
(
[0] => Array
(
[0] =>
[1] => 3
[2] => 1006
[3] => 1158901200
[4] => 1158901200
[5] => 1158904800
[6] => 1158904800
[7] => 0
[8] => Shark
[9] => Pilot
[10] => Shaken after a not-guilty verdict frees his client to go out and commit the same crime again, Sebastian Stark takes a job with the district attorney's office.
[11] => Default
[12] => 0
[13] => Drama
[14] => 0
[15] => 0
[16] => 0
[17] => 0
[18] => 0
[19] => 0
[20] => Default
[21] => 6
[22] => 15
[23] => KOIN
[24] => SH848759
[25] => EP8487590001
[26] => 1
[27] => 5
[28] => 22:00:00
[29] => 732941.208333
[30] => 0
[31] => 0
[32] =>
[33] => 1.00
[34] => 0
[35] => 0
[36] => 0
[37] => 0
)
)
file: /var/www/localhost/htdocs/mythweb-svn/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(?),
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[1] =>
[2] => 3
[3] => 1006
[4] => 1158901200
[5] => 1158901200
[6] => 1158904800
[7] => 1158904800
[8] => 0
[9] => Shark
[10] => Pilot
[11] => Shaken after a not-guilty verdict frees his client to go out and commit the same crime again, Sebastian Stark takes a job with the district attorney's office.
[12] => Default
[13] => 0
[14] => Drama
[15] => 0
[16] => 0
[17] => 0
[18] => 0
[19] => 0
[20] => 0
[21] => Default
[22] => 6
[23] => 15
[24] => KOIN
[25] => SH848759
[26] => EP8487590001
[27] => 1
[28] => 5
[29] => 22:00:00
[30] => 732941.208333
[31] => 0
[32] => 0
[33] =>
[34] => 1.00
[35] => 0
[36] => 0
[37] => 0
[38] => 0
)
file: /var/www/localhost/htdocs/mythweb-svn/modules/tv/detail.php
line: 146
class: schedule
function: save
type: ->
args: Array
(
[0] => 3
)
file: /var/www/localhost/htdocs/mythweb-svn/modules/tv/handler.php
line: 62
class:
function: require_once
type:
args: Array
(
[0] => /var/www/localhost/htdocs/mythweb-svn/modules/tv/detail.php
)
file: /var/www/localhost/htdocs/mythweb-svn/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
[0] => /var/www/localhost/htdocs/mythweb-svn/modules/tv/handler.php
)
==========================================================================
$_GET: Array
(
[chanid] => 1006
[starttime] => 1158901200
)
==========================================================================
$_POST: Array
(
[record] => 3
[profile] => Default
[transcoder] => 0
[recgroup] => Default
[recpriority] => 0
[timestretch] => 1.00
[dupin] => 15
[dupmethod] => 6
[autocommflag] => 1
[maxepisodes] =>
[startoffset] =>
[endoffset] =>
[save] => Update Recording Settings
)
==========================================================================
$_SESSION: Array
(
[language] => English
[tmpl] => default
[skin] => default
[prefer_channum] => 1
[date_statusbar] => %a %b %e, %Y, %I:%M %p
[date_scheduled] => %a %b %e, %Y (%I:%M %p)
[date_scheduled_popup] => %a %b %e, %Y
[date_recorded] => %a %b %e, %Y
(%I:%M %p)
[date_search] => %a %b %e, %Y, %I:%M %p
[date_listing_key] => %a %b %e, %Y, %I:%M %p
[date_listing_jump] => %a %b %e, %Y
[date_channel_jump] => %a %b %e, %Y
[time_format] => %I:%M %p
[recorded_pixmaps] => 1
[guide_favonly] =>
[timeslot_size] => 300
[num_time_slots] => 36
[timeslot_blocks] => 3
[timeslotbar_skip] => 20
[max_stars] => 4
[star_character] => ♦
[video_sortby] => Array
(
[0] => Array
(
[field] => title
[reverse] =>
)
)
[siunits] => NO
[recorded_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[list_time] => 1157684400
[scheduled_recordings] => Array
(
[disp_scheduled] => 1
[disp_duplicates] => 1
[disp_deactivated] => 1
[disp_conflicts] => 1
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search] => Array
(
[searchstr] => draft
[search_title] => 1
[search_subtitle] => 1
[search_description] =>
[search_category] =>
[search_category_type] =>
[type] => q
[s] => shark
[ctype] => Array
(
[0] => movie
[1] => series
[2] => sports
[3] => tvshow
)
[stars_gt] => 0
[stars_lt] => 1
[starttime] => now
[endtime] => + 2 weeks
[as] => Array
(
[0] => shark
)
[af] => Array
(
[0] => Array
(
[0] => title
)
)
[aj] => Array
(
[0] => AND
)
[hd] =>
[commfree] =>
[airdate_start] =>
[airdate_end] =>
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => xxxxx
[HTTP_USER_AGENT] => Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.5) Gecko/20060731 Ubuntu/dapper-security Firefox/1.5.0.5
[HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://xxxxx/mythweb/tv/detail/1006/1158901200
[HTTP_COOKIE] => mythweb_id=1008412e51ed332b23e49182582de50a
[CONTENT_TYPE] => application/x-www-form-urlencoded
[CONTENT_LENGTH] => 189
[PATH] => /bin:/sbin:/usr/bin:/usr/sbin:/usr/local/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/sbin:/usr/sbin
[SERVER_SIGNATURE] =>