MySQL Error

[alasizon]

In attempting to buy an aircraft, I got this:

MySQL errno 1054
MySQL error Unknown column 'Value_AC' in 'field list'
MySQL query INSERT INTO FlyNET_Accounts_VA (VA_ID, Value, Reason, TS, Object, Object_ID, Partner, Value_AC) VALUES ('1632', '-36000', 'Aircraft purchase', '1221336270', 'Nicollier Menestrel II', '15553', 'FlyNET System', '-36000')
Function Called from At line
0 stackTrace() /home/fsa_ftp/public_html/global_functions.php5 486
1 db_query() /home/fsa_ftp/public_html/aircraft_buy_n.php5 94
2 include() /home/fsa_ftp/public_html/index.php5 329

[alasizon]

Got another one today while attempting to purchase an A320.

MySQL errno 1054
MySQL error Unknown column 'Value_AC' in 'field list'
MySQL query INSERT INTO FlyNET_Accounts_VA (VA_ID, Value, Reason, TS, Object, Object_ID, Partner, Value_AC) VALUES ('1632', '-61000000', 'Aircraft purchase', '1221336270', 'Airbus A320', '15553', 'FlyNET System', '-61000000')
Function Called from At line
0 stackTrace() /home/fsa_ftp/public_html/global_functions.php5 486
1 db_query() /home/fsa_ftp/public_html/aircraft_buy_n.php5 94
2 include() /home/fsa_ftp/public_html/index.php5 329

[DaKurt]

Ok, lately we added some columns to the DB and it looks like that they have never been added to the fsairlines.net test-database. That might explain some other bugs (errors when uploading reports)

Joe is going to check that tonight and hopefully fix it

[Quantum]

Hi,

Looks like Joe has fixed this? Yesterday I was also getting mysql errors although the aircraft were placed on fleet at no charge. Scrapping them deleted them from fleet but no payment rcvd from scrap.
Did three trial purchases/scrapping today and all works perfectly.

Regards

John

[DaKurt]

yes Joe just fixed it