Ticket #2043: mythweb errortext.txt

File mythweb errortext.txt, 8.3 KB (added by torbjorn.jansson@…, 19 years ago)

the error text

Line 
1Fatal Error at /var/www/html/MythWeb/includes/db.php, line 558:
2SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (program.category_type IN ('','movie','series','sports','tvshow') AND IF(' at line 10 [#1064]
3
4If you choose to submit a bug report, please make sure to include a
5brief description of what you were doing, along with the following
6backtrace as an attachment (please don't paste the whole thing into
7the ticket).
8Backtrace:
9
10 datetime: 2006-07-11 22:38:21 (CEST)
11 errornum: 256
12 error type: User Error
13error string: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (program.category_type IN ('','movie','series','sports','tvshow') AND IF(' at line 10 [#1064]
14 filename: /var/www/html/MythWeb/includes/db.php
15 error line: 558
16
17==========================================================================
18
19Backtrace:
20
21 file: /var/www/html/MythWeb/includes/db.php
22 line: 558
23 class:
24function: trigger_error
25 type:
26 args: Array
27(
28 [0] => SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (program.category_type IN ('','movie','series','sports','tvshow') AND IF(' at line 10 [#1064]
29 [1] => 256
30)
31
32 file: /var/www/html/MythWeb/includes/db.php
33 line: 145
34 class: Database_Query_mysql
35function: execute
36 type: ->
37 args: Array
38(
39 [0] => Array ( )
40)
41
42 file: /var/www/html/MythWeb/includes/programs.php
43 line: 154
44 class: Database
45function: query
46 type: ->
47 args: Array
48(
49 [0] => SELECT program.*,
50 UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
51 UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
52 IFNULL(programrating.system, "") AS rater,
53 IFNULL(programrating.rating, "") AS rating,
54 channel.channum
55 FROM program
56 LEFT JOIN programrating USING (chanid, starttime)
57 LEFT JOIN channel ON program.chanid = channel.chanid
58 WHERE program.chanid IN (20522,1000,2001,1001,2002,1002,1003,2004,1004,1005,1006,1007,1009,1010,2008,1008,2125,1013,2153,2054,2060,20340,20349,20342,20329,20330,20425) AND (program.endtime > FROM_UNIXTIME('1152650301') AND program.starttime < FROM_UNIXTIME('1155328701') AND program.starttime != program.endtime) AND (()) AND (program.category_type IN ('','movie','series','sports','tvshow') AND IF(program.category_type = "movie", program.stars >= 0 AND program.stars <= 1, 1) AND program.starttime>='2006-07-11 22:38:21' AND program.endtime<='2006-07-25 22:38:21')
59GROUP BY program.chanid, program.starttime ORDER BY program.starttime
60)
61
62 file: /var/www/html/MythWeb/modules/tv/search.php
63 line: 288
64 class:
65function: load_all_program_data
66 type:
67 args: Array
68(
69 [0] => 1152650301
70 [1] => 1155328701
71 [2] =>
72 [3] =>
73 [4] => (()) AND (program.category_type IN ('','movie','series','sports','tvshow') AND IF(program.category_type = "movie", program.stars >= 0 AND program.stars <= 1, 1) AND program.starttime>='2006-07-11 22:38:21' AND program.endtime<='2006-07-25 22:38:21')
74)
75
76 file: /var/www/html/MythWeb/modules/tv/handler.php
77 line: 62
78 class:
79function: require_once
80 type:
81 args: Array
82(
83 [0] => /var/www/html/MythWeb/modules/tv/search.php
84)
85
86 file: /var/www/html/MythWeb/mythweb.php
87 line: 24
88 class:
89function: require_once
90 type:
91 args: Array
92(
93 [0] => /var/www/html/MythWeb/modules/tv/handler.php
94)
95
96
97==========================================================================
98
99$_GET: Array
100(
101 [type] => a
102 [af] => Array
103 (
104 [0] => Array
105 (
106 [0] => title
107 )
108
109 )
110
111 [as] => Array
112 (
113 [0] => Àventyr
114 )
115
116 [starttime] => now
117 [endtime] => + 2 weeks
118 [airdate_start] =>
119 [airdate_end] =>
120 [ctype] => Array
121 (
122 [0] =>
123 [1] => movie
124 [2] => series
125 [3] => sports
126 [4] => tvshow
127 )
128
129 [stars_gt] => 0
130 [stars_lt] => 1
131 [search] => Search
132)
133
134==========================================================================
135
136$_SESSION: Array
137(
138 [language] => English
139 [Theme] => default
140 [date_statusbar] => %a %b %e, %Y, %H:%M
141 [date_scheduled] => %a %b %e, %Y (%H:%M)
142 [date_scheduled_popup] => %a %b %e, %Y
143 [date_recorded] => %a %b %e, %Y<br />(%H:%M)
144 [date_search] => %a %b %e, %Y, %H:%M
145 [date_listing_key] => %a %b %e, %Y, %H:%M
146 [date_listing_jump] => %a %b %e, %Y
147 [date_channel_jump] => %a %b %e, %Y
148 [time_format] => %H:%M
149 [siunits] => YES
150 [weathericonset] => Default
151 [recorded_descunder] =>
152 [guide_favonly] =>
153 [list_time] => 1152649800
154 [scheduled_recordings] => Array
155 (
156 [disp_scheduled] => 1
157 [disp_duplicates] => 1
158 [disp_deactivated] => 1
159 [disp_conflicts] => 1
160 )
161
162 [scheduled_sortby] => Array
163 (
164 [0] => Array
165 (
166 [field] => airdate
167 [reverse] =>
168 )
169
170 [1] => Array
171 (
172 [field] => title
173 [reverse] =>
174 )
175
176 )
177
178 [recorded_title] =>
179 [recorded_sortby] => Array
180 (
181 [0] => Array
182 (
183 [field] => airdate
184 [reverse] => 1
185 )
186
187 [1] => Array
188 (
189 [field] => title
190 [reverse] =>
191 )
192
193 )
194
195 [Skin] => default
196 [] => Array ( )
197 [schedules_sortby] => Array
198 (
199 [0] => Array
200 (
201 [field] => title
202 [reverse] =>
203 )
204
205 [1] => Array
206 (
207 [field] => airdate
208 [reverse] =>
209 )
210
211 )
212
213 [video_sortby] => Array
214 (
215 [0] => Array
216 (
217 [field] => title
218 [reverse] =>
219 )
220
221 )
222
223 [search_sortby] => Array
224 (
225 [0] => Array
226 (
227 [field] => airdate
228 [reverse] =>
229 )
230
231 [1] => Array
232 (
233 [field] => title
234 [reverse] =>
235 )
236
237 )
238
239 [recorded_recgroup] =>
240 [tmpl] => default
241 [skin] => default
242 [prefer_channum] => 0
243 [recorded_pixmaps] => 1
244 [timeslot_size] => 300
245 [num_time_slots] => 36
246 [timeslot_blocks] => 3
247 [timeslotbar_skip] => 20
248 [max_stars] => 4
249 [star_character] => &diams;
250 [search] => Array
251 (
252 [searchstr] => Discover Magazine
253 [search_title] => 1
254 [search_subtitle] =>
255 [search_description] =>
256 [search_category] =>
257 [search_category_type] =>
258 [ctype] => Array
259 (
260 [0] =>
261 [1] => movie
262 [2] => series
263 [3] => sports
264 [4] => tvshow
265 )
266
267 [stars_gt] => 0
268 [stars_lt] => 1
269 [starttime] => now
270 [endtime] => + 2 weeks
271 [as] => Array
272 (
273 [0] => Àventyr
274 )
275
276 [af] => Array
277 (
278 [0] => Array ( )
279 )
280
281 [aj] => Array
282 (
283 [0] => AND
284 )
285
286 [type] => a
287 [hd] =>
288 [airdate_start] =>
289 [airdate_end] =>
290 [s] => blaj
291 )
292
293)