Abandoned Shopping Cart Email Reminder

[jberman]

Looks like you are either missing files, files corrupted during upload or of the sort. Try re-uploading all files one at a time in their proper directories and see if it fixes it.

This has been attempted twice and the screen remains the same.

[knuckle-101]

This has been attempted twice and the screen remains the same.

Not sure about this one. Did you make sure the SQL was installed properly? As you see in the image it works and all I did was drop the files in their proper directories and upload the SQL . Weird indeed as far as I can tell something did not upload or it corrupted during upload or your SQL was not installed. Maybe someone with the same issue as you have can be more assistance.

Attachment 11979

[jberman]

There were SQL errors in the cart_reminder_install.php (latest version).

On line 46:

$sql = "UPDATE `".DB_PREFIX."configuration_group` SET `sort_order` = $last_id WHERE `configuration_group_id`=";

The "configuration_group_id" variable isn't passed into the statement. I commented this out.

In addition to that, the statements that follow do not append the DB_PREFIX to the configuration table.

i.e.

$sql = "INSERT INTO configuration ...

should be

$sql = "INSERT INTO `".DB_PREFIX."configuration` ...

Thanks for all your help!

[Trademagic]

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

[DrByte]

/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):

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.

[Trademagic]

Thx dr. Byte, but that didn't work. Called godaddy and they recommended getting rid of the php -f and going direct, this occurred, so, getting deeper...

/home/content/69/11416569/html/cart_reminder_cron.php: line 1: ?php
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 2:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 3: /**
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 4: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 5: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 6: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 7: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 8: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 9: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 10: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 11: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 12: **/
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 13:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 14: /bin: is a directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 15:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 16: =: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 16:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 17:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 45: syntax error near unexpected token `('
/home/content/69/11416569/html/cart_reminder_cron.php: line 45: `/* Step 1: Remove all items in cart_reminder table that don't have an associated cart (where the users aren't logged in) */
'

What now? They recommended doing /web/cgi-bin/php5_3 as prefix

[dsimon55]

Does anyone know will this work with Ver 1.50?

[travbacon]

using 1.54. our server is set in another time zone. so we set the time zone adding the command for our time zone in the php.ini.

now we are getting this message every minutes as an error

strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.

any clues how we can fix this in the coding?

cart_reminder_cron.php on line 101

i think if we remove the time zone setting in our php.ini file it goes away but the problem is now the orders that come in do not match our time zone.

THanks.

[ianhg]

Using version zen cart 1.5.4 and COWOA version 2.4
Does anyone know if cart reminder will work with COWOA or will it only work with customers who have actually created an account?
Thanks

[gonsman]

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

Hi Trademagic,

I believe the problem is that you removed a bunch of spaces. You need to have a space after each * and after "cd". Try formatting it like this:

0 * * * * cd /home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null