xacars/fspassengers pirep not pending [SOLVED]

Edwin · September 23, 2011

Hi,

Last week i've build up my phpvms website and all appears to go ok. I tried flying with xacars and also with fspassengers.

Both are logging the flight and i can export succesfully and I receive emails like:

A PIREP has been submitted by LUX0001 (pilot name) LUX1020: ELLX to EDDT Aircraft: 2 Flight Time: 0.52 Filed using: xacars Comment:

A PIREP has been submitted by LUX0001 (pilot name) LUX1024: ELLX to EDDW Aircraft: 2 Flight Time: 00.59 Filed using: fspax Comment: FSPassengers Flight.

However, i never receive any pending pirep in the admin center and also my flighthours do not go up.

I googled around and searched the forums here, but cant find any solution for my problem.

I did find how to turn on the debugger and started it. Then I filed the xacars again (saved the pirep to my hdd). Receiving the email again and in log.txt is filling up:

=====

Time: 09.23.11 20:53:31

=====

Time: 09.23.11 20:53:31

Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions

Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')

Error: (1364) - Field 'price' doesn't have a default value

=====

Somehow i think it has to do with the error showing up, but i can't find any solution for it.

Also the xacars.log is filling up with the following but no pending pireps for approval popping up:

=====

Time: 09.23.11 20:53:31

=====

Time: 09.23.11 20:53:31

/action.php/acars/xacars/pirep

=====

Time: 09.23.11 20:53:31

a:2:{s:5:"DATA1";s:15:"XACARS_MSFS|2.0";s:5:"DATA2";s:226:"LUX0001~~LUX1020~LX-LGI~28001~IFR~ELLX~EDDT~EDDT~22.09.2011 18:34~01:05~00:52~10329~9265~96~0~OFFLINE~1316709292~1316709829~1316713004~1316713230~108560~127090~117825~49.6322~6.21448~1243~52.5556~13.2915~131~2436~2604~311~468~";}

=====

Time: 09.23.11 20:53:31

Array

(

[pilotid] => 1

 => LUX

[flightnum] => 1020

[depicao] => ELLX

[arricao] => EDDT

[aircraft] => 2

[flighttime] => 0.52

[submitdate] => NOW()

[route] =>

[route_details] =>

[comment] =>

[fuelused] => 4685.15558973

[source] => xacars

[load] => 96

[log] =>

)

=====

Can anyone help me out with sorting this problem?

All i changed is the skin and modified the layout and such, database wise i didn't touch anything.

Thanks!

Best regards,

Edwin

simpilot · September 23, 2011

You will need to get rid of

Error: (1364) - Field 'price' doesn't have a default value

Make sure xACARS is reporting a price (I dont use xACARS so I can't help you with that)

or

Set a default value for the price column in the PIREPS data table - default it to 0.

Edwin · September 24, 2011

You will need to get rid of
Error: (1364) - Field 'price' doesn't have a default value
Make sure xACARS is reporting a price (I dont use xACARS so I can't help you with that)

or

Set a default value for the price column in the PIREPS data table - default it to 0.

How do i set a default value in that column?

I also tried with FSPax, but cant reproduce the error there unless I do another flight. I think i will do a small flight, see what comes up there.

Strider · September 24, 2011

Did you put a price into the field when putting the schedules into phpvms?

Edwin · September 24, 2011

Yes i did.

Edwin · September 24, 2011

I moved the install folder back in main website and ran checkdb and checkinstall:

These are the results:

phpVMS Virtual Airline Administration Software

Install Check

phpVMS Build Number: 934

Checking PHP version

[OK] PHP version is 5.3.8.x

ASP Tags

[OK] ASP-style tags are disabled

Checking connectivity...

[OK] Can contact outside servers

Checking for SimpleXML module...

[OK] SimpleXML module exists!

Checking file hashes for corrupt or mismatched files

[Checksum failed] /core/modules/ACARS/fspax.php did not match, possibly corrupt or out of date

I think for fspax this can cause files not to upload correctly.

I also did checkdb, but they gave all ok results:

phpVMS Virtual Airline Administration Software

Database Check

Checking phpvms_acarsdata...OK

Checking phpvms_adminlog...OK

Checking phpvms_aircraft...OK

Checking phpvms_airlines...OK

Checking phpvms_airports...OK

Checking phpvms_awards...OK

Checking phpvms_awardsgranted...OK

Checking phpvms_bids...OK

Checking phpvms_customfields...OK

Checking phpvms_downloads...OK

Checking phpvms_expenselog...OK

Checking phpvms_expenses...OK

Checking phpvms_fieldvalues...OK

Checking phpvms_financedata...OK

Checking phpvms_fuelprices...OK

Checking phpvms_groupmembers...OK

Checking phpvms_groups...OK

Checking phpvms_navdata...OK

Checking phpvms_news...OK

Checking phpvms_pages...OK

Checking phpvms_pilots...OK

Checking phpvms_pirepcomments...OK

Checking phpvms_pirepfields...OK

Checking phpvms_pireps...OK

Checking phpvms_pirepvalues...OK

Checking phpvms_ranks...OK

Checking phpvms_schedules...OK

Checking phpvms_sessions...OK

Checking phpvms_settings...OK

Checking phpvms_updates...OK

Strider · September 24, 2011

fspax.php

Reupload that file, and that should fix that problem. also are you on freehosting?

Edwin · September 24, 2011

no, i have a server build on my own based on windows 2008 with IIS+PHP and mysql. Everything works ok, except no data is written into the database after I send in my pirep.

When i add a bid and do the flight, flight finish, bid is removed because of complete, but nothing happens, but it detects that the flight is completed.

I just did a flight with FSPassengers, all went well. exported the flight, received an email, bid was removed from my va, but no pending pirep and no flight time added.

This appeared in the log:

 =====
Time: 09.25.11 10:37:02
FSPAX DEBUG
=====

=====
Time: 09.25.11 10:37:02
Array
(
   [FsPAskConnexion] => yes
   [userName] => LUX0001
   [Password] => none
)

=====

=====
Time: 09.25.11 10:37:02
a:3:{s:15:"FsPAskConnexion";s:3:"yes";s:8:"UserName";s:7:"LUX0001";s:8:"Password";s:4:"none";}
=====

=====
Time: 09.25.11 10:37:10
FSPAX DEBUG
=====

=====
Time: 09.25.11 10:37:10
Array
(
   [FsPAskToRegister] => yes
   [userName] => LUX0001
   [Password] => none
   [CompanyName] => Luxair
   [PilotName] => LUX0001
   [FlightId] => LUX1050
   [OnlineNetworkNbr] => 0
   [FlightDate] => 2011-09-25
   [AircraftName] => CS 737-200 Luxair LX-LGI
   [AircraftType] => MEJ
   [NbrPassengers] => 118
   [CargoWeight] => 0 lbs
   [Mtow] => 155499 lbs
   [startAircraftWeight] => 139629 lbs
   [EndAircraftWeight] => 135762 lbs
   [startFuelQuantity] => 6894 kg
   [EndFuelQuantity] => 5120 kg
   [DepartureIcaoName] => ELLX - Luxembourg - Luxembourg
   [ArrivalIcaoName] => EDDF - Frankfurt/Main - Germany
   [DepartureLocalHour] => 13:40
   [ArrivalLocalHour] => 14:02
   [DepartureGmtHour] => 11:40:00
   [ArrivalGmtHour] => 12:02:00
   [TotalBlockTime] => 00:22:24
   [TotalBlockTimeNight] => 00:00:00
   [TotalAirbornTime] => 00:21:09
   [TotalTimeOnGround] => 00:03:37
   [TotalDistance] => 95 Nm
   [MaxAltitude] => 17821ft
   [CruiseSpeed] => 306 kt
   [CruiseMachSpeed] => 0.48
   [CruiseTimeStartSec] => 468
   [CruiseTimeStopSec] => 1069
   [CruiseFuelStart] => 5707 kg
   [CruiseFuelStop] => 5354 kg
   [LandingSpeed] => 116 kt
   [LandingPitch] => 9.01
   [TouchDownVertSpeedFt] => -303.85
   [CaptainSentMayday] => 0
   [CrashFlag] => 0
   [FlightResult] => Perfect
   [MaxTimeAcceleration] => 1
   [FsPassengersVersion] => Dec 22 2008
   [PassengersOpinion] => 94
   [PassengersOpinionText] => 
   [FailureText] => 
   [CasualtiesText] => 
   [PilotBonusText] => You landed at the scheduled airport. (+30)<br>

   [bonusPoints] => 30
   [PilotPenalityText] => 
   [PenalityPoints] => 0
   [bitsPenalityDisabled] => 22528
)

=====

=====
Time: 09.25.11 10:37:10
a:52:{s:16:"FsPAskToRegister";s:3:"yes";s:8:"UserName";s:7:"LUX0001";s:8:"Password";s:4:"none";s:11:"CompanyName";s:6:"Luxair";s:9:"PilotName";s:7:"LUX0001";s:8:"FlightId";s:7:"LUX1050";s:16:"OnlineNetworkNbr";s:1:"0";s:10:"FlightDate";s:10:"2011-09-25";s:12:"AircraftName";s:24:"CS 737-200 Luxair LX-LGI";s:12:"AircraftType";s:3:"MEJ";s:13:"NbrPassengers";s:3:"118";s:11:"CargoWeight";s:5:"0 lbs";s:4:"Mtow";s:10:"155499 lbs";s:19:"StartAircraftWeight";s:10:"139629 lbs";s:17:"EndAircraftWeight";s:10:"135762 lbs";s:17:"StartFuelQuantity";s:7:"6894 kg";s:15:"EndFuelQuantity";s:7:"5120 kg";s:17:"DepartureIcaoName";s:30:"ELLX - Luxembourg - Luxembourg";s:15:"ArrivalIcaoName";s:31:"EDDF - Frankfurt/Main - Germany";s:18:"DepartureLocalHour";s:5:"13:40";s:16:"ArrivalLocalHour";s:5:"14:02";s:16:"DepartureGmtHour";s:8:"11:40:00";s:14:"ArrivalGmtHour";s:8:"12:02:00";s:14:"TotalBlockTime";s:8:"00:22:24";s:19:"TotalBlockTimeNight";s:8:"00:00:00";s:16:"TotalAirbornTime";s:8:"00:21:09";s:17:"TotalTimeOnGround";s:8:"00:03:37";s:13:"TotalDistance";s:5:"95 Nm";s:11:"MaxAltitude";s:7:"17821ft";s:11:"CruiseSpeed";s:6:"306 kt";s:15:"CruiseMachSpeed";s:4:"0.48";s:18:"CruiseTimeStartSec";s:3:"468";s:17:"CruiseTimeStopSec";s:4:"1069";s:15:"CruiseFuelStart";s:7:"5707 kg";s:14:"CruiseFuelStop";s:7:"5354 kg";s:12:"LandingSpeed";s:6:"116 kt";s:12:"LandingPitch";s:4:"9.01";s:20:"TouchDownVertSpeedFt";s:7:"-303.85";s:17:"CaptainSentMayday";s:1:"0";s:9:"CrashFlag";s:1:"0";s:12:"FlightResult";s:7:"Perfect";s:19:"MaxTimeAcceleration";s:1:"1";s:19:"FsPassengersVersion";s:11:"Dec 22 2008";s:17:"PassengersOpinion";s:2:"94";s:21:"PassengersOpinionText";s:0:"";s:11:"FailureText";s:0:"";s:14:"CasualtiesText";s:0:"";s:14:"PilotBonusText";s:47:"You landed at the scheduled airport. (+30)<br>
";s:11:"BonusPoints";s:2:"30";s:17:"PilotPenalityText";s:0:"";s:14:"PenalityPoints";s:1:"0";s:20:"BitsPenalityDisabled";s:5:"22528";}
=====

=====
Time: 09.25.11 10:37:10
Array
=====

I found this in the log.txt:

=====
Time: 09.25.11 10:37:10
=====
Time: 09.25.11 10:37:10
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->fspax > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1050', 'ELLX', 'EDDF', '', '', '94.237023274118', '2', '00.22', '00:22:00', '-303.85', NOW(), 0, 'CompanyName=Luxair<br />rnPilotName=LUX0001<br />rnFlightId=LUX1050<br />rnOnlineNetworkNbr=0<br />rnFlightDate=2011-09-25<br />rnAircraftName=CS 737-200 Luxair LX-LGI<br />rnAircraftType=MEJ<br />rnNbrPassengers=118<br />rnCargoWeight=0 lbs<br />rnMtow=155499 lbs<br />rnStartAircraftWeight=139629 lbs<br />rnEndAircraftWeight=135762 lbs<br />rnStartFuelQuantity=6894 kg<br />rnEndFuelQuantity=5120 kg<br />rnDepartureIcaoName=ELLX - Luxembourg - Luxembourg<br />rnArrivalIcaoName=EDDF - Frankfurt/Main - Germany<br />rnDepartureLocalHour=13:40<br />rnArrivalLocalHour=14:02<br />rnDepartureGmtHour=11:40:00<br />rnArrivalGmtHour=12:02:00<br />rnTotalBlockTime=00:22:24<br />rnTotalBlockTimeNight=00:00:00<br />rnTotalAirbornTime=00:21:09<br />rnTotalTimeOnGround=00:03:37<br />rnTotalDistance=95 Nm<br />rnMaxAltitude=17821ft<br />rnCruiseSpeed=306 kt<br />rnCruiseMachSpeed=0.48<br />rnCruiseTimeStartSec=468<br />rnCruiseTimeStopSec=1069<br />rnCruiseFuelStart=5707 kg<br />rnCruiseFuelStop=5354 kg<br />rnLandingSpeed=116 kt<br />rnLandingPitch=9.01<br />rnTouchDownVertSpeedFt=-303.85<br />rnCaptainSentMayday=0<br />rnCrashFlag=0<br />rnFlightResult=Perfect<br />rnMaxTimeAcceleration=1<br />rnFsPassengersVersion=Dec 22 2008<br />rnPassengersOpinion=94<br />rnPassengersOpinionText=<br />rnFailureText=<br />rnCasualtiesText=<br />rnPilotBonusText=You landed at the scheduled airport. (+30)<br>n<br />rnBonusPoints=30<br />rnPilotPenalityText=<br />rnPenalityPoints=0<br />rnBitsPenalityDisabled=22528<br />rn', '118', '1774', '0', 'fspax', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.23.11 20:53:31
=====
Time: 09.23.11 20:53:31
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.23.11 21:05:42
=====
Time: 09.23.11 21:05:42
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 20:45:23
=====
Time: 09.24.11 20:45:23
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 20:49:36
=====
Time: 09.24.11 20:49:36
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.81.113.252' WHERE `pilotid`=
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====


=====

=====
Time: 09.24.11 20:50:46
=====
Time: 09.24.11 20:50:46
Backtrace: DB::write_debug > DB::query > SchedulesData::addSchedule > Operations->add_schedule_post > Operations->schedules > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_schedules (`code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `aircraft`, `flightlevel`, `distance`, `deptime`, `arrtime`, `flighttime`, `daysofweek`, `price`, `flighttype`, `notes`, `enabled`) VALUES ('LUX', '1020', 'ELLX', 'EDDT', '', '', '2', '28000', '319.84405589721', '10:00', '11:00', '1.00', '0123456', '', 'P', '', 1)
Error: (1265) - Data truncated for column 'price' at row 1
=====


=====

=====
Time: 09.24.11 20:52:39
=====
Time: 09.24.11 20:52:39
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 21:20:42
=====
Time: 09.24.11 21:20:42
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 21:37:03
=====
Time: 09.24.11 21:37:03
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 21:43:36
=====
Time: 09.24.11 21:43:36
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS_Free->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.81.113.252' WHERE `pilotid`=
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====


=====

=====
Time: 09.24.11 21:43:52
=====
Time: 09.24.11 21:43:52
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS_Free->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.81.113.252' WHERE `pilotid`=
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====


=====

=====
Time: 09.24.11 21:44:16
=====
Time: 09.24.11 21:44:16
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS_Free->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.81.113.252' WHERE `pilotid`=
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: CREATE TABLE `phpvms_expenselog` ( `dateadded` INT NOT NULL , `name` VARCHAR( 25 ) NOT NULL , `type` VARCHAR( 2 ) NOT NULL , `cost` FLOAT NOT NULL , INDEX ( `dateadded` ) ) ENGINE = MYISAM ;
Error: (1050) - Table 'phpvms_expenselog' already exists
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `lastip` VARCHAR( 25 ) NULL DEFAULT '';
Error: (1060) - Duplicate column name 'lastip'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `rankid` INT NOT NULL DEFAULT '0' AFTER `transferhours` ;
Error: (1060) - Duplicate column name 'rankid'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `ranklevel` INT NOT NULL DEFAULT '0' AFTER `rank` ;
Error: (1060) - Duplicate column name 'ranklevel'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pireps` ADD `gross` FLOAT NOT NULL AFTER `flighttype`;
Error: (1060) - Duplicate column name 'gross'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pireps` ADD `route` TEXT NOT NULL AFTER `arricao`, ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_acarsdata` ADD `route` TEXT NOT NULL AFTER `arrtime`, ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_schedules` DROP `maxload` ;
Error: (1091) - Can't DROP 'maxload'; check that column/key exists
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_schedules` ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route_details'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_aircraft` ADD `minrank` INT NOT NULL DEFAULT '0' AFTER `maxcargo`;
Error: (1060) - Duplicate column name 'minrank'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_aircraft` ADD `ranklevel` INT NOT NULL DEFAULT '0' AFTER `minrank` ;
Error: (1060) - Duplicate column name 'ranklevel'
=====


=====

=====
Time: 09.24.11 21:57:08
=====
Time: 09.24.11 21:57:08
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: -- It's sometimes missing INSERT INTO `phpvms_settings` VALUES(NULL , 'Total VA Hours', 'TOTAL_HOURS', '0', 'Your total hours', 0);
Error: (1062) - Duplicate entry 'TOTAL_HOURS' for key 'name'
=====


=====

=====
Time: 09.24.11 21:57:40
=====
Time: 09.24.11 21:57:40
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.81.113.252' WHERE `pilotid`=
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====


=====

=====
Time: 09.24.11 22:05:42
=====
Time: 09.24.11 22:05:42
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=0 WHERE `pilotid`=1
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====


=====

=====
Time: 09.24.11 22:05:42
=====
Time: 09.24.11 22:05:42
Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions
Query: UPDATE phpvms_pilots SET `totalpireps`=0 WHERE `pilotid`=2
Error: (1054) - Unknown column 'totalpireps' in 'field list'
=====


=====

=====
Time: 09.24.11 22:06:38
=====
Time: 09.24.11 22:06:38
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->xacars > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1020', 'ELLX', 'EDDT', '', '', '319.84405589721', '2', '0.52', '0:52:00', '0', NOW(), 0, '', '96', '4685.15558973', '0', 'xacars', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: CREATE TABLE `phpvms_expenselog` ( `dateadded` INT NOT NULL , `name` VARCHAR( 25 ) NOT NULL , `type` VARCHAR( 2 ) NOT NULL , `cost` FLOAT NOT NULL , INDEX ( `dateadded` ) ) ENGINE = MYISAM ;
Error: (1050) - Table 'phpvms_expenselog' already exists
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `lastip` VARCHAR( 25 ) NULL DEFAULT '';
Error: (1060) - Duplicate column name 'lastip'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `rankid` INT NOT NULL DEFAULT '0' AFTER `transferhours` ;
Error: (1060) - Duplicate column name 'rankid'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pilots` ADD `ranklevel` INT NOT NULL DEFAULT '0' AFTER `rank` ;
Error: (1060) - Duplicate column name 'ranklevel'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pireps` ADD `gross` FLOAT NOT NULL AFTER `flighttype`;
Error: (1060) - Duplicate column name 'gross'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_pireps` ADD `route` TEXT NOT NULL AFTER `arricao`, ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_acarsdata` ADD `route` TEXT NOT NULL AFTER `arrtime`, ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_schedules` DROP `maxload` ;
Error: (1091) - Can't DROP 'maxload'; check that column/key exists
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_schedules` ADD `route_details` TEXT NOT NULL AFTER `route`;
Error: (1060) - Duplicate column name 'route_details'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_aircraft` ADD `minrank` INT NOT NULL DEFAULT '0' AFTER `maxcargo`;
Error: (1060) - Duplicate column name 'minrank'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: ALTER TABLE `phpvms_aircraft` ADD `ranklevel` INT NOT NULL DEFAULT '0' AFTER `minrank` ;
Error: (1060) - Duplicate column name 'ranklevel'
=====


=====

=====
Time: 09.24.11 22:10:00
=====
Time: 09.24.11 22:10:00
Backtrace: DB::write_debug > DB::query > Installer::sql_file_update
Query: -- It's sometimes missing INSERT INTO `phpvms_settings` VALUES(NULL , 'Total VA Hours', 'TOTAL_HOURS', '0', 'Your total hours', 0);
Error: (1062) - Duplicate entry 'TOTAL_HOURS' for key 'name'
=====


=====

=====
Time: 09.25.11 10:37:10
=====
Time: 09.25.11 10:37:10
Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->fspax > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'LUX', '1050', 'ELLX', 'EDDF', '', '', '94.237023274118', '2', '00.22', '00:22:00', '-303.85', NOW(), 0, 'CompanyName=Luxair<br />rnPilotName=LUX0001<br />rnFlightId=LUX1050<br />rnOnlineNetworkNbr=0<br />rnFlightDate=2011-09-25<br />rnAircraftName=CS 737-200 Luxair LX-LGI<br />rnAircraftType=MEJ<br />rnNbrPassengers=118<br />rnCargoWeight=0 lbs<br />rnMtow=155499 lbs<br />rnStartAircraftWeight=139629 lbs<br />rnEndAircraftWeight=135762 lbs<br />rnStartFuelQuantity=6894 kg<br />rnEndFuelQuantity=5120 kg<br />rnDepartureIcaoName=ELLX - Luxembourg - Luxembourg<br />rnArrivalIcaoName=EDDF - Frankfurt/Main - Germany<br />rnDepartureLocalHour=13:40<br />rnArrivalLocalHour=14:02<br />rnDepartureGmtHour=11:40:00<br />rnArrivalGmtHour=12:02:00<br />rnTotalBlockTime=00:22:24<br />rnTotalBlockTimeNight=00:00:00<br />rnTotalAirbornTime=00:21:09<br />rnTotalTimeOnGround=00:03:37<br />rnTotalDistance=95 Nm<br />rnMaxAltitude=17821ft<br />rnCruiseSpeed=306 kt<br />rnCruiseMachSpeed=0.48<br />rnCruiseTimeStartSec=468<br />rnCruiseTimeStopSec=1069<br />rnCruiseFuelStart=5707 kg<br />rnCruiseFuelStop=5354 kg<br />rnLandingSpeed=116 kt<br />rnLandingPitch=9.01<br />rnTouchDownVertSpeedFt=-303.85<br />rnCaptainSentMayday=0<br />rnCrashFlag=0<br />rnFlightResult=Perfect<br />rnMaxTimeAcceleration=1<br />rnFsPassengersVersion=Dec 22 2008<br />rnPassengersOpinion=94<br />rnPassengersOpinionText=<br />rnFailureText=<br />rnCasualtiesText=<br />rnPilotBonusText=You landed at the scheduled airport. (+30)<br>n<br />rnBonusPoints=30<br />rnPilotPenalityText=<br />rnPenalityPoints=0<br />rnBitsPenalityDisabled=22528<br />rn', '118', '1774', '0', 'fspax', 0, '')
Error: (1364) - Field 'price' doesn't have a default value
=====


=====

=====
Time: 09.25.11 10:37:10
=====
Time: 09.25.11 10:37:10
Backtrace: DB::write_debug > DB::query > PIREPData::addComment > PIREPData::fileReport > ACARSData::FilePIREP > include_once > ACARS->__call > ACARS->fspax > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_pirepcomments (`pirepid`, `pilotid`, `comment`, `postdate`) VALUES (, 1, 'FSPassengers Flight. No aircraft entered', NOW())
Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'FSPassengers Flight. No aircraft entered', NOW())' at line 2
=====


=====


=====

It gives errors, but don't know how to fix that.

Edited September 28, 2011 by joeri
made it a bit more vieuwable

Edwin · September 30, 2011

Since i can't get any proper response and can't find the problem myself, i decided not to use this program for my flight registrations.

program itself looks very great and very easy to set up (followed the dummy guide) but somehow i cannot get it to work, it's a pity, as it looks great.

joeri · September 30, 2011

shoot me over a pm i will look at it

Edwin · October 4, 2011

file attach

Nabeel · October 4, 2011

That's strange - what MySQL version are you running?

Can you do an export table for the pireps table?

Nabeel · October 4, 2011

It looks to me your database didn't setup correctly.

Did you run the installer, or manually import the SQL file?

Edwin · October 4, 2011

It looks to me your database didn't setup correctly.

Did you run the installer, or manually import the SQL file?

I ran the installer

I downloaded the latest version of mysql from the mysql website: 5.2.34 CE revision 7780 when i do mysql workbench about.

i followed the mysql instructions in the dummy guide to create the database basics and added the create delete etc..

how do i do an export table in mysql?

Edwin · October 4, 2011

I ran the installer

I downloaded the latest version of mysql from the mysql website: 5.2.34 CE revision 7780 when i do mysql workbench about.

i followed the mysql instructions in the dummy guide to create the database basics and added the create delete etc..

how do i do an export table in mysql?

i think i found the export, i attached a file

Nabeel · October 4, 2011

I need the .sql dump file, with the table structure, no data

Edwin · October 4, 2011

I need the .sql dump file, with the table structure, no data

could you please give me instruction how to do that?

Nabeel · October 4, 2011

What tool are you using? Just a screenshot of the columns will be fine.

Edwin · October 4, 2011

What tool are you using? Just a screenshot of the columns will be fine.

This ok?

I found how to dump, but getting the following error:

WARNING

Error checking mysqldump version

Could not parse version number from mysqldump.exe:

mysqldump: unknown variable 'set-variable=max_allowed_packet=16M'

googling now how to fix this error

Edwin · October 4, 2011

fixed my export error..

i made the dump, but had to rename it.. txt extension should be sql

Nabeel · October 4, 2011

Thanks, what phpVMS version?

Edwin · October 4, 2011

that would be 934

i found a file named version and it has above numbers in it, so i asume its 934

Nabeel · October 4, 2011

What about the pilots table?

Can you do a complete reinstall from scratch? For some reason, your tables aren't created properly. I wonder if it's a MySQL issue

Edwin · October 4, 2011

What about the pilots table?

Can you do a complete reinstall from scratch? For some reason, your tables aren't created properly. I wonder if it's a MySQL issue

i did a complete reinstall a few days ago, but the issue remained.

attached pilots.sql (renamed to txt)

Nabeel · October 4, 2011

Strange... make sure you have prices for all of your schedules... I think that's what's missing

Edwin · October 4, 2011

Strange... make sure you have prices for all of your schedules... I think that's what's missing

I created only one schedule and added something like 65 in it.

Nabeel · October 4, 2011

Can you run this ALTER statement and try?

ALTER TABLE  `phpvms_pireps` CHANGE  `price`  `price` FLOAT NULL DEFAULT  '0';

Edwin · October 5, 2011

Can you run this ALTER statement and try?
ALTER TABLE  `phpvms_pireps` CHANGE  `price`  `price` FLOAT NULL DEFAULT  '0';

i think i altered the it now and will check with a flight and let you know outcome

Edwin · October 6, 2011

just did a flight, price error is gone, but new error appeared:

Time: 10.06.11 21:13:53

Backtrace: DB::write_debug > DB::query > PIREPData::fileReport > ACARSData::FilePIREP > kACARS_Free->index > call_user_func_array > MainController::RunAllActions

Query: INSERT INTO phpvms_pireps( `pilotid`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `distance`, `aircraft`, `flighttime`, `flighttime_stamp`, `landingrate`, `submitdate`, `accepted`, `log`, `load`, `fuelused`, `expenselist`, `source`, `exported`, `rawdata`) VALUES ( 1, 'EDB', '1000', 'ELLX', 'EHRD', '', 'a:0:{}', '155.43734663832', '1', '00.40', '00:40:00', '-501', NOW(), 0, '[18:45] Aircraft Title - CS 737-200 KLM*[18:45] Aircraft Model - B732*[18:45] Flight Number EDB1000*[18:45] Departure ELLX*[18:45] Destination EHRD*[18:45] Boarding*[18:47] Taxiing to Runway*[18:47] Taking Off*[18:47] Taking Off*[18:47] 145kts*[18:47] pitch angle -13 degrees*[18:47] 45302 (lbs) of fuel onboard*[18:48] Climbing*[18:59] TOC Reached*[18:59] Cruise 24000*[19:02] TOD Reached*[19:02] Descending*[19:03] Simulator Paused*[19:05] Simulator Un-Paused*[19:15] On Approach*[19:17] Simulator Paused*[20:02] Simulator Un-Paused*[20:03] Simulator Paused*[20:04] Simulator Un-Paused*[20:05] Simulator Paused*[20:05] Simulator Un-Paused*[20:14] Landing Rate -501fpm*[20:14] 38483 (lbs) of fuel onboard*[20:14] pitch angle -12 degrees*[20:14] Taxiing to Gate*[20:15] Arrived*[20:15] Max Sim Rate: 1x*[20:15] kACARS_Free Version 1.0.1.0*', '105', '3276.29768851', '0', 'kACARS', 0, '')

Error: (1364) - Field 'gross' doesn't have a default value

the alter command i executed seem to have solved the error for the price, can i do the same command for the other fields as well?

Edwin · October 6, 2011

i found this on the internet:

http://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/

could it be that somehow my mysql installation is somehow newer and could cause some values not written correctly during installation?

I looked up my mysql installer and this is what it says: mysql-installer-5.5.15.0

xacars/fspassengers pirep not pending [SOLVED]

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation