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

[Prasad]

__vtlib_get_modulevar_value was added to bring compatibility to pre-vtlib
modules which missed some of
metadata required for the runtime.

On Mon, Mar 18, 2024 at 10:12 PM Alan Lord <alanslists at gmail.com> wrote:

> 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/
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240420/adede2c7/attachment.html>