Salemaker problem in 1.5.5d

[Mikeondraco]

Hi,

have just set up a sale using Salemaker and have come across a bug/issue. If you try and enter anything in the start or end date fields, it defaults to a date sometime in 2036 in both fields regardless, and consequently no sale can be started. If the fields are left blank, then it works as it should, starting immediately and never ending.

Is there a fix for this, or there something I have not done ?

Michael

[mc12345678]

Hi,

have just set up a sale using Salemaker and have come across a bug/issue. If you try and enter anything in the start or end date fields, it defaults to a date sometime in 2036 in both fields regardless, and consequently no sale can be started. If the fields are left blank, then it works as it should, starting immediately and never ending.

Is there a fix for this, or there something I have not done ?

Michael

Tough to say why that is occurring on the site it is. I wasn't able to reproduce the issue with a relatively vanilla install. (at least one that doesn't have any modifications to the salemaker system.)

So, please if you could, provide all of the information asked of the posting tips so that assistance (rather than all out guesses) can be offered.

Posting tips are displayed above the message box when reply or reply quote is selected or when writing a new post.

[carlwhat]

hard to imagine it is a bug.... more than likely a plugin or probably a javascript loading problem.

from what i can tell on a v155 install, the admin makes use of spiffcal for calendars which is javascript dependent.

are you getting any console errors when using the web development tools?

these can be a little tricky to track down.

good luck.

[DrByte]

Hi,

When it flips to a 2036 date it's usually because it's just unable to interpret the date data in the field so just shows the max generic value. Basically a 2036 date means you've got an invalid date in that database field. Often that's just because it's in an invalid format.

1. Try using US-formatted dates: MM-DD-YY or MM-DD-YYYY or the format MySQL most prefers: YYYY-MM-DD

2. If that doesn't work, please go to Admin->Tools->Server Info and post the version info in the top of the page and down to and including the details about your Zen Cart version history. I'm mostly interested in the MySQL version and the MySQL "mode" details, but the other info can be helpful too.

[Mikeondraco]

Thanks all, that was an interesting one. I have set up the date field formats in 1.5.5d for UK use (i.e dd/mm/yyyy) and the drop-down calendars in SaleMaker entered selected dates into the fields in that format, so I expected it to work. However, at DrByte's suggestion above, I modified those selected dates to mm/dd/yyyy format and it worked.

Thanks again all .. Michael