Errore 500 Back office

[Elena B]

Salve a tutti, per favore ho bisogno di un aiuto.

Se vado sul tab "CLIENTI" nel BO di prestashop, mi esce questo errore:

Sembra che si sia verificato un errore inaspettato

An exception occurred while executing 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT con.date_add FROM ps_guest g LEFT JOIN ps_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY con.date_add DESC LIMIT 1) as connect FROM ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50' with params [1, 1, 1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'arredoqu_prestashop.ps_guest' doesn't exist

[Doctrine\DBAL\Exception\TableNotFoundException 0]

 

Come posso rimediare??

Grazie mille veramente a chi mi potrà aiutare!!!!

[musicmaster]

It looks like you deleted the ps_guest table. You should never delete it: you should only empty it occasionally when you don't need its contents.

 

[Elena B]

I didn't touch the DB at all!

But now, how can I do?

Thank you

Edited February 20, 2021 by Elena B (see edit history)

[musicmaster]

Are you familiar with Phpmyadmin? You should check that the table is indeed missing and in that case copy from another installation.