Prestashop 1.7 - Backend product list missing -PROBLEM

[Alien(PL)]

Hey,

i have big problem with one of my stores

Prestashop 1.7

Prestashop stopped showing products on the backend without any reason. It appears like a new Presta, but it has over 1000 products.
- 2 of 5 admin accounts only show a product list with products
- if i create a new account with admin privileges - no products
- if i create a new account as a seller - then the product list is visible

What might cause it and how to fix it?

Frontend display products without a problem.

[Prestachamps]

Hello,
Do you mean the SuperAdmin when you say Admin?
Probably there is some issue in the database level with the permissions for the employees. Probably some authorization roles is missing for the administrator. 
You can try to verify and correct it in the database in the ps_module_access and ps_authorization_role tables. 
Please create a backup before you start to work in the database, or firstly try to solve it on a development version of the site. 

If you are familiar with SQL you can try to generate the missing roles: 

Global Fix DB role : SELECT CONCAT( "INSERT INTO ps_module_access (id_profile, id_authorization_role) VALUES ('1', '" , id_authorization_role , "');COMMIT;" ) FROM ps_authorization_role where id_authorization_role not in (SELECT id_authorization_role FROM ps_module_access)

Probably the following article will be also helpful for you: 
https://www.prestashop.com/forums/topic/600537-ps-17-access-denied-in-design-pages-as-superadmin/

I hope that I could help.
Have a nice day, Leo.

[Knowband Plugins]

We request you to kindly check the permission for the seller or admin,

Advance Parameter -> Team -> Permission -> {then select the member and check the permission}

Kindly check the screenshot for your reference : https://nimb.ws/dYfbFR

[Alien(PL)]

@Prestachamps it seems it worked! Thank you!

[Fr4ancky]

Same problem. After clickin products i get a http error 500

 

The database sollution dit not work

 

[Alien(PL)]

when you get the 500 its not the same problem.

 

 

[Nickz]

On 6/7/2022 at 4:18 AM, Alien(PL) said:

Prestashop stopped showing products on the backend without any reason.

Have a look into the the servers update politics. All of sudden is highly unsusual 

[Prestachamps]

Hi @Fr4ancky,

if you have 500 error, the enable the debug mode and check the Console log or the network tab of Chrome Devtools (F12 -> network) for the exception/error that is being caused at the 500 error.

Have a nice day, Leo.

[Fr4ancky]

The weird things is.. In debugmode I have the productpage without products. 

When debugmode is disabled i got an http erro 500

I dwongraded PHP to 7.2 and now it works. 

IN PHP sellers can use productspage but superadmin get the error