Airline Mogul Forum

Airline Mogul => Bugs => Topic started by: CornField on January 12, 2008, 09:28:56 pm

Title: Submitting airport bug...
Post by: CornField on January 12, 2008, 09:28:56 pm
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 's Vineyard Airport') OR EXISTS (SELECT 1 FROM `temp_airport` WHERE `airport_' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/submit_airport.php on line 57
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 's Vineyard Airport') OR EXISTS (SELECT 1 FROM `temp_airport` WHERE `airport_' at line 1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/submit_airport.php on line 60
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 's Vineyard Airport', 'MVY', 'KMVY', '413930', '706143', '9', '91762', '1', '50',' at line 1

Got this when I went to submit MVY......

Could possibly be the apostrophe I entered in the airport name without thinking of it.
Title: Submitting airport bug...
Post by: StephenM on January 12, 2008, 11:22:56 pm
Looks like the ' crashed it alright. Put in \' instead and it will work fine.