Error in report

[geraldbigot]

Hi,

I add some custom fields in Document module and create a report with these new fields.
When I launch report, I have error like this :

Unknown column 'vtiger_notescf.cf_731' in 'field list'

How could I resolve it ?

Thanks

[omarllorens]

I've seen that Documents module had an error in function generateReportsQuery. Here is defined the query for the report and the table vtiger_notescf is not added.

I've updated coreBOS , so you can do a git pull to update your installation or look this commit to apply the patch.

https://github.com/tsolucio/corebos/commit/4f0ab393ad3fd552e7b940d35e305f1e28a4fd6c

---

I've added an other commit https://github.com/tsolucio/corebos/commit/9c970023d717a705771b62020abe1a8c32846c41

This fix the same error but when we create a report with Documents like a secondary module.

[geraldbigot]

Very good and quick.
Thanks.

[geraldbigot]

Hello,

I have a new error in report :

Echec de la génération du rapport!
Unknown column 'vtiger_contactdetailsRelServices793.firstname' in 'field list'

How could I solve it ?

Thanks

[joebordes]

First: detail the selected modules and columns
Second: go to global variables, and set to 1 the variable Debug_Report_query, then launch the report again, you will get the query on screen, paste it here.

[geraldbigot]

(04-15-2016, 04:59 PM)joebordes Wrote: First: detail the selected modules and columns
Second: go to global variables, and set to 1 the variable Debug_Report_query, then launch the report again, you will get the query on screen, paste it here.

Hi,

I set Debug_Report_Query to 1 and launched the report again : nothing more than :
Unknown column 'vtiger_contactdetailsRelServices793.firstname' in 'field list'

Gérald

[joebordes]

That is odd. Did you set the variable to your user?

In any case, please detail the selected modules and columns or try to reproduce in the online demo so I can see it.

[geraldbigot]

Hi,

I create same report in online demo :
http://corebos.org/demos/corebos/index.php?module=Reports&action=SaveAndRun&record=38

Error is Unknown column 'vtiger_contactdetailsRelProducts812.firstname' in 'field list'

[omarllorens]

Thanks, Gerald.

I've seen that exist two errors.

1.- Your error is because of you have created a relational custom field with Contacts in Products, and the query that is generated fail.
2.- Products by default have in "More Information" tab the related list with contacts, if you want to see this list in the report, you have select the related module "Contacts" in step 2, but if I try this report not fail but not show me any value from contacts.

We will fix it and update coreBOS asap

[geraldbigot]

Hello Omar,

I chose contacts as related module in step 2 but not better.

Thanks for investigating.