Ranked by number of recordscUrl POST request failed. Please check cUrl is installed on the server and the $base_url setting is correct.
URL:http://the-eis.com/citizenscience/index.php/services/report/requestReport?report=library/alice/leaderboard-individuals.xml
Server response
{"error":"There was an SQL error: ERROR: syntax error at or near \"ORDER\"\nLINE 39: ORDER BY \"records\" LIMIT 21\n ^ - \n SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records\n FROM cache_occurrences_functional of\n JOIN users u on u.id=of.created_by_id\n JOIN people p on p.id=u.person_id\n\n WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and\n CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and\n CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and\n CONCAT(p.surname, ', ', p.first_name) !='admin' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, Zambezi' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, North West' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, GSN' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, South' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, North Central' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, Kavango' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Count, Greater Fish River' and\n CONCAT(p.surname, ', ', p.first_name) !='Event Book, HWC data' and\n CONCAT(p.surname, ', ', p.first_name) !='Carnivore Tracker, App' and\n CONCAT(p.surname, ', ', p.first_name) !='Museums, Various' and\n CONCAT(p.surname, ', ', p.first_name) !='Warden, Moewe Bay' and\n CONCAT(p.surname, ', ', p.first_name) !='Nest records, Various' and\n CONCAT(p.surname, ', ', p.first_name) !='Kwando Carnivore, Project' and\n CONCAT(p.surname, ', ', p.first_name) !='Brown Hyena Research, Project' and\n CONCAT(p.surname, ', ', p.first_name) not like 'Cheetah Conservation, Fund' and\n CONCAT(p.surname, ', ', p.first_name) !='IZW, Berlin' and\n CONCAT(p.surname, ', ', p.first_name) not like 'Naankuse, Group' and\n CONCAT(p.surname, ', ', p.first_name) !='AfriCat, North' and\n CONCAT(p.surname, ', ', p.first_name) !='Ongava, Research Centre' and\n CONCAT(p.surname, ', ', p.first_name) !='Gondwana, Collection' and\n CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, North West' and\n CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, Nyae Nyae' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Otjozondjupa' and\n CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Zambezi' \n\n \n GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC\n \n ORDER BY \"records\" LIMIT 21","code":44,"file":"\/var\/www\/www.the-eis.com\/citizenscience\/indicia_warehouse\/system\/libraries\/drivers\/Database\/Pgsql.php","line":342,"trace":[]}
There was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 39: ORDER BY "records" LIMIT 21
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Zambezi' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, GSN' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, South' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North Central' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Kavango' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Greater Fish River' and
CONCAT(p.surname, ', ', p.first_name) !='Event Book, HWC data' and
CONCAT(p.surname, ', ', p.first_name) !='Carnivore Tracker, App' and
CONCAT(p.surname, ', ', p.first_name) !='Museums, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Warden, Moewe Bay' and
CONCAT(p.surname, ', ', p.first_name) !='Nest records, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Kwando Carnivore, Project' and
CONCAT(p.surname, ', ', p.first_name) !='Brown Hyena Research, Project' and
CONCAT(p.surname, ', ', p.first_name) not like 'Cheetah Conservation, Fund' and
CONCAT(p.surname, ', ', p.first_name) !='IZW, Berlin' and
CONCAT(p.surname, ', ', p.first_name) not like 'Naankuse, Group' and
CONCAT(p.surname, ', ', p.first_name) !='AfriCat, North' and
CONCAT(p.surname, ', ', p.first_name) !='Ongava, Research Centre' and
CONCAT(p.surname, ', ', p.first_name) !='Gondwana, Collection' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, Nyae Nyae' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Otjozondjupa' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Zambezi'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 21