DataObjectManager icon indicating copy to clipboard operation
DataObjectManager copied to clipboard

ManyManyDataObjectManager Join ambiguous error

Open PatrickElsing opened this issue 13 years ago • 0 comments

When use the ManyManyDataObjectManager and add a join clause it can occur an ambigous mysql error. To prevent this error, change Line 63 in code/ManyManyDataObjectManager.php

From: $this->sourceJoin .= " LEFT JOIN "$manyManyTable" ON ("$source"."ID" = "{$sourceField}ID" AND "$manyManyTable"."{$this->manyManyParentClass}ID" = '$parentID')";

To: $this->sourceJoin .= " LEFT JOIN "$manyManyTable" ON ("$source"."ID" = "$manyManyTable"."{$sourceField}ID" AND "$manyManyTable"."{$this->manyManyParentClass}ID" = '$parentID')";

PatrickElsing avatar Jan 23 '12 14:01 PatrickElsing