Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Zero date in timestamp #2

Closed
zerocrates opened this issue May 18, 2016 · 0 comments
Closed

Zero date in timestamp #2

zerocrates opened this issue May 18, 2016 · 0 comments
Assignees

Comments

@zerocrates
Copy link
Member

See http://omeka.org/forums/topic/record-relations-plugin-installation-issue

Newer MySQL versions by default don't allow the "all-zero" timestamps they used to. You could replace that default with CURRENT_TIMESTAMP (as the zero date was usually just a workaround for wanting two timestamps on one record, which was previously illegal), or with some arbitrary but valid date. The arbitrary date method then requires you to use something like our Timestamp mixin to correctly set the date from the PHP side.

On a quasi-related note, I'd guess that the current timestamp doesn't update correctly. Usually ON UPDATE clauses don't really work with the Omeka ORM (as it always specifies a value for every column).

See also omeka/Omeka#678.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants