[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