Log Messages

ทั้งหมด 5 ผลลัพธ์

Time	Level	Category	Message

10:25:14.256	info	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=dohdashboard
10:25:14.257	info	yii\db\Command::query	select * from kpi_hdc k left join kpi_template i on i.id=k.kpi_template_id left join kpi_template_to_year y on y.kpi_template_id=k.kpi_template_id where y.year='2019' and k.kpi_template_id='42'
10:25:14.258	info	yii\db\Command::query	SELECT regioncode,changwatname FROM cchangwat WHERE changwatcode='21'
10:25:14.258	info	yii\db\Command::query	SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(A.ampurcodefull,"TOTAL") as areacode, A.ampurname as areaname, MAX(K.date_com) AS report_date, SUM(K.target) as target, (SUM(K.target)-SUM(K.result)) as result, SUM(K.total) as total, ROUND((SUM(IFNULL(K.target,0))-SUM(IFNULL(K.result,0)))/SUM(IFNULL(K.target,0))*100,2 ) as total_ratio, MAX(K.date_com) as date_com FROM s_kpi_dental38 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN campur a ON a.ampurcodefull=LEFT(K.areacode,4) WHERE K.id = '35652a40027c24bbc3653428d3577b72' AND K.b_year = 2562 AND LEFT(K.areacode,2) = '21' GROUP BY A.ampurcodefull WITH ROLLUP) X
10:25:14.576	error	yii\db\Exception	PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'A.ampurcodefull' in 'field list' in /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php:1258 Stack trace: #0 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(1258): PDOStatement->execute() #1 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute() #2 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal() #3 /var/www/html/pi.dashboard/frontend/modules/dashboard/controllers/DentalcariesfreeController.php(82): yii\db\Command->queryAll() #4 /var/www/html/pi.dashboard/frontend/modules/dashboard/controllers/DentalcariesfreeController.php(405): frontend\modules\dashboard\controllers\DentalcariesfreeController->getSqlQueryData() #5 [internal function]: frontend\modules\dashboard\controllers\DentalcariesfreeController->actionAmpur() #6 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #7 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams() #8 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction() #9 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #10 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest() #11 /var/www/html/pi.dashboard/frontend/web/index.php(22): yii\base\Application->run() #12 {main} Next yii\db\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'A.ampurcodefull' in 'field list' The SQL being executed was: SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(A.ampurcodefull,"TOTAL") as areacode, A.ampurname as areaname, MAX(K.date_com) AS report_date, SUM(K.target) as target, (SUM(K.target)-SUM(K.result)) as result, SUM(K.total) as total, ROUND((SUM(IFNULL(K.target,0))-SUM(IFNULL(K.result,0)))/SUM(IFNULL(K.target,0))*100,2 ) as total_ratio, MAX(K.date_com) as date_com FROM s_kpi_dental38 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN campur a ON a.ampurcodefull=LEFT(K.areacode,4) WHERE K.id = '35652a40027c24bbc3653428d3577b72' AND K.b_year = 2562 AND LEFT(K.areacode,2) = '21' GROUP BY A.ampurcodefull WITH ROLLUP) X in /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Schema.php:664 Stack trace: #0 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException() #1 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute() #2 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal() #3 /var/www/html/pi.dashboard/frontend/modules/dashboard/controllers/DentalcariesfreeController.php(82): yii\db\Command->queryAll() #4 /var/www/html/pi.dashboard/frontend/modules/dashboard/controllers/DentalcariesfreeController.php(405): frontend\modules\dashboard\controllers\DentalcariesfreeController->getSqlQueryData() #5 [internal function]: frontend\modules\dashboard\controllers\DentalcariesfreeController->actionAmpur() #6 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #7 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams() #8 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction() #9 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #10 /var/www/html/pi.dashboard/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest() #11 /var/www/html/pi.dashboard/frontend/web/index.php(22): yii\base\Application->run() #12 {main} Additional Information: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'A.ampurcodefull' in 'field list' )