VTModuleDesigner icon indicating copy to clipboard operation
VTModuleDesigner copied to clipboard

Record you are trying to access cannot be found

Open jayo2005 opened this issue 11 years ago • 1 comments

Vtiger 6.1 I have two modules one called Trainers which I made and one called Players which is actually contacts. I created an UI 10 related module to Players and related it to Trainers. Upon saving the player/contact I get Record you are trying to access cannot be found. If I remove the UI 10 releated module from players/contacts. every thing works but I cant add a related module?

jayo2005 avatar Nov 25 '14 16:11 jayo2005

@jayo2005, I had a similar issue recently. The problem is caused by the database table to which the new field is bound. The Contacts module is spread across multiple tables in the database, but Module designer automatically suggests the vtiger_contacts table which does not exist.

screenshot from 2014-12-01 21 26 52

A solution that worked for me was to edit the Table name field and use one of the existing tables of the module, like is used by the built-in fields

screenshot from 2014-12-01 21 29 58

In your case the more suitable table for the related module field would probably be vtiger_contactdetails

makerdrone avatar Dec 01 '14 19:12 makerdrone