Ad missing after marked sold

ncangler · March 4th, 2011, 11:30 AM

I have a member that marked his boat for sale as SOLD 2 days ago and now he'd like to unmark it sold as the sale did not go thru. I looked but cannot find the ad in Classifieds search. I checked phpmyadmin and the ad is in the database. How can I edit the phpmyadmin table to make his ad show up again and mark it unsold?

I would have thought that his ad would be searchable in the past 30 days?

Thanks for your help!
Randy

ncangler · March 4th, 2011, 11:38 AM

After I posted this it occurred to me to check the admin area to see how many days SOLD ads show up. It was set to "1" so I upped it to "10" and then found the ad and was able to relist it. Cool! Hope this helps someone else.

Chuck S · March 4th, 2011, 12:01 PM

Yes and you could have seen the ad in the approve photos que under expired ads

ncangler · March 4th, 2011, 12:06 PM

Hey thanks for that tip Chuck. Hadn't seen that before.

Chuck S · March 4th, 2011, 02:34 PM

Yep there is a few ques under that thing