Database Exception – yii\db\Exception
Настройки конфига:SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "tbl_products" does not exist
LINE 1: SELECT COUNT(*) FROM "tbl_products" INNER JOIN "tbl_products...
^
The SQL being executed was: SELECT COUNT(*) FROM "tbl_products" INNER JOIN "tbl_products_to_category" ON tbl_products.id = tbl_products_to_category.id WHERE ("status"=1) AND ("category"=8)
Error Info: Array
(
[0] => 42P01
[1] => 7
[2] => ERROR: relation "tbl_products" does not exist
LINE 1: SELECT COUNT(*) FROM "tbl_products" INNER JOIN "tbl_products...
^
)
↵
Caused by:PDOException
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "tbl_products" does not exist
LINE 1: SELECT COUNT(*) FROM "tbl_products" INNER JOIN "tbl_products...
^
Код: Выделить всё
'dsn' => 'pgsql:host=localhost;port=5432;dbname=db1',
'username' => '..',
'password' => '..',
'charset' => 'utf8',
'schemaMap' => [
'pgsql'=> [
'class'=>'yii\db\pgsql\Schema',
'defaultSchema' => 'db1' //specify your schema here
]
],