Edwin

i did a complete reinstall a few days ago, but the issue remained. attached pilots.sql (renamed to txt)

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

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

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

could you please give me instruction how to do that?

i think i found the export, i attached a 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?

file attach

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.

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.

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

Yes i did.

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.

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