Exception

Database Exceptionyii\db\Exception

SQLSTATE[HY000]: General error: 1722 OCIStmtExecute: ORA-01722: invalid number
(/root/php-5.5.38/ext/pdo_oci/oci_statement.c:148)
The SQL being executed was: SELECT * FROM "T_WEBSITE_MODULES" WHERE ("TYPE_FLAG"=2) AND ("ID"='1616/en')

Error Info: Array
(
    [0] => HY000
    [1] => 1722
    [2] => OCIStmtExecute: ORA-01722: invalid number
 (/root/php-5.5.38/ext/pdo_oci/oci_statement.c:148)
)
  • 1. in /web/www/default/vendor/yiisoft/yii2/db/Schema.php at line 628
    619620621622623624625626627628629630631632633634635636637
     
            $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 /web/www/default/vendor/yiisoft/yii2/db/Command.php at line 852 yii\db\Schema::convertException(PDOException, 'SELECT * FROM "T_WEBSITE_MODULES...')
    846847848849850851852853854855856857858
                    $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 /web/www/default/vendor/yiisoft/yii2/db/Command.php at line 373 yii\db\Command::queryInternal('fetch', null)
    367368369370371372373374375376377378379
         * @return array|boolean the first row (in terms of an array) of the query result. False is returned if the query
         * results in nothing.
         * @throws Exception execution failed
         */
        public function queryOne($fetchMode = null)
        {
            return $this->queryInternal('fetch', $fetchMode);
        }
     
        /**
         * Executes the SQL statement and returns the value of the first column in the first row of data.
         * This method is best used when only a single value is needed for a query.
         * @return string|null|boolean the value of the first column in the first row of the query result.
    
  • 4. in /web/www/default/vendor/yiisoft/yii2/db/Query.php at line 243 yii\db\Command::queryOne()
    237238239240241242243244245246247248249
         * If this parameter is not given, the `db` application component will be used.
         * @return array|boolean the first row (in terms of an array) of the query result. False is returned if the query
         * results in nothing.
         */
        public function one($db = null)
        {
            return $this->createCommand($db)->queryOne();
        }
     
        /**
         * Returns the query result as a scalar value.
         * The value returned will be the first column in the first row of the query results.
         * @param Connection $db the database connection used to generate the SQL statement.
    
  • 5. in /web/www/default/vendor/yiisoft/yii2/db/ActiveQuery.php at line 300 yii\db\Query::one(null)
    294295296297298299300301302303304305306
         * @return ActiveRecord|array|null a single row of query result. Depending on the setting of [[asArray]],
         * the query result may be either an array or an ActiveRecord object. Null will be returned
         * if the query results in nothing.
         */
        public function one($db = null)
        {
            $row = parent::one($db);
            if ($row !== false) {
                $models = $this->populate([$row]);
                return reset($models) ?: null;
            } else {
                return null;
            }
    
  • 6. in /web/www/default/frontend/controllers/ReportController.php at line 385 yii\db\ActiveQuery::one()
    379380381382383384385386387388389390391
    		}
    		$leftlist=$this->leftmenu($pid);
     
    		//print_r($leftlist);exit;
    		$list=Yii::$app->user->getOneRightReportList($id);
    		$discountList = DiscountPolicy::getAllPolicy();
    		$model=WebsiteModules::find()->where(['TYPE_FLAG'=>$type,'ID'=>$id])->one();
    				if(empty($model))
    			return $this->redirect(['ztyj']);
    		$reportfirst=Reports::find()->where(['WSM_ID'=>$id])->orderBy('DATELINE')->one();
    		if($list)
    		$html=$this->renderPartial('dwlist',['res'=>$list,'model'=>$model]);
    	    else
    
  • 7. frontend\controllers\ReportController::actionZtyj('1616/en')
  • 8. in /web/www/default/vendor/yiisoft/yii2/base/InlineAction.php at line 55 – call_user_func_array([frontend\controllers\ReportController, 'actionZtyj'], ['1616/en'])
    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);
        }
    }
    
  • 9. in /web/www/default/vendor/yiisoft/yii2/base/Controller.php at line 151 yii\base\InlineAction::runWithParams(['id' => '1616/en'])
    145146147148149150151152153154155156157
            }
     
            $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 */
    
  • 10. in /web/www/default/vendor/yiisoft/yii2/base/Module.php at line 455 yii\base\Controller::runAction('ztyj', ['id' => '1616/en'])
    449450451452453454455456457458459460461
            $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);
                Yii::$app->controller = $oldController;
     
                return $result;
            } else {
                $id = $this->getUniqueId();
                throw new InvalidRouteException('Unable to resolve the request "' . ($id === '' ? $route : $id . '/' . $route) . '".');
    
  • 11. in /web/www/default/vendor/yiisoft/yii2/web/Application.php at line 84 yii\base\Module::runAction('report/ztyj', ['id' => '1616/en'])
    78798081828384858687888990
                $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;
    
  • 12. in /web/www/default/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();
    
  • 13. in /web/www/default/frontend/web/index.php at line 124 yii\base\Application::run()
    118119120121122123124
                    $config['components']['urlManager']['rules']['<controller:(largedata)>/<action:(index)>/<id:\d+>']='<controller>/<action>';
                    $config['components']['urlManager']['rules']['<controller:(largedata)>/<action:(view)>/<id:\d+>/<inframe:\d+>/<num:\d+>']='<controller>/<action>';
                    $config['components']['urlManager']['rules']['<controller:(largedata)>/<action:(view)>/<id:\d+>']='<controller>/<action>';
                    $config['components']['urlManager']['rules']['<controller:(pts)>/<action:(index)>/<id:\d+>']='<controller>/<action>';
                }
    $application = new yii\web\Application($config);
    $application->run();
    
  • $_GET = [
        'id' => '1616/en',
    ];
    
    $_SERVER = [
        'REDIRECT_REDIRECT_STATUS' => '200',
        'REDIRECT_STATUS' => '200',
        'HTTP_CONNECTION' => 'Keep-Alive',
        'HTTP_ACCEPT' => '*/*',
        'HTTP_ACCEPT_ENCODING' => 'deflate, gzip',
        'HTTP_HOST' => 'www.sxcoal.com',
        'HTTP_MAX_FORWARDS' => '10',
        'HTTP_USER_AGENT' => 'Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)',
        'HTTP_X_FORWARDED_PROTO' => 'http',
        'HTTP_X_FORWARDED_PORT' => '80',
        'HTTP_X_ORIGINAL_HOST' => 'www.sxcoal.com',
        'HTTP_X_ORIGINAL_URL' => '/report/ztyj?id=1616/en',
        'HTTP_X_FORWARDED_FOR' => '154.213.180.21:20002',
        'HTTP_X_ARR_LOG_ID' => '7482e026-2384-4d85-827a-b6376b638736',
        'PATH' => '/sbin:/usr/sbin:/bin:/usr/bin',
        'LD_LIBRARY_PATH' => '/web/websrc/apache/lib:/web/websrc/openssl/lib',
        'SERVER_SIGNATURE' => '',
        'SERVER_SOFTWARE' => 'Apache',
        'SERVER_NAME' => 'www.sxcoal.com',
        'SERVER_ADDR' => '10.0.0.10',
        'SERVER_PORT' => '80',
        'REMOTE_ADDR' => '10.0.0.212',
        'DOCUMENT_ROOT' => '/web/www/default',
        'REQUEST_SCHEME' => 'http',
        'CONTEXT_PREFIX' => '',
        'CONTEXT_DOCUMENT_ROOT' => '/web/www/default',
        'SERVER_ADMIN' => 'admin@linuxeye.com',
        'SCRIPT_FILENAME' => '/web/www/default/frontend/web/index.php',
        'REMOTE_PORT' => '19346',
        'REDIRECT_URL' => '/frontend/web/report/ztyj',
        'REDIRECT_QUERY_STRING' => 'id=1616/en',
        'GATEWAY_INTERFACE' => 'CGI/1.1',
        'SERVER_PROTOCOL' => 'HTTP/1.1',
        'REQUEST_METHOD' => 'GET',
        'QUERY_STRING' => 'id=1616/en',
        'REQUEST_URI' => '/report/ztyj?id=1616/en',
        'SCRIPT_NAME' => '/frontend/web/index.php',
        'PHP_SELF' => '/frontend/web/index.php',
        'REQUEST_TIME_FLOAT' => 1566325074.0910001,
        'REQUEST_TIME' => 1566325074,
    ];