Recover Cart [Support Thread]

[ak6000]

I just installed and configured this module without any problem or error message.

When I go to either tool->Recover cart sales or Report->Recover cart sales results I see the following warring with no listing even though I have personally created few abandoned cart!

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

Thanks for your help.

[Decostyle]

Check your cache folder for the debug log and it will give you a clue as to what went wrong.

I just installed and configured this module without any problem or error message.

When I go to either tool->Recover cart sales or Report->Recover cart sales results I see the following warring with no listing even though I have personally created few abandoned cart!

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

Thanks for your help.

[ak6000]

Thanks for your reply DecoStyle. Per your recommendation, I checked the cache folder and find out the 'scart' db table did not exist.

Since I was upgraded from v1.3.9 I used the Upgrade sql patch, but apparently I needed to use Install instead!

So I used the install-ZC-v-1-5.sql and everything is working.

[smcelligott]

This seems like a very simple problem, but I can't figure out why only one other responder has said that their site has the same problem.

Since my problems seem to be prefix related, I courageously changed the beginning of the install script to be:

(Please note: <PREFIX> is replaced with my actual prefix; and <DATABASE> is replaced by the name of my database)

DROP TABLE IF EXISTS <PREFIX>_scart;
CREATE TABLE <PREFIX>_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)
) ENGINE=MyISAM;

When I run this amended SQL statement, it errors out with:

MySQL said:
#1146 - Table '<DATABASE>.configuration_group' doesn't exist

Well duh silly Zen Cart, I know that table doesn't exist because the actual table is: <DATABASE>.<PREFIX>_configuration_group.

Since I am rather SequIlliterate (for those who humour is not as warped as mine, that means illiterate when it comes to all things SQL), I have no idea how I could, or more importantly whether I should, further edit this SQL statement.

Is there some other place in my admin settings where perhaps my prefix name should be stored but it isn't? Surely the fact that I have a prefix would not be unusual, but perhaps for some unknown reason some 'processes' may not be 'seeing' that a prefix exists???? This might explain some other dramas I am experiencing . . . your insights would be majorly appreciated!

[thebigkick]

Downloaded, Installed files on my website and ran the SQL in the ZC Admin. Not seeing anything in the Admin under Tools or Configuration.

Running ZC v1.3.9
Installed v 1.3.0 Recover Cart Sales - Version: 3.1.0 for Zen Cart® Versions v1.3.8.

Maybe I did something wrong?
Thanks

[thebigkick]

Got it working. I never changed user permissions under Tools > Admin Settings.

ma bad

[mickymix]

Just wanted to add my two cents, after one whole morning wasted trying to solve my problem with no success...

Running ZenCart v1.3.9
Followed instructions as given, carefully.
I was always getting the following message:

12 statements processed
Error: Impossible to add configuration_key "" as already existand (or similar meaning message, I'm Italian)
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Well, the upgrade_exceptions table was empty, and I was only able to find the _scart table, correctly created, but I was not able to find ANY of the RCS_ entry in zencart_configuration table.

I tried to apply the SQL patch using the Admin side, but the message was always the same.
I tried doing this UPLOADING the patch, but this not even worked (it was indeed my first time...)
I tried doing this from myPHPAdmin and obviously there were many references missing...

So, after a DB clearing of the wrongly created tables (the ones created from myPHPAdmin for example...), I decided to run the "DO IT BY HAND" way...

Well, I know this could be very dangerous, but I know how SQL behaves and I know how to enter some data...

I took my risks.

I then entered the first zencart_configuration table value and I succeeded, so I went on with the second... and the third (I know, I had to enter also the value for zencart_configuration_group, but I looked for the right value before starting...).

After the third value, I was already tired (you know: computers should help, not complicate our lives...).

So I edited the original SQL patch to remove the already entered values, to reflect the values which were created by the script (see above) and decided to try to complete this phase within myPHPAdmin...

I succeeded and I was finally able to find all the configuration values within the Configuration menu, to edit them and to finally find my abandoned carts...

I guess that the instruction to create the configuration table is somewhat too long and this could be a problem.

My suggestion is to split it into two shorter instructions to avoid any problems to other, similar to the one I personally suffered.

Hope having given some useful hints to you all.

Best regards.

mickymix

[Spartan]

Thanks for your reply DecoStyle. Per your recommendation, I checked the cache folder and find out the 'scart' db table did not exist.

Since I was upgraded from v1.3.9 I used the Upgrade sql patch, but apparently I needed to use Install instead!

So I used the install-ZC-v-1-5.sql and everything is working.

I am having the same issue, however, I did not upgrade from 1.3.9, and I am trying to run the Install-ZC-v-1-5.sql.
[I did copy over my database from 1.3.8, but did not have this mod installed - I did have Keepcart, in case that was related.]


I get the same error, but here is my log:

PHP Fatal error: 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 1 :: CREATE TABLE zen_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; in /home/spartan1/public_html/shop/includes/classes/db/mysql/query_factory.php on line 101

I notice that the SQL says "CREATE TABLE scart", where the log says "CREATE TABLE zen_scart".
I dont know if that is somehow a problem.

Any ideas as to the problem here?

Should I try to run the Upgrade sql?

[DrByte]

"TYPE=MyISAM" should be "ENGINE=MyISAM" in modern versions of MySQL.

[CSGODeimos]

I'm having the weirdest error happen. This module has worked great for years and now it's giving the error "WARNING: An Error occurred, please refresh the page and try again." Is there any reason this would randomly happen? No changes has been made to the site as far as I'm aware. We just did out quarterly PCI compliance, surely that doesn't have anything to do with it.