[Vtigercrm-developers] Query error "unknown column" in reports with a related module

[Alan Lord]

Check this "gem" of a piece of code in YOUR OWN system and make sue all 
the tables are defined - I have raised several bugs with it over the 
years when certain modules had errors in here...

https://code.vtiger.com/vtiger/vtigercrm/-/blob/master/include/utils/VtlibUtils.php#L284

FWIW - why this thing was necessary I have no idea as all this 
information is available in the module's main Class file.

Alternatively it could be in ReportRun or in the 
generateReportsSecQuery() method of the module's Class file perhaps...

HTH

Al




On 14/03/2024 21:34, Steve Kenow wrote:
> We have several reports that use a related module for nothing more than 
> a condition - none of the module's fields are in the report. Both are 
> core modules - accounts and service contracts. These reports did work in 
> VT6.5.0 and now in VT7.5.0 they return 0 records (number of records 
> displays NaN at the top of the report). Looking at the debug, there was 
> a fatal error trying to execute the query - Unknown column 
> 'vtiger_servicecontractscf.cf_1472' in 'where clause'
> 
> Which is reasonable, because the table was not included -
//www.vtiger.com/