Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-4184

JIRA User Import PreparedStatementCallback; bad SQL grammar

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Support Request
    • Icon: Medium Medium
    • None
    • 2.8
    • Import & Export
    • Crowd 2.8.0 (Build:#645 - 2014-11-05)
      JIRA v6.3.9#6339-sha1:46fa261
      MySQL 14.14 Distrib 5.5.40
      Debian 7.7

      Trying to import user from exsisting usign the importer getting this exception:

      org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT usr.user_name AS user_name, grp.group_name AS group_name FROM cwd_membership mem INNER JOIN cwd_group grp ON mem.parent_id = grp.id INNER JOIN cwd_user usr ON mem.child_id = usr.ID WHERE membership_type = 'GROUP_USER' AND usr.directory_id = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'membership_type' in 'where clause'
      

      Full strack trace is attached.

              Unassigned Unassigned
              48dc322cb53a Frank Kubis
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: