Database Exception – yii\db\Exception

1. in /local/www/board.orsk.ru/vendor/yiisoft/yii2/db/Schema.php at line 534

525526527528529530531532533534535536537538539540541542543

 
        $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, (int) $e->getCode(), $e);
    }
 
    /**
     * Returns a value indicating whether a SQL statement is for read purpose.
     * @param string $sql the SQL statement
     * @return boolean whether a SQL statement is for read purpose.
     */
    public function isReadQuery($sql)
    {

2. in /local/www/board.orsk.ru/vendor/yiisoft/yii2/db/Command.php – yii\db\Schema::convertException(PDOException, 'SELECT count(id) FROM `b_board_p...') at line 837

831832833834835836837838839840841842843

                $this->pdoStatement->closeCursor();
            }
 
            Yii::endProfile($token, 'yii\db\Command::query');
        } catch (\Exception $e) {
            Yii::endProfile($token, 'yii\db\Command::query');
            throw $this->db->getSchema()->convertException($e, $rawSql);
        }
 
        if (isset($cache, $cacheKey, $info)) {
            $cache->set($cacheKey, [$result], $info[1], $info[2]);
            Yii::trace('Saved query result in cache', 'yii\db\Command::query');
        }

3. in /local/www/board.orsk.ru/vendor/yiisoft/yii2/db/Command.php – yii\db\Command::queryInternal('fetchColumn', 0) at line 376

370371372373374375376377378379380381382

     * @return string|null|boolean 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);
        } else {
            return $result;
        }
    }

4. in /local/www/board.orsk.ru/common/models/BoardPartner.php – yii\db\Command::queryScalar() at line 166

160161162163164165166167168169170171172

            )->queryColumn();
            $query_category=' AND user_id IN ('.implode(',',$users_partner).') ';
        }
 
        $data=[];
        $data['pages'] = new Pagination([
            'totalCount' => \Yii::$app->getDb()->createCommand('SELECT count(id) FROM '.self::tableName().' WHERE sys_domain='.\Yii::$app->params['domain_id'].' AND active=1 AND shop=1 '.$query_category)->queryScalar(),
            'pageSize' => 10
        ]);
        $data['shops']=Yii::$app->getDb()->createCommand(
            'SELECT a.*, (select count(id) from b_board_ads  WHERE sys_user_id=a.user_id AND moder_state=1 AND ads_ispartner=1 AND sys_domain='.\Yii::$app->params['domain_id'].' ) as countAds '
            .'FROM '.self::tableName().' a '
            .'WHERE a.sys_domain='.\Yii::$app->params['domain_id'].' AND a.active=1 AND a.shop=1 '.$query_category

5. in /local/www/board.orsk.ru/pda/controllers/ShopController.php – common\models\BoardPartner::getShops(67) at line 15

9101112131415161718192021

{
    public function actionIndex()
    {
        $category_id=(int)\Yii::$app->request->get('category_id',0);
        return $this->render('index',[
            'category_id'=>$category_id,
            'data'=>BoardPartner::getShops($category_id)
        ]);
    }
 
    public function actionView($id){
        $category_id=(int)\Yii::$app->request->get('category_id',0);
        $shop=BoardPartner::getShop($id);

My ERROR

Database Exception – yii\db\Exception

Caused by: 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 ')' at line 1