Nevermind. Probably two different errors. I keep forgetting to checkout the svn in the drupal iform folder as well. :lol:
However, can comeone help me with this log? What did I forget?
2015-06-08 19:16:50 +02:00 --- error: Missing i18n entry general_errors.There was an SQL error: ERROR: function st_makevalid(geometry) does not exist
LINE 36: 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 o.id as occurrence_id,
w.title as website,
o.survey_title as survey,
o.recorders as user,
o.sample_id as sample_id,
o.preferred_taxon as taxon,
CASE WHEN o.preferred_taxon=o.default_common_name THEN null ELSE o.default_common_name END as common,
o.taxa_taxon_list_id as taxa_taxon_list_id,
o.location_name as location_name,
coalesce(o.public_entered_sref, s.entered_sref) as entered_sref,
o.date_start as date_start,
o.date_end as date_end,
o.date_type as date_type,
o.zero_abundance as zero_abundance,
o.taxon_group as taxon_group,
o.record_status as record_status,
st_astext(coalesce(s.geom, o.public_geom)) as geom,
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,
CASE WHEN o.data_cleaner_info='pass' THEN '<div class="pass-icon" title="This record passes all automated verification checks."/></div>' WHEN not w.verification_checks_enabled THEN '<div title="This record is not included in the automated verification check system."/>-</div>' END as pass,
case when o.data_cleaner_info is not null and o.data_cleaner_info<>'pass' then replace(replace(replace(replace(o.data_cleaner_info, '[', '<div class="fail-icon '), ']', '" '), '{', 'title="'), '}', '"></div>') end as fails,
o.images as images
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 OR o.training IS NULL) 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')
ORDER BY o.id DESC LIMIT 21 for language en_GB