KCPilot

Hey I just did the update and now I'm not able to log into the site. Any ideas? Here is my DB check: Checking phpvms_acarsdata...OK Checking phpvms_adminlog... [ERROR] The table phpvms_adminlog is missing! Checking phpvms_aircraft...OK Checking phpvms_airlines...OK Checking phpvms_airports... [ERROR] The column chartlink is missing! Checking phpvms_awards...OK Checking phpvms_awardsgranted...OK Checking phpvms_bids... [ERROR] The column dateadded is missing! Checking phpvms_customfields... [ERROR] The column value is missing! 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... [ERROR] The column permissions is missing! 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... [ERROR] The column flighttime_stamp is missing! [ERROR] The column landingrate is missing! [ERROR] The column fuelunitcost is missing! [ERROR] The column revenue is missing! [ERROR] The column exported is missing! [ERROR] The column rawdata is missing! Checking phpvms_pirepvalues...OK Checking phpvms_ranks...OK Checking phpvms_schedules... [ERROR] The column flightlevel is missing! Checking phpvms_sessions... [ERROR] The table phpvms_sessions is missing! Checking phpvms_settings...OK Checking phpvms_updates...OK Thanks! KC

Okay, I watched the PIREP video that helped with the route. That will take a little training slide show. But now since we fly round-robins (a local) I get "The departure airport is the same as the arrival airport" Now yes this is not a common airline flight, but what if the airline was conducting training, RTB or a functional flight test? How would I fix that?

Nabeel, Sorry, I'm one of those old school pilots (round dials, lol) still learning this php/website stuff! The folks I’m working with in my VA really like your creation, but we are a Military VA, so we’re trying to modify some of the stuff to work for our operations. I do understand that we need to specify how to track the flight. For the most part we do use flight numbers/codes (aka Mission Numbers), but not all the time. Basically we will not use the flight and scheduling function maybe 60-75% of the time as the other flights will be tasked via email. So I guess we need a way to make the system take the 25-40% we do not have on the schedule. Also, I’ve added a flight to the schedule to try it out and get “The flight code and number you entered is not a valid route.” I’m not sure what the cause of that is. The route was enabled, unless I missed something. So back to your post, where would I put the flightnum=hidden in the code. I’ve tried it in the local config and didn’t want to mess with the other areas. Also what would the code be? Also, if I changed "hub" to "base" or "MAJCOM" would that screw things up (aka be a real bad thing?) Thanks for the help again! Also, I read in the past forum posts you guys might do a Mil version. If you do, I'd be happy to help with some inputs as to what we use. Regards, KC

I'm having issues with the PIREPS. I don't want to use the "Enter Flight Number" function so when I enter a PIREP and leave it blank I get: "You must fill out all of the required fields!" with Version 1.2.700 How do I make that not a required field? Thanks!

Okay, I used the "Full Version" with the "Update Version" and it got me in. Thanks Nabeel!

Nabeel; I'm using Version 1.2.764 from the from the "Download the latest beta (full install)" So should I be using the "Full Version" with the "Update Version"?

Hey, I'm having problems with the install. I'm new with all this php/MySQL stuff. So far after deleting everything in both the database and the phpVMS program itself and reloading it three different times I keep getting this message: 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)' at line 2 I'm running MySQL version 5.0.81-community. Thanks in advance for the help!