Why in Yii the model does not see the table in the database?

Question

MySQL

After the transfer to the server, the following situation periodically occurs:
The table "{{user}}" for active record class "User" cannot be found in the database.
Moreover, this occurs only sometimes, sometimes more often, sometimes less often and only on the server, there are no problems in the local version. There is a table in the database, there is no error in the title.
The project uses the Smarty template engine.

Answer 1

As far as I remember, bracket-syntax for table names is only enabled when tablePrefix is ​​present.
If you don't have a database table prefix, remove the brackets.

Answer 2

A similar error fell when there were problems connecting to the database.

Answer 3

set schema caching when connecting to the
database like this
```php
'components' => [
// ...
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql :host=localhost;dbname=my_table',
'username' => 'root',
'password' => 'password',
'charset' => 'utf8',
'tablePrefix' => 'tbl_',
// turn on schema caching to improve performance
'schemaCache' => 'db_cache', // Which engine will cache
'schemaCacheDuration' => 3600, // Cache time
'enableSchemaCache' => true, // Enable db table schema caching
],
// ...
],
```