Auction ended email sent every 3. day

zews · September 5th, 2007, 08:12 AM

After an auction is finished, there is sent an email about it. But I have a problem that this email is repeated every third day after the auction is finnished.

Several users report this problem.

I have version 2.61 installed.

Chuck S · September 5th, 2007, 08:42 AM

Hello around line 29 in sendnotice.php edit the query and make sure the code is as posted here in bold

Code:

Content visible to verified customers only.

zews · September 5th, 2007, 10:33 AM

Thank you!

It looks like some auctions are beeing reopened without the users doing it. Might there be something wrong with this code also? (line 81 sendnotice.php)

// Close out expired ads
$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);

Chuck S · September 5th, 2007, 02:53 PM

No that looks fine there. I think the sendnotice change I made should help. It will guarantee ads which are not closed and status is 0 will send the email and then it will set status to todays unixdate which means on the next time sendnotice runs that one auction will not be sent an email

If not we can work on this some more but let me know how that changes works out first. I dont have a production site to work with to test.

agbates · September 17th, 2007, 05:50 PM

I am now getting the same thing. I keep getting emails saying the auction has closed, except mine are everyday. Plus the auctions aren't going away. I've got my Number of days to show sold/closed ads? set at 1. Auctions keep getting bumped for some reason..should I try this as well?

Chuck S · September 17th, 2007, 06:29 PM

Yes go ahead and try never got a response back from the other user.

agbates · September 17th, 2007, 06:48 PM

OK., I've made the edit, will have to give it a day or so to see what I get back (if anything)

zews · September 18th, 2007, 12:31 AM

The fix in post 2 fixed both emails and the problem with reopening auctions.

Chuck S · September 18th, 2007, 07:59 AM

enjoy and let us know if there is anything else you need.

agbates · September 21st, 2007, 05:05 PM

This seems to have solved my dilemma as well.

Chuck S · September 21st, 2007, 06:57 PM

Have a great evening if you need anything else let me know.

wacnstac · February 26th, 2008, 08:22 PM

Chuck I am having the same problem as described above and am using the sendnotice.php dated 2/22/08. I had previously posted in another thread that my users were getting multiple emails upon the expiration of an auction. This was not correct. What is really happening is that the auction expires, they get an email, and then the auction sets itself up for another 3 days continuing the cycle. This is the same exact problem the users above describe. I am running 2.61 and like I said the latest sendnotice.php. Does the latest sendnotice have all the above fixes in it?

wacnstac · February 26th, 2008, 08:25 PM

Oh and by the way, I have confirmed that this happens on auctions that are marked as sold before they expire if that helps you any.

Chuck S · February 26th, 2008, 08:38 PM

Correct look at the code posted above and this is in the build already. If an auction or ad is marked sold status is set to a unix datestamp not 0 hense the sendnotice script will only pull info for open auctions and close them as noted status = 0 so it is impossible to send an email again for an auction once the script is ran. You might want to check to ensure your cron script is correctly running meaning the queries are updating the enddate and status fields.

I have tested this thoroughly and see no issues.

wacnstac · February 26th, 2008, 09:12 PM

Um, the code for most recent sendnotice.php does not match what is shown above.

Chuck S · February 26th, 2008, 10:12 PM

Your telling me you do not see status=0 in the query to grab auctions?

wacnstac · February 26th, 2008, 10:29 PM

Here is the code in sendnotice.php as released on 2/22/08

Code:

Content visible to verified customers only.

This doesn't look like the fix posted above.

Chuck S · February 27th, 2008, 07:01 AM

Try the code in the post then thanks.

wacnstac · February 27th, 2008, 05:18 PM

This is pathetic and unfortunately common place with Photopost these days. This problem which was posted here and know about since September of last year was fixed by the code in post 2 of this thread and yet this code never made it into a released version of sendnotice.php even though it has been released as late as 2/22 of this year. Come on Photopost let's get it together!