‌020 7290 710 asiakaspalvelu@premises.fi
Select Page
Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND text_key = 'floor'' at line 1 The SQL being executed was: SELECT text_value FROM tbl_stg_realty_text WHERE cust_itemcode = AND text_key = 'floor'' in /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/db/Schema.php:664 Stack trace: #0 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'SELECT text_val...') #1 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute('SELECT text_val...') #2 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL) #3 /var/www/premises-fi/hakuri/frontend/controllers/RealtySearchController.php(237): yii\db\Command->queryAll() #4 [internal function]: frontend\controllers\RealtySearchController->actionView('2774') #5 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array) #6 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array) #7 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('view', Array) #8 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('realty-search/v...', Array) #9 /var/www/premises-fi/hakuri/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 /var/www/premises-fi/wp-content/themes/divi-child/hakuri.php(31): yii\base\Application->run() #11 /var/www/premises-fi/wp-includes/template-loader.php(78): include('/var/www/premis...') #12 /var/www/premises-fi/wp-blog-header.php(19): require_once('/var/www/premis...') #13 /var/www/premises-fi/index.php(17): require('/var/www/premis...') #14 {main}