search

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
513 stars 156 forks source link

marine.flightairmap.com Marine data live website not working #441

Open b4b857f6ee opened 4 years ago

b4b857f6ee commented 4 years ago

Hello,

The https://marine.flightairmap.com is not working.

Last data : https://marine.flightairmap.com/marine/latest

b4b857f6ee commented 4 years ago

Some error: https://marine.flightairmap.com/marine/ident/MATARANKA

Invalid query : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND marine_output.ident = 'MATARANKA' ORDER BY marine_output.date DESC LIMIT 25' at line 1 Whole query: SELECT marine_output.* FROM marine_output WHERE AND marine_output.ident = :ident ORDER BY marine_output.date DESC LIMIT 25 OFFSET 0

b4b857f6ee commented 4 years ago

The behavior is the same with a local instance.

Sinager commented 4 years ago

Hi, have a look at this small change I submitted. Solves the problem on my install.

https://github.com/Ysurac/FlightAirMap/pull/452