Ads not clearing out properly...

robferrari · July 29th, 2005, 10:17 PM

None of my ads were being removed when expired and I don't even think expiration notices were going out. So I searched on here and found that sendnotice.php needed to be put in a cron to handle notices and removals. Is that right?

I just ran sendnotice.php from the browser and it said "Done". Now no ads are appearing and there are dozens that are new and just posted this week which shouldn't have been expired. The main page still shows the same ad counts.

I'm using 2.11 vB3 Enhanced

Where have my ads gone and what do I specifically need to do for expiration notices and removals to take place?

Thank you,
rob

robferrari · July 29th, 2005, 10:27 PM

OK, I saw the sticky in the Installation Forum...

Cron Job: sendnotice.php

I ran the Db scan and that fixed my counts. However, where in the heck did all my ads go and why!?!

Like I said, there should still be hundreds of ads that haven't expired, but now all categories are showing 0.

Chuck S · July 29th, 2005, 10:30 PM

Well the script is absolute in that it expires things that are expired. You should be able to view expired ads in admin approve window

robferrari · July 29th, 2005, 10:31 PM

I found all the ads in the Expired Que and except for the old ones, they have expiration of July 29th. So where is this bugged? In the php or options config?

robferrari · July 29th, 2005, 10:39 PM

Quote:

Originally Posted by omegatron

Well the script is absolute in that it expires things that are expired. You should be able to view expired ads in admin approve window

OK, I can approve everything back in, so the ads aren't lost. <whew>

FYI even ads posted 6 months ago and long expired showed an expiration of July 29th. So doesn't matter between ads posted today or 6 months ago, all July 29th. Why would this be? sendnotice.php has never been run before or another setting?

robferrari · July 29th, 2005, 10:41 PM

I've got 31 pages of ads to approve. Why can't I toggle all from Leave to Approve at once?

robferrari · July 29th, 2005, 10:43 PM

Even after I approve the ads and run the Db scan to update numbers, the front page isn't getting the count back, but I can see the approved ads again.

robferrari · July 29th, 2005, 10:56 PM

Sorry for the shotgun of posts, but I just want to get all the issues posted as I'm going to bed soon and you can just answer all at once on your own time.

So in summary, my outstanding issues/questions are...

1) All ads have expiration of July 29th. So where is this bugged? In the php or options config? Why would this be? sendnotice.php has never been run before or another setting?

2) Even after I approve the ads and run the Db scan to update numbers, the front page isn't getting the count back, but I can see the approved ads again.

3) All ads are now displayed as SOLD!!!

Thanks,
rob

Chuck S · July 30th, 2005, 08:24 AM

Wow okay lets try and answer this

1. There is no bug here. As you see you never ran the cron script and your ads where all expired and thus you ran it on July 29th hense all ads expired on July 29th

2 and 3. Yes you can approve them back but that just sets them for display. For any ad you want active you must hit resell which will set the enddate to a future date and approve to 0 and reset a few other things then it will be fine.

No bugs anywhere that I see just a lack of maintenance. Would not be the first time someone has not set the cron task to clean house.

robferrari · July 30th, 2005, 06:20 PM

Quote:

Originally Posted by omegatron

Wow okay lets try and answer this

1. There is no bug here. As you see you never ran the cron script and your ads where all expired and thus you ran it on July 29th hense all ads expired on July 29th

Thank you for the help. Glad all the problems are simply me not setting the cron script.

So just to confim, even if ads were posted July 28th, if I ran the cron job for the first time July 29th, they would be expired? That part really doesn't make sense that I lost all ads, even ones just posted and not expired. That's what made me think something else was wrong. So if I send the script to run now daily, what will keep it from not removing new ads posted today?

Thank you,
rob

robferrari · July 30th, 2005, 06:44 PM

Quote:

Originally Posted by omegatron

For any ad you want active you must hit resell which will set the enddate to a future date and approve to 0 and reset a few other things then it will be fine.

When I hit resell it says item isn't in Db although it is appearing in the categories as sold.

Chuck S · July 30th, 2005, 06:44 PM

It does not remove ads that are not expired. It removes ads that are expired so as stated your ads had to be expired

Yes you run the cron every day

robferrari · July 30th, 2005, 06:48 PM

Quote:

Originally Posted by omegatron

It does not remove ads that are not expired. It removes ads that are expired so as stated your ads had to be expired

Yes you run the cron every day

So we do have a bug, this is what I'm trying to tell you. I said it from the begining too. I have dozens and dozens of ads posted in the last week that are intended to have a 15 day expiration by default. So yes, the problem might be the system isn't setting the expiration date right, but where? Is something I need to configure?

Trust me, many ads have been posted that had not reached their expiration, but the system expired them, that's why no ads were left. Now if this is something with the configuration on my side or a bug (I doubt it), I don't know, but it isn't working.

robferrari · July 30th, 2005, 07:02 PM

Just to prove to you I'm not lying.

The first image shows the count for NEW ads that have been posted since this problem last night. There are 7 ads posted in the past half day.

The second image is after running sendnotice.php, which then showed no ads in the categories and then after updating the count, showed 0 for all on this main page.

Chuck S · July 30th, 2005, 07:40 PM

what version of the software you running?

Make sure your running the latest so we are not tracking any old bugs.

I find nothing wrong with the above process's on 2.41

robferrari · July 30th, 2005, 09:47 PM

Quote:

Originally Posted by omegatron

what version of the software you running?

I guess you don't read everything I type, communication might be better in the future if you do that. I will try upgrading first.

Quote:

Originally Posted by robferrari

I'm using 2.11 vB3 Enhanced

Remember, I'm the paying customer. Thanks.

Chuck S · July 30th, 2005, 10:08 PM

Thats your first post in this thread and on another day my friend. I deal with many posts and many people.

Your using 2.11 and it is strongly suggested to upgrade.

robferrari · July 30th, 2005, 11:24 PM

Quote:

Originally Posted by omegatron

Thats your first post in this thread and on another day my friend. I deal with many posts and many people.

Your using 2.11 and it is strongly suggested to upgrade.

It only takes a few seconds to review my posts to get all the information. My time is valuable too, I shouldn't have to repeat things.

I have upgraded to 2.41 and the problem still exists.

I created a new ad and set expiration at 90 days. The ad appeared correctly. I ran sendnotice.php and it removed it with an expiration date of today.

Chuck S · July 31st, 2005, 09:40 AM

There is no issue here that I see. Here is a brand new install I am doing and you can test it

http://www.reeftalk.com/classifieds/index.php

Go ahead and run sendnotice.php yourself

http://www.reeftalk.com/classifieds/sendnotice.php

It does not expire ads that are not expired period and here is the query in 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);

NOTICE WHERE enddate < $today

robferrari · July 31st, 2005, 12:27 PM

Quote:

Originally Posted by omegatron

There is no issue here that I see. Here is a brand new install I am doing and you can test it

http://www.reeftalk.com/classifieds/index.php

Go ahead and run sendnotice.php yourself

http://www.reeftalk.com/classifieds/sendnotice.php

It does not expire ads that are not expired period and here is the query in 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);

NOTICE WHERE enddate < $today

I believe you that it works fine on your new install. Please tell me why it may not be working on my individual install? I now have the latest version at 2.41. I have done no customizations. Are there any settings in the Options or Config that could cause it not to put the expiration out 90 days or for the sendnotice script to not accurately filter off that?

Trust me, I have a standard install, no customizations, the Db obviously works because everything else appears to be working fine. I have proven to you with my screen shots it isn't working, so please help.

If you can't help, tell me someone that can.