Ticket #12795: Fatal_Error_Column_inetref_cannot_be_null.html

File Fatal_Error_Column_inetref_cannot_be_null.html, 12.5 KB (added by scottn@…, 10 years ago)

Page displayed after crash

Line 
1<html><head>
2<meta http-equiv="content-type" content="text/html; charset=windows-1252"><link href="Fatal_Error_Column_inetref_cannot_be_null_files/socialwidgets.css" type="text/css" rel="stylesheet"></head><body><div id="message">
3
4<h2>Fatal Error</h2>
5
6<p class="err">
7 !!NoTrans: SQL Error: Column 'inetref' cannot be null [#1048]!!</p>
8
9<div id="backtrace">
10
11 <p>
12 If you choose to <b><u><a href="http://svn.mythtv.org/trac/newticket" target="_blank"> submit a bug report </a></u></b>
13 please make sure to include a brief description of what you were doing,
14 along with the following backtrace as an attachment <i>(please don\'t just paste the whole thing into the ticket)</i>
15 </p>
16
17 <textarea cols="100" rows="100"> datetime: 2016-05-28 14:07:27
18(NZST)
19 errornum: 256
20 error type: User Error
21error string: !!NoTrans: SQL Error: Column 'inetref' cannot be null
22[#1048]!!
23 filename:
24/usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
25 error line: 98
26
27==========================================================================
28
29Backtrace:
30
31
32 file:
33/usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
34 line: 98
35 class:
36function: trigger_error
37 type:
38 args: Array
39(
40 [0] =&gt; SQL Error: Column 'inetref' cannot be null [#1048]
41 [1] =&gt; 256
42)
43
44 file: /usr/share/mythtv/mythweb/classes/Database.php
45 line: 261
46 class: Database_Query_mysqlicompat
47function: execute
48 type: -&gt;
49 args: Array
50(
51 [0] =&gt; Array ( )
52)
53
54 file: /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
55 line: 650
56 class: Database
57function: query
58 type: -&gt;
59 args: Array
60(
61 [0] =&gt; REPLACE INTO oldrecorded
62(chanid,starttime,endtime,title,subtitle,description,season,episode,category,seriesid,programid,inetref,recordid,station,rectype,recstatus,duplicate,generic)
63 VALUES ('1002',NOW(),NOW(),'Iron Man','','After surviving an unexpected
64 attack in enemy territory, jet-setting industrialist Tony Stark builds a
65 high-tech suit of armor and vows to protect the world as Iron Man.
66Starring Robert Downey
67Jr.','0','0','Unknown','157308542','10440137',NULL,'0','TV2','0',11,1,0)
68)
69
70 file: /usr/share/mythtv/mythweb/modules/tv/detail.php
71 line: 264
72 class: Program
73function: rec_never_record
74 type: -&gt;
75 args: Array ( )
76 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
77 line: 82
78 class:
79function: require_once
80 type:
81 args: Array
82(
83 [0] =&gt; /usr/share/mythtv/mythweb/modules/tv/detail.php
84)
85
86 file: /usr/share/mythtv/mythweb/mythweb.php
87 line: 35
88 class:
89function: require_once
90 type:
91 args: Array
92(
93 [0] =&gt; /usr/share/mythtv/mythweb/modules/tv/handler.php
94)
95
96
97==========================================================================
98
99$_GET:
100 Array
101(
102 [never_record] =&gt; yes
103 [chanid] =&gt; 1002
104 [starttime] =&gt; 1464943500
105 [manualid] =&gt; 0
106)
107
108==========================================================================
109
110$_SESSION:
111 Array
112(
113 [cache_engine] =&gt; Cache_Null
114 [stream] =&gt; Array
115 (
116 [include_user_and_password] =&gt;
117 )
118
119 [prefer_channum] =&gt; 1
120 [recorded_pixmaps] =&gt; 1
121 [guide_favonly] =&gt;
122 [timeslot_size] =&gt; 300
123 [num_time_slots] =&gt; 36
124 [timeslot_blocks] =&gt; 3
125 [timeslotbar_skip] =&gt; 20
126 [max_stars] =&gt; 4
127 [star_character] =&gt; &amp;#9733;
128 [show_popup_info] =&gt; 1
129 [show_channel_icons] =&gt; 1
130 [sortby_channum] =&gt; 1
131 [recorded_paging] =&gt;
132 [genre_colors] =&gt; 1
133 [show_video_covers] =&gt; 1
134 [settings] =&gt; Array
135 (
136 [screens] =&gt; Array
137 (
138 [tv] =&gt; Array
139 (
140 [upcoming recordings] =&gt; Array
141 (
142 [title] =&gt; on
143 [channel] =&gt; on
144 [record date] =&gt; on
145 [length] =&gt; on
146 )
147
148 )
149
150 )
151
152 [last] =&gt; Array
153 (
154 [0] =&gt; tv
155 [1] =&gt; channels
156 )
157
158 [host] =&gt; localhost
159 )
160
161 [backend] =&gt; Array
162 (
163 [127.0.0.1] =&gt; Array
164 (
165 [proto_version] =&gt; Array
166 (
167 [last_check_version] =&gt; 88
168 [last_check_time] =&gt; 1464398622
169 )
170
171 )
172
173 [timezone] =&gt; Array
174 (
175 [value] =&gt; Pacific/Auckland
176 [last_check_time] =&gt; 1464337660
177 )
178
179 )
180
181 [language] =&gt; English
182 [date_statusbar] =&gt; %a %b %e, %Y, %I:%M %p
183 [date_scheduled] =&gt; %a %b %e, %Y (%I:%M %p)
184 [date_scheduled_popup] =&gt; %a %b %e, %Y
185 [date_recorded] =&gt; %a %b %e, %Y (%I:%M %p)
186 [date_search] =&gt; %a %b %e, %Y, %I:%M %p
187 [date_listing_key] =&gt; %a %b %e, %Y, %I:%M %p
188 [date_listing_jump] =&gt; %a %b %e, %Y
189 [date_channel_jump] =&gt; %a %b %e, %Y
190 [date_job_status] =&gt; %a %b %e, %Y, %I:%M %p
191 [time_format] =&gt; %I:%M %p
192 [tv] =&gt; Array
193 (
194 [last] =&gt; Array
195 (
196 [0] =&gt; detail
197 [1] =&gt; 1002
198 [2] =&gt; 1464943500
199 )
200
201 [set] =&gt; Array
202 (
203 [chan_sort] =&gt; channum
204 )
205
206 [show_advanced_schedule] =&gt;
207 )
208
209 [recorded_sortby] =&gt; Array
210 (
211 [0] =&gt; Array
212 (
213 [field] =&gt; airdate
214 [reverse] =&gt; 1
215 )
216
217 [1] =&gt; Array
218 (
219 [field] =&gt; title
220 [reverse] =&gt;
221 )
222
223 )
224
225 [list_time] =&gt; 1464940800
226 [recording_details] =&gt; Array
227 (
228 [show_Conflict] =&gt; 1
229 [show_PreviousRecording] =&gt; 1
230 [show_EarlierShowing] =&gt; 1
231 [show_CurrentRecording] =&gt; 1
232 [show_WillRecord] =&gt; 1
233 )
234
235 [video_sortby] =&gt; Array
236 (
237 [0] =&gt; Array
238 (
239 [field] =&gt; title
240 [reverse] =&gt;
241 )
242
243 )
244
245 [schedules_sortby] =&gt; Array
246 (
247 [0] =&gt; Array
248 (
249 [field] =&gt; airdate
250 [reverse] =&gt;
251 )
252
253 [1] =&gt; Array
254 (
255 [field] =&gt; title
256 [reverse] =&gt;
257 )
258
259 )
260
261 [scheduled_recordings] =&gt; Array
262 (
263 [disp_scheduled] =&gt; 1
264 [disp_duplicates] =&gt;
265 [disp_deactivated] =&gt;
266 [disp_conflicts] =&gt; 1
267 )
268
269 [scheduled_sortby] =&gt; Array
270 (
271 [0] =&gt; Array
272 (
273 [field] =&gt; airdate
274 [reverse] =&gt;
275 )
276
277 [1] =&gt; Array
278 (
279 [field] =&gt; title
280 [reverse] =&gt;
281 )
282
283 )
284
285)
286
287==========================================================================
288
289$_SERVER:
290 Array
291(
292 [REDIRECT_STATUS] =&gt; 200
293 [HTTP_HOST] =&gt; mythtv.quantumchaos451.co.nz
294 [HTTP_USER_AGENT] =&gt; Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
295rv:46.0) Gecko/20100101 Firefox/46.0
296 [HTTP_ACCEPT] =&gt;
297text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
298 [HTTP_ACCEPT_LANGUAGE] =&gt; en-NZ,en;q=0.7,en-US;q=0.3
299 [HTTP_ACCEPT_ENCODING] =&gt; gzip, deflate
300 [HTTP_DNT] =&gt; 1
301 [HTTP_REFERER] =&gt;
302http://mythtv.quantumchaos451.co.nz/mythweb/tv/detail/1002/1464943500
303 [HTTP_COOKIE] =&gt; _ga=GA1.3.88034222.1421729347;
304mythweb_id=q5lkhai49tv8a4go7dhnfdc8p4; TVView=poster;
305jwplayer.volume=100; PHPSESSID=ln6uo5n2st3ncvn2eu9eq3jg01
306 [HTTP_CONNECTION] =&gt; keep-alive
307 [PATH] =&gt;
308/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
309 [SERVER_SIGNATURE] =&gt; &lt;address&gt;Apache/2.4.7 (Ubuntu) Server
310 at mythtv.quantumchaos451.co.nz Port 80&lt;/address&gt;
311
312 [SERVER_SOFTWARE] =&gt; Apache/2.4.7 (Ubuntu)
313 [SERVER_NAME] =&gt; mythtv.quantumchaos451.co.nz
314 [SERVER_ADDR] =&gt; 192.168.1.100
315 [SERVER_PORT] =&gt; 80
316 [REMOTE_ADDR] =&gt; 192.168.1.1
317 [DOCUMENT_ROOT] =&gt; /var/www/html
318 [REQUEST_SCHEME] =&gt; http
319 [CONTEXT_PREFIX] =&gt;
320 [CONTEXT_DOCUMENT_ROOT] =&gt; /var/www/html
321 [SERVER_ADMIN] =&gt; webmaster@quantumchaos451.co.nz
322 [SCRIPT_FILENAME] =&gt; /var/www/html/mythweb/mythweb.php
323 [REMOTE_PORT] =&gt; 59774
324 [REDIRECT_QUERY_STRING] =&gt; never_record=yes
325 [REDIRECT_URL] =&gt; /mythweb/tv/detail/1002/1464943500
326 [GATEWAY_INTERFACE] =&gt; CGI/1.1
327 [SERVER_PROTOCOL] =&gt; HTTP/1.1
328 [REQUEST_METHOD] =&gt; GET
329 [QUERY_STRING] =&gt; never_record=yes
330 [REQUEST_URI] =&gt; /tv/detail/1002/1464943500?never_record=yes
331 [SCRIPT_NAME] =&gt; /mythweb/mythweb.php
332 [PATH_INFO] =&gt; /tv/detail/1002/1464943500
333 [PATH_TRANSLATED] =&gt; /var/www/html/tv/detail/1002/1464943500
334 [PHP_SELF] =&gt; /mythweb/mythweb.php/tv/detail/1002/1464943500
335 [REQUEST_TIME_FLOAT] =&gt; 1464401247.225
336 [REQUEST_TIME] =&gt; 1464401247
337 [STATUS] =&gt; 200
338 [URL] =&gt; /mythweb/tv/detail/1002/1464943500
339 [HTTP_X_FORWARDED_PROTO] =&gt;
340 [HTTPS] =&gt;
341 [HTTP_PORT] =&gt; 80
342)
343
344==========================================================================
345
346$constant_list["user"]:
347 Array
348(
349 [ERROR] =&gt; 512
350 [E_ASSERT_ERROR] =&gt; 4096
351 [FATAL] =&gt; 256
352 [JOB_ABORTED] =&gt; 288
353 [JOB_ABORTING] =&gt; 9
354 [JOB_CANCELLED] =&gt; 320
355 [JOB_COMMFLAG] =&gt; 2
356 [JOB_DONE] =&gt; 256
357 [JOB_ERRORED] =&gt; 304
358 [JOB_ERRORING] =&gt; 8
359 [JOB_EXTERNAL] =&gt; 4
360 [JOB_FINISHED] =&gt; 272
361 [JOB_LIST_ALL] =&gt; 1
362 [JOB_LIST_DONE] =&gt; 2
363 [JOB_LIST_ERROR] =&gt; 8
364 [JOB_LIST_NOT_DONE] =&gt; 4
365 [JOB_LIST_RECENT] =&gt; 16
366 [JOB_LIVE_REC] =&gt; 2
367 [JOB_METADATA] =&gt; 4
368 [JOB_NONE] =&gt; 0
369 [JOB_NO_FLAGS] =&gt; 0
370 [JOB_PAUSE] =&gt; 1
371 [JOB_PAUSED] =&gt; 6
372 [JOB_PENDING] =&gt; 2
373 [JOB_QUEUED] =&gt; 1
374 [JOB_RESTART] =&gt; 8
375 [JOB_RESUME] =&gt; 2
376 [JOB_RETRY] =&gt; 7
377 [JOB_RUN] =&gt; 0
378 [JOB_RUNNING] =&gt; 4
379 [JOB_STARTING] =&gt; 3
380 [JOB_STOP] =&gt; 4
381 [JOB_STOPPING] =&gt; 5
382 [JOB_SYSTEMJOB] =&gt; 255
383 [JOB_TRANSCODE] =&gt; 1
384 [JOB_UNKNOWN] =&gt; 0
385 [JOB_USERJOB] =&gt; 65280
386 [JOB_USERJOB1] =&gt; 256
387 [JOB_USERJOB2] =&gt; 512
388 [JOB_USERJOB3] =&gt; 1024
389 [JOB_USERJOB4] =&gt; 2048
390 [JOB_USE_CUTLIST] =&gt; 1
391 [PHP_MIN_VERSION] =&gt; 5.3
392 [WARNING] =&gt; 1024
393 [WebDBSchemaVer] =&gt; 4
394 [dupsin_all] =&gt; 15
395 [dupsin_newepisodes] =&gt; 16
396 [dupsin_oldrecorded] =&gt; 2
397 [dupsin_recorded] =&gt; 1
398 [error_email] =&gt;
399 [gb] =&gt; 1073741824
400 [hostname] =&gt; mythtv
401 [http_host] =&gt; mythtv.quantumchaos451.co.nz
402 [kb] =&gt; 1024
403 [max_stars] =&gt; 4
404 [mb] =&gt; 1048576
405 [module] =&gt; tv
406 [modules_path] =&gt; /usr/share/mythtv/mythweb/modules
407 [num_time_slots] =&gt; 36
408 [prefer_channum] =&gt; 1
409 [rectype_always] =&gt; 4
410 [rectype_daily] =&gt; 2
411 [rectype_dontrec] =&gt; 8
412 [rectype_findone] =&gt; 6
413 [rectype_once] =&gt; 1
414 [rectype_override] =&gt; 7
415 [rectype_template] =&gt; 11
416 [rectype_weekly] =&gt; 5
417 [root] =&gt; /mythweb/
418 [root_auth_url] =&gt; http://mythtv.quantumchaos451.co.nz/mythweb/
419 [root_url] =&gt; http://mythtv.quantumchaos451.co.nz/mythweb/
420 [searchtype_keyword] =&gt; 3
421 [searchtype_manual] =&gt; 5
422 [searchtype_people] =&gt; 4
423 [searchtype_power] =&gt; 1
424 [searchtype_title] =&gt; 2
425 [skin] =&gt; default
426 [skin_img_url] =&gt;
427http://mythtv.quantumchaos451.co.nz/mythweb/skins/default/img/
428 [skin_url] =&gt;
429http://mythtv.quantumchaos451.co.nz/mythweb/skins/default/
430 [star_character] =&gt; &amp;#9733;
431 [stream_url] =&gt; http://mythtv.quantumchaos451.co.nz:80//mythweb/
432 [tb] =&gt; 1099511627776
433 [timeslot_blocks] =&gt; 3
434 [timeslot_size] =&gt; 300
435 [timeslotbar_skip] =&gt; 20
436 [tmpl] =&gt; default
437 [tmpl_dir] =&gt; modules/tv/tmpl/default/
438)
439
440
441</textarea>
442
443</div>
444
445
446</div>
447
448
449<div id="ajax_working" class="hidden">
450 <span id="ajax_num_requests">0</span> requests pending.</div>
451
452
453
454
455</body></html>