About two years ago I made a script for my daughter to sell tickets to shows for her dance classes. The users could order tickets online and pay via PayPal. The script is also counting down the remaining number of available seats after payment and the customer gets a receipt in their e-mail with the booking confirmation. Another e-mail is sent to my daughter so she can see who bought the tickets.
There are only 2 shows a year (one in december and one in the end of May). I'm not sure I remember all the code I wrote, since I did it a while ago and have a lot of other things all the time, so when a project is up and running I kinda forget what I did and move on to the next project.
But in december some people, not all, had some problem with a page when they return from PayPal and paid their tickets. But for others it worked fine.
Now the same thing happened to a customer the other day and I have no idea why. The only error code they sent to my daughter was this:
"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"
I haven't looked at my pages and code yet, since I don't have them where I am now. I'm just confused when it works for most people, but some people can use it as it's supposed to.
So, my question is actually what I would look for or maybe ask the people who get the code. I'm not sure I want to mess around with the code when it's close to a show now and people are buying the tickets.
Does anyone have clue on what to do or look for here? For me it sounds strange.
And, I'm not a programmer. I'm just playing around and tend to survive with my scripts most of the time. It's fun.