Indicia-Team / warehouse

GNU General Public License v3.0
5 stars 3 forks source link

Exception when report requests taxa_taxon_list attributes #436

Closed JimBacon closed 2 years ago

JimBacon commented 2 years ago

Reports can include a parameter of datatype taxattrs to return a list of taxa_taxon_list attributes. When you try to use this, an exception occurs with the following error message.

pg_query(): Query failed: ERROR:  relation "taxa_taxon_list_attributes_websites" does not exist
LINE 3: JOIN "taxa_taxon_list_attributes_websites" AS "aw" ON ("aw"....
             ^ at line 86 in file D:\websites\warehouse\system\libraries\drivers\Database\Pgsql.php

There is no such table as taxa_taxon_list_attributes_websites. It is expected that the same issue would arise if trying to report on termlists_term_attributes as neither of these two types of attributes are assigned to websites.

JimBacon commented 2 years ago

Not pushing to master until after the bank holiday weekend.