Project

General

Profile

Actions

Bug #21555

closed

Powermail-related: RIGHT OUTER JOIN is not supported

Added by Xavier Perseguers over 14 years ago. Updated about 14 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2009-11-15
Due date:
% Done:

0%

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

Description

After installing powermail and going to page > create content element > regular text element:

DBAL fatal error: No handler found in handler_getFromTableList() for: "(tx_powermail_fieldsets RIGHT JOIN tt_content ON tx_powermail_fieldsets.tt_content = tt_content.uid) LEFT JOIN tx_powermail_fields ON tx_powermail_fieldsets.uid = tx_powermail_fields.fieldset" (SQL engine parse ERROR: No table name found as expected in parseFromTables()!: near "(tx_powermail_fieldsets RIGHT JOIN tt_content ON t")

Information reported by Ries over Skype
(issue imported from #M12596)


Files

12596_dbal.diff (3.08 KB) 12596_dbal.diff Administrator Admin, 2009-11-15 16:06
Actions #1

Updated by Xavier Perseguers over 14 years ago

Parentheses around the first join are not needed and bug DBAL parser, they should be removed, I prepare another patch for that issue

Actions #2

Updated by Xavier Perseguers over 14 years ago

Patch is attached to related bug entry on Powermail's bugtracker: http://forge.typo3.org/issues/show/5371

Actions #3

Updated by Xavier Perseguers over 14 years ago

DBAL part of the bug is resolved and commited to DBAL-trunk as changeset 26547.

Please refer to Powermail's bugtracker for corresponding patch status

Actions #4

Updated by Xavier Perseguers about 14 years ago

Powermail patch has been committed too.

Actions

Also available in: Atom PDF