Few Errors, Some With New version, some were there before!

phpVMS Legacy Support (v2/v5)
1

Hi Nabeel,

Some errors i need help with.

First; When i try to add a download i  get this error: Unknown column ‘description’ in ‘field list’  - Note this was here before i updated to the latest release aswell and has still not gone.

Also, I dont know whether this is an error but only in the past couple of months the website is saying;

* Total Pilots: 14  - Correct

* Total Flights: 595 - Correct

* Total Hours Flown: 63.51 - Incorrect!

We have over 3,000hrs flying time and its a bit weird

Finally, The routemap error i reported still doesnt work, Since i updated though i get a new error:

Warning: Invalid argument supplied for foreach() in /home/pulseair/public_html/members/core/modules/RouteMap/RouteMap.php on line 56

Warning: Division by zero in /home/pulseair/public_html/members/core/modules/RouteMap/RouteMap.php on line 80

Warning: Division by zero in /home/pulseair/public_html/members/core/modules/RouteMap/RouteMap.php on line 81

Thomas.

PS- Love the work with the new release, well done sir!

2

Can you run the /install/checkdb.php and paste the output?

Thanks, I’ll take a look. I didn’t announce the new version yet because I thought there might still be a few issues, so I can just have another quick update. Also, where is that “total hours flown” shown? And running a reset in Maintenance doesn’t help?

And which map type? Do all those airports exist with routes?

3

Also, do a me a favor.

http://downloads.phpvms.net

Download the phpvms_unittest.zip, extract to your phpVMS install (there should be a unittest folder), then run:

/unittest/run_tests.php

Or link me to it

4

And can someone else verify this?

5

Well i think you have just found the problem with the downloads,

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...
[ERROR] The column description is missing! 
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_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

Think i need to add a “description” column to the database?

Link sent to you.

6

For the hours, just go to the update hours in the maintenance part in the admin panel, that should recalculate the hours and put the correct hours up.

Cheers

Dan C

7

Ok this and a few other issues fixed and released as a full release