Autoresponder+ for ZC v1.3.x [support thread]

Steven300:

My first thought is that your database table, orders_status_history, might have additional columns added to it (perhaps by another mod).

Can you check the table using phpMyAdmin. There should be 6 fields:

orders_status_history_id
orders_id
orders_status_id
date_added
customer_notified
comments

You're absolutely right - there are 5 additional fields...

track_id1
to
track_id5

I think it must be SuperOrders or a tracking code contribution we installed.

In autoresponder.php, if you were to replace the following code (lines 693, 1366 and 2037):

$sql_insert_new_status="insert into " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " values ( '', '".$result->fields['orders_id']."', '".$this_auto_post_order_status_id."', now(), 0, '' )";

with this:

$sql_insert_new_status="insert into " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " (orders_status_history_id, orders_id, orders_status_id, date_added, customer_notified, comments) values ( '', '".$result->fields['orders_id']."', '".$this_auto_post_order_status_id."', now(), 0, '' )";

.. it would then work error-free and it would work fine as far as Autoresponder+ is concerned. The only problem being that no values would be inserted into the 5 fields of your other mod. Whether that would be a problem or not, I don't know.

That didn't work unfortunately. Same error message:

1136 Column count doesn't match value count at row 1
in:
[insert into orders_status_history values ( '', '212648', '3', now(), 0, '' )]

What about this?

$sql_insert_new_status="insert into " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added) values ('".$result->fields['orders_id']."', '".$this_auto_post_order_status_id."', now())";

If that doesn't work, I'm out of ideas :unsure:

Steven300:

What about this?

$sql_insert_new_status="insert into " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added) values ('".$result->fields['orders_id']."', '".$this_auto_post_order_status_id."', now())";

> 
> If that doesn't work, I'm out of ideas :unsure:

It didn't work :-(

But thanks for your assistance on this.

I've removed the order tracking code contribution and it works fine now.  We're not using it much at the moment anyway, so we'll post tracking codes in the comments section instead.

Steven300:

Sorry for the late reply, I have been in hospital for the last 5 weeks!

That's right.

As Glamorousshoe suggests, I think this could be an issue with setting the Days After correctly. To eliminate this possibility, one thing you could try is to create a test order, change the order's status to delivered(3), and then set the Days After to 0.

With regard to some of the other settings, make sure:

• Autoresponder+ is enabled.

• The correct preset is enabled.

• Query is set to Order.

• Order Status ID is set to 3.

• Subscribed is set to False.

• There are no location restrictions.

• There are no product restrictions.

• There is no time validation.

• A valid admin email address is entered (or left blank).

Check all other store emails are working.

Try turning on the logging feature to see what output Autoresponder+ provides (if any).

Hope that helps.

Sorry been a while since my question. Im working a lot of hours now. Anyways, yes regular emails are working fine. We just sent out a batch of them tonight. I was not able to test the acct with a fake order but I was able to try it within a day of an actual completed one. i tried every possible date around it...from 0 to 3 and nothing happened?

it seems installed right, is there a way i can uninstall this and try redoing it?

Sure, just follow the uninstall instructions in the read_me.

Also, if you try the mod's logging feature, it will provide some insight into what's happening.

Hello.. I just installed Autoresponder on a new site I am developing.. The install went smoothly and everything seemed fine.. When I run the autoresponder.php I get the Autoresponder successfully loaded.. Yet I do not get the emails.. I am in test mode.. I have a completed order 2 days ago and have the "Days After set to 1 day.. I also turned on logging and no log is being created..:(

CarStickersDecals:

Hello.. I just installed Autoresponder on a new site I am developing.. The install went smoothly and everything seemed fine.. When I run the autoresponder.php I get the Autoresponder successfully loaded.. Yet I do not get the emails.. I am in test mode.. I have a completed order 2 days ago and have the "Days After set to 1 day.. I also turned on logging and no log is being created..:(

Fixed....

Steven. The order status update after emailling don't work for me.

I defined a few order status. 6 is tracing (for asking whether the customers get the pacakge), 7 is dispached (changed to dispached after ship the pacakge). dispached after 21 days, Autoresponder will send a email to asking the customers whether get the package, then the order status change to 6(tracing) after emailing. After 14 days, Autoresponder will change the order status to 3(delivered) from 6(tracing) after send a email to the customers for asking for a products reviews

But Autoresponder don't send any email and change the order status. Could you help me?

enjoyhobbies:

Steven. The order status update after emailling don't work for me.

I defined a few order status. 6 is tracing (for asking whether the customers get the pacakge), 7 is dispached (changed to dispached after ship the pacakge). dispached after 21 days, Autoresponder will send a email to asking the customers whether get the package, then the order status change to 6(tracing) after emailing. After 14 days, Autoresponder will change the order status to 3(delivered) from 6(tracing) after send a email to the customers for asking for a products reviews

But Autoresponder don't send any email and change the order status. Could you help me?

enjoyhobbies:

dispached after 21 days

I think you mean "21 days after dispatched"?

Okay so you need to set up 2 emails:

FIRST EMAIL:
Order Status ID = 7
Post Order Status ID = 6
Days After = 21

SECOND EMAIL:
Order Status ID = 6
Post Order Status ID = 3
Days After = 14

Is that right?

Shouldn't you have dispatched as 6 and tracing as 7? Then it would mostly be in the correct order.

You said that the order status update feature doesn't work. Then you said it doesn't send out emails either.

Which is it? What's working and not working?

I just installed autoresponder 2.3 on zencart 1.3.8a and I am having problems with HTML emails - messages seems to contain no HTML at all. I harcoded autoresponder.php to force HTML messages to all recepients but email template is not event coming thorugh - all I get is just the simple text from HTML text area - no links, not tags, no template.

any insights?

Dee

Dee,

I'm afraid I don't fully understand how Zen Cart sends out plain vs html emails.

I think it's one of the few things that Autoresponder+ is missing - full control over the email type.

Hopefully it can be added at some point, but probably not by me.

Steven300:

I think you mean "21 days after dispatched"?

Okay so you need to set up 2 emails:

FIRST EMAIL:
Order Status ID = 7
Post Order Status ID = 6
Days After = 21

SECOND EMAIL:
Order Status ID = 6
Post Order Status ID = 3
Days After = 14

Is that right?

Shouldn't you have dispatched as 6 and tracing as 7? Then it would mostly be in the correct order.

You said that the order status update feature doesn't work. Then you said it doesn't send out emails either.

Which is it? What's working and not working?

Seven. That's right. I have set up 2 emails as you said. Should i have dispatched as 6 and tracing as 7?
I set up a email to send out preview request, it works.
Just the order status update feature doesn't work and it doesn't send out emails either.

enjoyhobbies:

Should i have dispatched as 6 and tracing as 7?

It probably won't fix the problem but I just thought it would make more sense.

Could the problem be to do with this:
http://www.zen-cart.com/forum/showthread.php?p=852240#post852240

I didn't do anything on the orders_status_history table.

CarStickersDecals:

Hello.. I just installed Autoresponder on a new site I am developing.. The install went smoothly and everything seemed fine.. When I run the autoresponder.php I get the Autoresponder successfully loaded.. Yet I do not get the emails.. I am in test mode.. I have a completed order 2 days ago and have the "Days After set to 1 day.. I also turned on logging and no log is being created..:(

Fixed....

Do you care to tell how you fixed this? I am having the same problem.

Hi steven,

I spent some time to make the autoresponder-idea much more easy to extend and based on module (like e.g. payment, shipping..)

So new autoresponder "preset emails" are realized using Email Modules (e.g. module "birthday", "review" etc.)

you can find the addon
Aftersales Automatic Trigger Email Campaigns on:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=1661

Hi,

You already told me about your mod by PM about a week ago and I replied to you.

Why are you now telling me about it again and in the Autoresponder+ support thread?

It's great that you have written an autoresponder mod but please stop spamming it.

1.3.8p3
I have a few custom mods and super orders. Install was simple, drag.n.drop via ftp. :cool: - no overwrites.

SQL gave the following message:

8 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

and my admin page to access autoresponder+ is blank other than these two lines:

Autoresponder+
Title Value Action

I have read the thread and am not sure where to go from here... ideas? :lookaroun

I am guessing the info is in my error code but I do not know what it means. I saved the entire sql query return message, let me know if that would help :-)