Nabeel

What webserver and OS?

Give 931 a shot..

Thanks! Back now, though

I'm moving this to addons

Updated Tickets: [VMS-283] - TOTAL_HOURS missing in install/update [VMS-284] - Pilot pay not calculated correctly [VMS-285] - Use 7 for Sunday in addition to 0 [VMS-286] - Edit Expenses shows error [VMS-287] - Cache issues with airlines [VMS-288] - Add 'asp_tags' check to checkinstall script Changed Files: m admin/templates/finance_expenselist.tpl m core/common/OperationsData.class.php m core/common/PIREPData.class.php m core/templates/schedule_results.tpl m core/version m install/checkinstall.php m install/hashlist m install/install.sql m install/structure.xml m install/update.sql VMS-283 VMS-284 VMS-285 VMS-286 VMS-287 VMS-288 #closed fixed View complete changes Download from here

Changed Files: m admin/templates/finance_expenselist.tpl m core/common/OperationsData.class.php m core/common/PIREPData.class.php m core/templates/schedule_results.tpl m core/version m install/checkinstall.php m install/hashlist m install/install.sql m install/structure.xml m install/update.sql VMS-283 VMS-284 VMS-285 VMS-286 VMS-287 VMS-288 #closed fixed View complete changes Download from here

Updated Tickets: [VMS-283] - TOTAL_HOURS missing in install/update [VMS-284] - Pilot pay not calculated correctly [VMS-285] - Use 7 for Sunday in addition to 0 [VMS-286] - Edit Expenses shows error [VMS-287] - Cache issues with airlines [VMS-288] - Add 'asp_tags' check to checkinstall script Changed Files: m admin/templates/finance_expenselist.tpl m core/common/OperationsData.class.php m core/common/PIREPData.class.php m core/templates/schedule_results.tpl m core/version m install/checkinstall.php m install/hashlist m install/install.sql m install/structure.xml m install/update.sql VMS-283 VMS-284 VMS-285 VMS-286 VMS-287 VMS-288 #closed fixed View complete changes Download from here

Looks like a Windows server with that path. Error 500 is a server error, check your server logs, might be some clues in there

No prob! Let us know if you need more help!

DO NOT do this! Bad bad bad idea! I posted the fix for the problem above

Cool, I've fixed the bug, and it'll be in the next update. Thanks

That's going to break ALOT of things. There's a few other threads too, did you look through those? Like I said, I need those log files to see if there's anything wrong in there

Under maintenance, try clearing the cache

You're on the right track. You'd do: $position = PilotData::getFieldValue($pilot->pilotid, 'RANK'); // RANK is the name of the custom field $output = array(); $output[] = $pilotcode.' '. $pilot->firstname.' '.$pilot->lastname; $output[] = $position; $output[] = $pilot->rank.', '.$pilot->hub; $output[] = 'Total Flights: ' . $pilot->totalflights; $output[] = 'Total Hours: ' . $totalhours; Something like that

Crap. I guess it should be: SUM(p.pilotpay * p.flighttime) as pilotpay

Crap, bug added: http://bugs.phpvms.net/browse/VMS-286

Did you guys update the lib/js folder, specifically lib/js/phpvms.js?

The skeleton is in install/templates/config.tpl

http://bugs.phpvms.net/browse/VMS-285 Edit: The problem is the PHP date function says Sunday is 0. You can set in Excel that column as a string so it won't chop off the zero. Or in the schedule_results.tpl, you can do: Find this: if(strpos($route->daysofweek, date('w')) === false) continue; Right above that, add: /* Check if a 7 is being used for Sunday, since PHP thinks 0 is Sunday */ $route->daysofweek = str_replace('7', '0', $route->daysofweek); I've updated the default template to handle this

http://bugs.phpvms.net/browse/VMS-284

Bug added http://bugs.phpvms.net/browse/VMS-283

Can you guys enable debug_log and check the logs folder, and email me the the logs folder zipped up?

Create a custom field and make it private. Then in the generateSignatures() function in PilotData, you can call getFieldValue() I think to pull that value (look in the profile template for the exact call) and that'll output it in..

In LA for the weekend on work/mini-vacation!

Currently over the Rockies