ps_guest' doesn't exist - 500 Internal Error

[see_k]

Hallo 

I am total lost

When I go to 

Sale(Verkauf) / Customer/Kunden

Then I get a 500 Error

Switched Debug Mode on:

https://www.art-outdoor.ch/shop_61/admin427mkcmkl/index.php/sell/customers/?_token=aB-ILc1Oyhc4f_SrIXC5xUOcwD2Zsshf_Om22lOcGT4

 

Does not exist

 

I also have this

Any Idee 

 

Thanks for your help 

 

I was so close to go in production and now this ...

[NemoPS]

Import this

ps_guest.sql

[Rizzzle]

Having a similar problem. The above doesn't fix it.

When I click on "Customers" or "Shopping Carts"

PS 1.7.7.4

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 'XXX_XXXX.ps_connections' doesn't exist

[Doctrine\DBAL\Exception\TableNotFoundException 0]

[musicmaster]

Your error now is ps_connections missing. It looks you left out the statistics tables when copying/moving a shop.

Anyway, here is the connections table:

 

ps_connections.sql