Error in MySQL syntax when trying to perform External System Import

Related content

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

  1. User did not specify the external system(eg. Mantis, Bugzilla or etc.) username and password before import. Most users affected are using Internet Explorer.

The following appears in the atlassian-jira.log:

2012-05-03 10:57:10,907 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state
com.atlassian.jira.plugins.importer.SQLRuntimeException: 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

Workaround

  • Specified the username and password before import
  • Use another browser such as Mozilla or Chrome

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article

Related content

Powered by Confluence and Scroll Viewport.