Что такое database exception возникла внутренняя ошибка сервера

Подскажите пожалуйста откуда могут быть проблемы
Yii2 на локалхосте всё работает, в вот на сервере

Database Exception (#42)

Возникла внутренняя ошибка сервера.
Во время обработки запроса произошла ошибка.

concentum писал(а):Большое спасибо!!! nepster
РЕГИСТР СИМВОЛОВ в названии таблицы в модели, кто бы мог подумать

А как такое могло произойти?
Если создавать таблицы через миграции и генерировать модели, через GII, то такого не должно произсодить.

asked Dec 3, 2016 at 6:08

answered Dec 3, 2016 at 7:42

answered Feb 17, 2022 at 16:10

I use ubuntu 16.04.
PHP Version 7.0.4-7ubuntu2.
Apache/2.4.18 (Ubuntu) .
PHP extension: mysqli (in phpmyadmin Written).

I got Upgrade my ubuntu from 15.10 to 16.04 and I have this error:

My project correctly run in my server but I can’t run that in my os:

Database Exception – yiidbException
SQLSTATE[HY000] [2002] No such file or directory
↵
Caused by: PDOException
SQLSTATE[HY000] [2002] No such file or directory

in /var/www/html/iicitySite/vendor/yiisoft/yii2/db/Connection.php at line 579

For MAMP users solution is

'components' => [
    'db' => [
        'class' => 'yiidbConnection',
        'dsn' => 'mysql:host=localhost;port=8889;dbname=mydbname;unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock',
        'username' => 'myuser',
        'password' => 'mypassword',
        'charset' => 'utf8',
    ],
],

answered Sep 10, 2017 at 10:55

Hope this answer will help You:

Change the Host name from localhost to 127.0.0.1

This is inside backendcommonconfigmain-local.php

Now you run php yii migrate .

Hope, It will successfully create the tables in Database

answered Aug 9, 2016 at 12:54

I had this same problem too. Changing localhost didn’t solve my problem. Instead, add your db port like this:

'dsn'=>'mysql:host=localhost:3307;dbname=geep'

I’m running on MAMP environment and works well using 2 solutions above

1. change localhost to 127.0.0.1
2. remain as localhost and define mysql port even default port been used (localhost:3306)

answered Sep 7, 2018 at 1:17

For PHP 7.2.24-0ubuntu0.18.04.3,

• Get mysql socket path
• add socket info to the database config of yii2

To get the socket path login to the mysql and perform following steps

• Open Terminal and perform following steps

  mysql -u root -p
  mysql> show variables like '%sock%';
  +-----------------------------------------+------------------------------------------------------+
  | Variable_name                           | Value                                                |
  +-----------------------------------------+------------------------------------------------------+
  | mysqlx_socket                           | /tmp/mysqlx.sock                                     |
  | performance_schema_max_socket_classes   | 10                                                   |
  | performance_schema_max_socket_instances | -1                                                   |
  | socket                                  | /opt/packages/lampstack-7.3.9-0/mysql/tmp/mysql.sock |
  +-----------------------------------------+------------------------------------------------------+
  4 rows in set (0.00 sec)
  exit
  

• Next add following config information

  'class' => 'yiidbConnection',
  'dsn' => 'mysql:unix_socket=/opt/packages/lampstack-7.3.9-0/mysql/tmp/mysql.sock;dbname=basketmantra',
  'username' => 'root',
  'password' => 'root123',
  'charset' => 'utf8',
  

I hope this helps

In Some cases you may use httpd or apache or lampp then also make sure to check php and mysql commands in terminal are same as versions web servers are using.

phpinfo() in web server is helpful to find out the versions web server is using

    <?php
        phpinfo();
    ?>

For commands

    $ type php
    php is hashed (/usr/bin/php)

    $ type mysql
    mysql is /opt/packages/lampstack-7.3.9-0/mysql/bin/mysql

answered Mar 21, 2020 at 13:50

Using yii2, my solution is to comment codes in common/main-local.php
For some reason, yii2 try to get main-local.php in production instead of main.php in the folder common, but when is commented it works (get DB configs on common/main.php

<?php
// common/main-local.php
return [
 /*  'components' => [
       'db' => [
           'class' => 'yiidbConnection',
           'dsn' => 'mysql:host=172.17.0.2;dbname=ememariadb',
           'username' => 'dbsenha',
           'password' => 'dbUser',
           'charset' => 'utf8',
       ],
   ],*/
];

answered Jun 11, 2021 at 16:08

In my case I have my setup running in Docker. I had the same error message and had to run the migrate command inside docker.

docker exec -it <container ID> bash
cd app
php yii migrate

answered Mar 4 at 14:33