[Vtigercrm-developers] using getRelatedModuleRecordIds()

Alan Lord alanslists at gmail.com
Wed May 6 15:41:09 GMT 2015


Can one of the devs tell me why this isn't working?

My $recordModel is defined and has an id.

> $data = array('record' => $recordModel->getId(), 'module' => 'LSContracts', 'related_modules' => array('LSMeters'));
> $request = new Vtiger_Request($data, $data);
> $meterids = $recordModel->getModule()->getRelatedModuleRecordIds($request, array($recordModel->getId()));

The function isn't getting the tables for the query for some reason:

> PearDatabase ->ADODB error  Query Failed:SELECT vtiger_crmentity.crmid FROM vtiger_crmentity INNER JOIN  ON . = vtiger_crmentity.crmid
> WHERE . IN (?)::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON . = vtiger_crmentity.crmid
> WHERE . IN (2765764)' at line 1




More information about the vtigercrm-developers mailing list