Hello!
I'm following the directions listed within the following link to reset the admin password for our Confluence instance.
However when I run the below query (Using phpPgAdmin) I receive the syntax error shown in the screenshot. Any ideas as to what I'm doing wrong here?
insert into cwd_user(id, user_name, lower_user_name, active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, directory_id, credential) values (1212121, 'admin', 'admin', 'T', '2009-11-26 17:42:08', '2009-11-26 17:42:08', 'A. D.', 'a. d.', 'Ministrator', 'ministrator', 'A. D. Ministrator', 'a. d. ministrator', 'admin@example.com', 'admin@example.com', (select id from cwd_directory where directory_name='Confluence Internal Directory'), 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==');
insert into user_mapping values ('2c9681954172cf560000000000000001', 'admin', 'admin');
I really appreciate everyone's help, I'm completely new to both Postgresql and JIRA, so I apologize if this is a simple question.
It looks like the following has been appended to the front of the insert statement:
SELECT COUNT (*) as total FROM
Please try the queries without that, and let us know if you can add the user as expected.
Thanks, Ann!
It looks like the "Paginate Results" box was checked, which was appending the statement.
Unchecked the box, and now we're good to go!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for following up with us for the sake of the next person who has that box checked. :) Happy to hear you're all set!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hm..
Have you selected the correct database first?
e.g: \c jiradb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.