Relisted ad does not show on any pages

[GateKeeper]

Hello,
I relisted an old auction (well past the original end date), and the ad page now shows as an active auction with an end date in April. I cannot seem to get the ad to display in any of the standard queries for "All Ads", "Last Day", etc. I would have thought this would show up under "All Ads" at a minimum. It does show up in the "Recent - Feature Ad" at the bottom of the categories.
Any thoughts would be appreciated.
Thank you.

[Chuck S]

Thats interesting the query looks fine

Content visible to verified customers only.

status is 0 end date is the new date and your ad is approved right?

[GateKeeper]

This is quite interesting. I see no difference in the other active ads on the site, yet this one simply will not display in its rightful category, or show up on any of the appropriate queries.

Shell Vacations Club Kauai Coast Resort At the Beachboy

vs. a working ad

Paradise Isle Resort

To make this really easy to see, I list recent resorts at the bottom of the page for categories. The top listing shows the recent ad, but not the active ad in the category, while the bottom one shows both.
I cannot see a single difference in the two ad records in the database. Could this be a cache thing? The problem ad was re-listed yesterday morning, so I would expect any cache issue to have refreshed by now.
Thank you.

[Chuck S]

Your saying its just one ad not all relisted ads thats quite strange.

I know you have disected the code enough to know what I am showing you by the relist query.

The relist query sets status to 0 the new enddate to the enddate and your approval to whatever it needs to be thus the ad should be just like it was a brand new uploaded ad.

Your category links by the way dont really show anything wrong. Both to me show one ad a piece.

[GateKeeper]

I found the problem (my bad of course!), but I must have missed the flag when looking at the record in the DB.
It turns out that this was "Expired", then relisted, and required approval. But it wasn't in the Approval Queue. It was in the Expired Queue awaiting approval. Oddly, a whole bunch of ads were in there, so I am not sure how that works. The original settings did not require approval of ads for members of specific VB usergroups, and the ads always appeared without any approval from an admin.
All is well that ends well, and that ad is now showing again. Strange it would show in the recent feature block but not in the category. I wouldn't think it should show in the recent block either until it is approved.
Thanks for looking into this.

[Chuck S]

No problem enjoy whats left of the weekend there. I am still tired from losing an hour of sleep last night.

[ClayGP]

I am having the same problem here .. I think it is because that query is leaving the item with an approved status of 2. That is not how it should work if approval is not required.

Where do I go to fix this, and how do I tell which ads are relisted so I can activate them again? (I have a mix of real expired ads, and relisted ads in my queue)

Please help!

Thanks!

[ClayGP]

I ended up setting the query to approved='1' .. and that seems to work.

I also set all posters with approved status of 2 to 1 .. and the cron job 'should' expire the real ones that need to expire and leave the relisted ones active.

I'll just wait and see I guess...

[Chuck S]

The code is quite specific. The query uses the variable $moderate.

Content visible to verified customers only.

0 would be used if your electing to do moderation so if the ad is relisted and not shown check your moderation que or turn OFF moderation in usergroup permissions.