Exception

Database Exceptionyii\db\Exception

  • 1. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Connection.php at line 549
    540541542543544545546547548549550551552553554555556557558
            $token = 'Opening DB connection: ' . $this->dsn;
            try {
                Yii::info($token, __METHOD__);
                Yii::beginProfile($token, __METHOD__);
                $this->pdo = $this->createPdoInstance();
                $this->initConnection();
                Yii::endProfile($token, __METHOD__);
            } catch (\PDOException $e) {
                Yii::endProfile($token, __METHOD__);
                throw new Exception($e->getMessage(), $e->errorInfo, (int) $e->getCode(), $e);
            }
        }
     
        /**
         * Closes the currently active DB connection.
         * It does nothing if the connection is already closed.
         */
        public function close()
        {
    
  • 2. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Connection.php at line 863 yii\db\Connection::open()
    857858859860861862863864865866867868869
         * Returns the PDO instance for the currently active master connection.
         * This method will open the master DB connection and then return [[pdo]].
         * @return PDO the PDO instance for the currently active master connection.
         */
        public function getMasterPdo()
        {
            $this->open();
            return $this->pdo;
        }
     
        /**
         * Returns the currently active slave connection.
         * If this method is called the first time, it will try to open a slave connection when [[enableSlaves]] is true.
    
  • 3. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Connection.php at line 850 yii\db\Connection::getMasterPdo()
    844845846847848849850851852853854855856
         * is available and `$fallbackToMaster` is false.
         */
        public function getSlavePdo($fallbackToMaster = true)
        {
            $db = $this->getSlave(false);
            if ($db === null) {
                return $fallbackToMaster ? $this->getMasterPdo() : null;
            } else {
                return $db->pdo;
            }
        }
     
        /**
    
  • 4. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Command.php at line 219 yii\db\Connection::getSlavePdo()
    213214215216217218219220221222223224225
     
            if ($this->db->getTransaction()) {
                // master is in a transaction. use the same connection.
                $forRead = false;
            }
            if ($forRead || $forRead === null && $this->db->getSchema()->isReadQuery($sql)) {
                $pdo = $this->db->getSlavePdo();
            } else {
                $pdo = $this->db->getMasterPdo();
            }
     
            try {
                $this->pdoStatement = $pdo->prepare($sql);
    
  • 5. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Command.php at line 894 yii\db\Command::prepare(true)
    888889890891892893894895896897898899900
                        Yii::trace('Query result served from cache', 'yii\db\Command::query');
                        return $result[0];
                    }
                }
            }
     
            $this->prepare(true);
     
            $token = $rawSql;
            try {
                Yii::beginProfile($token, 'yii\db\Command::query');
     
                $this->pdoStatement->execute();
    
  • 6. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Command.php at line 388 yii\db\Command::queryInternal('fetchColumn', 0)
    382383384385386387388389390391392393394
         * @return string|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);
            } else {
                return $result;
            }
        }
    
  • 7. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Query.php at line 396 yii\db\Command::queryScalar()
    390391392393394395396397398399400401402
     
            $this->select = $select;
            $this->limit = $limit;
            $this->offset = $offset;
     
            if (empty($this->groupBy) && empty($this->having) && empty($this->union) && !$this->distinct) {
                return $command->queryScalar();
            } else {
                return (new Query)->select([$selectExpression])
                    ->from(['c' => $this])
                    ->createCommand($command->db)
                    ->queryScalar();
            }
    
  • 8. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\ActiveQuery.php at line 334 yii\db\Query::queryScalar('COUNT(*)', null)
    328329330331332333334335336337338339340
        /**
         * @inheritdoc
         */
        protected function queryScalar($selectExpression, $db)
        {
            if ($this->sql === null) {
                return parent::queryScalar($selectExpression, $db);
            }
            /* @var $modelClass ActiveRecord */
            $modelClass = $this->modelClass;
            if ($db === null) {
                $db = $modelClass::getDb();
            }
    
  • 9. in D:\Apache24\htdocs\vendor\yiisoft\yii2\db\Query.php at line 303 yii\db\ActiveQuery::queryScalar('COUNT(*)', null)
    297298299300301302303304305306307308309
         * If this parameter is not given (or null), the `db` application component will be used.
         * @return integer|string number of records. The result may be a string depending on the
         * underlying database engine and to support integer values higher than a 32bit PHP integer can handle.
         */
        public function count($q = '*', $db = null)
        {
            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.
    
  • 10. in D:\Apache24\htdocs\controllers\CustomerCaseController.php at line 20 yii\db\Query::count()
    14151617181920212223242526
    	{
    		Yii::$app->params['navBarMark']['case-content'] = 1;
     
    // 		$model_case = CustomerCase::find()->all();
    		$model_case = new CustomerCase();
    		if($nav == null){
    			$model_count = $model_case->find()->count();
    		}else{
    			$model_count = $model_case->find()->where(['nav_id'=>$nav])->count();
    		}
    // 		$model_count = $model_case->find()->where(['nav_id'=>$nav])->count();
    		$data['pages'] = new Pagination(['totalCount' => $model_count]);
    		$data['pages']->defaultPageSize = 12;
    
  • 11. app\controllers\CustomerCaseController::actionIndex(null)
  • 12. in D:\Apache24\htdocs\vendor\yiisoft\yii2\base\InlineAction.php at line 55 – call_user_func_array([app\controllers\CustomerCaseController, 'actionIndex'], [null])
    495051525354555657
            $args = $this->controller->bindActionParams($this, $params);
            Yii::trace('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);
        }
    }
    
  • 13. in D:\Apache24\htdocs\vendor\yiisoft\yii2\base\Controller.php at line 154 yii\base\InlineAction::runWithParams([])
    148149150151152153154155156157158159160
            }
     
            $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 */
    
  • 14. in D:\Apache24\htdocs\vendor\yiisoft\yii2\base\Module.php at line 454 yii\base\Controller::runAction('index', [])
    448449450451452453454455456457458459460
            $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;
            } else {
    
  • 15. in D:\Apache24\htdocs\vendor\yiisoft\yii2\web\Application.php at line 100 yii\base\Module::runAction('customer-case/index', [])
    949596979899100101102103104105106
                $params = $this->catchAll;
                unset($params[0]);
            }
            try {
                Yii::trace("Route requested: '$route'", __METHOD__);
                $this->requestedRoute = $route;
                $result = $this->runAction($route, $params);
                if ($result instanceof Response) {
                    return $result;
                } else {
                    $response = $this->getResponse();
                    if ($result !== null) {
                        $response->data = $result;
    
  • 16. in D:\Apache24\htdocs\vendor\yiisoft\yii2\base\Application.php at line 375 yii\web\Application::handleRequest(yii\web\Request)
    369370371372373374375376377378379380381
            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();
    
  • 17. in D:\Apache24\htdocs\web\index.php at line 12 yii\base\Application::run()
    6789101112
     
    require(__DIR__ . '/../vendor/autoload.php');
    require(__DIR__ . '/../vendor/yiisoft/yii2/Yii.php');
     
    $config = require(__DIR__ . '/../config/web.php');
     
    (new yii\web\Application($config))->run();
    
  •