197 replies to this topic

[Jack_mcs]

Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory.

Jack

[valley]

Jack_mcs, on Feb 5 2006, 03:12 PM, said:

Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory.

Jack

Hello Jack,
Many thanks for your reply. I got my host to check out
and it seems everything was OK> Any way I haven't
made more trials.

I have a problem with adsmin/auto_emailer_announce.php.

It looks like it is not writing the number of days field to the
auto_emailer/auto_announce.php file when you update after
filling in a number for example 2.

All the other fields seems to be writing new data.

When I simply update the fild carry the number inserted but
if you change menu and come back later it disapperars.

I think due to this the auto_announce.php do not out put
when you make a trial.

Could you please let me know how this can be fixed ?

Cheers
Shred

[Jack_mcs]

If the permissions on the file are correct then your host is blocking it somehow.

Jack

[valley]

Jack_mcs, on Feb 12 2006, 01:20 AM, said:

If the permissions on the file are correct then your host is blocking it somehow.

Jack

Hello Jack,

I have rechecked the permissions which are set to
777 both for the autoemailer directory and the files.

I did a trial changing the subject in the subject field
which has been updated in the file also with new time stamp.

When I change the number of days the time stamp is changed
showing the file has been accessed but the ield returns empty
during next refresh of the admin file.

Could you please let me know the line number or statement
that is re written to take the nunber of days ?
(I couln't find an obvious one . ) I can check if this is re written.

[valley]

valley, on Feb 12 2006, 06:07 AM, said:

Hello Jack,


Could you please let me know the line number or statement
that is re written to take the nunber of days ?
(I couln't find an obvious one . ) I can check if this is re written.

On checking the admin file I see a code section

else if ($pos_start = strpos($fp[$idx], "// Start Date Difference") !== FALSE)
		  {
			 for ($idy = $idx; $idy < count($fp); ++$idy)
			 {
				if ($pos_stop = strpos($fp[$idy], "// Stop Date Difference") !== FALSE)
				{
				   $new_text[0] = "	  if (\$diff >= 0 && \$diff < ". $ae_array['days'] . ")";
				   $new_text[1] = "\n";
				   array_splice($fp, $idx + 1, $idy  - $idx - 1, $new_text);
				   break;
				}
			 }
		  }

However I can't see a corresponding statement in the auto_announce.php
between the Date Selection and Subject . Have I got the latest file
or am I missing something ?

// Start Date Selection
	  $adjDate = sprintf("%s-%s-%s", $adjYr, substr($customer['customers_dob'], 5, 2),substr($customer['customers_dob'], 8, 2));
// Stop Date Selection
	  $diff = DifferenceBetween($currentDate, $adjDate);

	  if ($diff >= 0 && $diff < 18)
	  {
// Start Subject
		 $Subject = 'test' . ' ' . $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
// Stop Subject

[Jack_mcs]

You're correct. The current version has a problem. I have uploaded a new version that fixes this problem.

Jack

[valley]

Jack_mcs, on Feb 12 2006, 01:33 PM, said:

You're correct. The current version has a problem. I have uploaded a new version that fixes this problem.

Jack

Hello Jack,

Many thanks for the reply and upload of the New version.
I did try with the new announce file but still has no out put.
there ae no error message, when you open
in a browser, the page comes up done but no E mail sent.

I wonder the database link is ever opened.
(I have noticed that you make the call in auto_emailer.php
and not in auto_announce.php.)

I thought it was direct from the auto_announce in a previous
release.

Any ideas please ?

Shred

[Jack_mcs]

The first release was meant to run as a cron job and could not be accessed via admin. That was completely changed and now works as most other contributions. If you have files from previous versions they should be delteted. Also make sure your cron command is looking at the proper file to execute.

Jack

[valley]

Jack_mcs, on Feb 12 2006, 03:04 PM, said:

The first release was meant to run as a cron job and could not be accessed via admin. That was completely changed and now works as most other contributions. If you have files from previous versions they should be delteted. Also make sure your cron command is looking at the proper file to execute.

Jack

Can your latest version be run from browser ?
I try to run from the Browser for trials till I can get them working

Cheers

[valley]

Jack_mcs, on Feb 12 2006, 01:20 AM, said:

If the permissions on the file are correct then your host is blocking it somehow.

Jack

Hello Jack,
I nearly give up !!

I can't get announce to work at all .
On trying auto_orders I get

Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44
[Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44
[Sun Feb 12 16:48:01 2006] [error] PHP Warning:  mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_orders.php on line 44

[wmfwlr]

Hey,

The issue is the newline specified in the class.

It currently reads:

define("EmailNewLine", "\r\n");

Your SMTP server (likey QMail) mangles any line sthat already have the correct newline encoding (\r\n) and replaces them with \r\r\n. This is why you see the HTML rendering as text in your email client.

Replace the above line with

define("EmailNewLine", "\n");

This should fix the problem.

Let me know if you have any other questions.

Edited by wmfwlr, 22 March 2006, 01:46.

[Prophet_LA]

Hello,

first of all thanks a lot for this great contribution.

But I am facing right now a strange error msg:

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /usr/www/users/rotolosa/apfelplus/shop/admin/auto_emailer/class.Email.php on line 261

same for lines : 265,270,281,292,297,304

It seems like my actual PHP version 4.3.10 doesn't support &$var calls. I tried to remove all &'s. This will result in a wired formated email but eleminates the error msgs.

I was wondering that nonelse faces this problem.

[100asa]

wmfwlr, you're wonderful!
Contribution works great!
Best regards

[wmfwlr]

Hey

My quess is that you are actually running PHP 5. First, undo all your changes pertaining to the reference error. Change the line at roughly 620 that says

function Add($mimeBlock=null)

to be

function Add(&$mimeBlock=null)

This allows the method to accept the MIME blocks being added as references (but detected at 'compile' time).

Then change each of the lines that calls the Add method (roughly on the lines you indicated) to remove any reference operator. For example,

$this->RootContainer->Add($contentContainer);

instead of

$this->RootContainer->Add(&$contentContainer);

If this does not help I have a version that should fix your problem I can email to you directly.

Edited by wmfwlr, 26 March 2006, 21:30.

[kynchiiin2]

I am receiving the following from my cron-job...

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web_l/d29/s29/a0006nm2/www/RaidersStore/nfoscomm/catalog/admin/auto_emailer/auto_emailer.php on line 21/>
Could not connect

Any help would be greatly appreciated...

Thanks!
Steve

[Jack_mcs]

That's a setup problem on the server. You should ask your host what to take a look at it.

Jack

[kynchiiin2]

I'm using a different cron now and it is working.... except that now i get...

Parse error: parse error, unexpected ',' in /mnt/web_l/d29/s29/a0006nm2/www/RaidersStore/nfoscomm/catalog/admin/auto_emailer/auto_orders.php on line 28

Jack_mcs, on Apr 25 2006, 06:49 PM, said:

That's a setup problem on the server. You should ask your host what to take a look at it.

Jack

[Jack_mcs]

Are you using version 1.4? Has your auto_orders file been edited?

Jack

[Juanernesto]

Hello everybody!

I 've just found this contribution and I would like to know if it's also possible to send an invoice to each customer as a pdf attachement (automatically when his order status gets updated). In my store each purchase creates automatically an invoice.pdf. Would it be possible to have this invoice.pdf get mailed to each customer with this contribution?

Many thanks in advance,

Johannes

[Jack_mcs]

Yes. The orders and customers modules show how to attach a csv file and send it. You would need to alter it to send the pdf but it should work.

Jack