Recover Cart [Support Thread]

[a_berezin]

Hi Linda,

Like duh ... I knew that ... do not ask me what I was thinking ...

Sorry, but I can still ask, what do you think?

[Ajeh]

*cough*smarty pants*cough*
User moment where I thought that prid had a use but forgot for a moment that is only true in the session ... kinda sorta a lot like I had a senior or user moment ...

[spawnie69]

Happy Zen Year Everyone!

I ran into a jam with my install of recover cart sales module on my 1.39h zen store.
I uploaded the files first then ran the sql query in my admin.
I now get the following error when visiting the recover cart sales page:

1146 Table XXXXX_XXXX.scart' doesn't exist
in:
[SELECT cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified FROM customers_basket cb LEFT JOIN customers cus ON (cb.customers_id = cus.customers_id) LEFT JOIN scart sc ON (cb.customers_id = sc.customers_id) WHERE cb.customers_basket_date_added >= '20130107' AND cb.customers_id NOT IN ('') ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

So I assume the a table was not created.
What should I do? remove the files and restart the install?
I just noticed that I may have followed my steps in the reverse order looking at the install steps.
It says to run the SQL first and then upload files. Could this be the culprit?
Thanks everyone!



I

[stasinos]

Hi, I really appreciate having found this module and I want to implement it at my store. I am running zencart version 1.5.1 and from what I understand, I need to run the sql code first and I have a very limited knowledge of sql and I am wondering if someone can help me to edit the sql code that I need to run (I know how to run it from the store and Install SQL patches, but my database has a zen_ appended to the front of all of the tables and I am not proficient enough in sql to know all of the places in the sql code that I need to append the zen_ infront of. Would anyone be able to edit the sql script for me to append zen_ in the correct places? I would really appreciate your help?

Thank you so very much!

Susan