開始探索你的目的地和活動
開始探索你的目的地和活動
【香港迪士尼樂園酒店住宿優惠】香港迪士尼樂園酒店 Hong Kong Disneyland Hotel

【早鳥優惠】香港迪士尼樂園酒店Staycation優惠(海景陽台房)

Hong Kong Disneyland Hotel
SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE ((related_pro_cat = OR FIND_IN_SET('',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8
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 'OR FIND_IN_SET('',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 A' at line 1 (500 Whoops, looks like something went wrong.)

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 'OR FIND_IN_SET('',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 A' at line 1

Exception

Joomla\Database\Exception\ PrepareStatementFailureException

  1.         $this->statement  $connection->prepare($query);
  2.         if (!$this->statement)
  3.         {
  4.             throw new PrepareStatementFailureException($this->connection->error$this->connection->errno);
  5.         }
  6.     }
  7.     /**
  8.      * Replace named parameters with numbered parameters
  1.      * @since   2.0.0
  2.      * @throws  PrepareStatementFailureException
  3.      */
  4.     protected function prepareStatement(string $query): StatementInterface
  5.     {
  6.         return new MysqliStatement($this->connection$query);
  7.     }
  8.     /**
  9.      * Unlocks tables in the database.
  10.      *
  1.         $query->setLimit($limit$offset);
  2.         $sql $this->replacePrefix((string) $query);
  3.         $this->statement $this->prepareStatement($sql);
  4.         $this->sql    $query;
  5.         $this->limit  = (int) max(0$limit);
  6.         $this->offset = (int) max(0$offset);
DatabaseDriver->setQuery(object(MysqliQuery)) in /home/mroom/public_html/templates/bengsengtravel/html/manageprice/related_article.php (line 67)
  1.     $rqry "(related_pro_cat = ".$rpro[0]." OR FIND_IN_SET('".$rpro[0]."',related_pro_cat))";
  2. }
  3. echo "<div style='display:none;'>SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE (".$rqry.") AND article_id !=".$article_id." AND is_suggestion=1 AND article_status=1 order by total DESC limit 8</div>";
  4. $db2->setQuery("SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, ',', '')) + 1) as total FROM #__articles WHERE (".$rqry.") AND article_id !=".$article_id." AND is_suggestion=1 AND article_status=1 order by total DESC limit 8");
  5. $related_products $db2->loadObjectList();
  6. if(!empty($related_products)){

Stack Trace

PrepareStatementFailureException
Joomla\Database\Exception\PrepareStatementFailureException:
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 'OR FIND_IN_SET('',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 A' at line 1

  at /home/mroom/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141
  at Joomla\Database\Mysqli\MysqliStatement->__construct(object(mysqli), 'SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, \',\', \'\')) + 1) as total FROM fx_articles WHERE ((related_pro_cat =  OR FIND_IN_SET(\'\',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8')
     (/home/mroom/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089)
  at Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SELECT *,(CHAR_LENGTH(related_pro_cat) - CHAR_LENGTH(REPLACE(related_pro_cat, \',\', \'\')) + 1) as total FROM fx_articles WHERE ((related_pro_cat =  OR FIND_IN_SET(\'\',related_pro_cat))) AND article_id !=1449 AND is_suggestion=1 AND article_status=1 order by total DESC limit 8')
     (/home/mroom/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900)
  at Joomla\Database\DatabaseDriver->setQuery(object(MysqliQuery))
     (/home/mroom/public_html/templates/bengsengtravel/html/manageprice/related_article.php:67)