Page 1 of 1

Can't Update Settings - Haven't Got Permission

Posted: Wed May 29, 2019 5:27 am
by Gobbo
Hi,

I can't update settings, as I haven't got permission.

Why is this?

Shouldn't I have full permissions to update anything on my site?

Re: Can't Update Settings - Haven't Got Permission

Posted: Wed May 29, 2019 12:28 pm
by grgr
You probably should.

Have you tried going to system -> users -> user groups and checking the permissions?

Re: Can't Update Settings - Haven't Got Permission

Posted: Wed May 29, 2019 8:30 pm
by Gobbo
I selected everything in system -> users -> user groups->admin and it seems I don't have permission to update that either.

Re: Can't Update Settings - Haven't Got Permission

Posted: Wed May 29, 2019 9:35 pm
by grgr
You are logged to an Administration account not a Demonstration account?

Worst case, use phpMyAdmin and manually add the permissions (twice, once in the access part (if not already there) and once in the modify part) to the user_group table.

Code: Select all

"setting\/setting","user\/user","user\/user_permission",

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 2:10 am
by Gobbo
What's the file path for these scripts?

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 6:48 am
by straightlight
The quickest solution would be by resetting your oc_user_permission table on the database (truncate). Then, to re-insert the values with the SQL query from your install/opencart.sql file .

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 11:12 am
by grgr
opencart download -> upload -> install -> opencart.sql.

Open that file with a text editor such as notepad++ and find the user_group section - line starting with:

Code: Select all

INSERT INTO `[b]oc_[/b]user_group` (`user_group_id`, `name`, `permission`) VALUES
Be aware of the table prefix, in bold above, change as necessary.

As above then copy and paste that section into the sql tab in phpMyAdmin. I'm not going to post the whole thing here as it is really long.

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 6:24 pm
by straightlight
grgr wrote:
Thu May 30, 2019 11:12 am
opencart download -> upload -> install -> opencart.sql.

Open that file with a text editor such as notepad++ and find the user_group section - line starting with:

Code: Select all

INSERT INTO `[b]oc_[/b]user_group` (`user_group_id`, `name`, `permission`) VALUES
Be aware of the table prefix, in bold above, change as necessary.

As above then copy and paste that section into the sql tab in phpMyAdmin. I'm not going to post the whole thing here as it is really long.
The BB codes won't work with CODE but rather with QUOTE statements. However, the table prefix may need the change, indeed, if using different prefix name for your database tables.

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 8:33 pm
by Gobbo
I haven't got a folder called Download.

Re: Can't Update Settings - Haven't Got Permission

Posted: Thu May 30, 2019 9:21 pm
by grgr