Fatal Error at /var/www/html/MythWeb/includes/db.php, line 558: 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] If you choose to submit a bug report, please make sure to include a brief description of what you were doing, along with the following backtrace as an attachment (please don't paste the whole thing into the ticket). Backtrace: datetime: 2006-07-11 22:38:21 (CEST) errornum: 256 error type: User Error 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] filename: /var/www/html/MythWeb/includes/db.php error line: 558 ========================================================================== Backtrace: file: /var/www/html/MythWeb/includes/db.php line: 558 class: function: trigger_error type: args: Array ( [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] [1] => 256 ) file: /var/www/html/MythWeb/includes/db.php line: 145 class: Database_Query_mysql function: execute type: -> args: Array ( [0] => Array ( ) ) file: /var/www/html/MythWeb/includes/programs.php line: 154 class: Database function: query type: -> args: Array ( [0] => SELECT program.*, UNIX_TIMESTAMP(program.starttime) AS starttime_unix, UNIX_TIMESTAMP(program.endtime) AS endtime_unix, IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS rating, channel.channum FROM program LEFT JOIN programrating USING (chanid, starttime) LEFT JOIN channel ON program.chanid = channel.chanid 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') GROUP BY program.chanid, program.starttime ORDER BY program.starttime ) file: /var/www/html/MythWeb/modules/tv/search.php line: 288 class: function: load_all_program_data type: args: Array ( [0] => 1152650301 [1] => 1155328701 [2] => [3] => [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') ) file: /var/www/html/MythWeb/modules/tv/handler.php line: 62 class: function: require_once type: args: Array ( [0] => /var/www/html/MythWeb/modules/tv/search.php ) file: /var/www/html/MythWeb/mythweb.php line: 24 class: function: require_once type: args: Array ( [0] => /var/www/html/MythWeb/modules/tv/handler.php ) ========================================================================== $_GET: Array ( [type] => a [af] => Array ( [0] => Array ( [0] => title ) ) [as] => Array ( [0] => äventyr ) [starttime] => now [endtime] => + 2 weeks [airdate_start] => [airdate_end] => [ctype] => Array ( [0] => [1] => movie [2] => series [3] => sports [4] => tvshow ) [stars_gt] => 0 [stars_lt] => 1 [search] => Search ) ========================================================================== $_SESSION: Array ( [language] => English [Theme] => default [date_statusbar] => %a %b %e, %Y, %H:%M [date_scheduled] => %a %b %e, %Y (%H:%M) [date_scheduled_popup] => %a %b %e, %Y [date_recorded] => %a %b %e, %Y
(%H:%M) [date_search] => %a %b %e, %Y, %H:%M [date_listing_key] => %a %b %e, %Y, %H:%M [date_listing_jump] => %a %b %e, %Y [date_channel_jump] => %a %b %e, %Y [time_format] => %H:%M [siunits] => YES [weathericonset] => Default [recorded_descunder] => [guide_favonly] => [list_time] => 1152649800 [scheduled_recordings] => Array ( [disp_scheduled] => 1 [disp_duplicates] => 1 [disp_deactivated] => 1 [disp_conflicts] => 1 ) [scheduled_sortby] => Array ( [0] => Array ( [field] => airdate [reverse] => ) [1] => Array ( [field] => title [reverse] => ) ) [recorded_title] => [recorded_sortby] => Array ( [0] => Array ( [field] => airdate [reverse] => 1 ) [1] => Array ( [field] => title [reverse] => ) ) [Skin] => default [] => Array ( ) [schedules_sortby] => Array ( [0] => Array ( [field] => title [reverse] => ) [1] => Array ( [field] => airdate [reverse] => ) ) [video_sortby] => Array ( [0] => Array ( [field] => title [reverse] => ) ) [search_sortby] => Array ( [0] => Array ( [field] => airdate [reverse] => ) [1] => Array ( [field] => title [reverse] => ) ) [recorded_recgroup] => [tmpl] => default [skin] => default [prefer_channum] => 0 [recorded_pixmaps] => 1 [timeslot_size] => 300 [num_time_slots] => 36 [timeslot_blocks] => 3 [timeslotbar_skip] => 20 [max_stars] => 4 [star_character] => ♦ [search] => Array ( [searchstr] => Discover Magazine [search_title] => 1 [search_subtitle] => [search_description] => [search_category] => [search_category_type] => [ctype] => Array ( [0] => [1] => movie [2] => series [3] => sports [4] => tvshow ) [stars_gt] => 0 [stars_lt] => 1 [starttime] => now [endtime] => + 2 weeks [as] => Array ( [0] => äventyr ) [af] => Array ( [0] => Array ( ) ) [aj] => Array ( [0] => AND ) [type] => a [hd] => [airdate_start] => [airdate_end] => [s] => blaj ) )