Edwin Posted September 23, 2011 Report Posted 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 Quote
Administrators simpilot Posted September 23, 2011 Administrators Report Posted 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. Quote
Edwin Posted September 24, 2011 Author Report Posted 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. Quote
Strider Posted September 24, 2011 Report Posted September 24, 2011 Did you put a price into the field when putting the schedules into phpvms? Quote
Edwin Posted September 24, 2011 Author Report Posted 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 Quote
Strider Posted September 24, 2011 Report Posted September 24, 2011 fspax.php Reupload that file, and that should fix that problem. also are you on freehosting? Quote
Edwin Posted September 24, 2011 Author Report Posted September 24, 2011 (edited) 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 Quote
Edwin Posted September 30, 2011 Author Report Posted 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. Quote
Moderators joeri Posted September 30, 2011 Moderators Report Posted September 30, 2011 shoot me over a pm i will look at it Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 That's strange - what MySQL version are you running? Can you do an export table for the pireps table? Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 It looks to me your database didn't setup correctly. Did you run the installer, or manually import the SQL file? Quote
Edwin Posted October 4, 2011 Author Report Posted 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? Quote
Edwin Posted October 4, 2011 Author Report Posted 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 Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 I need the .sql dump file, with the table structure, no data Quote
Edwin Posted October 4, 2011 Author Report Posted 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? Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 What tool are you using? Just a screenshot of the columns will be fine. Quote
Edwin Posted October 4, 2011 Author Report Posted 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 Quote
Edwin Posted October 4, 2011 Author Report Posted October 4, 2011 fixed my export error.. i made the dump, but had to rename it.. txt extension should be sql Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 Thanks, what phpVMS version? Quote
Edwin Posted October 4, 2011 Author Report Posted 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 Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted 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 Quote
Edwin Posted October 4, 2011 Author Report Posted 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) Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 Strange... make sure you have prices for all of your schedules... I think that's what's missing Quote
Edwin Posted October 4, 2011 Author Report Posted 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. Quote
Administrators Nabeel Posted October 4, 2011 Administrators Report Posted October 4, 2011 Can you run this ALTER statement and try? ALTER TABLE `phpvms_pireps` CHANGE `price` `price` FLOAT NULL DEFAULT '0'; Quote
Edwin Posted October 5, 2011 Author Report Posted 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 Quote
Edwin Posted October 6, 2011 Author Report Posted 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? Quote
Edwin Posted October 6, 2011 Author Report Posted 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.