smokey68 Posted January 6, 2017 Report Share Posted January 6, 2017 Error because of having flown 211 flights but no routes are shown. Just went from v2 to v5.5.x Anyone know what the problem might be ? Error when filing Pirep Quote Link to comment Share on other sites More sharing options...
web541 Posted January 6, 2017 Report Share Posted January 6, 2017 Are there any schedules in your database? (and do they show up in the admin) Did you just export the .sql from your v2 and import it into v5.5.x? Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 6, 2017 Author Report Share Posted January 6, 2017 I installed new version on another subdomain and connected the new version to existing old database yes schedules show in admin panel and every pilot can add a bid and do whatever but cannot file a manual pirep or see their existing flown flights all other information lays out correctly Quote Link to comment Share on other sites More sharing options...
web541 Posted January 6, 2017 Report Share Posted January 6, 2017 hmmm, if I do remember correctly, it would be better to set up a new installation, new database then import as there are a few differences with the database between the two versions and therefore phpVMS may not be picking it up correctly. Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 6, 2017 Author Report Share Posted January 6, 2017 its gotta be a script error and not database error Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 found out the problem no solution though here is the error the schedules are not enabled within the schedules in admin panel but when i enable it i get this error There was an error editing the schedule: Unknown column 'week1' in 'field list' Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 [ERROR] The column core is missing!Checking phpvms_ledger...OKChecking phpvms_navdata...OKChecking phpvms_news...OKChecking phpvms_pages...OKChecking phpvms_pilots...[ERROR] The column payadjust is missing![ERROR] The column comment is missing!Checking phpvms_pirepcomments...OKChecking phpvms_pirepfields...OKChecking phpvms_pireps...[ERROR] The column modifieddate is missing![ERROR] The column paytype is missing!Checking phpvms_pirepvalues...OKChecking phpvms_ranks...OKChecking phpvms_schedules...[ERROR] The column week1 is missing![ERROR] The column week2 is missing![ERROR] The column week3 is missing![ERROR] The column week4 is missing![ERROR] The column payforflight is missing! Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 ok i have ran the update php and maybe have everything working now Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted January 7, 2017 Administrators Report Share Posted January 7, 2017 1 hour ago, vbegin7 said: found out the problem no solution though here is the error the schedules are not enabled within the schedules in admin panel but when i enable it i get this error There was an error editing the schedule: Unknown column 'week1' in 'field list' As web541 mentioned above, it would be best to use the database from the 5.5.2 install and then move/copy the data from each 2.1.x table over. The 5.5.2 database includes several new fields within various tables - the schedules table being but one of those with additions. If I recall, 'schedules' table added week1, week2, week3, week4. You don't necessarily NEED to enter data into the additional fields in the 'schedules' table, but you do need to have those fields so as not to get the error you show above. Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 its fixed all i had forgot to do was to run update.php and it fixed self in seconds Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 i do have one error ive had for a long time now ive seached forums and done everything possible when i submit pireps to vacentral i get somthin like this FAILED exporting PIREP #3723 - No response from API serverFAILED exporting PIREP #3722 - No response from API serverFAILED exporting PIREP #3721 - No response from API serverFAILED exporting PIREP #3720 - No response from API serverFAILED exporting PIREP #3719 - No response from API server i have changed api.vacentral.net to the api.phpvms.net and added config set xml but still no go Quote Link to comment Share on other sites More sharing options...
smokey68 Posted January 7, 2017 Author Report Share Posted January 7, 2017 What is the right Vacentral API URL ? Quote Link to comment Share on other sites More sharing options...
web541 Posted January 7, 2017 Report Share Posted January 7, 2017 Just to clarify, you should have this in your local.config.php file Config::set('VACENTRAL_DATA_FORMAT', 'xml'); Config::Set('VACENTRAL_ENABLED', true); Config::Set('VACENTRAL_API_SERVER', 'http://api.vacentral.net'); Config::Set('VACENTRAL_API_KEY', '----------Your Key--------------'); Config::Set('PHPVMS_API_SERVER', 'http://api.vacentral.net'); If you have this and it's still not working, post an issue in the vaCentral support forum because simpilot may have to help you on this one. Quote Link to comment Share on other sites More sharing options...
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.