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
)
)