Issue Bug Closed

#45825Problems with Install Tool and PostgreSQL

Gerald Buttinger 02/25/13, 15:28 updated 07/27/15, 08:11

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.