Banner Manager - Scheduled Date is Null

[ksoup]

Hi,

Zen Cart 1.3.9h

My Banner manager doesn't turn ads on like it should. So, I went back to the banner and noticed that the scheduled date is missing. I set it, save, go back in and it is still blank.

If I look at the database, there are only Nulls in the date scheduled column.

How do I fix??

[Ajeh]

Could you post the dates that you are using on the Banners in the Banner Manager that you find are disappearing?

Is this a Clean Install of Zen Cart or an Upgrade of an older version of Zen Cart? If an older version, what version did you upgrade from?

Has this ever worked for you?

[ksoup]

Could you post the dates that you are using on the Banners in the Banner Manager that you find are disappearing?

Is this a Clean Install of Zen Cart or an Upgrade of an older version of Zen Cart? If an older version, what version did you upgrade from?

Has this ever worked for you?

thank you, Ajeh... Clean install

they aren't disappearing, they just don't even write to the database.

we haven't used banner manager before now so i don't know :)

when you are in banner manager in admin, you can click on the down arrow for the calendar... I click on that and select Feb 7, 2011... it shows in the box until i hit save and then if i open the banner edit page again, it is blank and correspondingly null in the database.

[DrByte]

What version of PHP?

[ksoup]

What version of PHP?

thx 5.2.13

[DrByte]

Oops ... sorry, I meant to ask your MySQL version
... and whether STRICT_TRANS mode is enabled

[ksoup]

Oops ... sorry, I meant to ask your MySQL version
... and whether STRICT_TRANS mode is enabled

LOL... ok... 5.0.9 but cannot find information about STRICT_TRANS ... where would i find that?

[ksoup]

LOL... ok... 5.0.9 but cannot find information about STRICT_TRANS ... where would i find that?

looks like that was introduced with 5.2 so i guess it isn't :)

[ksoup]

looks like that was introduced with 5.2 so i guess it isn't :)

Sorry... I guess that was 5.0.2

[DrByte]

thank you, Ajeh... Clean install

they aren't disappearing, they just don't even write to the database.

we haven't used banner manager before now so i don't know :)

when you are in banner manager in admin, you can click on the down arrow for the calendar... I click on that and select Feb 7, 2011... it shows in the box until i hit save and then if i open the banner edit page again, it is blank and correspondingly null in the database.

Is it any different if you type in the date instead of using the javascript calendar?
What is the exact date you're entering/selecting?
I think Ajeh was wanting to see the actual digits and formatting you (or the javascript calendar) were using before clicking the save button.