Errors

[smokey68]

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

[web541]

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?

[smokey68]

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

[web541]

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.

[smokey68]

its gotta be a script error and not database error

 

[smokey68]

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'

[smokey68]

[ERROR] The column core is missing!
Checking phpvms_ledger...OK
Checking phpvms_navdata...OK
Checking phpvms_news...OK
Checking phpvms_pages...OK
Checking phpvms_pilots...
[ERROR] The column payadjust is missing!
[ERROR] The column comment is missing!
Checking phpvms_pirepcomments...OK
Checking phpvms_pirepfields...OK
Checking phpvms_pireps...
[ERROR] The column modifieddate is missing!
[ERROR] The column paytype is missing!
Checking phpvms_pirepvalues...OK
Checking phpvms_ranks...OK
Checking 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!

[smokey68]

ok i have ran the update php and maybe have everything working now

[ProAvia]

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.

[smokey68]

its fixed all i had forgot to do was to run update.php and it fixed self in seconds

[smokey68]

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 server
FAILED exporting PIREP #3722 - No response from API server
FAILED exporting PIREP #3721 - No response from API server
FAILED exporting PIREP #3720 - No response from API server
FAILED 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

[smokey68]

What is the right Vacentral API URL ?

[web541]

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.