Opened 19 years ago
Closed 19 years ago
#2385 closed defect (duplicate)
Unable to schedule program via MythWeb
Reported by: | Owned by: | xris | |
---|---|---|---|
Priority: | major | Milestone: | unknown |
Component: | mythweb | Version: | 0.20 |
Severity: | high | Keywords: | |
Cc: | Ticket locked: | no |
Description
mythweb-0.20-81.at installed on Centos 4.4, installed from ATRPMS.
Choose a program to schedule, click on it, brings up options. Leave default or change, doesn't matter, then click submit. Error as listed below:
Fatal Error at /var/www/html/mythweb/includes/objects/Database_Query_mysql.php, line 73: SQL Error: Column 'parentid' cannot be null #1048
If you choose to submit a bug report, please make sure to include a brief description of what you were doing, along with the following backtrace as an attachment (please don't paste the whole thing into the ticket).
Backtrace:
datetime: 2006-09-13 23:07:12 (PDT) errornum: 256
error type: User Error
error string: SQL Error: Column 'parentid' cannot be null #1048
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: Column 'parentid' cannot be null #1048 [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] => [1] => 4 [2] => 1492 [3] => 1158210000 [4] => 1158210000 [5] => 1158215400 [6] => 1158215400 [7] => 0 [8] => Rich Dad's Guide to Wealth With Robert Kiyosaki [9] => [10] => The author shares wealth-building strategies. [11] => Default [12] => 0 [13] => Special [14] => 0 [15] => 0 [16] => 0 [17] => 0 [18] => 0 [19] => 0 [20] => Default [21] => 6 [22] => 15 [23] => PBS [24] => SH797906 [25] => SH7979060000 [26] => 1 [27] => 4 [28] => 22:00:00 [29] => 732933.20833333 [30] => 0 [31] => 41 [32] => [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(?), ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[1] => [2] => 4 [3] => 1492 [4] => 1158210000 [5] => 1158210000 [6] => 1158215400 [7] => 1158215400 [8] => 0 [9] => Rich Dad's Guide to Wealth With Robert Kiyosaki [10] => [11] => The author shares wealth-building strategies. [12] => Default [13] => 0 [14] => Special [15] => 0 [16] => 0 [17] => 0 [18] => 0 [19] => 0 [20] => 0 [21] => Default [22] => 6 [23] => 15 [24] => PBS [25] => SH797906 [26] => SH7979060000 [27] => 1 [28] => 4 [29] => 22:00:00 [30] => 732933.20833333 [31] => 0 [32] => 41 [33] => [34] => 1.00 [35] => 0 [36] => 0 [37] => 0 [38] => 0
)
file: /var/www/html/mythweb/modules/tv/detail.php line: 146
class: Schedule
function: save
type: -> args: Array
(
[0] => 4
)
file: /var/www/html/mythweb/modules/tv/handler.php line: 62
class:
function: require_once
type: args: Array
(
[0] => /var/www/html/mythweb/modules/tv/detail.php
)
file: /var/www/html/mythweb/mythweb.php line: 24
class:
function: require_once
type: args: Array
(
[0] => /var/www/html/mythweb/modules/tv/handler.php
)
==========================================================================
$_GET: Array (
[chanid] => 1492 [starttime] => 1158210000
)
==========================================================================
$_POST: Array (
[record] => 4 [profile] => Default [transcoder] => 41 [recgroup] => Default [recpriority] => 0 [timestretch] => 1.00 [dupin] => 15 [dupmethod] => 6 [autocommflag] => 1 [maxepisodes] => [startoffset] => [endoffset] => [save] => Update Recording Settings
)
==========================================================================
$_SESSION: Array (
[language] => English [Theme] => default [Skin] => default [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<br />(%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 [video_sortby] => Array
(
[0] => Array
(
[field] => title [reverse] =>
)
)
[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] =>
)
)
[list_time] => 1158213600 [recorded_title] => [recorded_recgroup] => [recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] => 1
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[siunits] => NO [search_sortby] => Array
(
[0] => Array
(
[field] => airdate [reverse] =>
)
[1] => Array
(
[field] => title [reverse] =>
)
)
[search] => Array
(
[searchstr] => david foster [search_title] => 1 [search_subtitle] => 1 [search_description] => 1 [search_category] => 1 [search_category_type] => 1 [search_hd] => 1 [type] => a [s] => Shark [ctype] => Array
(
)
[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] =>
)
[tmpl] => default [skin] => default [prefer_channum] => 1 [recorded_pixmaps] => 1 [guide_favonly] => [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 20 [max_stars] => 4 [star_character] => ♦
)
==========================================================================
$_SERVER: Array (
[REDIRECT_AuthDigestEnableQueryStringHack] => On [REDIRECT_STATUS] => 200 [AuthDigestEnableQueryStringHack?] => On [HTTP_ACCEPT] => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* [HTTP_REFERER] => http://192.168.2.222/mythweb/tv/detail/1492/1158210000 [HTTP_ACCEPT_LANGUAGE] => en-us [CONTENT_TYPE] => application/x-www-form-urlencoded [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) [HTTP_HOST] => 192.168.2.222 [CONTENT_LENGTH] => 190 [HTTP_CONNECTION] => Keep-Alive [HTTP_CACHE_CONTROL] => no-cache [HTTP_COOKIE] => mythweb_id=4fj3hc9smsv35gv17k7noj14j2 [PATH] => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin [SERVER_SIGNATURE] => <address>Apache/2.0.52 (CentOS) Server at 192.168.2.222 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.0.52 (CentOS) [SERVER_NAME] => 192.168.2.222 [SERVER_ADDR] => 192.168.2.222 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.2.100 [DOCUMENT_ROOT] => /var/www/html [SERVER_ADMIN] => root@localhost [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php [REMOTE_PORT] => 4515 [REMOTE_USER] => webuser [AUTH_TYPE] => Digest [REDIRECT_URL] => /mythweb/tv/detail/1492/1158210000 [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /mythweb/tv/detail/1492/1158210000 [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /tv/detail/1492/1158210000 [PATH_TRANSLATED] => /var/www/html/tv/detail/1492/1158210000 [PHP_SELF] => /mythweb/mythweb.php/tv/detail/1492/1158210000 [argv] => Array ( ) [argc] => 0 [STATUS] => 200 [URL] => /mythweb/tv/detail/1492/1158210000
)