Ticket #2043: mythweb errortext.txt

File mythweb errortext.txt, 8.3 KB (added by torbjorn.jansson@…, 18 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)