Bug #26624: Query for workspace stages in Tx_Workspaces_Service_Stages->getStagesForWS() quotes values in a way that's incompatible with DBAL and Oracle - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #26624

closed

Query for workspace stages in Tx_Workspaces_Service_Stages->getStagesForWS() quotes values in a way that's incompatible with DBAL and Oracle

Added by Lucas Thurston about 13 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Category:

Workspaces

Target version:

Start date:

2011-05-05

Due date:

% Done:

Estimated time:

TYPO3 Version:

4.5

PHP Version:

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

The call $GLOBALS['TYPO3_DB']->exec_SELECTgetRows() that fetches the workspace stages wraps double quotes around a value in the WHERE clause. DBAL fails to convert this to valid Oracle SQL, so, for instance, the custom stages don't appear in the "Choose action" select menu at the bottom of the Workspaces module.

By changing these to single quotes, the query works as expected.

I have a patch and will submit to Gerrit presently.