Actions
Bug #45825
closedProblems with Install Tool and PostgreSQL
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2013-02-25
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.0
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
I have identified the following two problem with using the Typo3 Install Tool with Postgres:
1. in "typo3\sysext\install\Classes\CoreUpdates\AddFlexFormsToAclUpdate.php lines 102-103 look like this:
$where = 'deleted = 0 AND non_exclude_fields IS NOT NULL AND non_exclude_fields != ""'; $where .= ' AND (tables_select LIKE "%' . $search . '%" OR tables_modify LIKE "%' . $search . '%")';
in postgres strings should be wrapped in single-quotes and not double quotes. so these lines should look like this:
$where = "deleted = 0 AND non_exclude_fields IS NOT NULL AND non_exclude_fields != ''"; $where .= " AND (tables_select LIKE '%" . $search . "%' OR tables_modify LIKE '%" . $search . "%')";
2. a second problem lies with line 100 in the file typo3\sysext\install\Classes\Updates\TtContentUploadsUpdateWizard.php
this line reads:
$notMigratedRowsCount = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', 'tt_content', 'media <> \'\' AND CAST(CAST(media AS DECIMAL) AS CHAR) <> media OR (CType = \'uploads\' AND select_key != \'\')');
the resulting statement leads to an uncaught typo3 exception:
Uncaught TYPO3 Exception #1310027511: Could not parse where clause (More information) InvalidArgumentException thrown in file .../typo3/sysext/dbal/Classes/Database/DatabaseConnection.php in line 1680.
unfortunately i wasn't able to find out the exact reason for this second problem and wasn't able to solve it.
Actions