Hi Carlo,

I am trying verification 3 using the latest version of the IForm module from the repository and warehouse version 0.9.1, the same as you. I have accepted all the default settings for the form.

Attached is a screen shot showing a table of records on the left, details of a record on the right, and, at the bottom, the success response from verifying the record. It all seems to work.

If I understand correctly, your problem is that, when you click on a row in the table on the left, you do not see the details on the right appear.

I think you are getting a JavaScript error about data.Record missing. We can see there is no data.Record section in your json response.

The json response is built in client_helpers/prebuilt_forms/verification_3.php::ajax_details() using the results from two reports run on the warehouse which are selected when you edit the form.

The default "Report for record details" is Reports for prebuilt forms / Verification 3 / Record data for verification.
The default for "Report for record attributes" is Reports for prebuilt forms / Verification 3 / Record attributes for verification.

Are these the reports that you have selected?

Jim Bacon

This is what i see with 0.9.0 iform on verification_3 form page...
as you can see, i get an error in console and no box where i can click to verify... (i have only customized the page as i had on drupal 6 version)

and the same seen from Drupal 6 installation. here the record is complete, as i click the map is zoomed to the exact point and there are so much more info in the JSON...

The server is the same, as the DB (postgres and mysql), only different location for installation (D7 is in a subdomain and D6 in the main). PHP is 5.3 and OS is a Debian 6

Hi Carlo,

First, you need to get the latest version of the IForm module from the code repository.
https://code.google.com/p/indicia/sourc … runk/iform
There is no point debugging old versions.

If you still experience a problem we then have to determine if the problem is because the warehouse is not returning the correct information or because the client side is not parsing it in to json correctly.

The two reports used are
https://code.google.com/p/indicia/sourc … d_data.xml
and
https://code.google.com/p/indicia/sourc … ibutes.xml

You can test these on your warehouse
.../index.php/report_viewer/load?report_name=reports_for_prebuilt_forms/verification_3/record_data
and
.../index.php/report_viewer/load?report_name=reports_for_prebuilt_forms/verification_3/record_data_attributes
by providing an occurrence id of a record.

You should see results like those attached.

Jim Bacon.

Hi Jim,
i have tried to call /index.php/report_viewer/load?report_name=reports_for_prebuilt_forms/verification_3/record_data

with occurrence id 5341

and i get this error...

general_errors.There was an SQL error: ERROR: relation "index_locations_samples" does not exist LINE 33: left join (index_locations_samples ils ^ - select co.id as occurrence_id, co.taxon as taxon, co.recorders as recorder, p.email_address as email, co.verifier as verifier, CASE co.preferred_taxon WHEN co.taxon THEN null ELSE co.preferred_taxon END as preferred_taxon, o.comment as occurrence_comment, s.id as sample_id, coalesce(s.entered_sref, l.centroid_sref) as entered_sref, s.date_start as date, case when co.location_name=s.location_name then co.location_name else co.location_name || COALESCE(' - ' || s.location_name, '') end as location_name, s.comment as sample_comment, co.survey_title as survey_title, co.taxa_taxon_list_external_key as taxon_external_key, co.taxon_meaning_id as taxon_meaning_id, o.record_status as record_status, co.zero_abundance as zero_abundance, st_astext(coalesce(s.geom, l.centroid_geom)) as wkt, co.created_by_id as created_by_id, p.first_name as input_by_first_name, p.surname as input_by_surname, co.survey_id as survey_id, co.taxon_group as taxon_group, co.taxon_group_id as taxon_group_id, array_to_string(array_agg(locality.name), '|') as localities, array_to_string(array_agg(locality.id), '|') as locality_ids from cache_occurrences co join occurrences o on o.id=co.id and o.deleted=false join samples s on s.id=o.sample_id and s.deleted=false left join samples sparent on sparent.id=s.parent_id and sparent.deleted=false left join locations l on l.id=s.location_id and l.deleted=false left join (index_locations_samples ils join locations locality on locality.id=ils.location_id and locality.location_type_id=0 ) on ils.sample_id=s.id left join (users u join people p on p.id=u.person_id and p.deleted=false ) on u.id=o.created_by_id and u.id<>1 and u.deleted=false where co.id=5341 GROUP BY co.id, co.taxon, co.recorders, p.email_address, co.verifier, CASE co.preferred_taxon WHEN co.taxon THEN null ELSE co.preferred_taxon END, o.comment, s.id, coalesce(s.entered_sref, l.centroid_sref), s.date_start, case when co.location_name=s.location_name then co.location_name else co.location_name || COALESCE(' - ' || s.location_name, '') end, s.comment, co.survey_title, co.taxa_taxon_list_external_key, co.taxon_meaning_id, o.record_status, co.zero_abundance, st_astext(coalesce(s.geom, l.centroid_geom)), co.created_by_id, p.first_name, p.surname, co.survey_id, co.taxon_group, co.taxon_group_id LIMIT 21

Hi Jim,
i have installed the module on warehouse, ran the upgrade to update the db and finally i can see no error with the call /index.php/report_viewer/load?report_name=reports_for_prebuilt_forms/verification_3/record_data and i see a table of data.

then i have tried to see the json and with verification_3 i don't get any other information but if i use verification_4 the json is complete. the problem continue to be, i cannot click over an occurrence and see it on map..

Hi Jim,
problems continue to be...
i have cleaned the Drupal cache, used the default values for Validation 4 and tested the page.

Here is the JSON when i click over an occurrence in the table:

{
    "content": "<table>\n<tr><td class=\"caption\">Status<\/td><td class=\"status status-C\">Awaiting verification
<\/td><\/tr>\n<tr><td colspan=\"2\" class=\"header\">Record<\/td><\/tr>\n<tr><td class=\"caption\">ID
<\/td><td>5218<\/td><\/tr>\n<tr><td class=\"caption\">Species<\/td><td>COCCINELLA<\/td><\/tr>\n<tr><td
class=\"caption\">Recorder<\/td><td>Sforzi, Andrea<\/td><\/tr>\n<tr><td colspan=\"2\" class=\"header
\">Sample<\/td><\/tr>\n<tr><td class=\"caption\">Georeference<\/td><td>42.818595277778N 11.0902525E<
\/td><\/tr>\n<tr><td class=\"caption\">Date<\/td><td>2014-04-01<\/td><\/tr>\n<tr><td class=\"caption
\">Survey<\/td><td>Parco Regionale della Maremma<\/td><\/tr>\n<tr><td class=\"caption\">Numero individui
<\/td><td>1<\/td><\/tr>\n<tr><td class=\"caption\">Sesso<\/td><td>Indeterminato<\/td><\/tr>\n<tr><td
class=\"caption\">CMS Username<\/td><td>Andrea<\/td><\/tr>\n<tr><td class=\"caption\">Tipo di segnalazione
<\/td><td>Avvistato<\/td><\/tr>\n<tr><td class=\"caption\">Email<\/td><td>asforzi@gol.grosseto.it<\/td
><\/tr>\n<\/table>\n",
    "data": {
        "Record": [
            {
                "caption": "ID",
                "value": "5218"
            },
            {
                "caption": "Species",
                "value": "COCCINELLA"
            },
            {
                "caption": "Recorder",
                "value": "Sforzi, Andrea"
            }
        ],
        "Sample": [
            {
                "caption": "Georeference",
                "value": "42.818595277778N 11.0902525E"
            },
            {
                "caption": "Date",
                "value": "2014-04-01"
            },
            {
                "caption": "Survey",
                "value": "Parco Regionale della Maremma"
            },
            {
                "caption": "Numero individui",
                "value": "1"
            },
            {
                "caption": "Sesso",
                "value": "Indeterminato"
            },
            {
                "caption": "CMS Username",
                "value": "Andrea"
            },
            {
                "caption": "Tipo di segnalazione",
                "value": "Avvistato"
            },
            {
                "caption": "Email",
                "value": "asforzi@gol.grosseto.it"
            }
        ]
    },
    "extra": {
        "wkt": "POINT(1234561.26106883 5284400.83341411)",
        "taxon": "COCCINELLA",
        "recorder": "Sforzi, Andrea",
        "sample_id": "10264",
        "created_by_id": "3",
        "input_by_first_name": "Andrea",
        "input_by_surname": "Sforzi",
        "survey_title": "Parco Regionale della Maremma",
        "survey_id": "8",
        "date": "2014-04-01",
        "entered_sref": "42.818595277778N 11.0902525E",
        "taxon_external_key": null,
        "taxon_meaning_id": "4894",
        "recorder_email": "asforzi@gol.grosseto.it",
        "taxon_group": "Invertebrati",
        "taxon_group_id": "7",
        "localities": "",
        "locality_ids": ""
    }
}

The call is this: http://xxx.it/iform/ajax/verification_4 … 6daa5e8465

I don't get any error in console... only occurrence is not zoomed on map. the only othe error i have is with my current template the map is over (as z-index over the occurrence table but it's only a problem of css)...