Recover Cart [Support Thread]

[xlr82quik]

Hello, Just thought I would ask my question again in hopes that someone will be able to assist, here it is:

Hello, I just upgraded from the old version or recover cart sales to the new version of recover cart sales version and I am using zen cart 1.3.7 and PHP Version 5.05 and MySQL Version 5.0.27 and I am getting the following error message:

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /home/MYUSERNAME/public_html/admin/recover_cart_sales.php on line 381

Besides all the errors it appears that the program is working since under all the errors I see all the customers and their abandoned carts.

The error message goes away after I contact the customer, so the error only shows on uncontacted customers.

I hope someone can please help me.

Thank you.

[Woodymon]

Camay, Liberty, 100asa

I'm not sure but a Zen Cart bug fix was posted this past summer related to errors such as you all are reporting. Maybe this relates to your issue (or maybe it does not). Search Bug Reports forum area on "foreach()" or something that relates to the error message.

Woody

[Woodymon]

I am using zen cart 1.3.7 and PHP Version 5.05 and MySQL Version 5.0.27 and I am getting the following error message:

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /home/MYUSERNAME/public_html/admin/recover_cart_sales.php on line 381

The error message goes away after I contact the customer, so the error only shows on uncontacted customers.

I have observed the latest RCS mod version having issues with various datetime functions. Just before Andrew disappeared from the Zen Cart scene he added some new mod functionality but bugs were not fully vetted before he went MIA.

I have just decided to live with the issues as I do not have the coding chops to repair.

It indeed may be related to a MySQL and/or PHP version compatibility issue.

Woody

[twi]

can anyone tell me how to do the patch in admin>patch mysql?

the readme instructions tells me to patch but did not specify how to patch. specific and detailed instructions would be greatly appreciated. I do not know

p.s. how to use MySQL.

[kelvyn]

can anyone tell me how to do the patch in admin>patch mysql?

the readme instructions tells me to patch but did not specify how to patch. specific and detailed instructions would be greatly appreciated. I do not know

p.s. how to use MySQL.

ADMIN>TOOLS>INSTALL SQL PATCHES - paste the code and then press SEND!
(backup first!)

[twi]

you mean to paste in and the click send (four times) for each of the following below?:


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 '',

[clydejones]

you mean to paste in and the click send (four times) for each of the following below?:


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 '',

open the sql script in your text editor and then select all

copy the entire sql script

paste it into admin -> tools -> install sql patches and press the send button

[twi]

Thanks

[a_berezin]

This script requires the full processing. I love the idea of the script, but did not like how it is programmed.
Since I am no longer using this release, I have got only two corrections to the above errors.

recover_cart_sales.php
Find:

if ((time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {

Replace by

if ($basket->fields['datemodified'] != '' && (time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {

stats_recover_cart_sales.php
Find:

$custlist = '';

Add below

$cust_array = array();

[Woodymon]

Thanks Andrew for the patch.

To anyone else who wishes to work on improving or fixing bugs in this mod...

Just to report that after a cart is "recovered", in ZC admin under "Reports" > Recovered Sales Results", the "order date" displays correctly but the "date added to SC" and "RC email sent" are incorrect.

I added Andrew's patch but it did not appear to affect/correct this issue. Likely some other datetime functions are either translating the datetime entry incorrectly when being read from the DB or the datetime is incorrectly written to the database.

Also in ZC admin, under "Tools" > "Recover Cart Sales" I observe a few "ghost" entries, that is entries without a customer name attached. And sometimes an entry has no "Cart Total" or "Set Contacted" link or "delete" button associated with it.

Woody