Ticket #10636: Mythweb - Mysql error - recorded programs.txt

File Mythweb - Mysql error - recorded programs.txt, 9.7 KB (added by Raymond Wagner, 12 years ago)
Line 
1    datetime:  2012-04-21 20:15:19 (EST)
2    errornum:  256
3  error type:  User Error
4error string:  !!NoTrans: SQL Error: Unknown column 'recordedmarkup.data' in 'field list' [#1054]!!
5    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
6  error line:  79
7
8==========================================================================
9
10Backtrace:
11
12    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
13    line:  79
14   class: 
15function:  trigger_error
16    type: 
17    args:  Array
18(
19    [0] => SQL Error: Unknown column 'recordedmarkup.data' in 'field list' [#1054]
20    [1] => 256
21)
22
23    file:  /usr/share/mythtv/mythweb/classes/Database.php
24    line:  259
25   class:  Database_Query_mysql
26function:  execute
27    type:  ->
28    args:  Array
29(
30    [0] => Array
31        (
32            [0] => 1044
33            [1] => 1335002100
34        )
35
36)
37
38    file:  /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
39    line:  810
40   class:  Database
41function:  query
42    type:  ->
43    args:  Array
44(
45    [0] => SELECT recordedmarkup.type,
46                                 recordedmarkup.data
47                            FROM recordedmarkup
48                           WHERE recordedmarkup.chanid    = ?
49                             AND recordedmarkup.starttime = FROM_UNIXTIME(?)
50                             AND recordedmarkup.type      IN (10, 11, 12, 13, 14)
51                        GROUP BY recordedmarkup.type
52                        ORDER BY SUM((SELECT IFNULL(rm.mark, recordedmarkup.mark)
53                                        FROM recordedmarkup AS rm
54                                       WHERE rm.chanid = recordedmarkup.chanid
55                                         AND rm.starttime = recordedmarkup.starttime
56                                         AND rm.type IN (10, 11, 12, 13, 14)
57                                         AND rm.mark > recordedmarkup.mark
58                                ORDER BY rm.mark ASC LIMIT 1)- recordedmarkup.mark) DESC
59                           LIMIT 1
60    [1] => 1044
61    [2] => 1335002100
62)
63
64    file:  /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
65    line:  144
66   class:  Program
67function:  getAspect
68    type:  ->
69    args:  Array ( )
70    file:  /usr/share/mythtv/mythweb/modules/tv/recorded.php
71    line:  193
72   class: 
73function:  require_once
74    type: 
75    args:  Array
76(
77    [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
78)
79
80    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
81    line:  82
82   class: 
83function:  require_once
84    type: 
85    args:  Array
86(
87    [0] => /usr/share/mythtv/mythweb/modules/tv/recorded.php
88)
89
90    file:  /usr/share/mythtv/mythweb/mythweb.php
91    line:  35
92   class: 
93function:  require_once
94    type: 
95    args:  Array
96(
97    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
98)
99
100
101==========================================================================
102
103$_GET: Array
104(
105    [reverse] =>
106    [sortby] =>
107)
108
109==========================================================================
110
111$_SESSION: Array
112(
113    [language] => English
114    [date_statusbar] => %a %b %e, %Y, %I:%M %p
115    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
116    [date_scheduled_popup] => %a %b %e, %Y
117    [date_recorded] => %a %b %e, %Y (%I:%M %p)
118    [date_search] => %a %b %e, %Y, %I:%M %p
119    [date_listing_key] => %a %b %e, %Y, %I:%M %p
120    [date_listing_jump] => %a %b %e, %Y
121    [date_channel_jump] => %a %b %e, %Y
122    [date_job_status] => %a %b %e, %Y, %I:%M %p
123    [time_format] => %I:%M %p
124    [cache_engine] => Cache_Null
125    [stream] => Array
126        (
127            [include_user_and_password] =>
128        )
129
130    [prefer_channum] => 1
131    [recorded_pixmaps] => 1
132    [guide_favonly] =>
133    [timeslot_size] => 300
134    [num_time_slots] => 36
135    [timeslot_blocks] => 3
136    [timeslotbar_skip] => 20
137    [max_stars] => 4
138    [star_character] => ★
139    [show_popup_info] => 1
140    [show_channel_icons] => 1
141    [sortby_channum] => 1
142    [recorded_paging] =>
143    [genre_colors] => 1
144    [show_video_covers] => 1
145    [settings] => Array
146        (
147            [screens] => Array
148                (
149                    [tv] => Array
150                        (
151                            [upcoming recordings] => Array
152                                (
153                                    [title] => on
154                                    [channel] => on
155                                    [record date] => on
156                                    [length] => on
157                                )
158
159                        )
160
161                )
162
163        )
164
165    [backend] => Array
166        (
167            [192.168.100.234] => Array
168                (
169                    [proto_version] => Array
170                        (
171                            [last_check_version] => 72
172                            [last_check_time] => 1334998629
173                        )
174
175                )
176
177            [timezone] => Array
178                (
179                    [value] => Australia/Melbourne
180                    [last_check_time] => 1334933984
181                )
182
183        )
184
185    [tv] => Array
186        (
187            [last] => Array
188                (
189                    [0] => recorded
190                )
191
192        )
193
194    [list_time] => 1334991600
195    [recorded_sortby] => Array
196        (
197            [0] => Array
198                (
199                    [field] => airdate
200                    [reverse] => 1
201                )
202
203            [1] => Array
204                (
205                    [field] => title
206                    [reverse] =>
207                )
208
209        )
210
211    [scheduled_recordings] => Array
212        (
213            [disp_scheduled] => 1
214            [disp_duplicates] =>
215            [disp_deactivated] =>
216            [disp_conflicts] => 1
217        )
218
219    [scheduled_sortby] => Array
220        (
221            [0] => Array
222                (
223                    [field] => airdate
224                    [reverse] =>
225                )
226
227            [1] => Array
228                (
229                    [field] => title
230                    [reverse] =>
231                )
232
233        )
234
235    [recording_details] => Array
236        (
237            [show_Conflict] => 1
238            [show_PreviousRecording] => 1
239            [show_EarlierShowing] => 1
240            [show_CurrentRecording] => 1
241            [show_WillRecord] => 1
242        )
243
244)
245
246==========================================================================
247
248$_SERVER: Array
249(
250    [REDIRECT_STATUS] => 200
251    [HTTP_HOST] => 192.168.102.234
252    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0
253    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
254    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
255    [HTTP_ACCEPT_ENCODING] => gzip, deflate
256    [HTTP_CONNECTION] => keep-alive
257    [HTTP_REFERER] => http://192.168.102.234/mythweb/status
258    [HTTP_COOKIE] => mythweb_id=7s1qf380njqrk5hd4qer7ih6f4
259    [PATH] => /usr/local/bin:/usr/bin:/bin
260    [SERVER_SIGNATURE] => <address>Apache/2.2.22 (Ubuntu) Server at 192.168.102.234 Port 80</address>
261
262    [SERVER_SOFTWARE] => Apache/2.2.22 (Ubuntu)
263    [SERVER_NAME] => 192.168.102.234
264    [SERVER_ADDR] => 192.168.102.234
265    [SERVER_PORT] => 80
266    [REMOTE_ADDR] => 192.168.102.71
267    [DOCUMENT_ROOT] => /var/www
268    [SERVER_ADMIN] => webmaster@localhost
269    [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
270    [REMOTE_PORT] => 3869
271    [REDIRECT_URL] => /mythweb/tv/recorded
272    [GATEWAY_INTERFACE] => CGI/1.1
273    [SERVER_PROTOCOL] => HTTP/1.1
274    [REQUEST_METHOD] => GET
275    [QUERY_STRING] =>
276    [REQUEST_URI] => /tv/recorded
277    [SCRIPT_NAME] => /mythweb/mythweb.php
278    [PATH_INFO] => /tv/recorded
279    [PATH_TRANSLATED] => /var/www/tv/recorded
280    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
281    [REQUEST_TIME] => 1335003318
282    [STATUS] => 200
283    [URL] => /mythweb/tv/recorded
284    [HTTP_PORT] => 80
285)
286
287==========================================================================
288
289$constant_list["user"]: Array
290(
291    [ERROR] => 512
292    [E_ASSERT_ERROR] => 4096
293    [FATAL] => 256
294    [PHP_MIN_VERSION] => 5.3
295    [WARNING] => 1024
296    [WebDBSchemaVer] => 3
297    [disk_size] => 2116197437440
298    [disk_used] => 1371535867904
299    [dupsin_all] => 15
300    [dupsin_newepisodes] => 16
301    [dupsin_oldrecorded] => 2
302    [dupsin_recorded] => 1
303    [error_email] =>
304    [gb] => 1073741824
305    [hostname] => cameron-desktop
306    [http_host] => 192.168.102.234
307    [kb] => 1024
308    [max_stars] => 4
309    [mb] => 1048576
310    [module] => tv
311    [modules_path] => /usr/share/mythtv/mythweb/modules
312    [num_time_slots] => 36
313    [prefer_channum] => 1
314    [rectype_always] => 4
315    [rectype_channel] => 3
316    [rectype_daily] => 2
317    [rectype_dontrec] => 8
318    [rectype_finddaily] => 9
319    [rectype_findone] => 6
320    [rectype_findweekly] => 10
321    [rectype_once] => 1
322    [rectype_override] => 7
323    [rectype_weekly] => 5
324    [root] => /mythweb/
325    [root_auth_url] => http://192.168.102.234/mythweb/
326    [root_url] => http://192.168.102.234/mythweb/
327    [searchtype_keyword] => 3
328    [searchtype_manual] => 5
329    [searchtype_people] => 4
330    [searchtype_power] => 1
331    [searchtype_title] => 2
332    [skin] => default
333    [skin_img_url] => http://192.168.102.234/mythweb/skins/default/img/
334    [skin_url] => http://192.168.102.234/mythweb/skins/default/
335    [star_character] => &#9733;
336    [stream_url] => http://192.168.102.234:80//mythweb/
337    [tb] => 1099511627776
338    [timeslot_blocks] => 3
339    [timeslot_size] => 300
340    [timeslotbar_skip] => 20
341    [tmpl] => default
342    [tmpl_dir] => modules/tv/tmpl/default/
343)
344
345