DataObjectManager
DataObjectManager copied to clipboard
ManyManyDataObjectManager Join ambiguous error
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')";