Option to close a closed auction?

Badger · August 22nd, 2010, 03:20 PM

Here's a pic of the state of an auction that shows as CLOSED, yet the "Product Options" drop down gives me the option of closing it again?

What I'm trying to accomplish is restart the auction to have it run again as there was no successful bidder. I have another auction in the same state. I'm an Admin, but I'm also the original creator and owner of the ad itself.

What steps would I take to accomplish the above and I wasn't sure if this was a bug or not ...

Thanks...

Regards,
Doug

Chuck S · August 22nd, 2010, 05:32 PM

did you refresh the page as thats ajax

Badger · August 22nd, 2010, 05:53 PM

Quote:

Originally Posted by Chuck S

did you refresh the page as thats ajax

Yes Sir, I did ...

I have two auctions which closed a few days ago, as the one in the pic shows ...

However, the drop down box doesn't give me a choice to relist, but says I can close it again?

Should I try to CLOSE it from the drop down box and see what happens?

Regards,
Doug

Edit: Ok, I gambled and selected CLOSE from the drop down box and the auction which already said CLOSED (it had closed as an auction automatically because time had run out) remained marked as CLOSED, however, when I re-opened the drop down box, this time there was no CLOSE option, but a RELIST option. I selected that and the auction went live again.

I did that same thing with my other auction and it also worked the same there, so everything is working ok now.

Badger · August 23rd, 2010, 06:34 AM

Update:

Ok, there is something strange going on with auctions ....

Look at the first pic in Post #1 and check statistics ...

2 items sold for $500 ....

Now, the time expired with my 2 auctions mentioned in Post #1, but I never received an email indicating they had been closed, yet they were marked as closed within the ad itself, but not within the drop down box. (see pic in Post #1)

So, as indicated with edit update in Post #2, I selected "Close" in each one from their drop down boxes and I immediately received an email for both auctions saying those two auctions had been closed. Both drop down boxes then gave me an option to relist, which I did.

Now, look at the pic attached here and notice that the statistics adjusted the number of ads to 0 by subtracting those two auctions 2-2=0 and it also took the opening prices for each auction $500 and $1600, subtracting them both from the "Value of items sold", which was $500 (see pic in Post #1).

+$500 minus $2100 = current value shown of minus -$1600

Why would it do that when nothing at all sold?

Second, how to a fix stats to be correct for all true classifieds activity?

Regards,
Doug

Chuck S · August 23rd, 2010, 08:48 AM

You cant fix stats because there is nothing to fix it from since ads are temporary and removed. You can go into your cp_stats table in phpmyadmin and fix the amount via the database if you want.

Now as far as stats and auctions if I look at the editproduct.php script if you close an auction then the stats are updated

Code:

Content visible to verified customers only.

Likewise if you resell an ad since that indicates that functionality is there for a user when there buyer falls though there is code to minus out the amounts

Code:

Content visible to verified customers only.

So as far as those functions I did a little test

auction - PhotoPost Classifieds

I opened and closed an auction on my test site and the stats increased when I closed it which it should and then I relisted it and they where subtracted fine which they should.

what version are you using by the way?

Badger · August 23rd, 2010, 09:53 AM

Using upgrade 4.03, although bottom of screen says:

Powered by: PhotoPost Classifieds 4.01 vB3 Enhanced
Copyright 2010 All Enthusiast, Inc.

... and Admin screen says:

Classifieds 3.13 Update!
more info - quick link to Members Area

I think the problem is that whatever job that was supposed to run to close the auctions when they reached their time limit, apparently marked them as close (see pic in Post #1) but never did the other things, because the drop down box was still showing "Close Auction" and the stats totals never reflected the change, so, when I manually closed the auctions from the drop down box, of course it went into subtraction mode.

Again, phpMyAdmin scares the hell out of me, so I can't change the negative amounts manually....

Regards,
Doug

Chuck S · August 23rd, 2010, 10:12 AM

the only way to change the stats is to issue a query.

UPDATE cp_stats SET amt_sold='';

Badger · August 23rd, 2010, 12:36 PM

Is there a CRON job somewhere that monitors the ending of auctions and either closes them or restarts them?

Thanks ...

Regards,
Doug

Badger · August 23rd, 2010, 12:57 PM

I found these settings under "Admin Options" settings ... (see pic)..

Why is the line repeated twice with two different field values possible?

Should this be turned ON and is this why the auctions were marked CLOSED, but hadn't been officially expired and I received no emails?

Could this be the root of the problem as I can't find anywhere else in vBulletin 4.04 tasks where a CRON job runs that's related to Photopost Classifieds?

Regards,
Doug

Chuck S · August 23rd, 2010, 01:18 PM

Our settings are located in our program.

You will have to email me site info. I do not keep emails along time since I sent sometimes a hundred emails a day I clear out my mail folders weekly.

Badger · August 23rd, 2010, 03:29 PM

Quote:

Originally Posted by Chuck S

Our settings are located in our program.

You will have to email me site info. I do not keep emails along time since I sent sometimes a hundred emails a day I clear out my mail folders weekly.

Thanks Chuck ...

I sent an email ...

Regards,
Doug

Chuck S · August 23rd, 2010, 05:28 PM

No problem

Badger · August 24th, 2010, 07:53 AM

Here's another example of an anomaly I don't quite understand ....

This auction is marked closed within the body of the ad (see pic), but the the "Closing Auctions" box says it still has another 40 plus days to go?

Shouldn't this data have been updated when the auction closed, or maybe it didn't and the "CLOSED" indicator in the ad itself is wrong?

Regards,
Doug

Chuck S · August 24th, 2010, 08:10 AM

The closing auctions box is a thing outside the program its not part of the program so I would suspose your confusion is that box.

now adding AND status=0 to that box corrects that

Badger · August 24th, 2010, 08:14 AM

Understood .. ..

I see you're working on it ... thanks ..

Can you also reset "Items Sold" = 2 which will bring it back into balance?

Regards,
Doug

Chuck S · August 24th, 2010, 09:27 AM

okay no problem

Badger · August 24th, 2010, 11:03 AM

Hi Chuck…

I note that all the patches I did that permit "Contact Seller" to go to vBulletin's PM (Private Message) function, plus redirects "Membership List" and "Profile" functions to vBulletin's equivalents, have now gone with the fixes you performed. May I add them back if you are finished with the auction and comments fixes, as well as the CRON job check making sure it will close auctions from now on?

... or, would you prefer I wait until you're finished with other custom work?

Regards,
Doug

Chuck S · August 24th, 2010, 11:59 AM

your fine to do any mods

Badger · August 24th, 2010, 12:04 PM

Quote:

Originally Posted by Chuck S

your fine to do any mods

Thanks boss ...

Regards,
Doug

Badger · August 24th, 2010, 12:31 PM

Ok, mods in place and everything seems to work as before ...

I did find one extraneous link now that there's comments showing on Index page, which points to Photopost Profile still. I couldn't find which module (index.php?) the reference was in so I could redirect it to vBulletin's profile for the member. (see pic)..

Thanks Chuck ...

Regards,
Doug