ethan lacoste Posted August 20, 2021 Share Posted August 20, 2021 Oups... une erreur inattendue semble s'être produite 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 mod639_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 mod639_guest g LEFT JOIN mod639_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 mod639_customer c LEFT JOIN mod639_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN mod639_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 'dodobee271.mod639_guest' doesn't exist [Doctrine\DBAL\Exception\TableNotFoundException 0] Link to comment Share on other sites More sharing options...
Eolia Posted August 20, 2021 Share Posted August 20, 2021 il vous manque une table (mod639_guest) Utilisez cet outil (en mettant mod639_ comme préfixe) et tout redeviendra conforme https://shop.devcustom.net/tables.php Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now