Airline Mogul Forum

Airline Mogul => Bugs => Topic started by: Coastal on April 09, 2008, 05:45:34 am

Title: alliance voting [PW4]
Post by: Coastal on April 09, 2008, 05:45:34 am
i am the only member in the alliance right now but when i go to vote another member in it gives me the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 152
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Table 'airlinem_airlinemogul.zworld4_alliance_vote' doesn't exist

then tells me the vote has failed but doesn't register a vote.
Title: alliance voting [PW4]
Post by: Air Elbonia on April 09, 2008, 05:07:08 pm
try now, there was a typo in that query.
Title: alliance voting [PW4]
Post by: Coastal on April 09, 2008, 07:11:42 pm
still a problem:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 152
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Unknown column 'vote_id' in 'where clause'


Also when you go to the page to vote this is above the voting box:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 152
Title: alliance voting [PW4]
Post by: dbesse757 on April 09, 2008, 09:28:05 pm
I got the same message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 152
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Unknown column 'vote_id' in 'where clause'
Title: alliance voting [PW4]
Post by: EvoAirways on April 10, 2008, 02:30:28 am
Getting the same issue here
Title: alliance voting [PW4]
Post by: Air Elbonia on April 10, 2008, 07:46:35 am
will try to address it when i wake up... i need to get a better sleep schedule.  3am here.
Title: alliance voting [PW4]
Post by: Air Elbonia on April 10, 2008, 04:47:27 pm
Alright. it's no longer 3am. and i think i found the last bug in it.  dumb typos... always some dumb typos that hide on me.

try now?
Title: alliance voting [PW4]
Post by: EvoAirways on April 10, 2008, 05:10:55 pm
Still not working. It says it has passed but it hasn't

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (`is_base`=1 OR `is_hub`=1 OR `is_focus`>0)' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Unknown column 'vote_id' in 'where clause'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'Congratulations, you have been accepted', 'Congratulations, you have been acce' at line 1
The Vote Has Passed due to your Executive Order.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (`is_base`=1 OR `is_hub`=1 OR `is_focus`>0)' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Unknown column 'vote_id' in 'where clause'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'Congratulations, you have been accepted', 'Congratulations, you have been acce' at line 1
The Vote Has Passed!

Warning: Division by zero in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 76
Title: Alliance Vote Probel - World 6
Post by: pilotolange on April 10, 2008, 06:43:34 pm
I am having the same problem in WORLD 6.  :?
Title: alliance voting [PW4]
Post by: kjodleiken on April 10, 2008, 10:09:22 pm
World 4
Airline ID: 11097

I get this message when i go into the voting screen:

Quote
Warning: Division by zero in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 76
Title: alliance voting [PW4]
Post by: EvoAirways on April 10, 2008, 11:28:44 pm
Staff and Coders I realize your busy and this is a free game, but this is a big issue for those of us that have took the 10+m hit to start our respective alliances. Twice now this has been "fixed" yet here we are a days later with the same error but a different message.
Title: alliance voting [PW4]
Post by: travismb99 on April 11, 2008, 02:09:18 am
Have patience :) I'm sure it's being worked on.
Title: alliance voting [PW4]
Post by: EvoAirways on April 11, 2008, 02:48:49 am
I'm being patient but were approaching 24 hours since the last communication from the staff on this issue.
Title: alliance voting [PW4]
Post by: dktc on April 11, 2008, 02:57:15 am
Sorry about that. 24 hours is quite a long time in this game.... (while maybe not in other games :P ).

A quick update.... I just gave Will his to-do list for today.... and he escaped from me :cry:  We are a bit burnt out at the moment I think. Definitely frustrated with the clustered bugs.
Title: alliance voting [PW4]
Post by: EUROPAir on April 11, 2008, 03:35:36 am
Same here.. can't one just get our members in their alliances?!
Title: alliance voting [PW4]
Post by: Air Elbonia on April 11, 2008, 03:51:16 am
Quote from: "EvoAirways"
Staff and Coders I realize your busy and this is a free game, but this is a big issue for those of us that have took the 10+m hit to start our respective alliances. Twice now this has been "fixed" yet here we are a days later with the same error but a different message.


sincerest apologies for my delay in fixing this. work and life has been crazy over the past 72 hours (as things tend to get during the work week, especially when doing taxes in the States shortly before April 15).

I've forced my way temporarily into FT alliance in world 6 and personally have done my best to test out my bug fixes this time (prior, i was unable to properly test this file out and unfortunately only reacted to posted bugs).  To the best of my knowledge, it appears every single bug thusfar mentioned has been fixed.  the div/0 is gone (100% sure), I can vote as a non CEO and (after refreshing... I'll have to work on that) the vote seems to register as yes/no appropriately.  several of those bugs were caused by a typo in setting the variable which says who properly to accept (dumb, dumb error on my part).

The only feature i have not tested out is the CEO's force vote, however much of the mechanics behind that feature are the same as the mechanics involved in simply voting yes/no.  Apologies again for my delinquency in addressing this bug.  I believe, sincerely, based on my personal investigations that much of the script is now working properly.  as stellar of a job as our beta group did, some bugs are invariably going to escape even their watchful eyes.  Unfortunately this was one of them.
Title: alliance voting [PW4]
Post by: Coastal on April 11, 2008, 04:11:36 am
the CEO pass function does work, but the reject function while removing the rejected airline from the pending list still leaves it as an open vote when you go into view all votes.  

Also this warning still appears on the vote page:

Warning: Division by zero in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/alliance_vote.php on line 79
Title: alliance voting [PW4]
Post by: Air Elbonia on April 12, 2008, 12:43:41 am
I admit it was a hasty patch, to which i'm unsure if i have 100% properly done.  I'm guessing that it was saying something about "vote_id" not existing, as I clearly saw a bug involving such a warning.

Also, a patch is in place that will work for the div/0.
Title: alliance voting [PW4]
Post by: Coastal on April 12, 2008, 05:05:15 am
Quote from: "Air Elbonia"
I admit it was a hasty patch, to which i'm unsure if i have 100% properly done.  I'm guessing that it was saying something about "vote_id" not existing, as I clearly saw a bug involving such a warning.

Also, a patch is in place that will work for the div/0.


yep that was vote_id was what it was saying