• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

MySQL/PHP Error - Code is perfect

S

spoonman

Guest
I've been having this problem with a PHP script. I think it may have to do with a PHP or MySQL config file or version.

Here is the error
"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 'condition,description,location,date) VALUES ('3323','555','partsimg/','partsimg/' at line 1"

Now this is a typical error but the code is perfect. There is nothing wrong with it. I have tried rewriting the lines and triple-checked it. The page worked perfectly on an older Plesk server but once I moved it to the new server (8.1), it started giving me this error.

What could be the problem?
 
now I get this error

"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"

Like I said, I know 100% that there is no error in my code. I may have to move it to an old plesk server that we have.

I am at a crossroads because now I spent money to upgrade to 8.1 but my PHP/MySQL scripts do not work correctly on it. I can not have faith in my new server if I don't get PHP/MySQL working.
 
Originally posted by spoonman
Like I said, I know 100% that there is no error in my code.
Sir, Plesk 8.1 for Windows ships MySQL 5.
MySQL 4 is shipped with old Plesks.
Seems you are using some names which are keywords in MySQL 5 but were not in MySQL 4.
 
Back
Top