vt71 - cannot create records for many modules

Tested for:

Projects, Services, Assets, Service Contracts.

{"success":false,"error":{"code":"Record you are trying to access is not found","message":"Record you are trying to access is not found","title":null}}

mentioned in issue #716 (closed)

@manuelgit Can you enable dieonerror true in Peardatabase.php and share operation result.

@satish.dvnk

bottom of the error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS 0tags,vtiger_service.purchase_cost AS vtiger_servicepurchase_cost,vtiger_crme' at line 1

array ( 0 => array ( 'file' => '/home/vt71/include/database/PearDatabase.php', 'line' => 365, 'function' => 'checkError', ), 1 => array ( 'file' => '/home/vt71/data/CRMEntity.php', 'line' => 872, 'function' => 'pquery', ), 2 => array ( 'file' => '/home/vt71/modules/Vtiger/models/Record.php', 'line' => 302, 'function' => 'retrieve_entity_info', ), 3 => array ( 'file' => '/home/vt71/modules/Products/views/Detail.php', 'line' => 22, 'function' => 'getInstanceById', ), 4 => array ( 'file' => '/home/vt71/includes/main/WebUI.php', 'line' => 76, 'function' => 'preProcess', ), 5 => array ( 'file' => '/home/vt71/includes/main/WebUI.php', 'line' => 214, 'function' => 'triggerPreProcess', ), 6 => array ( 'file' => '/home/vt71/index.php', 'line' => 20, 'function' => 'process', ), ) Query Failed:SELECT vtiger_service.servicename AS vtiger_serviceservicename,vtiger_service.service_no AS vtiger_serviceservice_no,vtiger_service.discontinued AS vtiger_servicediscontinued,vtiger_service.sales_start_date AS vtiger_servicesales_start_date,vtiger_service.sales_end_date AS vtiger_servicesales_end_date,vtiger_service.start_date AS vtiger_servicestart_date,vtiger_service.expiry_date AS vtiger_serviceexpiry_date,vtiger_service.website AS vtiger_servicewebsite,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_service.service_usageunit AS vtiger_serviceservice_usageunit,vtiger_service.qty_per_unit AS vtiger_serviceqty_per_unit,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_service.servicecategory AS vtiger_serviceservicecategory,vtiger_service.unit_price AS vtiger_serviceunit_price,vtiger_service.taxclass AS vtiger_servicetaxclass,vtiger_service.commissionrate AS vtiger_servicecommissionrate,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_services_user_field.starred AS vtiger_services_user_fieldstarred,0.tags AS 0tags,vtiger_service.purchase_cost AS vtiger_servicepurchase_cost,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_service ON (vtiger_service.serviceid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_servicecf ON (vtiger_servicecf.serviceid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_producttaxrel ON (vtiger_producttaxrel.productid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_services_user_field ON (vtiger_services_user_field.recordid = vtiger_crmentity.crmid AND vtiger_services_user_field.userid = 1 ) WHERE vtiger_crmentity.crmid=? LIMIT 1::ADODB error Query Failed:SELECT vtiger_service.servicename AS vtiger_serviceservicename,vtiger_service.service_no AS vtiger_serviceservice_no,vtiger_service.discontinued AS vtiger_servicediscontinued,vtiger_service.sales_start_date AS vtiger_servicesales_start_date,vtiger_service.sales_end_date AS vtiger_servicesales_end_date,vtiger_service.start_date AS vtiger_servicestart_date,vtiger_service.expiry_date AS vtiger_serviceexpiry_date,vtiger_service.website AS vtiger_servicewebsite,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_service.service_usageunit AS vtiger_serviceservice_usageunit,vtiger_service.qty_per_unit AS vtiger_serviceqty_per_unit,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_service.servicecategory AS vtiger_serviceservicecategory,vtiger_service.unit_price AS vtiger_serviceunit_price,vtiger_service.taxclass AS vtiger_servicetaxclass,vtiger_service.commissionrate AS vtiger_servicecommissionrate,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_services_user_field.starred AS vtiger_services_user_fieldstarred,0.tags AS 0tags,vtiger_service.purchase_cost AS vtiger_servicepurchase_cost,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_service ON (vtiger_service.serviceid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_servicecf ON (vtiger_servicecf.serviceid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_producttaxrel ON (vtiger_producttaxrel.productid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_services_user_field ON (vtiger_services_user_field.recordid = vtiger_crmentity.crmid AND vtiger_services_user_field.userid = 1 ) WHERE vtiger_crmentity.crmid=? LIMIT 1::->You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS 0tags,vtiger_service.purchase_cost AS vtiger_servicepurchase_cost,vtiger_crme' at line 1

Also in list view: This is fresh installation and installation finished correctly

Query Failed:SELECT vtiger_role.roleid, vtiger_role.rolename FROM vtiger_role INNER JOIN vtiger_cv2role ON vtiger_cv2role.roleid = vtiger_role.roleid WHERE vtiger_cv2role.cvid = ?::ADODB error Query Failed:SELECT vtiger_role.roleid, vtiger_role.rolename FROM vtiger_role INNER JOIN vtiger_cv2role ON vtiger_cv2role.roleid = vtiger_role.roleid WHERE vtiger_cv2role.cvid = ?::->Table 'vtiger_vtig554.vtiger_cv2role' doesn't exist

@manuelgit Please check this commit

@satish.dvnk commit fixes module creation records yes.

Status changed to closed by commit ab3eef18

@satish.dvnk I have installed a fresh master on PHP7.1. Having the same error when adding lead, account, contact. No records added. Outputs error: "Record you are trying to access is not found" in quick or "{"success":false,"error":{"code":"Record you are trying to access is not found","message":"Record you are trying to access is not found","title":null}}" in full form.

With dieOnError enabled outputs:

array (
  0 => 
  array (
    'file' => '/www/vtiger/include/database/PearDatabase.php',
    'line' => 365,
    'function' => 'checkError',
  ),
  1 => 
  array (
    'file' => '/www/vtiger/data/CRMEntity.php',
    'line' => 718,
    'function' => 'pquery',
  ),
  2 => 
  array (
    'file' => '/www/vtiger/data/CRMEntity.php',
    'line' => 124,
    'function' => 'insertIntoEntityTable',
  ),
  3 => 
  array (
    'file' => '/www/vtiger/data/CRMEntity.php',
    'line' => 940,
    'function' => 'saveentity',
  ),
  4 => 
  array (
    'file' => '/www/vtiger/modules/Vtiger/models/Module.php',
    'line' => 169,
    'function' => 'save',
  ),
  5 => 
  array (
    'file' => '/www/vtiger/modules/Vtiger/models/Record.php',
    'line' => 259,
    'function' => 'saveRecord',
  ),
  6 => 
  array (
    'file' => '/www/vtiger/modules/Vtiger/actions/Save.php',
    'line' => 103,
    'function' => 'save',
  ),
  7 => 
  array (
    'file' => '/www/vtiger/modules/Vtiger/actions/Save.php',
    'line' => 40,
    'function' => 'saveRecord',
  ),
  8 => 
  array (
    'file' => '/www/vtiger/modules/Leads/actions/Save.php',
    'line' => 21,
    'function' => 'process',
  ),
  9 => 
  array (
    'file' => '/www/vtiger/includes/main/WebUI.php',
    'line' => 215,
    'function' => 'process',
  ),
  10 => 
  array (
    'file' => '/www/vtiger/index.php',
    'line' => 20,
    'function' => 'process',
  ),
)
Query Failed:insert into vtiger_crmentity_user_field(recordid,userid,starred) values(?,?,?)::ADODB error Query Failed:insert into vtiger_crmentity_user_field(recordid,userid,starred) values(?,?,?)::->Cannot add or update a child row: a foreign key constraint fails (`crm-vtiger`.`vtiger_crmentity_user_field`, CONSTRAINT `fk_projectid_vtiger_crmentity_user_field` FOREIGN KEY (`recordid`) REFERENCES `vtiger_project` (`projectid`) ON DELETE CASCADE)

Status changed to reopened

@satish.dvnk same now after few +-10 last commits

Query Failed:insert into vtiger_crmentity_user_field(recordid,userid,starred) values(?,?,?)::ADODB error Query Failed:insert into vtiger_crmentity_user_field(recordid,userid,starred) values(?,?,?)::->Cannot add or update a child row: a foreign key constraint fails (`vtiger_admin`.`vtiger_crmentity_user_field`, CONSTRAINT `fk_accountid_vtiger_crmentity_user_field` FOREIGN KEY (`recordid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE)
```

mentioned in merge request !286 (merged)

Status changed to closed by commit 40bf0985

@manuelgit - The query failure was resultant of foreign key constraints that were retained. This was not required any more and has been adjusted.