Serious Auction Problem again!

KenDude · November 14th, 2008, 12:40 PM

Chuck,

Remember when I reported that items were not ending properly in the auctions? Well it is happening again and right now you can check it out for yourself before any more maintenance runs on the site.

Here is the item in question:

Message - Cayman Classifieds

Note that it says it has SOLD but yet there are still over 21 hours remaining in the auction although the ending time listed and the time remaining make no sense whatsoever! They are:

Fri November 14, 2008 11:05pm
21 Hours, 25 Minutes, 56 Seconds

If you go to the Classifieds and look at the auction category nothing appears (because it has already been marked sold prematurely)

See this category: Message - Cayman Classifieds

Can you help ASAP?

Chuck S · November 14th, 2008, 12:47 PM

A user can close his auction so has the user done this?

The category you meantion is empty

Do you have links to any prior discussion?

Chuck S · November 14th, 2008, 12:50 PM

That is the only way any ad is going to be closed as the only place you can mark an auction closed is through sendnotice cron which is only going to close auctions that are older than the CURRENT TIME

Code:

Content visible to verified customers only.

or the user who placed the auction can mark it closed.

KenDude · November 14th, 2008, 05:15 PM

Chuck,

I am the user who listed the item, not him. I did NOT mark it sold. The item is in the Expired queue that is why it isn't showing up in the category, if you click on the item itself can you see it? It is in category that only a certain usergroup has access to so you might not be able to, if not let me know and I'll give you access to that group. As you could see from the info I posted in the first post, the ad says that is is expiring tonight at 11:05pm, yet still has 21 hours remaining? How is it even possible for

A) It to be expiring tonight when it is already marked expired and in the expired queue?

B) Assuming the website thinks it isn't expired and will expire tonight at 11:05 PM, instead of 21 hours remaining, it should have been something like 12 hours remaining, so the hours remaining isn't calculating correctly either.

Let me know what you need me to do, if you need access etc.

Chuck S · November 14th, 2008, 05:35 PM

Is your server is not way different timezone than the classifieds?

I know we render timezones for users as they place their offsets but the actual auctions are expired based on realtime on the server so if your server time is say 12 or 15 hours off I can see this happening.

I posted the query in sendnotice.php above. An auction can only be closed out two ways through the cron job and through you closing it.

Code:

Content visible to verified customers only.

The query has not changed in any new version basically all that cron task does is grab any auctions where the enddate is less than the current time on the server that are still open and it expires them and sends out the high bidder etc emails.

I did find your GMT offset was like 13 hours behind as it should be 6 to render the vb time correctly as I checked this by doing an admin action and now it reports the correct time there.

What is the unix timestamp in the database products table for that ad under enddate?

Chuck S · November 14th, 2008, 05:36 PM

I think I also got the issue here you set one day ahead to reset ads to be displayed so your auction actually ended last night at 12am so then we up it to one day just so you can still see the ad in showcat based on the settings you put.

KenDude · November 14th, 2008, 05:56 PM

Chuck,
Right now it is 5:51pm CDT

I am now seeing that the auction ends tomorrow, here are the stats above at this moment:

Sat November 15, 2008 10:05am
16 Hours, 13 Minutes, 58 Seconds

What is going on? A few hours ago it was supposed to end tonight Friday at 11:05 pm and have 21 hours to go, now it is 16 hours to go but ending tomorrow??? This makes no sense!

Ok sorry copied that from my message posted to the ad under yours.

I don't know what the unix timestamp is in the table but when I get home I can go int plesk and take a look and let you know.

I'm not following you with regard to settings and displaying the ad still, etc. Can you tell me which settings you mean and how should they be set in my admin panel??? If I have something wrong, please help me fix it!

Chuck S · November 14th, 2008, 06:21 PM

I do not think you understand what I am saying

1. Your auction correctly expired Friday at 12:04pm

2. Your GMT offset was wrong I fixed that for you. I am EST here.

There really is not a problem persay. The issue is with a feature in the program that you have turned on.

In Admin => ShowAd Options you have this set to 1 day

Number of days to show sold/closed ads?

This setting will allow those closed ads and auctions to show in your category display even if expired. Now this is where your issue comes in. To allow them to display we need to set the enddate to a higher date which is in your case another day.

I have something that might help in showproduct.php find this

Code:

Content visible to verified customers only.

change to this

Code:

Content visible to verified customers only.

KenDude · November 14th, 2008, 09:41 PM

Yep that new code seems to work, says "Auction Closed" now as it probably should!

Aren't you glad I keep finding these things in the code Chuck? You really ought to get me on your beta test team.

Chuck S · November 15th, 2008, 07:32 AM

Anyone can participate on the beta program

KenDude · December 6th, 2008, 04:29 PM

Well tell me how to sign up then, or do you simply mean downloading the files in the members area marked "beta" ?

Chuck S · December 6th, 2008, 08:09 PM

I mean when a beta is open in any particular software you can choose to participate

KenDude · December 7th, 2008, 10:12 PM

Ok, what's open right now?

Chuck S · December 8th, 2008, 11:06 AM

vbgallery is in the works but not open yet