On /statistics/registration: error : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'registration_count' in 'order clause'

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

On /statistics/registration: error : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'registration_count' in 'order clause' #349

Closed daviessm closed 6 years ago

daviessm commented 6 years ago

Page shows data, but above the graph this error is shown:

MOST COMMON AIRCRAFT REGISTRATIONS
Below are the Top 10 most common aircraft registrations.

error : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'registration_count' in 'order clause'

daviessm commented 6 years ago

Looks like lines 465, 466, 477, 478 in class.Stats.php should be order by s.cnt desc. Haven't set up a local repository yet to do a PR!

Ysurac commented 6 years ago

thanks