Dynamic Checklists

[Eduardo Chacón]

Dear group,

My name is Eduardo, I have an independent installation of Symbiota in:

http://colecciones.biologia.ucr.ac.cr/

Although I have setting many functions, I have some problems with the dynamic checklist because when I try to make a dynamic checklist, the site generates an empty list, even when there are records in the region.

I think I should set something here in the symbini.php but I am not pretty sure.

Can you help me how  symbini.php is set in the next lines?

 $checklists_checklistMenu = 1;
//$checklists_checklistCrumbs = "<a href='../index.php'>Home</a> &gt;&gt; <a href='index.php'>Checklists</a> &gt;&gt; ";
//collections/
$collections_indexMenu = 1;
$collections_harvestparamsMenu = 1;
//$collections_harvestparamsCrumbs = "<a href='../index.php'>Collections</a> &gt;&gt; ";

Eduardo

--

Eduardo Chacón-Madrigal

Escuela de Biología

Universidad de Costa Rica

Mi perfil Google Académico

Mi perfil ResearchGate

http://floracostaricensis.myspecies.info/

https://ucr-use-r.blogspot.com/

[egbiodi...@gmail.com]

Hello Eduardo,

 

Try running the following SQL. I bet this will fix your issue.

 

INSERT IGNORE INTO omoccurgeoindex(tid,decimallatitude,decimallongitude)

SELECT DISTINCT o.tidinterpreted, round(o.decimallatitude,2), round(o.decimallongitude,2)

FROM omoccurrences o

WHERE (o.tidinterpreted IS NOT NULL) AND (o.decimallatitude between -90 and 90) AND (o.decimallongitude between -180 and 180)

AND (o.cultivationStatus IS NULL OR o.cultivationStatus = 0) AND (o.coordinateUncertaintyInMeters IS NULL OR o.coordinateUncertaintyInMeters < 10000);

 

Cheers, Ed

--
You received this message because you are subscribed to the Google Groups "Symbiota" group.
To unsubscribe from this group and stop receiving emails from it, send an email to symbiotagrou...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/symbiotagroup/CAJBPNysypF0yT-S8eqA-zbhu%3D-o2qdXDF0A7gZYMvahP7h04KA%40mail.gmail.com.

[Matt Fossen]

I'm glad I found this... I was having the same issue and your SQL statement fixed it!