Bug #78250

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

Added by Nicole Cordes over 4 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2016-10-11
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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.


Related issues

Related to TYPO3 Core - Task #68401: Consolidate SqlParser.phpClosedMorton Jonuschat2015-07-20

Actions

Also available in: Atom PDF