Billd11 Posted April 30 Share Posted April 30 I am having a problem. It seems to have happened when I went to 1.7.8.11 version. I can't call up my customers. When I attempt to access the Customer mode I get this error message: 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 ss_dbprefixorders 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 ss_dbprefixguest g LEFT JOIN ss_dbprefixconnections 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 ss_dbprefixcustomer c LEFT JOIN ss_dbprefixgender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ss_dbprefixshop 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 'reggiea1_ss_dbname3b6.ss_dbprefixguest' doesn't exist [Doctrine\DBAL\Exception\TableNotFoundException 0] The address part seems to be OK but I have no access to the customer files themselves. I am new at this and don't know anything about data bases or anything else about this program. How can I fix this without having to start the entire store from scratch again? Thanks, Billd11 Link to comment Share on other sites More sharing options...
Prestashop Addict Posted May 1 Share Posted May 1 This is an upgrade issue, when the module statsdata (Data mining for statistics) is not installed. Just install it and deactivate it. 1 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