1

Topic: Verification forms and @taxon_list_id

Good evening, i'm updating Drupal7 and Indicia IForm to the last versions. I'm stuck on a message from IForm when i view Verification 4 and 5, that's: Please specify a @taxon_list_id option in the page configuration.

But i don't understand where setting this info... When i used old version IForm (0.90) i didn't set nothing and with this 1.1.0 it seems required. Can anyone help me to find a solution? Thanks

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

2

Re: Verification forms and @taxon_list_id

Hi

Navigate to the IForm configuration settings (admin/config/iform/settings) and scroll down to "Master species checklist". Choose a species list and save.

Jim Bacon.

3

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

Hi

Navigate to the IForm configuration settings (admin/config/iform/settings) and scroll down to "Master species checklist". Choose a species list and save.

Jim Bacon.

HI Jim,

i have set a taxon there but now i get this error returning to verification page:

Invalid response received from Indicia Warehouse. Array ( [result] => 1 [output] => Unrecognised entity taxon_rank [request] => index.php/services/data/taxon_rank?mode=json&orderby=sort_order&auth_token=fb117f697550ab95e20ff123481d5977dd5179e8&sortdir=DESC&nonce=721b2548a57ae456a0fe1b4917e2fac5bd5a09a1 )

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

4

Re: Verification forms and @taxon_list_id

Does your database contain a taxon_ranks table?

5

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

Does your database contain a taxon_ranks table?

Yes, it exists but it's empty (i don't think to have ever used this before)

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

6

Re: Verification forms and @taxon_list_id

I have never looked at this before either! This is a complete guess (which I am not optimistic about) but you could try populating the table.

A dump from our warehouse goes as follows

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.5
-- Dumped by pg_dump version 9.3.5
-- Started on 2016-12-14 17:26:14

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = indicia, pg_catalog;

--
-- TOC entry 5120 (class 0 OID 35131)
-- Dependencies: 509
-- Data for Name: taxon_ranks; Type: TABLE DATA; Schema: indicia; Owner: indicia_user
--

INSERT INTO taxon_ranks VALUES (64, 'Unknown', 'Unk', false, 0, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (39, 'Kingdom', 'Kng', false, 10, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (8, 'Subkingdom', 'SubKng', false, 20, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (29, 'Phylum', 'Phl', false, 30, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (11, 'Division', 'Div(b)', false, 30, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (56, 'Subphylum', 'SubPhl', false, 40, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (1, 'Subdivision', 'SubDiv', false, 40, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (106, 'Superclass', 'SupCls', false, 50, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (50, 'Class', 'Cls', false, 60, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (32, 'Subclass', 'SubCls', false, 70, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (37, 'Superorder', 'SupOrd', false, 90, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (73, 'Order', 'Ord', false, 100, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (101, 'Infraorder', 'InfOrd', false, 120, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (108, 'Suborder', 'SubOrd', false, 110, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (116, 'Section', 'Sec(z)', false, 130, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (80, 'Superfamily', 'SupFam', false, 170, '2014-05-09 16:17:17.524', 1, '2014-05-09 16:17:17.524', 1, false);
INSERT INTO taxon_ranks VALUES (25, 'Family', 'Fam', false, 180, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (3, 'Subfamily', 'SubFam', false, 190, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (115, 'Tribe', 'Trb', false, 210, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (69, 'Generic hybrid', 'GenHyb', true, 230, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (57, 'Genus', 'Gen', true, 230, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (59, 'Subgenus', 'SubGen', true, 240, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (14, 'Section', 'Sec(b)', true, 250, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (16, 'Series', 'Ser(b)', true, 270, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (10, 'Species group', 'SppGrp', true, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (38, 'Species aggregate', 'Agg', true, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (26, 'Species', 'Spp', true, 300, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (13, 'Species hybrid', 'SppHyb', true, 300, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (47, 'Subspecies hybrid', 'SubSppHyb', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (2, 'Subspecies', 'SubSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (55, 'Race', 'Rac', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (49, 'Form', 'Frm', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (44, 'Abberation', 'Abb', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (41, 'Variety', 'Var', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (111, 'Infraclass', 'InfCls', false, 80, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (112, 'Subsection', 'SubSec(z)', false, 140, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (31, 'Subseries', 'SubSer(b)', true, 280, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (17, 'Subsection', 'SubSec(b)', true, 260, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (42, 'Microspecies', 'MicSpp', true, 310, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (18, 'Nothosubspecies', 'NoSubSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (21, 'Microgene', 'MicGen', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (22, 'Praespecies', 'PraSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (19, 'Sublusus', 'SubLus', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (51, 'Varietal hybrid', 'VarHyb', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (7, 'Nothovariety', 'NoVar', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (4, 'Cultivar', 'Cult', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (33, 'Subvariety', 'SubVar', true, 340, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (74, 'Convariety', 'ConVar', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (71, 'Facies', 'Fac', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (46, 'Morphotype', 'Mor', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (52, 'Form hybrid', 'FrmHyb', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (30, 'Forma specialis', 'FrmSpc', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (9, 'ecad', 'ecad', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (63, 'Subspecies aggregate', 'SubAgg', true, 310, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (43, 'Genus aggregate', 'GenAgg', false, 228, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (98, 'Unranked', 'Unr', false, 0, '2014-05-09 16:17:17.524', 1, '2014-05-09 16:17:17.524', 1, false);
INSERT INTO taxon_ranks VALUES (67, 'Species pro parte', 'SppPP', false, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (15, 'Species sensu lato', 'SppSL', false, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (70, 'Breed', 'Brd', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (100, 'Infrakingdom', 'InfKng', false, 25, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (104, 'Infraphylum', 'InfPhl', false, 45, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (103, 'Parvorder', 'ParOrd', false, 125, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (127, 'Functional group', 'FunGp', false, 370, '2015-04-03 10:35:21.564', 1, '2015-04-03 10:35:21.564', 1, false);


--
-- TOC entry 5126 (class 0 OID 0)
-- Dependencies: 631
-- Name: taxon_ranks_id_seq; Type: SEQUENCE SET; Schema: indicia; Owner: indicia_user
--

SELECT pg_catalog.setval('taxon_ranks_id_seq', 156, true);


-- Completed on 2016-12-14 17:26:14

--
-- PostgreSQL database dump complete
--

7

Re: Verification forms and @taxon_list_id

Is your warehouse code up to date (or no older than the IForm code any way)?
Just wondering if there could be a backwards compatibility problem.

Jim Bacon.

8

Re: Verification forms and @taxon_list_id

Also, for info, while there isn't a packaged version of the complete IForm module and libraries, there are newer versions than 1.1.0

https://github.com/Indicia-Team/drupal- … m/releases
https://github.com/Indicia-Team/media/releases
https://github.com/Indicia-Team/client_helpers/releases

Jim Bacon.

9

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

Also, for info, while there isn't a packaged version of the complete IForm module and libraries, there are newer versions than 1.1.0

https://github.com/Indicia-Team/drupal- … m/releases
https://github.com/Indicia-Team/media/releases
https://github.com/Indicia-Team/client_helpers/releases

Jim Bacon.

At first i downloaed a little update "drupal-7-module-iform-master.zip" (few KB) but it didn't work fine. THen i found also "IForm.module.for.Drupal.7.complete.including.submodules.zip" about 7MB.

The warehouse, if not wrong, is 0.91

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

10

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

I have never looked at this before either! This is a complete guess (which I am not optimistic about) but you could try populating the table.

A dump from our warehouse goes as follows

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.5
-- Dumped by pg_dump version 9.3.5
-- Started on 2016-12-14 17:26:14

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = indicia, pg_catalog;

--
-- TOC entry 5120 (class 0 OID 35131)
-- Dependencies: 509
-- Data for Name: taxon_ranks; Type: TABLE DATA; Schema: indicia; Owner: indicia_user
--

INSERT INTO taxon_ranks VALUES (64, 'Unknown', 'Unk', false, 0, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (39, 'Kingdom', 'Kng', false, 10, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (8, 'Subkingdom', 'SubKng', false, 20, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (29, 'Phylum', 'Phl', false, 30, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (11, 'Division', 'Div(b)', false, 30, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (56, 'Subphylum', 'SubPhl', false, 40, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (1, 'Subdivision', 'SubDiv', false, 40, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (106, 'Superclass', 'SupCls', false, 50, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (50, 'Class', 'Cls', false, 60, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (32, 'Subclass', 'SubCls', false, 70, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (37, 'Superorder', 'SupOrd', false, 90, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (73, 'Order', 'Ord', false, 100, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (101, 'Infraorder', 'InfOrd', false, 120, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (108, 'Suborder', 'SubOrd', false, 110, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (116, 'Section', 'Sec(z)', false, 130, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (80, 'Superfamily', 'SupFam', false, 170, '2014-05-09 16:17:17.524', 1, '2014-05-09 16:17:17.524', 1, false);
INSERT INTO taxon_ranks VALUES (25, 'Family', 'Fam', false, 180, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (3, 'Subfamily', 'SubFam', false, 190, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (115, 'Tribe', 'Trb', false, 210, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (69, 'Generic hybrid', 'GenHyb', true, 230, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (57, 'Genus', 'Gen', true, 230, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (59, 'Subgenus', 'SubGen', true, 240, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (14, 'Section', 'Sec(b)', true, 250, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (16, 'Series', 'Ser(b)', true, 270, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (10, 'Species group', 'SppGrp', true, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (38, 'Species aggregate', 'Agg', true, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (26, 'Species', 'Spp', true, 300, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (13, 'Species hybrid', 'SppHyb', true, 300, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (47, 'Subspecies hybrid', 'SubSppHyb', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (2, 'Subspecies', 'SubSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (55, 'Race', 'Rac', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (49, 'Form', 'Frm', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (44, 'Abberation', 'Abb', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (41, 'Variety', 'Var', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (111, 'Infraclass', 'InfCls', false, 80, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (112, 'Subsection', 'SubSec(z)', false, 140, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (31, 'Subseries', 'SubSer(b)', true, 280, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (17, 'Subsection', 'SubSec(b)', true, 260, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (42, 'Microspecies', 'MicSpp', true, 310, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (18, 'Nothosubspecies', 'NoSubSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (21, 'Microgene', 'MicGen', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (22, 'Praespecies', 'PraSpp', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (19, 'Sublusus', 'SubLus', true, 320, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (51, 'Varietal hybrid', 'VarHyb', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (7, 'Nothovariety', 'NoVar', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (4, 'Cultivar', 'Cult', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (33, 'Subvariety', 'SubVar', true, 340, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (74, 'Convariety', 'ConVar', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (71, 'Facies', 'Fac', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (46, 'Morphotype', 'Mor', true, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (52, 'Form hybrid', 'FrmHyb', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (30, 'Forma specialis', 'FrmSpc', true, 350, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (9, 'ecad', 'ecad', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (63, 'Subspecies aggregate', 'SubAgg', true, 310, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (43, 'Genus aggregate', 'GenAgg', false, 228, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (98, 'Unranked', 'Unr', false, 0, '2014-05-09 16:17:17.524', 1, '2014-05-09 16:17:17.524', 1, false);
INSERT INTO taxon_ranks VALUES (67, 'Species pro parte', 'SppPP', false, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (15, 'Species sensu lato', 'SppSL', false, 290, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (70, 'Breed', 'Brd', false, 330, '2013-10-23 08:19:49.567', 1, '2013-10-23 08:19:49.567', 1, false);
INSERT INTO taxon_ranks VALUES (100, 'Infrakingdom', 'InfKng', false, 25, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (104, 'Infraphylum', 'InfPhl', false, 45, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (103, 'Parvorder', 'ParOrd', false, 125, '2014-09-23 20:35:20.622', 1, '2014-09-23 20:35:20.622', 1, false);
INSERT INTO taxon_ranks VALUES (127, 'Functional group', 'FunGp', false, 370, '2015-04-03 10:35:21.564', 1, '2015-04-03 10:35:21.564', 1, false);


--
-- TOC entry 5126 (class 0 OID 0)
-- Dependencies: 631
-- Name: taxon_ranks_id_seq; Type: SEQUENCE SET; Schema: indicia; Owner: indicia_user
--

SELECT pg_catalog.setval('taxon_ranks_id_seq', 156, true);


-- Completed on 2016-12-14 17:26:14

--
-- PostgreSQL database dump complete
--

I tried with your dump but i continue to get error from warehouse:

Invalid response received from Indicia Warehouse. Array ( [result] => 1 [output] => Unrecognised entity taxon_rank [request] => index.php/services/data/taxon_rank?mode=json&orderby=sort_order&nonce=ad46fb7e6f9a271392365382e5a3c32d129a01af&sortdir=DESC&auth_token=0ed850721f7271eb5b0ee5b4a81e3a53f43882d9 )

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

11 (edited by Jim Bacon 14-12-2016 18:39:49)

Re: Verification forms and @taxon_list_id

I'm not surprised. "Unrecognised entity" sounds more serious.
This commit introduce the taxon_rank service so your warehouse must be more recent than this for it to work.

[Edit] We can't just go by the date of the commit. We have to look at whether that commit was still in development and, if so, when it got merged in to a release. [/edit]

Jim Bacon.

12

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

I'm not surprised. "Unrecognised entity" sounds more serious.
This commit introduce the taxon_rank service so your warehouse must be more recent than this for it to work.

[Edit] We can't just go by the date of the commit. We have to look at whether that commit was still in development and, if so, when it got merged in to a release. [/edit]

Jim Bacon.

Ok so i need to update warehouse. Which is the right version for it? Or should i wait fir a stable commit?

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

13

Re: Verification forms and @taxon_list_id

To confirm that your warehouse is out of date and not supporting this service, can you look in modules/indicia_svc_data/controllers/services/data.php and search for the public function taxon_rank().

It should appear as in https://github.com/Indicia-Team/warehou … 9c55bff6d7. If not, then an update is required.

See https://github.com/Indicia-Team/warehouse/releases for the latest.

Jim Bacon

14 (edited by carlo_politi 15-12-2016 14:58:00)

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

To confirm that your warehouse is out of date and not supporting this service, can you look in modules/indicia_svc_data/controllers/services/data.php and search for the public function taxon_rank().

It should appear as in https://github.com/Indicia-Team/warehou … 9c55bff6d7. If not, then an update is required.

See https://github.com/Indicia-Team/warehouse/releases for the latest.

Jim Bacon


I downloaded the latest warehouse from your last link, copied over the old and i started the update process but i get this error:

The upgrade failed.

An error occurred during the upgrade.

The error was described as:
There was an SQL error: ERROR: column o.record_substatus does not exist LINE 39: o.record_substatus, ^ - CREATE OR REPLACE VIEW detail_occurrences AS SELECT o.id, o.confidential, o.comment, o.taxa_taxon_list_id, ttl.taxon_meaning_id, o.record_status, o.determiner_id, t.taxon, s.entered_sref, s.entered_sref_system, s.geom, st_astext(s.geom) AS wkt, s.location_name, s.survey_id, s.date_start, s.date_end, s.date_type, s.location_id, l.name AS location, l.code AS location_code, s.recorder_names, (d.first_name::text || ' '::text) || d.surname::text AS determiner, o.website_id, o.external_key, o.created_by_id, c.username AS created_by, o.created_on, o.updated_by_id, u.username AS updated_by, o.updated_on, o.downloaded_flag, o.sample_id, o.deleted, o.zero_abundance, t.external_key AS taxon_external_key, ttl.taxon_list_id, o.sensitivity_precision, o.record_substatus, o.record_decision_source FROM occurrences o JOIN samples s ON s.id = o.sample_id AND s.deleted = false LEFT JOIN people d ON d.id = o.determiner_id AND d.deleted = false LEFT JOIN locations l ON l.id = s.location_id AND l.deleted = false LEFT JOIN taxa_taxon_lists ttl ON ttl.id = o.taxa_taxon_list_id AND ttl.deleted = false LEFT JOIN taxa t ON t.id = ttl.taxon_id AND t.deleted = false JOIN surveys su ON s.survey_id = su.id AND su.deleted = false JOIN users c ON c.id = o.created_by_id JOIN users u ON u.id = o.updated_by_id WHERE o.deleted = false; CREATE OR REPLACE VIEW list_occurrences AS SELECT su.title AS survey, l.name AS location, s.date_start, s.date_end, s.date_type, s.entered_sref, s.entered_sref_system, t.taxon, o.website_id, o.id, s.recorder_names, o.zero_abundance, ttl.taxon_list_id, o.record_status, o.record_substatus FROM occurrences o JOIN samples s ON o.sample_id = s.id AND s.deleted = false LEFT JOIN locations l ON s.location_id = l.id LEFT JOIN taxa_taxon_lists ttl ON o.taxa_taxon_list_id = ttl.id LEFT JOIN taxa t ON ttl.taxon_id = t.id LEFT JOIN surveys su ON s.survey_id = su.id AND su.deleted = false WHERE o.deleted = false; CREATE OR REPLACE VIEW detail_occurrence_comments AS SELECT oc.id, oc.comment, oc.occurrence_id, oc.email_address, oc.updated_on, oc.person_name, c.username, o.website_id, oc.created_on, oc.created_by_id, c.username AS created_by, oc.updated_by_id, u.username AS updated_by, oc.record_status, oc.record_substatus, oc.query FROM occurrence_comments oc JOIN occurrences o ON o.id = oc.occurrence_id AND o.deleted = false LEFT JOIN users c ON oc.created_by_id = c.id LEFT JOIN users u ON oc.updated_by_id = u.id WHERE oc.deleted = false; CREATE OR REPLACE VIEW list_occurrence_comments AS SELECT oc.id, oc.comment, oc.occurrence_id, oc.email_address, oc.updated_on, oc.person_name, u.username, o.website_id, oc.record_status, oc.record_substatus, oc.query FROM occurrence_comments oc JOIN occurrences o ON o.id = oc.occurrence_id AND o.deleted = false LEFT JOIN users u ON oc.created_by_id = u.id WHERE oc.deleted = false;
Please refer to the application log files for more information.



I looked inside application/logs and i see this:


2016-12-15 15:05:51 +01:00 --- debug: Session Library initialized
2016-12-15 15:05:51 +01:00 --- debug: upgrading Indicia database to version_0_9_0
2016-12-15 15:05:51 +01:00 --- info: Scripts ran for Indicia version_0_9_0
2016-12-15 15:05:51 +01:00 --- debug: upgrading Indicia database to version_0_9_1
2016-12-15 15:05:51 +01:00 --- debug: Upgrading file 201403240925_generated_by_subtype.sql
2016-12-15 15:05:51 +01:00 --- debug: Upgrading file 201404041020_drop_unused_col.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404041021_recreate_col.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404171333_taxon_rank.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404210900_groups.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404210901_relations.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404210902_group_pages.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404210903_group_ids.sql
2016-12-15 15:05:52 +01:00 --- debug: Upgrading file 201404210904_groups_views.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201404210905_groups_sample_views.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201404210906_constraint_unique_filter_name.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201404221245_drop_groups_users_unique.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201404241107_list_group_pages.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201404301939_cascade_location_delete.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201405021011_new_notification_types.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201405022104_cascade_survey_delete.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201405221116_privacy_precision.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201405221117_list_samples.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201405291503_new_notification_types.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201406091516_notifications_new_email_column.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201406230850_taxon_group_view_external_key.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201407070840_new_pt_notification_type.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201407281128_clone_surveys.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201408261256_detail_users.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201408271208_group_private_records_triggers.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201409071116_reduce_precision.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201409090948_taxa_marine_flag.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201409271331_groups_locations.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201409291528_list_groups_locations.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201410071828_detail_occurrences.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201410101158_drop_group_pages_unique.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411101400_group_pages_administrator.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411210659_survey_media.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411210825_group_logos.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411232053_survey_attribute_tables.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411232055_survey_attribute_views.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411261054_index_groups_locations.sql
2016-12-15 15:05:53 +01:00 --- debug: Upgrading file 201411261055_index_groups_taxon_groups.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201411261650_add_exif_to_media_tables.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201412011839_cascade_occurrence_delete.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201412101513_survey_comments.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201412101519_survey_comments_views.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201412101520_gv_sample_comments.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201501051132_get_output_system.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201501051133_get_output_sref.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201501101900_drop_f_wrap_ddl.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201502231055_detail_groups_users.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201504171128_detail_groups_url_safe_title.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201504210945_occurrence_record_status_updates.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201504211042_occurrence_record_decision_source_data.sql
2016-12-15 15:05:54 +01:00 --- debug: Upgrading file 201504221942_record_status_views.sql
2016-12-15 15:05:54 +01:00 --- error: Error in file: /var/www/IndiciaWarehouse090/modules/indicia_setup/db/version_0_9_1/201504221942_record_status_views.sql
2016-12-15 15:05:54 +01:00 --- error: There was an SQL error: ERROR:  column o.record_substatus does not exist
LINE 39:     o.record_substatus,
             ^ - CREATE OR REPLACE VIEW detail_occurrences AS
SELECT o.id,
    o.confidential,
    o.comment,
    o.taxa_taxon_list_id,
    ttl.taxon_meaning_id,
    o.record_status,
    o.determiner_id,
    t.taxon,
    s.entered_sref,
    s.entered_sref_system,
    s.geom,
    st_astext(s.geom) AS wkt,
    s.location_name,
    s.survey_id,
    s.date_start,
    s.date_end,
    s.date_type,
    s.location_id,
    l.name AS location,
    l.code AS location_code,
    s.recorder_names,
    (d.first_name::text || ' '::text) || d.surname::text AS determiner,
    o.website_id,
    o.external_key,
    o.created_by_id,
    c.username AS created_by,
    o.created_on,
    o.updated_by_id,
    u.username AS updated_by,
    o.updated_on,
    o.downloaded_flag,
    o.sample_id,
    o.deleted,
    o.zero_abundance,
    t.external_key AS taxon_external_key,
    ttl.taxon_list_id,
    o.sensitivity_precision,
    o.record_substatus,
    o.record_decision_source
   FROM occurrences o
     JOIN samples s ON s.id = o.sample_id AND s.deleted = false
     LEFT JOIN people d ON d.id = o.determiner_id AND d.deleted = false
     LEFT JOIN locations l ON l.id = s.location_id AND l.deleted = false
     LEFT JOIN taxa_taxon_lists ttl ON ttl.id = o.taxa_taxon_list_id AND ttl.deleted = false
     LEFT JOIN taxa t ON t.id = ttl.taxon_id AND t.deleted = false
     JOIN surveys su ON s.survey_id = su.id AND su.deleted = false
     JOIN users c ON c.id = o.created_by_id
     JOIN users u ON u.id = o.updated_by_id
  WHERE o.deleted = false;

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

15

Re: Verification forms and @taxon_list_id

...and if i re-enter warehouse, it doesn't tell me about anymore to upgrade db...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

16

Re: Verification forms and @taxon_list_id

I suggest you start by having a look in the database and seeing if the column record_substatus  exists in the occurrences table.

It should have been created by the update 201504210945_occurrence_record_status_updates.sql which we can see was performed just before the error occurred.

Jim Bacon.

17

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

I suggest you start by having a look in the database and seeing if the column record_substatus  exists in the occurrences table.

It should have been created by the update 201504210945_occurrence_record_status_updates.sql which we can see was performed just before the error occurred.

Jim Bacon.

They were not created/added...

I added by adding using the script. Now when I try to execute these line (from :

ALTER TABLE occurrence_comments
   ADD COLUMN query boolean,
   -- Add columns to log occurrence status changes with the comments
   ADD COLUMN record_status character(1) CONSTRAINT occurrence_comments_record_status_check CHECK (record_status = ANY (ARRAY['I'::bpchar, 'C'::bpchar, 'V'::bpchar, 'R'::bpchar, 'T'::bpchar, 'D'::bpchar])),
   ADD COLUMN record_substatus smallint CONSTRAINT occurrence_comments_record_substatus_check CHECK (record_substatus BETWEEN 1 AND 5);
UPDATE occurrence_comments SET query=FALSE;
ALTER TABLE occurrence_comments ALTER query SET default false;


I get this error:

ERROR:  relation "occurrence_comments" does not exist.

But table "occurrence_comments" exists with these fields:

id
comment
created_by_id
created_on
updated_by_id
updated_on
occurrence_id
email_address
deleted
person_name
auto_generated
generated_by
implies_manual_check_required
generated_by_subtype

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

18

Re: Verification forms and @taxon_list_id

That often happens if you are running commands against the wrong schema.
To test you can try

SELECT count(*) FROM occurrence_comments

and then

SELECT count(*) FROM your_schema_name.occurrence_comments

where your_schema_name is replaced by the name of your database schema.

If the first says 'relation does not exist' and the second works the you can use

SET search_path = your_schema_name, public

to set the default schema for the rest of your session, meaning the first statement should now work.


Jim Bacon

19

Re: Verification forms and @taxon_list_id

I have executed all remaning scripts from 0.9.1 to 1.14.0... i hope to have done all..

i have also tried to re-open Verification form 4 and i get this:

general_errors.There was an SQL error: ERROR: function st_makevalid(geometry) does not exist LINE 13: AND (''='' OR st_intersects(s.geom, ST_MakeValid(st_geomfr... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. - SELECT count(distinct o.id) FROM cache_occurrences o JOIN samples s on s.id=o.sample_id JOIN websites w on w.id=o.website_id JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE o.training=false AND (o.website_id in (2) OR privacyusers.id=1 OR privacyusers.allow_share_for_verification=true OR privacyusers.allow_share_for_verification IS NULL) AND o.website_id in (2) AND ('unverified'<>'fail' OR (o.data_cleaner_info is not null and o.data_cleaner_info <>'pass')) AND (''='' OR st_intersects(s.geom, ST_MakeValid(st_geomfromtext('',900913)))) AND o.record_status IN ('C','S')

while if i try Verification form 5 i get this:

general_errors.There was an SQL error: ERROR: relation "cache_occurrences_functional" does not exist LINE 3: FROM cache_occurrences_functional o ^ - SELECT count(o.*) FROM cache_occurrences_functional o JOIN cache_occurrences_nonfunctional onf on onf.id=o.id JOIN cache_samples_nonfunctional snf on snf.id=o.sample_id JOIN cache_taxa_taxon_lists cttl on cttl.id=o.taxa_taxon_list_id JOIN websites w on w.id=o.website_id and w.deleted=false JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE o.training=false AND (o.website_id in (2) OR privacyusers.id=1 OR privacyusers.allow_share_for_verification=true OR privacyusers.allow_share_for_verification IS NULL) AND o.website_id in (2) AND o.release_status='R'

Related to this last error, i don't see any table called "cache_occurrences_functional", neither in scripts...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

20

Re: Verification forms and @taxon_list_id

Hi Carlo,

It sounds like you are making good progress.

ST_MakeValid is a PostGIS function, http://postgis.org/documentation/manual … alid.html. Perhaps you also need to upgrade this.

The cache is an optional module and so the database updates for it are contained within the module. See \modules\cache_builder\db and, in particular \version_1_0_0\201512221019_cache_tables_revisions.sql.

Jim Bacon.

21

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

Hi Carlo,

It sounds like you are making good progress.

ST_MakeValid is a PostGIS function, http://postgis.org/documentation/manual … alid.html. Perhaps you also need to upgrade this.

The cache is an optional module and so the database updates for it are contained within the module. See \modules\cache_builder\db and, in particular \version_1_0_0\201512221019_cache_tables_revisions.sql.

Jim Bacon.

Goodday Jim,
what version should i use? The greatest problem i have is i cannot upgrade the SO on this server (it's a Debian 6 with Postgres 8.4 and PostGis 1.5). I hope to be able to update the PostGis without reinstalling all and a new SO...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

22

Re: Verification forms and @taxon_list_id

Hi Carlo

http://indicia-docs.readthedocs.io/en/l … ation.html says PostGIS > 2.0.0 is required.

PostGIS 2.0 is just about supported by PostgrSQL 8.4, see https://trac.osgeo.org/postgis/wiki/Use … QLPostGIS. However, it says "you can compile and install , but you'll be missing some functionality" so I don't know if it will work.

There are installation instructions at https://trac.osgeo.org/postgis/wiki/Use … ebian60src

Jim Bacon.

23

Re: Verification forms and @taxon_list_id

Hi

Part of this conversation may be missing, caused by the NBN moving the Forum to a new server. Looks like two post from Carlo may have been lost.

Mike Weideli

24

Re: Verification forms and @taxon_list_id

MikeWeideli wrote:

Hi

Part of this conversation may be missing, caused by the NBN moving the Forum to a new server. Looks like two post from Carlo may have been lost.

Oh ok... i will try to repostthem...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

25

Re: Verification forms and @taxon_list_id

Jim Bacon wrote:

Hi Carlo

http://indicia-docs.readthedocs.io/en/l … ation.html says PostGIS > 2.0.0 is required.

PostGIS 2.0 is just about supported by PostgrSQL 8.4, see https://trac.osgeo.org/postgis/wiki/Use … QLPostGIS. However, it says "you can compile and install , but you'll be missing some functionality" so I don't know if it will work.

There are installation instructions at https://trac.osgeo.org/postgis/wiki/Use … ebian60src

Jim Bacon.

I have followed the last link, downloading and building from sources but i continue to get error because it seems always out of update. PostGis says always "1.5"...

Postgres says: psql (9.3.11, server 8.4.22lts6)

postgres=# SELECT postgis_full_version();
postgis_full_version
-------------------------------------------------------------------------------------------------------
POSTGIS="1.5.1" GEOS="3.3.9-CAPI-1.7.9" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.7" USE_STATS

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit