Premium Gate Search - Error Message

[jghastings]

Hi,

I'm airline 8330 in world 1194, and I'm getting the following message when trying to use premium gate search (which is paid for until 10th March):


Subquery returns more than 1 row
 
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/gate_search.php on line 453


I don't get offered any airports at all, regardless of what I set the search parameters to.

Any idea what's going on?

Thanks,
JG

[StephenM]

More than likely you have two entries for the March expiry of Gate Search. I'll take a look shortly.

[jghastings]

Bit of an update.

Just discovered that this problem is partially resolved in that I can now do some searches, but if I tick the "Show my own gates" box the message still comes up.

Not too much of a problem for now as I have a separate record of my own gates, but would be good if this could be looked into.

Thanks,
JG

[ScreamingEagle]

I'm having the same problem, it seems to be a small part of a bigger problem.

If you restrict the search to show airports less then 35 million or 40 million whatever your smallest hub is, it will work with the box checked.

You may run into problems when you go to add gates/build terminals.  I can no longer add routes because it will not let me create any gates (build or rent).

If you check your gate listings you probably have double entries for your hub(s).

Hopefully AM gets this fixed.

[StephenM]

Thanks for the updates, it is a different problem to what I had originally thought so I am looking into it now.

[StephenM]

Okay, we have a fix in place to prevent the problem from occurring in the future. It will be a bit longer before we have the gate numbers rectified (and the gate search errors disappear).