• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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