Ticket #13027: mythweb-error.txt

File mythweb-error.txt, 11.6 KB (added by ronaldo.carballo@…, 9 years ago)

Bug report

Line 
1 datetime: 2017-04-16 07:56:53 (CDT)
2 errornum: 256
3 error type: User Error
4error string: !!NoTrans: SQL Error: Table './mythconverg/program' is marked as crashed and last (automatic?) repair failed [#144]!!
5 filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
6 error line: 98
7
8==========================================================================
9
10Backtrace:
11
12 file: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
13 line: 98
14 class:
15function: trigger_error
16 type:
17 args: Array
18(
19 [0] => SQL Error: Table './mythconverg/program' is marked as crashed and last (automatic?) repair failed [#144]
20 [1] => 256
21)
22
23 file: /usr/share/mythtv/mythweb/classes/Database.php
24 line: 263
25 class: Database_Query_mysqlicompat
26function: execute
27 type: ->
28 args: Array
29(
30 [0] => Array
31 (
32 [0] => Array ( )
33 )
34
35)
36
37 file: /usr/share/mythtv/mythweb/classes/Database.php
38 line: 347
39 class: Database
40function: query
41 type: ->
42 args: Array
43(
44 [0] => SELECT DISTINCT category_type
45 FROM program
46 ORDER BY category_type
47 [1] => Array ( )
48)
49
50 file: /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
51 line: 721
52 class: Database
53function: query_list
54 type: ->
55 args: Array
56(
57 [0] => SELECT DISTINCT category_type
58 FROM program
59 ORDER BY category_type
60)
61
62 file: /usr/share/mythtv/mythweb/modules/tv/search.php
63 line: 539
64 class: Program
65function: category_types
66 type: ::
67 args: Array ( )
68 file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/search.php
69 line: 96
70 class:
71function: category_type_list
72 type:
73 args: Array ( )
74 file: /usr/share/mythtv/mythweb/modules/tv/search.php
75 line: 415
76 class:
77function: require_once
78 type:
79 args: Array
80(
81 [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/search.php
82)
83
84 file: /usr/share/mythtv/mythweb/modules/tv/handler.php
85 line: 82
86 class:
87function: require_once
88 type:
89 args: Array
90(
91 [0] => /usr/share/mythtv/mythweb/modules/tv/search.php
92)
93
94 file: /usr/share/mythtv/mythweb/mythweb.php
95 line: 35
96 class:
97function: require_once
98 type:
99 args: Array
100(
101 [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
102)
103
104
105==========================================================================
106
107$_DEBUG: Array
108(
109 [Database Warnings] => Array
110 (
111 [0] => Array
112 (
113 [Query] => SET SESSION sql_mode = "";
114 [Warnings] => Array
115 (
116 [0] => Array
117 (
118 [#] => 3090
119 [MSG] => Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
120 )
121
122 )
123
124 )
125
126 )
127
128)
129
130==========================================================================
131
132$_SESSION: Array
133(
134 [cache_engine] => Cache_Null
135 [stream] => Array
136 (
137 [include_user_and_password] =>
138 )
139
140 [prefer_channum] => 1
141 [recorded_pixmaps] => 1
142 [guide_favonly] =>
143 [timeslot_size] => 300
144 [num_time_slots] => 36
145 [timeslot_blocks] => 3
146 [timeslotbar_skip] => 20
147 [max_stars] => 4
148 [star_character] => ★
149 [show_popup_info] => 1
150 [show_channel_icons] => 1
151 [sortby_channum] => 1
152 [recorded_paging] =>
153 [genre_colors] => 1
154 [show_video_covers] => 1
155 [settings] => Array
156 (
157 [screens] => Array
158 (
159 [tv] => Array
160 (
161 [upcoming recordings] => Array
162 (
163 [title] => on
164 [channel] => on
165 [record date] => on
166 [length] => on
167 )
168
169 )
170
171 )
172
173 [last] => Array
174 (
175 [0] => tv
176 [1] => playgroup
177 )
178
179 )
180
181 [backend] => Array
182 (
183 [192.168.0.47] => Array
184 (
185 [proto_version] => Array
186 (
187 [last_check_version] => 88
188 [last_check_time] => 1492346382
189 )
190
191 )
192
193 [timezone] => Array
194 (
195 [value] => America/Chicago
196 [last_check_time] => 1492346382
197 )
198
199 )
200
201 [language] => English
202 [date_statusbar] => %a %b %e, %Y, %I:%M %p
203 [date_scheduled] => %a %b %e, %Y (%I:%M %p)
204 [date_scheduled_popup] => %a %b %e, %Y
205 [date_recorded] => %a %b %e, %Y (%I:%M %p)
206 [date_search] => %a %b %e, %Y, %I:%M %p
207 [date_listing_key] => %a %b %e, %Y, %I:%M %p
208 [date_listing_jump] => %a %b %e, %Y
209 [date_channel_jump] => %a %b %e, %Y
210 [date_job_status] => %a %b %e, %Y, %I:%M %p
211 [time_format] => %I:%M %p
212 [tv] => Array
213 (
214 [last] => Array
215 (
216 [0] => search
217 )
218
219 [show_advanced_schedule] => 1
220 )
221
222 [scheduled_recordings] => Array
223 (
224 [disp_scheduled] => 1
225 [disp_duplicates] =>
226 [disp_deactivated] =>
227 [disp_conflicts] => 1
228 )
229
230 [scheduled_sortby] => Array
231 (
232 [0] => Array
233 (
234 [field] => airdate
235 [reverse] =>
236 )
237
238 [1] => Array
239 (
240 [field] => title
241 [reverse] =>
242 )
243
244 )
245
246 [search] => Array
247 (
248 [ctype] => Array
249 (
250 [0] => movie
251 [1] => series
252 [2] => tvshow
253 )
254
255 [categories] => Array
256 (
257 [0] => All
258 )
259
260 [stars_gt] => 0
261 [stars_lt] => 1
262 [starttime] => now
263 [endtime] => + 2 weeks
264 [as] => Array
265 (
266 [0] => monk
267 )
268
269 [af] => Array
270 (
271 [0] => Array
272 (
273 [0] => title
274 )
275
276 )
277
278 [aj] => Array
279 (
280 [0] => AND
281 )
282
283 [type] => a
284 [hd] =>
285 [commfree] =>
286 [unwatched] =>
287 [scheduled] =>
288 [generic] =>
289 [distinctTitle] =>
290 [airdate_start] =>
291 [airdate_end] =>
292 )
293
294 [search_sortby] => Array
295 (
296 [0] => Array
297 (
298 [field] => airdate
299 [reverse] =>
300 )
301
302 [1] => Array
303 (
304 [field] => title
305 [reverse] =>
306 )
307
308 )
309
310 [recording_details] => Array
311 (
312 [show_Conflict] => 1
313 [show_PreviousRecording] => 1
314 [show_EarlierShowing] => 1
315 [show_CurrentRecording] => 1
316 [show_WillRecord] => 1
317 )
318
319 [schedules_sortby] => Array
320 (
321 [0] => Array
322 (
323 [field] => airdate
324 [reverse] =>
325 )
326
327 [1] => Array
328 (
329 [field] => title
330 [reverse] =>
331 )
332
333 )
334
335 [list_time] => 1491933600
336 [recorded_sortby] => Array
337 (
338 [0] => Array
339 (
340 [field] => airdate
341 [reverse] => 1
342 )
343
344 [1] => Array
345 (
346 [field] => title
347 [reverse] =>
348 )
349
350 )
351
352 [recorded_title] =>
353 [recorded_recgroup] =>
354 [] => Array ( )
355)
356
357==========================================================================
358
359$_SERVER: Array
360(
361 [REDIRECT_STATUS] => 200
362 [HTTP_HOST] => mythtv-vm.local
363 [HTTP_CONNECTION] => keep-alive
364 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
365 [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36
366 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
367 [HTTP_REFERER] => http://mythtv-vm.local/mythweb/
368 [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch
369 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
370 [HTTP_COOKIE] => mythweb_id=6qv11j4cm33ijau3amq121hki1
371 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
372 [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at mythtv-vm.local Port 80</address>
373
374 [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu)
375 [SERVER_NAME] => mythtv-vm.local
376 [SERVER_ADDR] => ::a00:27ff:fe52:4655
377 [SERVER_PORT] => 80
378 [REMOTE_ADDR] => ::426c:8fff:fe2b:6f98
379 [DOCUMENT_ROOT] => /var/www/html
380 [REQUEST_SCHEME] => http
381 [CONTEXT_PREFIX] =>
382 [CONTEXT_DOCUMENT_ROOT] => /var/www/html
383 [SERVER_ADMIN] => webmaster@localhost
384 [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
385 [REMOTE_PORT] => 53980
386 [REDIRECT_URL] => /mythweb/tv/search
387 [GATEWAY_INTERFACE] => CGI/1.1
388 [SERVER_PROTOCOL] => HTTP/1.1
389 [REQUEST_METHOD] => GET
390 [QUERY_STRING] =>
391 [REQUEST_URI] => /tv/search
392 [SCRIPT_NAME] => /mythweb/mythweb.php
393 [PATH_INFO] => /tv/search
394 [PATH_TRANSLATED] => /var/www/html/tv/search
395 [PHP_SELF] => /mythweb/mythweb.php/tv/search
396 [REQUEST_TIME_FLOAT] => 1492347413.133
397 [REQUEST_TIME] => 1492347413
398 [STATUS] => 200
399 [URL] => /mythweb/tv/search
400 [HTTP_X_FORWARDED_PROTO] =>
401 [HTTPS] =>
402 [HTTP_PORT] => 80
403)
404
405==========================================================================
406
407$constant_list["user"]: Array
408(
409 [ERROR] => 512
410 [E_ASSERT_ERROR] => 4096
411 [FATAL] => 256
412 [PHP_MIN_VERSION] => 5.3
413 [WARNING] => 1024
414 [WebDBSchemaVer] => 4
415 [dupsin_all] => 15
416 [dupsin_newepisodes] => 16
417 [dupsin_oldrecorded] => 2
418 [dupsin_recorded] => 1
419 [error_email] =>
420 [gb] => 1073741824
421 [hostname] => mythtv-VM
422 [http_host] => mythtv-vm.local
423 [kb] => 1024
424 [max_stars] => 4
425 [mb] => 1048576
426 [module] => tv
427 [modules_path] => /usr/share/mythtv/mythweb/modules
428 [num_time_slots] => 36
429 [prefer_channum] => 1
430 [rectype_always] => 4
431 [rectype_daily] => 2
432 [rectype_dontrec] => 8
433 [rectype_findone] => 6
434 [rectype_once] => 1
435 [rectype_override] => 7
436 [rectype_template] => 11
437 [rectype_weekly] => 5
438 [root] => /mythweb/
439 [root_auth_url] => http://mythtv-vm.local/mythweb/
440 [root_url] => http://mythtv-vm.local/mythweb/
441 [searchtype_keyword] => 3
442 [searchtype_manual] => 5
443 [searchtype_people] => 4
444 [searchtype_power] => 1
445 [searchtype_title] => 2
446 [skin] => default
447 [skin_img_url] => http://mythtv-vm.local/mythweb/skins/default/img/
448 [skin_url] => http://mythtv-vm.local/mythweb/skins/default/
449 [star_character] => &#9733;
450 [stream_url] => http://mythtv-vm.local:80//mythweb/
451 [tb] => 1099511627776
452 [timeslot_blocks] => 3
453 [timeslot_size] => 300
454 [timeslotbar_skip] => 20
455 [tmpl] => default
456 [tmpl_dir] => modules/tv/tmpl/default/
457)
458
459