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