Why getting SQLSTATE[42S22] error on deploy

Question

I have just finished my Symfony 7 project, and it runs fine on my PC with XAMPP. Now I've deployed it on my webserver, created the database, and have tried to run the doctrine migration in the shell. When I do so, I get the following errors:

In ExceptionConverter.php line 67:

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i_c.TABLE_NAME' in 'where clause'


In Exception.php line 28:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i_c.TABLE_NAME' in
  'where clause'


In Statement.php line 130:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i_c.TABLE_NAME' in
  'where clause'

I dont understand the problem, particularly because I don't have the column i_c.TABLE_NAME. Additionally, if I export all tables from my local database, everything works fine, although this error still shows up when I run the command php bin/console doctrine:schema:validate. Specifically, it says that the mapping files are correct, but throws this error again.

Answer 1

I changed the version in the .env MariaDB, and now it works.