Can't assign fleets

avalonceo · Post by **avalonceo** » Fri Jan 25, 2008 5:49 pm

Don't know if I messed something up or not, but when I tried to assign A/C to my fleets I got this message.

MySQL errno 1109
MySQL error Unknown table 'va' in where clause
MySQL query SELECT a.ID, a.Type, a.Registration, adb.Manufacturer, adb.Type, a.Fleet_ID FROM FlyNET_Aircrafts a, FlyNET_VirtualAirlines VA, FlyNET_Aircraft_DB adb WHERE a.Owner=va.Name AND va.ID='3785' AND adb.ID=a.ACDB_ID AND a.Fleet_ID != '250' ORDER BY a.Type, a.Registration, adb.Manufacturer, adb.Type
Function Called from At line
0 stacktrace() /hsphere/local/home/flynet/flynet.turksim.org/global_functions.php5 668
1 db_query() /hsphere/local/home/flynet/flynet.turksim.org/fleet_assign_ac.php5 25
2 include() /hsphere/local/home/flynet/flynet.turksim.org/index.php5 86

avalonceo · Post by **avalonceo** » Fri Jan 25, 2008 5:52 pm

The problem is since fixed, I simply selected a fleet I had created and then pressed assign, the appropriate checkboxes appeared when I did that

vaccaro · Post by **vaccaro** » Fri Jan 25, 2008 5:56 pm

Fixed for me too.
Thanks again Konny