1076 replies to this topic

[midijay]

hi

1st great contrib.  had this working fine, for a little while, then moved to a dedicated server and although everything else in Osc works fine for some reason this contrib stopped working.

Not completely mind you, it still shows the carts to recover, it's just that when you hit "send email" it takes a few seconds then just takes you back to adnim/recover_cart_sales.php as if you had not done anything.  The emails don't send and the carts are still there showing as uncontacted.

Has anyone come across this?

[musashi79uk]

sakwoya, on 15 November 2010 - 10:23 AM, said:

The error o.orders_status > a:3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";}  is down to the way the contribution started saving multiple statuses - I've reverted to just saving one status so you'll get o.orders_status > 0 (or whatever) to properly correct that error you'll need to change the query to something along the lines of o.orders_status = 0 or o.orders_status = 3 and so on

Where do I change this in the file? I can't seem to find where and what to change?

[sbetto]

midijay, on 27 January 2011 - 01:55 PM, said:

hi

1st great contrib.  had this working fine, for a little while, then moved to a dedicated server and although everything else in Osc works fine for some reason this contrib stopped working.

Not completely mind you, it still shows the carts to recover, it's just that when you hit "send email" it takes a few seconds then just takes you back to adnim/recover_cart_sales.php as if you had not done anything.  The emails don't send and the carts are still there showing as uncontacted.

Has anyone come across this?

Hi midijay, I experienced this issue too and think I have resolved the issue (at least all appears to be working for me now :-)
I have V2.23a dated 1DEC2008 installed but am using the file recover_cart_sales.php (catalog/admin) from the 2.0a version dated 11JAN2011 with a change to where the email is sent. I have replaced the code at around line 308 in catalog/admin/recover_cart_sales.php

Replaced this code below:
//tep_mail($custname, $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, EMAIL_FROM);
//Let's build a message object using the email class
    $mimemessage = new email(array('X-Mailer: osCommerce'));
    // add the message to the object
    $mimemessage->add_text($email);
    $mimemessage->build_message();

      $mimemessage->send($custname, $outEmailAddr, '', EMAIL_FROM, EMAIL_TEXT_SUBJECT);
With this code:
tep_mail('', $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, EMAIL_FROM);  

*** please note I am no expert in this code but this did work for me to at least get the emails sending. (I found info on this forum helpful - http://www.oscmax.com/forums/oscmax-v2-customization-mods/19425-cant-send-email-recover-cart-sales-2-22-a-2.html) I have not experienced any other fallout as a result of this change as yet but there could well be as its early days of this install for me.
Cheers, Sarah

Edited by sbetto, 18 February 2011 - 01:47 AM.

[magnetiKmania]

Hi,

I'm new to this contribution, I've installed everything following the steps and it seemed to work at the start. In my admin panel I have the recovert cart sales available under configuration but when I try to find it on Tools the only that appears is this:

[img]http://www.magnetikmania.com/external_images/cartproblem.jpg[/img]

Does anyone have had the same issue or knows how to solution it?

Thanks!

[14steve14]

magnetiKmania, on 15 May 2011 - 09:12 PM, said:

Hi,

I'm new to this contribution, I've installed everything following the steps and it seemed to work at the start. In my admin panel I have the recovert cart sales available under configuration but when I try to find it on Tools the only that appears is this:

[img]http://www.magnetikmania.com/external_images/cartproblem.jpg[/img]

Does anyone have had the same issue or knows how to solution it?

Thanks!

  Surely its only a case of a missing define in your languages folder.  I didnt know this worked with 2.3.1

[magnetiKmania]

Hi,

I Installed this contribution as MS2 but it doesn't seem to work. I can edit all the aspects in the configuration but once Im at tools the I get this < as a new tool that goes to error. Do you know maybe why?

[img]http://magnetikmania.com/external_images/ScreenShot.png[/img]

[Brainbug125]

Just a question...
I really not interested to have "Multiple dropdown Configuration" because it change my configuration.php in a way that i dont like.
I know that this contrib needs  that (why?)...but i trying to keep things (and my code) as much clean it possible.
Is there a chance to install this contrib hacked without needing to install that "dropdown"?
I like this contrib but i think that I will have some conflicts..
Is there another contrib around that can make same job?
Tx

[Brainbug125]

Umm maybe i found the answer..

seems that is only  one option that need this..

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
   VALUES ('', "Pending sales statuses", 'RCS_PENDING_SALE_STATUS', 'a:1:{i:0;s:1:"0";}',
   "Select the order statuses that can be considered as pending. This information is used to find a succesfull order from the same customer with the same products", 6501, 85, NULL, NOW(), 'tep_get_multiple_order_status_names', 'tep_cfg_pull_down_multiple_order_statuses(');

I will try to install without this

[Brainbug125]

stats_recover_cart_sales.php

Around line 45 i have eliminated this but i dunno the effects

and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ')

Maybe is better if i esclude all this file

[simplebabytweet]

I recently installed this. Every aspect works great, except the send emails portion. The contrib acts like it is sending an email, but the mail is actually never sent. I am using v2.2 RCA. If this has been referenced somewhere else in this thread, please point me to it as I was not able to find thie same problem.

[simplebabytweet]

This worked thanks!

sbetto, on 18 February 2011 - 01:35 AM, said:

Hi midijay, I experienced this issue too and think I have resolved the issue (at least all appears to be working for me now )
I have V2.23a dated 1DEC2008 installed but am using the file recover_cart_sales.php (catalog/admin) from the 2.0a version dated 11JAN2011 with a change to where the email is sent. I have replaced the code at around line 308 in catalog/admin/recover_cart_sales.php

Replaced this code below:
//tep_mail($custname, $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, EMAIL_FROM);
//Let's build a message object using the email class
$mimemessage = new email(array('X-Mailer: osCommerce'));
// add the message to the object
$mimemessage->add_text($email);
$mimemessage->build_message();

  $mimemessage->send($custname, $outEmailAddr, '', EMAIL_FROM, EMAIL_TEXT_SUBJECT);
With this code:
tep_mail('', $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, EMAIL_FROM);  

*** please note I am no expert in this code but this did work for me to at least get the emails sending. (I found info on this forum helpful - http://www.oscmax.com/forums/oscmax-v2-customization-mods/19425-cant-send-email-recover-cart-sales-2-22-a-2.html) I have not experienced any other fallout as a result of this change as yet but there could well be as its early days of this install for me.
Cheers, Sarah

[simplebabytweet]

Idefix_SIN, on 16 May 2010 - 08:51 AM, said:

I have exactly the same problem. Any solution to this yet??

Thanks !

It looks like this problem has been around for a while. Any solutions?
This is what I get

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 ':1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased ' at line 1

select o.orders_id, o.customers_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), orders_status s where (o.customers_id = 299 OR o.customers_email_address like "dana_XXXX" OR o.customers_name like "DanaXXXX") and o.orders_status > a:1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20120902" and ot.class = "ot_total"


Dana was the last person to abandon a cart.

[simplebabytweet]

Idefix_SIN, on 16 May 2010 - 08:51 AM, said:

[img]http://forums.oscommerce.com/public/style_images/master/snapback.png[/img][/url]xtreme109, on 23 February 2010, 15:19, said:

new problem on the reports/stats page!!

Working... 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 ':3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_stat' at line 1

select o.orders_id, o.customers_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), orders_status s where (o.customers_id = 39 OR o.customers_email_address like "evan@xxx.com" OR o.customers_name like "Evan xxx") and o.orders_status > a:3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100223" and ot.class = "ot_total"

Ideas?

]
I have exactly the same problem. Any solution to this yet??

Thanks !

[honda4]

Hi, I have installed this contrib last week and it works to my full statisfaction.

I have a question however.
The installation is 2.2 RC2, with version 2.0a of this contrib.

When I sent the e-mails, they arrive in plain text, showing the HTML tags. I can live with is, but this could look better.

Is there a setting or patch or so?

Cheers, Rene

[honda4]

simplebabytweet, on 04 September 2012 - 06:49 PM, said:

It looks like this problem has been around for a while. Any solutions?
This is what I get

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 ':1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased ' at line 1

select o.orders_id, o.customers_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), orders_status s where (o.customers_id = 299 OR o.customers_email_address like "dana_XXXX" OR o.customers_name like "DanaXXXX") and o.orders_status > a:1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20120902" and ot.class = "ot_total"


Dana was the last person to abandon a cart.

I found this on a French site, it worked for me:


Patch for stats_recover_cart_sales.php

REPLACE:

	 $orders_query_raw = "select o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and o.orders_status > ' . RCS_PENDING_SALE_STATUS . ' and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';

BY:

	 $orders_query_raw = "select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ') and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';

Edited by honda4, 11 October 2012 - 02:00 PM.

[simplebaby]

Thanks that worked!!!

[iflyamphib]

Getting started early on new years resolutions, one of which to get RCS fully functional. Few months ago I migrated my sites (started over completely new) over to osc 2.3.1

1) I added the Multiple Dropdown Config addon (http://addons.oscommerce.com/info/6634)
2) Uploaded the RCS files to the appropriate locations
3) Added the sql for RCS
4) Found the forum reference to missing language file (stats_recover_cart_sales.php) and added that. That took care of the missing headers on the RCS report page.

Sign in under my test account and abandon a cart, then sign out. Run the RCS report under the Tools menu works correctly. Emails are sent correctly, and shown as having contacted the customer. If I then sign back in as the customer and complete the transaction, the abandoned cart is removed from the RCS report under Tools.

Here's where the last problem occurs: Under the Recovered Cart Sales Report (Under Reports), Examined Records and Recovered Sales are zero. Everything but this last step works.