1.4.2 upgrade. Clicking on Customer Groups & Carts getting access denied

[BenC]

As title says since I have upgraded to 1.4.2 I cannot access the customers - group & cart pages I get an error Access denied in a big red box.

Any ideas? Everything else seems to work ok.

[rudders18]

Hi
I had the same problem on 1.4.2.5 and 1.4.3. I fixed it by adding the missing rows in the ps_access table, for me it was tab numbers 71 and 73, the numbers may be different for you. This was after an upgrade from 1.3.6

[BenC]

I have upgraded to 1.4.3 and still getting the same error. You sau you added missing rows, could you be more specific im not a web developer so need a little more info

Thanks

[rudders18]

Hi
You need to be able to use phpMyAdmin and modify the access table in your database, probably called something like ps_access. This table has a row for each user, each tab for that user then has a combination of 4 1s or 0s saying what access that user has to that tab.

It appears that for some reason during the upgrade the administrator, ID 1 does not have some of the tabs and their relevant access data.

So for example the data row for tab number 65 was missing, I added a row for user ID 1, tab number 65 and then set the 4 access values to 1.

This seems to be a common problem so I image someone may have written a little SQL file to do this for you but again you will need to use phpMyAdmin.

If you have never used phpMyAdmin or do not have access to it through your web host this may be difficult to achieve.

[rudders18]

Hi
Follow this bug report, PSCFI-2540, as it seems others have reported this issue