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@…, 8 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>