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

[warayutpetch]

[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]

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]

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