Issue Bug Closed

#15487exec_SELECT_mm_query -> whereClause is added without an 'AND'

Wolfgang Neider 01/23/06, 15:16 updated 08/12/06, 14:21

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)

Reviews 0

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