Problem On Finance Page of FSA Web Site

Please report Bugs and Problems here
Myrm
Flight Attendant
Posts: 123
Joined: Thu Jun 21, 2007 2:29 pm
Location: Living in a giant ants nest in Sweden

Problem On Finance Page of FSA Web Site

Post by Myrm » Sun Aug 09, 2009 9:01 am

Hi

Apologies if this has already been brought to your attention (I did have a look but couldn't find any like posts):

When going to the Finances Page of my VA (Swedish Airways), I get the following error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/fsa_www/public_html/finances.php5 on line 17

I am still able to see the graph etc.

I use Firefox 3.5.2 on Vista Ultimate 64-bit (SP2).

I also tried the same page with IE 8 but get the same error.
Myrm

"Glöm inte vår Tobias" (In memory of Tobias Enroth 1999-2007)

Image

Motomad1
Flight Attendant
Posts: 130
Joined: Tue Jun 09, 2009 7:59 am
Location: Australia
Contact:

Re: Problem On Finance Page of FSA Web Site

Post by Motomad1 » Sun Aug 09, 2009 9:30 am

Yes i get the same problem and im using Firefox, but i can see the graph and all the Text/Info.
ImageImage
Image

alasizon
FSAirlines DB and Wiki Admin
Posts: 865
Joined: Tue Apr 08, 2008 2:08 am
Location: PHX

Re: Problem On Finance Page of FSA Web Site

Post by alasizon » Sun Aug 09, 2009 4:27 pm

It's been noted in three different threads now, I am sure Joe is working on fixing it.
Matt-FSAirlines DB Admin
Image

Myrm
Flight Attendant
Posts: 123
Joined: Thu Jun 21, 2007 2:29 pm
Location: Living in a giant ants nest in Sweden

Re: Problem On Finance Page of FSA Web Site

Post by Myrm » Sun Aug 09, 2009 4:44 pm

alasizon wrote:It's been noted in three different threads now, I am sure Joe is working on fixing it.
Then I apologise for making a new thread on it, I didn't see the others. :oops:
Myrm

"Glöm inte vår Tobias" (In memory of Tobias Enroth 1999-2007)

Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Problem On Finance Page of FSA Web Site

Post by joefremont » Sun Aug 09, 2009 6:41 pm

Myrm wrote:
alasizon wrote:It's been noted in three different threads now, I am sure Joe is working on fixing it.
Then I apologise for making a new thread on it, I didn't see the others. :oops:
Don't apologise, it got my attention and its fixed now.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

hezza
Captain
Posts: 205
Joined: Mon Mar 17, 2008 6:08 pm
Location: Banbury

Re: Problem On Finance Page of FSA Web Site

Post by hezza » Sun Aug 09, 2009 7:22 pm

Don't apologise, it got my attention and its fixed now.
Thanks for the attention. In my case however the problem has merely changed.
Instead of the previous mysql error, the graph now shows a (very) incorrect balance.

EDIT:

The last transaction (an aircraft purchase) is not showing either.

G
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Problem On Finance Page of FSA Web Site

Post by joefremont » Sun Aug 09, 2009 8:29 pm

Yup, I see that, how does it look now.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

hezza
Captain
Posts: 205
Joined: Mon Mar 17, 2008 6:08 pm
Location: Banbury

Re: Problem On Finance Page of FSA Web Site

Post by hezza » Sun Aug 09, 2009 8:35 pm

The balance now shows correctly (including the last transaction), but that transaction is still not listed, even after logging out, clearing caches and logging back in.

G
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Problem On Finance Page of FSA Web Site

Post by joefremont » Mon Aug 10, 2009 12:07 am

Yes, Sorry about that, fixed now.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

alasizon
FSAirlines DB and Wiki Admin
Posts: 865
Joined: Tue Apr 08, 2008 2:08 am
Location: PHX

Re: Problem On Finance Page of FSA Web Site

Post by alasizon » Mon Aug 10, 2009 1:27 am

joefremont wrote:Yes, Sorry about that, fixed now.
Actually for me Joe it's still not showing the last transaction. (Last one shown is a 03:30 leasing transaction when I did have another B744 go out later in the day so...)
Matt-FSAirlines DB Admin
Image

User avatar
Quantum
FSAirlines DB Admin
Posts: 1439
Joined: Sat Apr 29, 2006 8:23 pm
Location: UK

Re: Problem On Finance Page of FSA Web Site

Post by Quantum » Mon Aug 10, 2009 4:01 pm

Hi Joe,

A quick scan amongst VA's who have flown today (inc CBFS) is that the finance pages are 'lagging' behind by one flight transaction. I noticed it yesterday when the last flight on our log wasn't showing on the finance page. A few flights have been flown since and the flights are getting reported except the last, which will only appear when another flight is completed.

Regards

John
CEO - Classic British Flight Services
Classic aircraft on Classic routes
ImageImage

User avatar
flightsimer
Chief Pilot
Posts: 1815
Joined: Tue Oct 09, 2007 3:35 am

Re: Problem On Finance Page of FSA Web Site

Post by flightsimer » Tue Aug 11, 2009 10:39 pm

yup same for me... i got 2 messages on aircraft being leased today, then got scared when i looked at my finances thinking they might have got a free lease since nothing for the second one was there... looked at the airline's finances page and it showed both being made so i figured it was a bug...
Owner/CEO
North Eastern Airways

Image
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: Problem On Finance Page of FSA Web Site

Post by joefremont » Wed Aug 12, 2009 2:50 am

I made a patch to show the correct value, while I track down the real problem.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

Motomad1
Flight Attendant
Posts: 130
Joined: Tue Jun 09, 2009 7:59 am
Location: Australia
Contact:

Re: Problem On Finance Page of FSA Web Site

Post by Motomad1 » Wed Aug 12, 2009 8:56 am

Yep all those links have gone for me, not sure how up-to-date the Finance page is, as you guys were saying
ImageImage
Image

User avatar
flightsimer
Chief Pilot
Posts: 1815
Joined: Tue Oct 09, 2007 3:35 am

Re: Problem On Finance Page of FSA Web Site

Post by flightsimer » Tue Aug 18, 2009 5:05 am

i just noticed, i cant page back in time. went to go look for something on the next page but couldnt.
Owner/CEO
North Eastern Airways

Image
Image

Post Reply