Recover Cart [Support Thread]

[r1formetoo]

This is odd. I've uploaded all the correct files to all the correct folders and verified that I'm using the correct permissions (755 for folders and 644 for files) concerning this module. When I try to install the module I get an error saying "Internal Server Error". However, I've noticed that both new boxes for the module are indeed located under the tools and reports menu but nothing new is in the configuration section. When I click on the link in the tools or reports section to use the mod I get an error reading of that below. Being that I'm no database guru I have no idea what it means.......

Ian

1146 Table 'redlines_zen.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 >= '20101028' AND cb.customers_id NOT IN ('') ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC]

[r1formetoo]

Please help someone!

Ian

[econcepts]

1146 Table 'redlines_zen.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 >= '20101028' AND cb.customers_id NOT IN ('') ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC]

This means that you either did not run the full patch to install the mod (which creates a new table called scart) or that when trying to run the patch it did not complete. In either case, your database does not have the scart table which is required to run the mod.

When you run the SQL patch what type of message do you get?

Could there be a permission issue on the live server that does not allow the user to create a table? If so, that will fail (but adding new settings to the configuration will work as the table(s) are already present for those.

Check with your host to see if there are some MySQL restrictions on creating a new table.

You could also try to run the patch through phpMyAdmin to see what occurs (just the portion that creates the scart table). But you'll need to make sure you alter the language to add the redlines_zen prefix before any table created.

If you can isolate what is different from the test server and the live server you'll have found the answer as to what is causing it not to install. There has to be a configuration difference between the two or it would work on both just fine (since it works on the test server.)

[zyzlee]

Could anyone help me pls?
When I import the sql patches had this note:

12 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

How can deal with this?

PS:This mod can work right in zencart 1.39h . I had tested in a new cart.

[econcepts]

Yes, it should work with 1.3.9 versions.

You could safely ignore the error you got while installing. All that means is some config variable that was trying to be inserted with the patch was already present in your database (meaning it is there.)

Have you tried to see if the module is installed and working?

[zyzlee]

Yes, it should work with 1.3.9 versions.

You could safely ignore the error you got while installing. All that means is some config variable that was trying to be inserted with the patch was already present in your database (meaning it is there.)

Have you tried to see if the module is installed and working?

Thank you for your reply.It could not work with this error.

when click the tool--->recover cart sale,it will go to
http://www.mywebsite.us/admin/FILENA...CART_SALES.php
page not find in the website.
when click the report-->recovered sales results,it will go to
http://www.mywebist.us/admin/FILENAM...CART_SALES.php
page not find in the website.

[econcepts]

Thank you for your reply.It could not work with this error.

when click the tool--->recover cart sale,it will go to
http://www.mywebsite.us/admin/FILENA...CART_SALES.php
page not find in the website.
when click the report-->recovered sales results,it will go to
http://www.mywebist.us/admin/FILENAM...CART_SALES.php
page not find in the website.

This isn't a result of the SQL patch (that error will still have it work). You have not uploaded all files to the right locations. That is why you are getting this error. Specifically in this case, the define language files for pointing to the correct file locations is missing in your case.

My suggestion would be to go back and re-upload all files again making sure you put them in the correct locations. That should get you up and running.

:)

[zyzlee]

This isn't a result of the SQL patch (that error will still have it work). You have not uploaded all files to the right locations. That is why you are getting this error. Specifically in this case, the define language files for pointing to the correct file locations is missing in your case.

My suggestion would be to go back and re-upload all files again making sure you put them in the correct locations. That should get you up and running.

:)

Thank you for your reply.
I had checked all the file in right position before.
But I will try again.For this is really a good mod.

[zyzlee]

ok,I had reupload all the files and reinstalled the sql patch.
It still had some thing does not work:
1.admin-->configuration-->Recover Cart Sales has nothing to configurate.
2.after send mail to the test custom,admin-->reports-->Recover Cart Sales show:
1054 Unknown column 'RCS_PENDING_SALE_STATUS' in 'where clause'
in:
[SELECT o.orders_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value FROM orders o LEFT JOIN orders_total ot ON (o.orders_id = ot.orders_id) LEFT JOIN orders_status s ON (s.orders_status_id = o.orders_status AND s.language_id = 1) WHERE o.customers_id = 12 AND o.orders_status > RCS_PENDING_SALE_STATUS AND o.date_purchased >= '2011-01-01' AND ot.class = 'ot_total']
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.
3.after send mail to the test custom,admin-->tools-->Recover Cart Sales still show Uncontacted.

[zyzlee]

Thank you:Econcepts.
I just do the sql patch in th phpadmin.Now I think all the things work right.
Thank you again.

I had done all the things before,but it did not work.But today it work.
It's a very good beginning for the new year.

Happy new year!