Issue Bug Closed

#78250Database analyzer can't create table with dbal in native mode

Nicole Hummel 10/11/16, 21:54 updated 10/02/18, 11:06

Description

Following steps should be necessary to reproduce the problem:

1) activate dbal
2) install news extension

expected result:
news should be installed and database tables should be generated

actual result:
no tables are generated

Go to Install Tool and run the database analyzer. it will show the necessary tables for news. Trying to execute those gives error message “Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘C’ at line 1”.

After having a look into dbal I found the problem. \TYPO3\CMS\Dbal\Database\DatabaseConnection::admin_query expects the CREATETABLE type to return an array. Instead a string was return but $string0 was taken as sql query.

Reviews 1