Small bugfix in Posters plugin

Omeka Classic Plugins
1

While trying to install the Posters plugin I’ve got an error. After debugging I found the reason:

In plugins/Posters/PostersPlugin.php file line 54:

            `date_created` TIMESTAMP NOT NULL default '0000-00-00 00:00:00',

modify it to something like:

            `date_created` TIMESTAMP NOT NULL default '2000-01-01 00:00:01',

This is because TIMESTAMP value in MySQL does not allow the original one…

Ref:
https://dev.mysql.com/doc/refman/5.7/en/datetime.html

Hope this helps…

2

Yes, you’re correct about the problem and the solution here. Those “zero” timestamps have been changed in most plugins but clearly Posters was left out.

There’s a slight bit of additional code needed to get the actual correct dates recorded, but otherwise you’re right on. I’ve already made the change that should fix the problem.

Thanks for the report!