Database Exception – yii\db\Exception

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recommend' in 'where clause' 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(197): 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[42S22]: Column not found: 1054 Unknown column 'recommend' in 'where clause'
The SQL being executed was: SELECT COUNT(*) FROM `wp_posts` WHERE (`post_date` < '2025-07-13 04:37:37') AND ((`post_status`='publish') AND (`audit_status`='1') AND (`status`='1')) AND (`ID` NOT IN ('133', '130', '267302', '269487', '270226', '271161', '271186', '271773', '275498', '275519', '275817', '275818', '275819', '275843', '275854', '276143', '276144', '276145', '276784', '274990', '276978', '276982', '276987', '276988', '276989', '277333', '277334', '277343', '277344', '277346', '277893', '277894', '277895', '277898', '277901', '277904', '277906', '277912', '277914', '278333', '278341', '278346', '278347', '278354', '278968', '278969', '278970', '278971', '278972', '279265', '279268', '279277', '279283', '279294', '279682', '279691', '279698', '279711', '279712', '280093', '280094', '280095', '280096', '280097', '280098', '280114', '280756', '280794', '280806', '280814', '280824', '280836', '281598', '281599', '281600', '281601', '281602', '282364', '282365', '282366', '282367', '282373', '282454', '282705', '282774', '282778', '282779', '282780', '282781', '283175', '283176', '283177', '283178', '283179', '283616', '283647', '283648', '283649', '283650', '283651', '284092', '284094', '284095', '284096', '284097', '284609', '284610', '284618', '284624', '284627', '284704', '285065', '285066', '285067', '285068', '285069', '285418', '285417', '285445', '285446', '285447', '285452', '285455', '285466', '285467', '285468', '285809', '285810', '285811', '285812', '285813', '285814')) AND (find_in_set(2,p_category_id)) AND (find_in_set(recommend,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(197): 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] => 42S22
    [1] => 1054
    [2] => Unknown column 'recommend' in 'where clause'
)

Copied!

Database Exception – yii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recommend' in 'where clause'
The SQL being executed was: SELECT COUNT(*) FROM `wp_posts` WHERE (`post_date` < '2025-07-13 04:37:37') AND ((`post_status`='publish') AND (`audit_status`='1') AND (`status`='1')) AND (`ID` NOT IN ('133', '130', '267302', '269487', '270226', '271161', '271186', '271773', '275498', '275519', '275817', '275818', '275819', '275843', '275854', '276143', '276144', '276145', '276784', '274990', '276978', '276982', '276987', '276988', '276989', '277333', '277334', '277343', '277344', '277346', '277893', '277894', '277895', '277898', '277901', '277904', '277906', '277912', '277914', '278333', '278341', '278346', '278347', '278354', '278968', '278969', '278970', '278971', '278972', '279265', '279268', '279277', '279283', '279294', '279682', '279691', '279698', '279711', '279712', '280093', '280094', '280095', '280096', '280097', '280098', '280114', '280756', '280794', '280806', '280814', '280824', '280836', '281598', '281599', '281600', '281601', '281602', '282364', '282365', '282366', '282367', '282373', '282454', '282705', '282774', '282778', '282779', '282780', '282781', '283175', '283176', '283177', '283178', '283179', '283616', '283647', '283648', '283649', '283650', '283651', '284092', '284094', '284095', '284096', '284097', '284609', '284610', '284618', '284624', '284627', '284704', '285065', '285066', '285067', '285068', '285069', '285418', '285417', '285445', '285446', '285447', '285452', '285455', '285466', '285467', '285468', '285809', '285810', '285811', '285812', '285813', '285814')) AND (find_in_set(2,p_category_id)) AND (find_in_set(recommend,category_id))

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'recommend' in 'where clause'
)

↵

Caused by: PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recommend' in 'where clause'

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 197 – yii\db\Query::count()

191192193194195196197198199200201202203

            $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' => '2',
    'category_id' => 'recommend',
    'style' => '1',
    'page' => '1',
    'page_size' => '20',
];