Internal Server Error

[flyalaska]

When I was resetting the finances, I got a Internal Server Error. Is there a permission that needs to be set for that?

[Nabeel]

Nope... that's a server problem... is it still doing that? I'd notify your host..

[flyalaska]

Nope... that's a server problem... is it still doing that? I'd notify your host..

You are my host!

[Nabeel]

You are my host!

Oh! Uh oh. Let me look at that then...weird. I didn't get an email notice. Looking at it right now... it's whenever you recalculate expenses?

[Nabeel]

Give it a shot now

[flyalaska]

Give it a shot now

Will resetting the finances set everything to 0.00? The reason I tried, my finances are in the hole big time.

http://www.flyaka.com/index.php/Finances/

My default fuel was at 5.10, changed the config to 1.10. So how do I fix the total outcome?

[Nabeel]

Will resetting the finances set everything to 0.00? The reason I tried, my finances are in the hole big time.

http://www.flyaka.co...x.php/Finances/

My default fuel was at 5.10, changed the config to 1.10. So how do I fix the total outcome?

It won't reset existing PIREPs.

[flyalaska]

Same Error

[Nabeel]

Same Error

Strange, can you send me a login? I know what the error is, just have to adjust a value

[flyalaska]

PM Sent

[Nabeel]

Thanks, it's not a server issue, it's a code problem... infinite loop or race condition. I added a bug:

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

Sorry for all the problems...

[flyalaska]

It's not a problem.

[Nabeel]

I have another update tomorrow, it'll be solved for that one...

[flyalaska]

ok, would that fix my screwed up finances?

http://www.flyaka.com/index.php/Finances/

[Nabeel]

Do you have expenses?

It seems to me like the cron/scheduled scripts haven't run. Empty the phpvms_updates table, and see if that helps. Are they just screwed up now? Or was it before the update?

[flyalaska]

Before the update, just never got around to it. No expenses yet.

[flyalaska]

I was looking at the finacedata table. ID in the total looks all whacked.

along with the other negatives.

[Nabeel]

Before the update, just never got around to it. No expenses yet.

Ah ok, then your PIREPs are probably not done correctly (fuel prices off, the pax/costs)

[flyalaska]

how do I fix that, do I need to go into each pirep and manually fix it?

[Nabeel]

how do I fix that, do I need to go into each pirep and manually fix it?

Since nothing is cached now, you can probalby update all the fuel prices using a sql query, something like

update phpvms_pireps set fuelunitcost='1.10'; 
update phpvms_pireps set fuelprice = fuelunitcost * fuelused;

That'll change the fuel price in bulk, and then the complete price.

That financedata table isn't used anymore, so I wouldn't worry about it

[flyalaska]

That changed all the prices in the database, the total still shows -1,149,305,157.47

[Nabeel]

That changed all the prices in the database, the total still shows -1,149,305,157.47

Yeah, you gotta go and fix them I guess, the ticket prices, pax counts, they all count yea

[flyalaska]

After the update, the reset finance option has disappeared.

[Nabeel]

After the update, the reset finance option has disappeared.

Yep, I took it out since it doesn't actually do anything anymore

[flyalaska]

Yep, I took it out since it doesn't actually do anything anymore

Okay! I'm trying to figure out how to get my finances back in the black. ANy ideas? Do I need to edit every pirep?

[Nabeel]

Okay! I'm trying to figure out how to get my finances back in the black. ANy ideas? Do I need to edit every pirep?

Yeah, I guess it'll come down to that, since they're all done live now and not cached