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

update_db error #454

Closed hunnomad closed 4 years ago

hunnomad commented 4 years ago

PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'flightmap_db.spotter_output.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /data/www/mydomain.org/require/class.Spotter.php:9933 Stack trace:

0 /data/www/mydomain.org/require/class.Spotter.php(9933): PDOStatement->execute(Array)

1 /data/www/mydomain.org/require/class.Stats.php(2897): Spotter->countAllDatesLastMonth(Array)

2 /data/www/mydomain.org/scripts/update_db.php(117): Stats->addOldStats()

3 {main}

thrown in /data/www/mydomain.org/require/class.Spotter.php on line 9933