Update Retrieving the JIRA Administrator documentation

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Tracked Elsewhere
    • Component/s: Documentation
    • None

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      From the Retrieving the JIRA Administrator - If no users or groups exist in JIRA documentation, it's showing this SQL query:

      insert into cwd_user values (999999,1,'localadmin','localadmin',1,'2012-01-04 19:49:05-08','2012-01-04 19:49:05-08','local','local','admin','admin','local admin','local admin','localadmin@localadmin.com','localadmin@localadmin.com','uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==');

      When we run the SQL query above in the MySQL database, it's throws this error message:

      Error Code: 1136. Column count doesn't match value count at row 1

      Looks like there are two missing column in the SQL query. The correct one should be like this:

      insert into cwd_user values (999999,1,'localadmin','localadmin',1,'2012-01-04 19:49:05-08','2012-01-04 19:49:05-08','local','local','admin','admin','local admin','local admin','localadmin@localadmin.com','localadmin@localadmin.com','uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==',NULL,NULL);

            Assignee:
            Unassigned
            Reporter:
            John Chin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: