Error in daemon_spotter.php

Ysurac / FlightAirMap

Open source project displaying live aircrafts, ships or trackers on 2D/3D map. Browse through the data based on a particular aircraft, airline, airport, tracker or vessel to search through the database or see extensive statistics. Can use ADS-B in SBS1 format (dump1090, Radarcape,...), VRS, VA (VATSIM, IVAO whazzup.txt, phpvms,...), ACARS (acarsdec, acarsdeco2), APRS, AIS as datasource.

https://www.flightairmap.com/

GNU Affero General Public License v3.0

516 stars 157 forks source link

Error in daemon_spotter.php #395

Closed dterweij closed 6 years ago

dterweij commented 6 years ago

DATA : hex : 780DB0 - ident : CSN345 - ICAO : A333 - Departure Airport : ZBAA - Arrival Airport : EHAM - Latitude : 53.15291 - Longitude : 6.94901 - waypoints :  - Altitude : 234 - Heading : 234 - Speed : 469 - Departure Airport Time :  - Arrival Airport time :  - Pilot :  - Source name : DUMP1090
\o/ Add CSN345 from sbs in Live DB : -- Delete previous data -- (Add to Spotter archive : Error : SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION air.ST_Within does not exist
success)success

Ysurac commented 6 years ago

What is the DB used ? MariaDB, MySQL or PostgreSQL ? And what version ? For MySQL, you need at least version 5.6.1. For PostgreSQL, PostGIS must be installed.

dterweij commented 6 years ago

$ mysql --version
mysql  Ver 14.14 Distrib 5.5.59, for Linux (x86_64) using readline 5.1
$ cat /etc/centos-release
CentOS release 6.9 (Final)

There is no MySQL 5.6+ package for CentOS 6 (See Remi Repository).

Ysurac commented 6 years ago

MySQL 5.6.x is available since 2012, I can't support MySQL 5.5 because of the lack of spatial extensions support.

You should be able to install it from the Official MySQL Community repository.

dterweij commented 6 years ago

I rather stay at stable stock packages. Newest not always safest way :)