Jump to content

Customer Data base error


Billd11

Recommended Posts

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

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
×
×
  • Create New...