I'm getting this other error, when i try to use the map explorer form:
Notice: Undefined index: explore-ownData in iform_map_explorer::get_form() (line 230 of /var/www/drupal-7.36/sites/all/modules/iform/client_helpers/prebuilt_forms/map_explorer.php)
i get error when i try to set "ownData=1"...
and setting this params, i get also:
general_errors.There was an SQL error: ERROR: syntax error at or near "ORDER" LINE 36: ORDER BY o.id DESC LIMIT 3000 ^ - SELECT o.id as occurrence_id, w.title || ' | ' || o.survey_title as source, o.sample_id as sample_id, CASE WHEN o.preferred_taxon=o.default_common_name then o.preferred_taxon ELSE o.preferred_taxon || COALESCE(' | ' || o.default_common_name, '') END as taxon, o.taxon_group as taxon_group, o.taxa_taxon_list_id as taxa_taxon_list_id, o.location_name as location_name, regexp_replace(o.public_entered_sref, ',[^ ]', ', ', 'g') as entered_sref, o.date_start as date_start, o.date_end as date_end, o.date_type as date_type, CASE WHEN w.id IN (2) THEN '' ELSE w.title || '-> ' END || CASE WHEN LENGTH(o.recorders)>30 THEN 'Recorder' ELSE o.recorders END as recorder, o.zero_abundance as zero_abundance, o.record_status as record_status, CASE WHEN CAST(o.created_by_id AS character varying) = '' AND o.website_id IN (2) THEN true ELSE false END as belongs_to_user, o.certainty as certainty, round(length(o.public_entered_sref) / 24.0, 2) as fo, case o.record_status when 'C' then case o.certainty when 'C' then 'green' when 'L' then 'orange' when 'U' then 'red' else 'blue' end when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'black' end as sc, case o.record_status when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'blue' end as fc, length(o.public_entered_sref) as zi, st_astext(o.public_geom) as geom, o.images as images, case when o.input_form is null then '' else o.input_form end as input_form FROM cache_occurrences o JOIN websites w on w.id=o.website_id JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE (o.training=false OR o.training IS NULL) AND (o.website_id in (2) OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (2) AND o.record_status not in ('I','T') AND (1=1 OR o.record_status not in ('D','R')) AND (''='' OR st_intersects(o.public_geom, st_geomfromtext('',900913))) AND o.created_by_id= ORDER BY o.id DESC LIMIT 3000
Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit