Dwight Posted February 7, 2016 Report Share Posted February 7, 2016 I have entered schedules, but when I go back in to edit the entire schedule is wiped out, yet it shows on the table in the Schedules on Admin Panel. I edit the schedule and reenter all of the flight data then hit the Edit Schedule button and get the following error message back: There was an error editing the schedule: 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 '' at line 1 Here are the screenshots. I had already entered the flight information and added the schedule, then went back into edit it and had nothing on the input screen. When I reentered the info I then had the error pop up. Any ideas what file(s) is screwed up? This started after I filed my first PIREP and I went in and updated ticket prices on the original entered schedules. Prior to that I had 26 schedules entered and everything was working fine. Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted February 9, 2016 Administrators Report Share Posted February 9, 2016 use near '' at line 1 makes me think there is an empty field for some reason, or there is some piece of data that possibly has a single quote in it that is not being escaped before hitting the database. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.