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

Had a look at our code and can't find anything like you have above.

How could this happen we just did a download and install I believe.

This is the closest thing:

if ($products_as_url == 'true') {

	$products_id = $result300->fields['products_id'];
	$products_id_part = "&products_id=" . $products_id;
	
	$sql_find_category="SELECT DISTINCT PTC.categories_id
	FROM " . AUTO_TABLE_PRODUCTS_TO_CATEGORIES . " PTC 
	WHERE PTC.products_id = '".$products_id."'";
	
	$sql_find_category_result=$db->Execute($sql_find_category);
	
	$category_id = $sql_find_category_result->fields['categories_id'];
	
	if ( dirname($_SERVER['PHP_SELF']) == "/" ) {
	$initial_url = HTTP_SERVER . "/index.php?main_page=product_info&cPath=";
	} else {
	$initial_url = HTTP_SERVER . dirname($_SERVER['PHP_SELF']) . "/index.php?main_page=product_info&cPath=";
	}

It looks like you have v2.1, whereas the code I quoted is from v2.1a onwards.

However, the changes between these two versions are minimal. v2.1a simply adds the ability to link directly to the product's review page. v2.1 should be working for you, so I doubt upgrading will help, although you could always try.

I think the solution here will be to hard code your website URL into the code. Give me a few minutes to work on that.

Actually would you mind upgrading to the latest version because then I can work with the latest code? :smile:

Okay so I just tried this on my test site and it works. To hard code your URL with the latest version of Autoresponder+:

Find this code:

/* Build first part of URL */
//If hyperlink is to main product page
if ($products_as_url == 'yes, to product page') {
	
//If store is not in a directory
if ( dirname($_SERVER['PHP_SELF']) == "/" ) {
$initial_url = HTTP_SERVER . "/index.php?main_page=product_info&cPath=";
} else {
$initial_url = HTTP_SERVER . dirname($_SERVER['PHP_SELF']) . "/index.php?main_page=product_info&cPath=";
}
		
} else { //Hyperlink is to product review page

//If store is not in a directory
if ( dirname($_SERVER['PHP_SELF']) == "/" ) {
$initial_url = HTTP_SERVER . "/index.php?main_page=product_reviews_write&cPath=";
} else {
$initial_url = HTTP_SERVER . dirname($_SERVER['PHP_SELF']) . "/index.php?main_page=product_reviews_write&cPath=";
}

}

Replace with:

/* Build first part of URL */
//If hyperlink is to main product page
if ($products_as_url == 'yes, to product page') {
		
$initial_url = "http://www.findbliss.com/shop/index.php?main_page=product_info&cPath=";

} else { //Hyperlink is to product review page

$initial_url = "http://www.findbliss.com/shop/index.php?main_page=product_reviews_write&cPath=";

}

Remember to make the above change 3 times.

I can't find that code anywhere in our install to replace with the new hard coded address?

Any chance I could pay you to fix this thing so it works properly? We are gearing up to run a contest every month to generate more reviews and know this link is a big part of increasing reviews.

Appreciate all the help either way.

Hi,

Unfortunately I don't provide custom work.

These are the steps that you need to take:

First, download the latest version of Autoresponder+ (v2.3).

In autoresponder.php (v2.3), replace the aforementioned code, starting at lines 411, 1084, and 1755.

Upload all of v2.3 to overwrite all the mod's old files.

Make a note of your admin settings.

Run the uninstall.sql file.

Run the install.sql file.

Reapply admin settings.

Thanks for all your help. The autoresponder is working perfectly and we even have the headers and text to match the css on our site.

Is there a way to change the look of the customers name text and the text and color of the product details and product link?

Thanks again for creating a great program.

I just installed this mod and it seems its installed correctly but in testing im not getting any emails.

i have installed ver 2.3

any clues to where i can start debugging this?

Oh, it also has the message.

Autoresponder successfully loaded.
End of message.

and still no emails. I just went through and checked all the settings this morning.

Well i have adjusted every setting i can think of and still no emails.:frusty:

Mod is still in test mode, im not willing to turn it on live while im still testing it.

Maybe i will just delete until i can figure out how to fix it:huh:

:frusty:

So, any input? delete it? start over yet again? Im lost, i figured installing this may be a little difficult so i wanted it to be one of the last mods i did....and yea, still not working.

Oh well, guess its manual emails for me.

What exactly are you testing? They are different options. I have tested it for product review and it worked fine. It sends the customer an email and the admin at the same time. You must set the days after which you want the mod to work correctly and then run the autoresponder. I had problems with it in the early stages because I had set the day incorrectly but after that it is working.

Now time to start on customizing the message.

Glamorousshoe:

What exactly are you testing? They are different options. I have tested it for product review and it worked fine. It sends the customer an email and the admin at the same time. You must set the days after which you want the mod to work correctly and then run the autoresponder. I had problems with it in the early stages because I had set the day incorrectly but after that it is working.

Now time to start on customizing the message.

weird, I never got a notification email that someone replied to this thread? Oh well...

I was doing the sample test. I checked the date my last order was set to delivered status and set the internal date accordingly. I tried every date around that date before and after and still nothing came to the admin email. I didnt want to set it as live until I knew that it was working and not sending like tons of spam.

Now from the instructions, you are supposed to set it to the date your last order is "delivered" status correct??

If someone could suggest anything it would be much appreciated.

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

fusionsp:

Now from the instructions, you are supposed to set it to the date your last order is "delivered" status correct??

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.

Hello,

Have done a first time install of the Auto Responder using the latest version (2.3) on zencart 1.38a with all patches applied.

On running, I get this error:

1146 Table 'database1.AUTO_TABLE_ORDERS_STATUS_HISTORY' doesn't exist
in:
[SELECT DISTINCT OSH.orders_id, O.customers_email_address, O.customers_name FROM AUTO_TABLE_ORDERS_STATUS_HISTORY OSH, AUTO_TABLE_ORDERS O WHERE OSH.date_added like '2010-03-04%' AND OSH.orders_status_id IN (3) AND OSH.orders_id=O.orders_id AND OSH.orders_status_id=O.orders_status]

I'm using a test account (in my name) in test mode, with the order updated to "dispatched" (order status 3) today and the AutoResponder set to 0 days.

I realise this error is similar to the one reported at the start of the thread, but the problem and fix are for version 1 and not 2.3.

Any help much appreciated as it looks a fab contribution if I can get it to work!

Hi,

Did you upload the following file?

includes/extra_datafiles/autoresponder.php

Steven300:

Hi,

Did you upload the following file?

includes/extra_datafiles/autoresponder.php

I have now! Thanks....I missed it in the install and it works perfectly now.

Very grateful for the quick response and a really useful contribution.

Glad it's working for you :smile:

Steven300:

Glad it's working for you :smile:

Actually, do seem to have found a bug.

On the function to process orders of one order status (e.g. Dispatched) and change them to another order status (e.g. Followed Up), I'm getting the following error when running:

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

212649 is the order number
3 is the status of the order it should be changed to (the original order status was 10)

If I don't try and automatically change the order status, then it works fine.

Any ideas on how to fix?

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