Jump to content

ps_guest' doesn't exist - 500 Internal Error


see_k
 Share

Recommended Posts

Hallo 

I am total lost

When I go to 

Sale(Verkauf) / Customer/Kunden

image.png.1e581dd05c1ee5693135eae0646da42a.png

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

image.thumb.png.a8abe00af8b52a1ccca70375c904ec22.png

 

Does not exist

image.png.c724ffb3efd4c52f8c993d33af4e1b26.png

 

I also have this

image.png.c18a0d4046bae66ce4b1e5971bfca7b4.png

Any Idee 

 

Thanks for your help 

 

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

Share this post


Link to post
Share on other sites

  • 1 year later...

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]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More