search

jeboehm / docker-mailserver

Docker Mailserver based on the famous ISPMail guide
MIT License
363 stars 97 forks source link

Base table or view not found: 1109 Unknown table 'CHECK_CONSTRAINTS' #313

Open warayutpetch opened 1 month ago

warayutpetch commented 1 month ago 
[critical] Error thrown while running command "doctrine:migrations:migrate -n". Message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_CONSTRAINTS' in information_schema"

In ExceptionConverter.php line 91:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1109 Unknown table 'CHECK_CONSTRAINTS' in information_sc
  hema

In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_CO
  NSTRAINTS' in information_schema

In Statement.php line 55:

  SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_CO
  NSTRAINTS' in information_schema

doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]

test external database in centos 7 mariadb 5.5 and '11.4.3-MariaDB' same issue

jeboehm commented 4 weeks ago

Could you try to add the following environment variable to the web container please? DATABASE_URL="mysql://%env(MYSQL_USER)%:%env(MYSQL_PASSWORD)%@%env(MYSQL_HOST)%:%env(MYSQL_PORT)%/%env(MYSQL_DATABASE)%"

warayutpetch commented 4 weeks ago

Could you try to add the following environment variable to the web container please? DATABASE_URL="mysql://%env(MYSQL_USER)%:%env(MYSQL_PASSWORD)%@%env(MYSQL_HOST)%:%env(MYSQL_PORT)%/%env(MYSQL_DATABASE)%"

add DATABASE_URL to .env file inproject

problem solved