最新活动
筛选方式
排序方式
Exception -> object(PDOException)#4 (8) { ["message":protected]=> string(283) "SQLSTATE[42000]: Syntax error or access violation: 1064 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 'ORDER BY event.`event_start_date` DESC, event.`event_start_date_time`' at line 30" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(55) "/var/www/vhosts/fytgsweb/public_html/include/db.inc.php" ["line":protected]=> int(41) ["trace":"Exception":private]=> array(2) { [0]=> array(6) { ["file"]=> string(55) "/var/www/vhosts/fytgsweb/public_html/include/db.inc.php" ["line"]=> int(41) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> NULL } } [1]=> array(4) { ["file"]=> string(55) "/var/www/vhosts/fytgsweb/public_html/sc/events_list.php" ["line"]=> int(218) ["function"]=> string(7) "prepare" ["args"]=> array(1) { [0]=> string(1342) "SELECT event.`event_id`, event.`title_sc` AS event_title, event.`index_thumbnail`, event.`description_sc` AS event_desc, event.`event_start_date`, event.`event_end_date`, event.`event_start_time` AS start_time, event.`event_end_time` AS end_time, event.`event_venue_sc` AS venue, event.`event_remark_sc` AS remark, event.`external_url_sc` AS external_url, event.`button_txt_sc` AS button_txt, event.`button_url_sc` AS button_url, event_cat.`name_sc` AS event_cat_title FROM `fytgs_event` AS event, `fytgs_event_cat` AS event_cat WHERE event.`event_cat_id` = event_cat.`event_cat_id` AND event.`is_active` = 1 AND event.`is_delete` = 0 AND event_cat.`is_active` = 1 AND event_cat.`is_delete` = 0 AND event.`posting_date_from` <= CURDATE() AND CASE WHEN event.`posting_date_to` IS NULL THEN CURDATE() >= event.`posting_date_from` ELSE CURDATE() BETWEEN event.`posting_date_from` AND event.`posting_date_to` END ORDER BY event.`event_start_date` DESC, event.`event_start_date_time` DESC ORDER BY event.`event_start_date` DESC, event.`event_start_date_time` DESC LIMIT 0, 3" } } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(227) "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 'ORDER BY event.`event_start_date` DESC, event.`event_start_date_time`' at line 30" } }
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'ORDER BY event.`event_start_date` DESC, event.`event_start_date_time`' at line 30 in /var/www/vhosts/fytgsweb/public_html/include/db.inc.php:41 Stack trace: #0 /var/www/vhosts/fytgsweb/public_html/include/db.inc.php(41): PDOStatement->execute(NULL) #1 /var/www/vhosts/fytgsweb/public_html/sc/events_list.php(218): prepare('SELECT \r\n\t\t\t\t\t\t...') #2 {main} thrown in /var/www/vhosts/fytgsweb/public_html/include/db.inc.php on line 41