CoreBOSBB
Error in report - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: User Support (https://discussions.corebos.org/forumdisplay.php?fid=6)
+--- Thread: Error in report (/showthread.php?tid=235)

Pages: 1 2


Error in report - geraldbigot - 02-02-2016

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


RE: Error in report - omarllorens - 02-02-2016

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.


RE: Error in report - geraldbigot - 02-02-2016

Very good and quick.
Thanks.


New Error in report - geraldbigot - 04-15-2016

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


RE: Error in report - joebordes - 04-15-2016

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.


RE: Error in report - geraldbigot - 04-16-2016

(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


RE: Error in report - joebordes - 04-16-2016

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.


RE: Error in report - geraldbigot - 04-19-2016

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'


RE: Error in report - omarllorens - 04-20-2016

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


RE: Error in report - geraldbigot - 04-20-2016

Hello Omar,

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

Thanks for investigating.