Recover Cart [Support Thread]

[Attachment no longer available]

The SQL is definitely not updating the configuration table.
See attachment, I sorted the configuration keys alphabetically & nothing starting RCS shows up.
The SQL code looks OK to me; not that I know much :)

Could it be a permission thing?

I tried just running the piece of SQL starting with "INSERT INTO configuration (configuration_id.......)
Seemed to run OK but did not update the table.

Help!!

Try deleting the configuration_group table entry (or entries?) associated with the name "Recover Cart Sales", make sure that there are no items in the configuration table that start with RCS_ and then re-run the SQL that I posted.

Tried that but did not work. :(

I found this tip in the zen cart wiki (see below) & now the configuration table is updated & RCS works (mostly) still cannot "configure" but Tool & Reports are OK. :unsure:

Tip
"Sometimes the patch tool will give you this error:
ERROR: Cannot insert configuration_key "" because it already exists

This may be related to particular versions of PHP, MySQL, and phpMyAdmin, or it may not. If you get this error, you can just run the SQL file directly in phpMyAdmin. "

I have v1.5.1 and and doing a new install; I could only get the upgrade-ZC-v-1-5.sql file to upload. When I tried the install-ZC-v-1-5.sql through Tools> Install SQL Patches it fails and says, Warning: An Error occurred,please refresh the page and try again. But since I got positive confirmation that the "upgrade" file took, I uploaded the files to my admin folder. I'm not sure if this is how it is designed to work, but that's what I did.

Now, I have all the RCS menus displaying in Admin. But, even after adding products to my cart and logging off, I don't see anything in the reports. However, I do get an error that says: Warning: Ad Error occurred, please refresh the page and try again.

I've double checked my admin folders and everything is uploaded correctly. I suspect it's related to the database, but I have no idea where to start. Any ideas?

Thanks in advance.

Seems that this is the offending script:

CREATE TABLE scart (
scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
PRIMARY KEY (scartid),
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid)
) TYPE=MyISAM;

I removed the TYPE=MyISAM from the script and it appears to be working now.

Is TYPE=MyISAM critical? What does it do that might mess something else up?

Okay, I sent a test e-mail to myself, but I didn't get it.

Also, I was earlier able to change RCS configurations but now it's a blank page.

Infidel:

I have v1.5.1 and and doing a new install; I could only get the upgrade-ZC-v-1-5.sql file to upload. When I tried the install-ZC-v-1-5.sql through Tools> Install SQL Patches it fails and says, Warning: An Error occurred,please refresh the page and try again. But since I got positive confirmation that the "upgrade" file took, I uploaded the files to my admin folder. I'm not sure if this is how it is designed to work, but that's what I did.

Now, I have all the RCS menus displaying in Admin. But, even after adding products to my cart and logging off, I don't see anything in the reports. However, I do get an error that says: Warning: Ad Error occurred, please refresh the page and try again.

I've double checked my admin folders and everything is uploaded correctly. I suspect it's related to the database, but I have no idea where to start. Any ideas?

Thanks in advance.

I just installed this and I'm having the exact problem. The 'upgrade' file worked but I'm getting an error in the admin menus. Help would be greatly appreciated.

Neo

I am receiving both error messages:

WARNING: An Error occurred, please refresh the page and try again.

and

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

This seems like an important mod but I just cannot seem to get it to work with 1.5.1

ok, I changed the TYPE=MyISAM; to ENGINE=MyISAM; and I am now able to see the abandoned carts. WOW! This is really cool.

Unfortunately, my Configuration, Configure RCS is blank and I cannot see any settings. Any suggestions?

Hi, woody

I use Zen cart 1.3.9h, I found there is a function called Who's online can check customer activity, also can show if they put item to shopping cart or not
but I can not contact them, do you know how to deal with that?

https://www.uniwarestore.com/ this is the store. I put who's online to main page.

It seems that the install went through fine but the Admin Config is a blank page with no configuration options available. I have tried most everything but do not know what I am missing. Is there a way to uninstall this and start over?

I noticed that there was a folder named "boxes" with files in it in the older version of this mod but this folder is missing in the current version. Could this be the result of the admin config not showing up but for a blank page?

I am sorry if this has been answered, but I searched and could not find an answer.

Plugin is working fine except that email message has the only the folder that the store is in and the product.

It does not include the
http://www.rjfinewood.com

This is the link
/wood-tissue-box-cover/tissue-box-covers-cube/tissue-box-cover-crotch-mahogany

Should be this
http://www.rjfinewood.com/wood-tissue-box-cover/tissue-box-covers-cube/tissue-box-cover-crotch-mahogany#.Uz7Mg1coNBk

Any idea?
Thanks

Also notice that the signature address is also messed up.

It is just showing the

Sincerely,

RJ Spomer
/wood-tissue-box-cover/

thanks

Hi, I'm still getting a blank page in zencart Admin - Configuration - Configure RCS and would be really grateful for your help.

This is what I've got:
Zen Cart 1.5.1
Recover Cart Sales - Version: 4.00.00a
PHP Version: 5.2.17
Database: MySQL 5.0.77

I made the changes you suggested in post no. 541 of this thread, deleted the configuration_group table entry associated with the name "Recover Cart Sales", made sure that there are no items in the configuration table that start with RCS_ and then re-ran the SQL that you posted in post no. 548.

I don't get any error messages, just keep getting a blank at Admin - Configuration - Configure RCS.

Thank you!

I thought I would restate my issue.

My store is in a folder of my main website. The email that is sent out shows the product links without the website url and shows only the folder and the files. Could this be a is with the Configuration Settings in configure.php ?

Hope this helps

Thanks

One more time the right term is the TLD is not included in the product links in the email sent to the customer.

Thanks

remops:

One more time the right term is the TLD is not included in the product links in the email sent to the customer.

Thanks

Just curious, do you have Ceon's Back in Stock Notification installed as well?

https://www.zen-cart.com/showthread.php?181440-Ceon-Back-In-Stock-Notifications-3-0-0&p=1187209#post1187209

I have had this problem for ages now and I am not sure which plug-in broke which, but I want to say it might have been this one now that I think about it. BiSN has been installed from nearly the beginning.

From the other thread, it seems there are a few of us now...

No I do not but thanks. This plugin could be great for me but I can not use it with the way it is working.

Thanks again!