Error if "Date Start" of poll is empty: "Save failed with the following error: Incorrect date value: 'NOW' for column joomla.jos_sexy_polls.date_start at row 1"

Jefferson49 / Joomla_plugin_sexypolling_reloaded

Migration of the joomla plugin "Sexy Polling" to joomla 4.x

GNU General Public License v3.0

2 stars 3 forks source link

Error if "Date Start" of poll is empty: "Save failed with the following error: Incorrect date value: 'NOW' for column joomla.jos_sexy_polls.date_start at row 1" #60

Closed Jefferson49 closed 5 months ago

Jefferson49 commented 10 months ago

Observed with Joomla 4.4., plugin v4.2.0

Administration -> Poll: Error if "Date Start" of poll is empty (e.g. current value is deleted) and poll is saved: "Save failed with the following error: Incorrect date value: 'NOW' for column joomla.jos_sexy_polls.date_start at row 1"

save_poll_failed

Jefferson49 commented 10 months ago

Root cause: Default value "NOW" is not properly handled for field type "calendar"

\admin\models\forms\sexypoll.xml, line 84 <field name="date_start" type="calendar" default="NOW" label ...>

Might be an issue of the Joomla-CMS platform

Jefferson49 commented 9 months ago

Looks like "Function strftime() is deprecated" is an issue in the Joomla platform: https://github.com/joomla/joomla-cms/pull/41266

Pull requests with changes in the code seem to be scheduled for Joomla 4.4

Jefferson49 commented 5 months ago

Same issue as: #92

Fixed with: bebfb7a