Auction ended email sent every 3. day
 

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.

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

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);

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.

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?

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

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

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

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

This seems to have solved my dilemma as well.

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

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?

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.

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.

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

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

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

This doesn't look like the fix posted above.

Try the code in the post then thanks.

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!