If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Specials and SaleMaker / Banners expiring later than the "expires on" date

Banners expiring later than the "expires on" date

Started by thannaree on 12 Apr 2012, 8:20 AM · Views: 3,442

Results 1 to 9 of 9
12 Apr 2012, 8:20 AM
#1
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Banners expiring later than the "expires on" date

I am setting up a sale with salemaker and use banners to advertise it on the site home page.

The sale expires exactly on the "expires on" date set in the admin. However, the banners expire a day later than the "expires on" date set in the admin.

As these 2 don't coincide, I have been setting the banner to expire a day earlier so far but was wondering if this was normal behavior?

Please advise...

12 Apr 2012, 12:57 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Banners expire at the end of the day on the date that they are set for ...

So if you set it for 04/12/2012 and today is 04/12/2012, then it will expire at the end of the day tonight ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

12 Apr 2012, 1:15 PM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Banners expiring later than the "expires on" date

Where is the geo-location of your host server?

If you are in CHINA and your server is in ENGLAND, the server's time will be several hours EARLIER than the time in CHINA.

20 years a Zencart User

13 Apr 2012, 5:35 AM
#4
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Thanks Ajeh for confirming.

Hi schoolboy, that's what I initially thought - we're located in the Asian zone and the server is in the US. However, both sales and banners should then expires at the same time, no? ... that's strange.

15 Sep 2012, 9:46 AM
#5
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Thannaree:

Thanks Ajeh for confirming.

Hi schoolboy, that's what I initially thought - we're located in the Asian zone and the server is in the US. However, both sales and banners should then expires at the same time, no? ... that's strange.

This time I've created a discount coupon and set a banner ... and again have the same issue. The discount coupon expired exactly at the end of the day it was set for, but the banner almost a day later.

I'm looking at the database and found the following data:

Coupon:
coupon_expire_date
2012-09-11 00:00:00

Banner:
expires_date
2012-09-11 23:59:59

Is this host-related?

15 Sep 2012, 12:48 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Banners expire at the end of the day that you have set the expiration for ...

Banner:
expires_date
2012-09-11 23:59:59

means that at the stroke of midnight of 9-12-2012, which is after 2012-09-11 23:59:59, the banner will expire ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

16 Sep 2012, 3:45 AM
#7
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Ajeh:

Banners expire at the end of the day that you have set the expiration for ...

Banner:
expires_date
2012-09-11 23:59:59

means that at the stroke of midnight of 9-12-2012, which is after 2012-09-11 23:59:59, the banner will expire ...

Thanks Ajeh for your quick reply.

The issue is that the banner always expires one day later.

When I set the banner to expire at the end of 2012-09-11, it expires at the end of 2012-09-12. The data in the database shows:

expires_date
2012-09-11 **23:59:59

**Whereas when I set the coupon to expire at the end of 2012-09-11, it well expires at the end of 2012-09-11. The data in the database shows:

coupon_expire_date
2012-09-11 00:00:00

Is it normal to have these 2, both set to expire at the end of 2012-09-11, expire at different times? I am not much familiar with databases and am not sure why one shows 23:59:59 and the other 00:00:00 ...

Please advise.

16 Sep 2012, 1:20 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Look at the dates and times ...

The Banner date is 2012-09-11 23:59:59

9-11-2012 at 23:59:59 is the second before midnight ... meaning it expires at 9-12-2012 00:00:00 which is a second later ...

The Coupon date is 2012-09-11 00:00:00 that is midnight on 9-11-2012 ... meaning the second after 9-10-2012 11:59:59 ... so one is at exactly midnight on the date you set and the other is at midnight after the date you set ...

If you want the Banner to end at the end of 9-11-2012 (so it does not work on 9-12-2012) you set it to 9-11-2012 and it will end at the stroke of midnight on 9-12-2012, the start of the day for 9-12-2012 ... and it will work on 9-11-2012 but not on 9-12-2012 ...

If you want the Coupon to end at the end of 9-11-2012 (so it does not work on 9-12-2012) you set it to 9-12-2012 and it will end at the stroke of midnight on 9-12-2012, the start of the day for 9-12-2012 ... and it will work on 9-11-2012 but not work on 9-12-2012 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

17 Sep 2012, 3:51 AM
#9
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Re: Banners expiring later than the "expires on" date

Ajeh:

Look at the dates and times ...

The Banner date is 2012-09-11 23:59:59

9-11-2012 at 23:59:59 is the second before midnight ... meaning it expires at 9-12-2012 00:00:00 which is a second later ...

The Coupon date is 2012-09-11 00:00:00 that is midnight on 9-11-2012 ... meaning the second after 9-10-2012 11:59:59 ... so one is at exactly midnight on the date you set and the other is at midnight after the date you set ...

If you want the Banner to end at the end of 9-11-2012 (so it does not work on 9-12-2012) you set it to 9-11-2012 and it will end at the stroke of midnight on 9-12-2012, the start of the day for 9-12-2012 ... and it will work on 9-11-2012 but not on 9-12-2012 ...

If you want the Coupon to end at the end of 9-11-2012 (so it does not work on 9-12-2012) you set it to 9-12-2012 and it will end at the stroke of midnight on 9-12-2012, the start of the day for 9-12-2012 ... and it will work on 9-11-2012 but not work on 9-12-2012 ...

Okay I will follow your instructions. Thank you!!