Airline Mogul Forum

Airline Mogul => Bugs => Topic started by: Inti on October 14, 2007, 12:47:20 am

Title: Get MySQL Errors when I add airports
Post by: Inti 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?

Title: Get MySQL Errors when I add airports
Post by: Air Elbonia on October 14, 2007, 12:51:04 am

can you paste the mysql error?

Title: Get MySQL Errors when I add airports
Post by: dktc on October 14, 2007, 12:55:48 am

I think the airports are in there...
... I thought wrong. :roll:

Title: Get MySQL Errors when I add airports
Post by: Inti 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

Title: Get MySQL Errors when I add airports
Post by: Air Elbonia 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.

Title: Get MySQL Errors when I add airports
Post by: Inti 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!

Title: Get MySQL Errors when I add airports
Post by: dktc 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:

Title: Get MySQL Errors when I add airports
Post by: Inti 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

Title: Get MySQL Errors when I add airports
Post by: dktc 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.