[Vtigercrm-developers] vtiger 7.0 cannot save record for custom module

lucia digirolamo l.digirolamo at websonica.net
Fri Sep 28 13:16:13 GMT 2018


Hi,

I've created a module via vtlib and added some fields via layout editor. 
When I try to save a new record or opening an existing one, I get the 
error message saying that the record is not found. The records shows 
correctly in both vtiger_field and the table of my module. I enabled 
vtiger logs and the query shows an error:

PearDatabase ->ADODB error  Query Failed:SELECT vtiger_chiamate.name AS 
vtiger_chiamatename,vtiger_crmentity.smownerid AS 
vtiger_crmentityassigned_user_id,vtiger_crmentity.createdtime AS 
vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS 
vtiger_crmentitymodifiedtime,vtiger_chiamatecf.cf_1113 AS 
vtiger_chiamatecfcf_1113,vtiger_chiamatecf.cf_1115 AS 
vtiger_chiamatecfcf_1115,vtiger_chiamatecf.cf_1119 AS 
vtiger_chiamatecfcf_1119,vtiger_chiamatecf.cf_1121 AS 
vtiger_chiamatecfcf_1121,vtiger_chiamatecf.cf_1123 AS 
vtiger_chiamatecfcf_1123,vtiger_chiamatecf.cf_1125 AS 
vtiger_chiamatecfcf_1125,vtiger_crmentity.deleted, 
vtiger_crmentity.label FROM  vtiger_crmentity LEFT JOIN vtiger_chiamate 
ON (vtiger_chiamate.chiamateid = vtiger_crmentity.crmid  ) LEFT JOIN 
vtiger_chiamatecf ON (vtiger_chiamatecf.chiamateid = 
vtiger_crmentity.crmid  ) LEFT JOIN vtiger_chiamate_user_field ON 
(vtiger_chiamate_user_field.recordid = vtiger_crmentity.crmid  AND 
vtiger_chiamate_user_field.userid = 1 ) WHERE vtiger_crmentity.crmid=?  
LIMIT 1::->[1146]Table 'linkcrm.vtiger_chiamate_user_field' doesn't exist

I checked in my database and in fact the table 
vtiger_chiamate_user_field doesn't exist. But how am I supposed to 
create it? Which fields does this table need? There are costraints to 
apply (I imagine so)?

Can anybody help me?




More information about the vtigercrm-developers mailing list