Project

General

Profile

Actions

Bug #45825

closed

Problems with Install Tool and PostgreSQL

Added by Gerald Buttinger over 11 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Should have
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

Also available in: Atom PDF