Date Reverts back to 1969-12-31

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Trying to change the date of registry from default to actual
2.
3.

What is the expected output? What do you see instead?
To see registration open up today.  When I select today's date, update and then 
go back to the home page, it says that registration is closed as of 1969-12-31.

What version of the product are you using? On what operating system?
1.3.0.4 on Windows 7 Professional

Please provide any additional information below.

I'd like to have this competition page up and running for people to register 
today, if desired.  I have a live radio spot tonight that I'd like to announce 
the competition on at 7pm Central.  

Original issue reported on code.google.com by jmerri...@northernbrewer.com on 9 Oct 2014 at 5:49

[GoogleCodeExporter]

I'm not sure what the issue is, but if you have access to your MySQL database 
(via phpMyAdmin or something), you can do a manual override directly in the DB.

First, however, you need to convert the date into a Unix timestamp (how many 
seconds it will be from January 1, 1970). http://www.epochconverter.com will 
easily do it for you.

For example, 12:00AM midnight today, October 9, 2014 is 1412812800

Then, access the contest_info table in the DB. There are several open and close 
columns that have Unix timestamps. Choose the one that you want and insert the 
Unix timestamp from the epoch converter. See screenshot.

Hope that can help...

Original comment by gpzhumphrey on 9 Oct 2014 at 7:25

Attachments:

• [Screen shot 2014-10-09 at 1.22.13 PM copy.png](https://storage.googleapis.com/google-code-attachments/brewcompetitiononlineentry/issue-440/comment-1/Screen shot 2014-10-09 at 1.22.13 PM copy.png)