PhotoPost Community - View Single Post - SQL to mass change duration of existing ads

creativepart · February 21st, 2007, 11:30 AM

Thanks, I appreciate that.

I have some sold ads that are not going away. I run the cron job daily and process the expired ads deletes. They don't show up if you peruse the cats, but they show up in the toppage random ads display on my forum.

They all have status numbers -- and none of the non-sold ads seem to have status numbers. Can you give me an SQL to delete all ads with a status number? (We don't have any auctions, if that matters.) There are only 22 of these and I can manually delete them. Why would these not go away???

One more question, I see today that my licenses expired earlier this month. I have PP, RP and PP-C products. Do I need to renew all three licenses? Or just one?

Thanks
Paul Green
PS. I was surprised that I didn't receive any email notice that my licenses expired as well.

February 21st, 2007, 11:30 AM	#3 (permalink)
creativepart Member Verified Customer Join Date: May 2003 Location: Spring Branch, Texas Posts: 247	Thanks, I appreciate that. I have some sold ads that are not going away. I run the cron job daily and process the expired ads deletes. They don't show up if you peruse the cats, but they show up in the toppage random ads display on my forum. They all have status numbers -- and none of the non-sold ads seem to have status numbers. Can you give me an SQL to delete all ads with a status number? (We don't have any auctions, if that matters.) There are only 22 of these and I can manually delete them. Why would these not go away??? One more question, I see today that my licenses expired earlier this month. I have PP, RP and PP-C products. Do I need to renew all three licenses? Or just one? Thanks Paul Green PS. I was surprised that I didn't receive any email notice that my licenses expired as well. Last edited by creativepart; February 21st, 2007 at 11:50 AM.