Database Exception – yii\db\Exception

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set' in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php:1320
Stack trace:
#0 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute()
#1 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(443): yii\db\Command->queryInternal()
#3 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php(497): yii\db\Command->queryScalar()
#4 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
#5 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php(368): yii\db\ActiveQuery->queryScalar()
#6 /home/wwwroot/gmteight/advanced/frontend/service/IndexService.php(183): yii\db\Query->count()
#7 /home/wwwroot/gmteight/advanced/frontend/controllers/IndexController.php(24): frontend\service\IndexService->index()
#8 [internal function]: frontend\controllers\IndexController->actionArticle()
#9 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#10 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#11 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#12 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#13 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#14 /home/wwwroot/gmteight/advanced/frontend/web/index.php(34): yii\base\Application->run()
#15 {main}

Next yii\db\Exception: SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set'
The SQL being executed was: SELECT COUNT(*) FROM `wp_posts` WHERE (`post_date` < '2025-04-25 05:26:59') AND ((`post_status`='publish') AND (`audit_status`='1') AND (`status`='1')) AND (find_in_set(6,39,p_category_id)) in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Schema.php:676
Stack trace:
#0 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php(443): yii\db\Command->queryInternal()
#3 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php(497): yii\db\Command->queryScalar()
#4 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
#5 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php(368): yii\db\ActiveQuery->queryScalar()
#6 /home/wwwroot/gmteight/advanced/frontend/service/IndexService.php(183): yii\db\Query->count()
#7 /home/wwwroot/gmteight/advanced/frontend/controllers/IndexController.php(24): frontend\service\IndexService->index()
#8 [internal function]: frontend\controllers\IndexController->actionArticle()
#9 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#10 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#11 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#12 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#13 /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#14 /home/wwwroot/gmteight/advanced/frontend/web/index.php(34): yii\base\Application->run()
#15 {main}
Additional Information:
Array
(
    [0] => 42000
    [1] => 1582
    [2] => Incorrect parameter count in the call to native function 'find_in_set'
)

Copied!

Database Exception – yii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set'
The SQL being executed was: SELECT COUNT(*) FROM `wp_posts` WHERE (`post_date` < '2025-04-25 05:26:59') AND ((`post_status`='publish') AND (`audit_status`='1') AND (`status`='1')) AND (find_in_set(6,39,p_category_id))

Error Info: Array
(
    [0] => 42000
    [1] => 1582
    [2] => Incorrect parameter count in the call to native function 'find_in_set'
)

↵

Caused by: PDOException

SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set'

in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php at line 1320

1. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Schema.php at line 676

667668669670671672673674675676677678679680681682683684685

 
        $exceptionClass = '\yii\db\Exception';
        foreach ($this->exceptionMap as $error => $class) {
            if (strpos($e->getMessage(), $error) !== false) {
                $exceptionClass = $class;
            }
        }
        $message = $e->getMessage() . "\nThe SQL being executed was: $rawSql";
        $errorInfo = $e instanceof \PDOException ? $e->errorInfo : null;
        return new $exceptionClass($message, $errorInfo, $e->getCode(), $e);
    }
 
    /**
     * Returns a value indicating whether a SQL statement is for read purpose.
     * @param string $sql the SQL statement
     * @return bool whether a SQL statement is for read purpose.
     */
    public function isReadQuery($sql)
    {

2. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php at line 1325 – yii\db\Schema::convertException()

1319132013211322132313241325132613271328132913301331

                } else {
                    $this->pdoStatement->execute();
                }
                break;
            } catch (\Exception $e) {
                $rawSql = $rawSql ?: $this->getRawSql();
                $e = $this->db->getSchema()->convertException($e, $rawSql);
                if ($this->_retryHandler === null || !call_user_func($this->_retryHandler, $e, $attempt)) {
                    throw $e;
                }
            }
        }
    }

3. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php at line 1186 – yii\db\Command::internalExecute()

1180118111821183118411851186118711881189119011911192

 
        $this->prepare(true);
 
        try {
            $profile and Yii::beginProfile($rawSql, 'yii\db\Command::query');
 
            $this->internalExecute($rawSql);
 
            if ($method === '') {
                $result = new DataReader($this);
            } else {
                if ($fetchMode === null) {
                    $fetchMode = $this->fetchMode;

4. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Command.php at line 443 – yii\db\Command::queryInternal()

437438439440441442443444445446447448449

     * @return string|int|null|false the value of the first column in the first row of the query result.
     * False is returned if there is no value.
     * @throws Exception execution failed
     */
    public function queryScalar()
    {
        $result = $this->queryInternal('fetchColumn', 0);
        if (is_resource($result) && get_resource_type($result) === 'stream') {
            return stream_get_contents($result);
        }
 
        return $result;
    }

5. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php at line 497 – yii\db\Command::queryScalar()

491492493494495496497498499500501502503

            $this->offset = $offset;
 
            if ($e !== null) {
                throw $e;
            }
 
            return $command->queryScalar();
        }
 
        $command = (new self())
            ->select([$selectExpression])
            ->from(['c' => $this])
            ->createCommand($db);

6. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/ActiveQuery.php at line 352 – yii\db\Query::queryScalar()

346347348349350351352353354355356357358

        $modelClass = $this->modelClass;
        if ($db === null) {
            $db = $modelClass::getDb();
        }
 
        if ($this->sql === null) {
            return parent::queryScalar($selectExpression, $db);
        }
 
        $command = (new Query())->select([$selectExpression])
            ->from(['c' => "({$this->sql})"])
            ->params($this->params)
            ->createCommand($db);

7. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/db/Query.php at line 368 – yii\db\ActiveQuery::queryScalar()

362363364365366367368369370371372373374

    public function count($q = '*', $db = null)
    {
        if ($this->emulateExecution) {
            return 0;
        }
 
        return $this->queryScalar("COUNT($q)", $db);
    }
 
    /**
     * Returns the sum of the specified column values.
     * @param string $q the column name or expression.
     * Make sure you properly [quote](guide:db-dao#quoting-table-and-column-names) column names in the expression.

8. in /home/wwwroot/gmteight/advanced/frontend/service/IndexService.php at line 183 – yii\db\Query::count()

177178179180181182183184185186187188189

            $query = (new Query())
                ->from(['a' => $query])
                ->select("a.*,b.en_name author_name,b.avatar author_avatar")
                ->leftJoin(ArticleAuthor::tableName().' as b','a.post_author = b.id')
                ->groupBy("a.post_author");
        }
        $count = $query->count();
        if($style == '2'){
            if($cursor) $query->andWhere(['<','a.create_time',$cursor]);
            $data = $query
                ->orderBy("a.create_time desc")
                ->offset($this->getOffset())
                ->limit($this->getPageSize())

9. in /home/wwwroot/gmteight/advanced/frontend/controllers/IndexController.php at line 24 – frontend\service\IndexService::index()

18192021222324252627282930

    public function actionSlide(){
        $res = (new IndexService())->slide();
        return $this->json($res);
    }
 
    public function actionArticle(){
        $res = (new IndexService())->index();
        return $this->json($res);
    }
 
    public function actionTopNews(){
        $res = (new IndexService())->frontArticle();
        return $this->json($res);

10. frontend\controllers\IndexController::actionArticle()

11. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/InlineAction.php at line 57 – call_user_func_array()

515253545556575859

        $args = $this->controller->bindActionParams($this, $params);
        Yii::debug('Running action: ' . get_class($this->controller) . '::' . $this->actionMethod . '()', __METHOD__);
        if (Yii::$app->requestedParams === null) {
            Yii::$app->requestedParams = $args;
        }
 
        return call_user_func_array([$this->controller, $this->actionMethod], $args);
    }
}

12. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Controller.php at line 178 – yii\base\InlineAction::runWithParams()

172173174175176177178179180181182183184

        }
 
        $result = null;
 
        if ($runAction && $this->beforeAction($action)) {
            // run the action
            $result = $action->runWithParams($params);
 
            $result = $this->afterAction($action, $result);
 
            // call afterAction on modules
            foreach ($modules as $module) {
                /* @var $module Module */

13. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Module.php at line 552 – yii\base\Controller::runAction()

546547548549550551552553554555556557558

        $parts = $this->createController($route);
        if (is_array($parts)) {
            /* @var $controller Controller */
            list($controller, $actionID) = $parts;
            $oldController = Yii::$app->controller;
            Yii::$app->controller = $controller;
            $result = $controller->runAction($actionID, $params);
            if ($oldController !== null) {
                Yii::$app->controller = $oldController;
            }
 
            return $result;
        }

14. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/web/Application.php at line 103 – yii\base\Module::runAction()

979899100101102103104105106107108109

            $params = $this->catchAll;
            unset($params[0]);
        }
        try {
            Yii::debug("Route requested: '$route'", __METHOD__);
            $this->requestedRoute = $route;
            $result = $this->runAction($route, $params);
            if ($result instanceof Response) {
                return $result;
            }
 
            $response = $this->getResponse();
            if ($result !== null) {

15. in /home/wwwroot/gmteight/advanced/vendor/yiisoft/yii2/base/Application.php at line 384 – yii\web\Application::handleRequest()

378379380381382383384385386387388389390

    {
        try {
            $this->state = self::STATE_BEFORE_REQUEST;
            $this->trigger(self::EVENT_BEFORE_REQUEST);
 
            $this->state = self::STATE_HANDLING_REQUEST;
            $response = $this->handleRequest($this->getRequest());
 
            $this->state = self::STATE_AFTER_REQUEST;
            $this->trigger(self::EVENT_AFTER_REQUEST);
 
            $this->state = self::STATE_SENDING_RESPONSE;
            $response->send();

16. in /home/wwwroot/gmteight/advanced/frontend/web/index.php at line 34 – yii\base\Application::run()

28293031323334

$config = yii\helpers\ArrayHelper::merge(
    require __DIR__ . '/../../common/config/main.php',
    require __DIR__ . '/../config/main.php'
);
 
$app = (new yii\web\Application($config));
$app -> run();

$_GET = [
    'p_category_id' => '6,39',
];

Industrial and Commercial Bank of China data tracking: China's Q1 mobile phone export volume remained flat year-on-year, a decrease of 40% compared to the previous quarter.