Airline Mogul Forum

Submitting airport bug...

CornField

  • Airline Supervisor
  • **
    • Posts: 700
    • View Profile
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.

Your  Favorite Hometown Airline


StephenM

  • Administrator
  • Airline Board Member
  • *****
    • Posts: 6038
    • View Profile
Reply #1 on: January 12, 2008, 11:22:56 pm
Looks like the ' crashed it alright. Put in \' instead and it will work fine.
Stephen Murphy
Airline Mogul Chief Developer


 

SMF spam blocked by CleanTalk