Abandoned Shopping Cart Email Reminder

Also found a small bug in cart_reminder_cron.php, line 33.

Code:

---

$sql ="SELECT configuration_value FROM ".DB_PREFIX ." configuration WHERE configuration_key = 'CART_REMINDER'";

---

should be

Code:

---

$sql ="SELECT configuration_value FROM ".DB_PREFIX ."configuration WHERE configuration_key = 'CART_REMINDER'";

---

(I removed a space after ".DB_PREFIX .")

This script also needs the DB_PREFIX added to each statement.

Quote:

---

Originally Posted by jberman

Also found a small bug in cart_reminder_cron.php, line 33.

Code:

---

$sql ="SELECT configuration_value FROM ".DB_PREFIX ." configuration WHERE configuration_key = 'CART_REMINDER'";

---

should be

Code:

---

$sql ="SELECT configuration_value FROM ".DB_PREFIX ."configuration WHERE configuration_key = 'CART_REMINDER'";

---

(I removed a space after ".DB_PREFIX .")

This script also needs the DB_PREFIX added to each statement.

---

I'll check this and we'll update it if need be.

Quote:

---

Originally Posted by Zola

I'll check this and we'll update it if need be.

---

We have submitted a new version with bug fixes for db prefix issues. Please check for version 1.1 as soon as it is approved on the download page: http://www.zen-cart.com/downloads.php?do=file&id=1589

Hello!
Is there a way to change the webpage links in the email reminder from http://webpage.com/index.php?main_pa...oducts_id=3666 to http://webpage.com/shop/index.php?ma...oducts_id=3666

our store is in "shop" folder.


regards!

Quote:

---

Originally Posted by Gurrumino

Hello!
Is there a way to change the webpage links in the email reminder from http://webpage.com/index.php?main_pa...oducts_id=3666 to http://webpage.com/shop/index.php?ma...oducts_id=3666

our store is in "shop" folder.


regards!

---

Hi Gurrumino,

I have updated the package with some changes that should address the issue of the store folder. It looks like we didn't have the define variable DIR_WS_CATALOG in the links. I have not tested this on a live site yet so please let me know if this works so I can update the package on the Zen-Cart web site: https://www.box.com/shared/static/gx...nyhtkb9xpb.zip

Thanks,

-Sean

Hello gonsman, now is working perfectly ...:smile::D

Best Regards!

Quote:

---

Originally Posted by Gurrumino

Hello gonsman, now is working perfectly ...:smile::D

Best Regards!

---

Great! I will submit the update to the plugin page.

I noticed that the email sent by these module, the cart content is repeated, is just me? or is a little bug?

This is my first time, so please be gentle...

I have installed shopping cart reminder and been having the following email for days. It comes every hour, at the time chosen.

/bin/sh: 0: command not found
/bin/sh: php: command not found

The code I placed in cron is 0 ****cd/home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

I think I saved this correctly on godaddy cron Job manager but don't know if I did code right. Go daddy says never seen 0 ****cd before my address info, but copied it from instructions info.

I have read all dialogue here, and checked cart reminder install to confirm changes above this were on my copy correctly. I believe this is the only thing installed affecting core files.

My site is reasonablerigging.com and the site is on the index level of the site.

Can someone tell me what to do that does not involve inflicting pain on myself...?

Many thanks,

Marc

Quote:

---

Originally Posted by Trademagic

/bin/sh: 0: command not found
/bin/sh: php: command not found

The code I placed in cron is 0 ****cd/home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

---

Might try this instead (assuming the path is correct):

Code:

---

php -f /home/content/69/11416569/html/cart_reminder_cron.php > /dev/null

---

By starting with "php -f" it's saying "tell PHP to execute the file specified as the next parameter".
GoDaddy support can tell you what the correct syntax is to run PHP CLI (command-line-interface) with cron jobs on their servers.
Sometimes the -f is not needed.
Sometimes additional params are needed
Sometimes something other than the >/dev/null as a suffix might be required, depending on server configuration requirements and operating systems.