Opened 18 years ago

Closed 18 years ago

#2385 closed defect (duplicate)

Unable to schedule program via MythWeb

Reported by: blammo@… 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

(

[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] =>

)

[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] => &diams;

)

==========================================================================

$_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

)

Change History (1)

comment:1 Changed 18 years ago by Isaac Richards

Resolution: duplicate
Status: newclosed
Note: See TracTickets for help on using tickets.