Premium Gate Search / OCP ?Glitch?

[ScreamingEagle]

OCP feature is greatly appreciated however I think it's causing a nasty chain reaction.  (I'm not a coder so I'm purely speculating).

World 1217
Airline 12344 - ZigZag

I accidentally clicked OCP purchase on a gate that I had previously constructed a terminal for.

This seams to have somewhat destroyed the terminal as I have had to build a new terminal with 5 gates in lieu of adding 1 gate.

Unrelated or not, when I now go to Gate Search to add routes, I get the following error message:

"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"

No route creation options are presented, just the error message.

I think I broke something :/

[ScreamingEagle]

Something is really messed.

Can no longer add any gates, either by renting or building.
giving the error message:

"You cannot extend this terminal, as you no longer use this airport as a base of operations."

when clearly there is a terminal built and the city is a base.

Gate search will not give the error when cities over 40 million are excluded from the search.

Seems like by clicking the OCP to rent a gate with a terminal has caused some damage :/

Help

edit:

seems to be multiple terminals causing something:

View     ATL     KATL     Hartsfield - Jackson Atlanta International     90,039,280     173     350,000     720,209         United States             Extend Terminal
View    ATL    KATL    Hartsfield - Jackson Atlanta International    90,039,280    173    350,000    720,209       United States    OCP      Rent
View    ATL    KATL    Hartsfield - Jackson Atlanta International    90,039,280    173    350,000    720,209       United States          Extend Terminal
View    ORD    KORD    Chicago O'Hare International    69,353,654    198    350,000    1,533,606       United States          Extend Terminal
View    ORD    KORD    Chicago O'Hare International    69,353,654    198    350,000    1,533,606       United States    OCP      Rent
View    ORD    KORD    Chicago O'Hare International    69,353,654    198    350,000    1,533,606       United States          Extend Terminal
View    LAX    KLAX    Los Angeles International    59,542,151    255    350,000    1,884,317       United States          Extend Terminal
View    LAX    KLAX    Los Angeles International    59,542,151    255    350,000    1,884,317       United States          Extend Terminal
View    DFW    KDFW    Dallas/Fort Worth International    57,069,331    222    350,000    8,388,607       United States          Extend Terminal
View    DFW    KDFW    Dallas/Fort Worth International    57,069,331    222    350,000    8,388,607       United States          Extend Terminal
View    DEN    KDEN    Denver International    51,435,575    181    300,000    267,294       United States          Extend Terminal

[pseudoswede]

This now appears to be related to this bug...

http://stephenm.org/smfforum/index.php?topic=11040.0

[StephenM]

I have removed the duplicates in this case so the error will disappear, but there is no guarantee that the slots will be accurate. This will be rectified later today.

[ScreamingEagle]

I have removed the duplicates in this case so the error will disappear, but there is no guarantee that the slots will be accurate. This will be rectified later today.

Thank you kindly, if someone gets a chance can they please delete the extra one at LHR as well.

Can't build gates, or if a fix is nearby ignore and wait for the fix

thanks again