Project

General

Profile

Actions
Copy link

Bug #15487

closed

exec_SELECT_mm_query -> whereClause is added without an 'AND'

Added by Wolfgang Neider almost 19 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Wolfgang Klinger
Category:
-
Target version:
-
Start date:
2006-01-23
Due date:
% Done:

0%

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

Description

The "whereClause" for the exec_SELECT_mm_query is added in the function without an 'AND'. So mysql produces an error because there are already "where"-statements associating the local and the foreign table.

Select produced from exec_SELECT_mm_query with where-clause
SELECT tx_iflowgallery_description.filename,
tx_iflowgallery_description.image_description, tx_iflowgallery_imagecategories.catname
FROM tx_iflowgallery_description,tx_iflowgallery_description_catname_mm,tx_iflowgallery_imagecategories
WHERE
tx_iflowgallery_description.uid=tx_iflowgallery_description_catname_mm.uid_local AND tx_iflowgallery_imagecategories.uid=tx_iflowgallery_description_catname_mm.uid_foreign tx_iflowgallery_description.filename='Blaue Berge.jpg' tx_iflowgallery_imagecategories.catname='Normal'
(issue imported from #M2364)

Actions
Copy link

Also available in: Atom PDF