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] =>
Apache Server at xxxxx Port 80
[SERVER_SOFTWARE] => Apache [SERVER_NAME] => xxxxx [SERVER_ADDR] => xxx.xxx.xxx.xxx [SERVER_PORT] => 80 [REMOTE_ADDR] => xxx.xxx.xxx.xxx [DOCUMENT_ROOT] => /var/www/localhost/htdocs [SERVER_ADMIN] => root@localhost [SCRIPT_FILENAME] => /var/www/localhost/htdocs/mythweb/mythweb.php [REMOTE_PORT] => 60315 [REDIRECT_URL] => /mythweb/tv/detail/1006/1158901200 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /mythweb/tv/detail/1006/1158901200 [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /tv/detail/1006/1158901200 [PATH_TRANSLATED] => /var/www/localhost/htdocs/tv/detail/1006/1158901200 [PHP_SELF] => /mythweb/mythweb.php/tv/detail/1006/1158901200 [argv] => Array ( ) [argc] => 0 [STATUS] => 200 [URL] => /mythweb/tv/detail/1006/1158901200 ) }}}" defect closed minor unknown mythtv head medium fixed 0