1 | Fatal Error at /var/www/html/MythWeb/includes/db.php, line 558:
|
---|
2 | 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]
|
---|
3 |
|
---|
4 | If you choose to submit a bug report, please make sure to include a
|
---|
5 | brief description of what you were doing, along with the following
|
---|
6 | backtrace as an attachment (please don't paste the whole thing into
|
---|
7 | the ticket).
|
---|
8 | Backtrace:
|
---|
9 |
|
---|
10 | datetime: 2006-07-11 22:38:21 (CEST)
|
---|
11 | errornum: 256
|
---|
12 | error type: User Error
|
---|
13 | error 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 |
|
---|
19 | Backtrace:
|
---|
20 |
|
---|
21 | file: /var/www/html/MythWeb/includes/db.php
|
---|
22 | line: 558
|
---|
23 | class:
|
---|
24 | function: 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
|
---|
35 | function: 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
|
---|
45 | function: 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')
|
---|
59 | GROUP 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:
|
---|
65 | function: 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:
|
---|
79 | function: 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:
|
---|
89 | function: 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] => ♦
|
---|
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 | ) |
---|