Airline Mogul Forum

Get MySQL Errors when I add airports

Inti · 9 · 1688
« previous next »
Pages: 1

Inti

  • Airline Operative
  • *
    • Posts: 8
    • View Profile
on: October 14, 2007, 12:47:20 am
I've added 3 airports today.  All 3 times I got MySQL errors.

The airport codes are:

CUZ

IQT

TCQ

Anyone else had this problem?

Air Elbonia

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 2089
    • View Profile
Reply #1 on: October 14, 2007, 12:51:04 am
can you paste the mysql error?
Air Elbonia, First in Time Travel since 2073!  (AEB ID in Game: 333)

dktc

  • Administrator
  • Airline Board Member
  • *****
    • Posts: 4622
    • View Profile
Reply #2 on: October 14, 2007, 12:55:48 am
I think the airports are in there...
... I thought wrong. :roll:
D Express (id 616) 8)
AM Membership Officer / Official Broker

Inti

  • Airline Operative
  • *
    • Posts: 8
    • View Profile
Reply #3 on: October 14, 2007, 01:02:30 am
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 'OR `to_id`=' at line 5

Maps generated by the Great Circle Mapper - copyright © Karl L. Swartz.

Gate Rental for
Sorry, there are no gates left.


Display MapRent GateDisplay Market Share Chart
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 'AND (`gates` >0 OR `builtgates`>0) GROUP BY `g`.`user_id`, `r`.`user_id` ORDER B' at line 10
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/view_airport.php on line 269

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/view_airport.php on line 271

Air Elbonia

  • Administrator
  • Airline Senior Manager
  • *****
    • Posts: 2089
    • View Profile
Reply #4 on: October 14, 2007, 01:22:27 am
Well. this pointed out a separate bug then you thought.

gates will now tell you that an airport code returns 0 results (instead of displaying a link to nothing and a lot of blanks).

Submitted airports may take a few days to be approved, thereby may take a few days to surface in game.
Air Elbonia, First in Time Travel since 2073!  (AEB ID in Game: 333)

Inti

  • Airline Operative
  • *
    • Posts: 8
    • View Profile
Reply #5 on: October 14, 2007, 01:38:23 am
I did get this error after submitting all 3 airports:

Error: That airport has already been added to the game, sorry!

dktc

  • Administrator
  • Airline Board Member
  • *****
    • Posts: 4622
    • View Profile
Reply #6 on: October 14, 2007, 01:39:42 am
Quote from: "Inti"
I did get this error after submitting all 3 airports:

Error: That airport has already been added to the game, sorry!


Probably either you double-clicked or pressed enter twice. :wink:
D Express (id 616) 8)
AM Membership Officer / Official Broker

Inti

  • Airline Operative
  • *
    • Posts: 8
    • View Profile
Reply #7 on: October 14, 2007, 06:16:40 pm
the airports appear, along with more peruvian airports.

But the distances are huge.  For example.

LIM to CUZ = 10,382NM
LIM to TCQ = 10,382 NM

dktc

  • Administrator
  • Airline Board Member
  • *****
    • Posts: 4622
    • View Profile
Reply #8 on: October 14, 2007, 06:26:51 pm
Quote from: "Inti"
the airports appear, along with more peruvian airports.

But the distances are huge.  For example.

LIM to CUZ = 10,382NM
LIM to TCQ = 10,382 NM


Probably the +/- for the coordinate or the two were switched when entered. It will be fixed by Rick soon.
D Express (id 616) 8)
AM Membership Officer / Official Broker

Pages: 1
 

SMF spam blocked by CleanTalk