1 | Backtrace:
|
---|
2 |
|
---|
3 | datetime: 2007-08-19 10:55:22 (EDT)
|
---|
4 | errornum: 256
|
---|
5 | error type: User Error
|
---|
6 | error string: SQL Error: Column 'endtime' cannot be null [#1048]
|
---|
7 | filename: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
|
---|
8 | error line: 73
|
---|
9 |
|
---|
10 | ==========================================================================
|
---|
11 |
|
---|
12 | Backtrace:
|
---|
13 |
|
---|
14 | file: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
|
---|
15 | line: 73
|
---|
16 | class:
|
---|
17 | function: trigger_error
|
---|
18 | type:
|
---|
19 | args: Array
|
---|
20 | (
|
---|
21 | [0] => SQL Error: Column 'endtime' cannot be null [#1048]
|
---|
22 | [1] => 256
|
---|
23 | )
|
---|
24 |
|
---|
25 | file: /usr/share/mythtv/mythweb/includes/objects/Database.php
|
---|
26 | line: 220
|
---|
27 | class: Database_Query_mysql
|
---|
28 | function: execute
|
---|
29 | type: ->
|
---|
30 | args: Array
|
---|
31 | (
|
---|
32 | [0] => Array ( )
|
---|
33 | )
|
---|
34 |
|
---|
35 | file: /usr/share/mythtv/mythweb/includes/programs.php
|
---|
36 | line: 155
|
---|
37 | class: Database
|
---|
38 | function: query
|
---|
39 | type: ->
|
---|
40 | args: Array
|
---|
41 | (
|
---|
42 | [0] => SELECT program.*,
|
---|
43 | UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
|
---|
44 | UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
|
---|
45 | IFNULL(programrating.system, "") AS rater,
|
---|
46 | IFNULL(programrating.rating, "") AS rating,
|
---|
47 | channel.callsign,
|
---|
48 | channel.channum
|
---|
49 | FROM program
|
---|
50 | LEFT JOIN programrating USING (chanid, starttime)
|
---|
51 | LEFT JOIN channel ON program.chanid = channel.chanid
|
---|
52 | WHERE program.chanid='1005' AND (program.endtime > FROM_UNIXTIME('-68400') AND program.starttime < FROM_UNIXTIME('18000') AND program.starttime != program.endtime)
|
---|
53 | GROUP BY program.chanid, program.starttime, channel.callsign ORDER BY program.starttime
|
---|
54 | )
|
---|
55 |
|
---|
56 | file: /usr/share/mythtv/mythweb/modules/tv/channel.php
|
---|
57 | line: 44
|
---|
58 | class:
|
---|
59 | function: load_all_program_data
|
---|
60 | type:
|
---|
61 | args: Array
|
---|
62 | (
|
---|
63 | [0] => -68400
|
---|
64 | [1] => 18000
|
---|
65 | [2] => 1005
|
---|
66 | )
|
---|
67 |
|
---|
68 | file: /usr/share/mythtv/mythweb/modules/tv/handler.php
|
---|
69 | line: 64
|
---|
70 | class:
|
---|
71 | function: require_once
|
---|
72 | type:
|
---|
73 | args: Array
|
---|
74 | (
|
---|
75 | [0] => /usr/share/mythtv/mythweb/modules/tv/channel.php
|
---|
76 | )
|
---|
77 |
|
---|
78 | file: /usr/share/mythtv/mythweb/mythweb.php
|
---|
79 | line: 24
|
---|
80 | class:
|
---|
81 | function: require_once
|
---|
82 | type:
|
---|
83 | args: Array
|
---|
84 | (
|
---|
85 | [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
|
---|
86 | )
|
---|
87 |
|
---|
88 |
|
---|
89 | ==========================================================================
|
---|
90 |
|
---|
91 | $_GET: Array
|
---|
92 | (
|
---|
93 | [chanid] => 1005
|
---|
94 | [date] => 1187533800
|
---|
95 | )
|
---|
96 |
|
---|
97 | ==========================================================================
|
---|
98 |
|
---|
99 | $_SESSION: Array
|
---|
100 | (
|
---|
101 | [language] => English
|
---|
102 | [tmpl] => default
|
---|
103 | [skin] => default
|
---|
104 | [prefer_channum] => 1
|
---|
105 | [date_statusbar] => %a %b %e, %Y, %I:%M %p
|
---|
106 | [date_scheduled] => %a %b %e, %Y (%I:%M %p)
|
---|
107 | [date_scheduled_popup] => %a %b %e, %Y
|
---|
108 | [date_recorded] => %a %b %e, %Y<br />(%I:%M %p)
|
---|
109 | [date_search] => %a %b %e, %Y, %I:%M %p
|
---|
110 | [date_listing_key] => %a %b %e, %Y, %I:%M %p
|
---|
111 | [date_listing_jump] => %a %b %e, %Y
|
---|
112 | [date_channel_jump] => %a %b %e, %Y
|
---|
113 | [time_format] => %I:%M %p
|
---|
114 | [recorded_pixmaps] => 1
|
---|
115 | [guide_favonly] =>
|
---|
116 | [timeslot_size] => 300
|
---|
117 | [num_time_slots] => 36
|
---|
118 | [timeslot_blocks] => 3
|
---|
119 | [timeslotbar_skip] => 20
|
---|
120 | [max_stars] => 4
|
---|
121 | [star_character] => ♦
|
---|
122 | [list_time] =>
|
---|
123 | )
|
---|
124 |
|
---|
125 | ==========================================================================
|
---|
126 |
|
---|
127 | $_SERVER: Array
|
---|
128 | (
|
---|
129 | [REDIRECT_STATUS] => 200
|
---|
130 | [HTTP_HOST] => base.redchops.com:8080
|
---|
131 | [HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
|
---|
132 | [HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
|
---|
133 | [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
|
---|
134 | [HTTP_ACCEPT_ENCODING] => gzip,deflate
|
---|
135 | [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
|
---|
136 | [HTTP_KEEP_ALIVE] => 300
|
---|
137 | [HTTP_CONNECTION] => keep-alive
|
---|
138 | [HTTP_REFERER] => http://base.redchops.com:8080/mythweb/tv/detail/1005/1187533800
|
---|
139 | [HTTP_COOKIE] => mythweb_id=d88360fc53b5344fc7419bd03d4e4f12
|
---|
140 | [PATH] => /usr/local/bin:/usr/bin:/bin
|
---|
141 | [SERVER_SIGNATURE] => <address>Apache/2.2.3 (Ubuntu) DAV/2 SVN/1.4.3 PHP/5.2.1 Server at base.redchops.com Port 80</address>
|
---|
142 |
|
---|
143 | [SERVER_SOFTWARE] => Apache/2.2.3 (Ubuntu) DAV/2 SVN/1.4.3 PHP/5.2.1
|
---|
144 | [SERVER_NAME] => base.redchops.com
|
---|
145 | [SERVER_ADDR] => 192.168.1.100
|
---|
146 | [SERVER_PORT] => 80
|
---|
147 | [REMOTE_ADDR] => 65.43.181.77
|
---|
148 | [DOCUMENT_ROOT] => /var/www
|
---|
149 | [SERVER_ADMIN] => redchops@gmail.com
|
---|
150 | [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
|
---|
151 | [REMOTE_PORT] => 3270
|
---|
152 | [REDIRECT_URL] => /mythweb/tv/channel/1005/1187533800
|
---|
153 | [GATEWAY_INTERFACE] => CGI/1.1
|
---|
154 | [SERVER_PROTOCOL] => HTTP/1.1
|
---|
155 | [REQUEST_METHOD] => GET
|
---|
156 | [QUERY_STRING] =>
|
---|
157 | [REQUEST_URI] => /mythweb/tv/channel/1005/1187533800
|
---|
158 | [SCRIPT_NAME] => /mythweb/mythweb.php
|
---|
159 | [PATH_INFO] => /tv/channel/1005/1187533800
|
---|
160 | [PATH_TRANSLATED] => /var/www/tv/channel/1005/1187533800
|
---|
161 | [PHP_SELF] => /mythweb/mythweb.php/tv/channel/1005/1187533800
|
---|
162 | [PHP_AUTH_USER] => chops
|
---|
163 | [PHP_AUTH_PW] => doublehelix
|
---|
164 | [REQUEST_TIME] => 1187535322
|
---|
165 | [argv] => Array ( )
|
---|
166 | [argc] => 0
|
---|
167 | [STATUS] => 200
|
---|
168 | [URL] => /mythweb/tv/channel/1005/1187533800
|
---|
169 | )
|
---|
170 |
|
---|
171 |
|
---|