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 …
Alex HD at
HostingXtreme on 2014-08-05. Comments Off on 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 …
This error is often encountered on PHP MySQL content management systems when updating data or filling out a form for submission. It is also seen in WordPress, Drupal, Joomla installations which have broken themes or plugins.
- You have a broken software or application. You will need to contact your programmer or developer to fix the issue with the SQL statement in the application or form.
- If you are using WordPress, Joomla, Drupal or any other CMS, this may be due to broken plugins or addons which you installed.
- The SQL statement used by the programmer to add or update information to the database is incorrect or contains reserved (column) names.
- You have entered special characters like ‘ ; ” , etc. which your application is unable to understand. Your software should have automatically detected this and corrected it. Consult with your software developer.
- You are entering incorrect values into the form. Eg: Entering alphabets where only numbers are allowed.
This error is not related to the software or hardware on the server. It indicates an issue with the coding.