Anyone else have issues with date fields for Pages?

[Jimi Wikman]

I just realized that if I add a date field I get errors anytime someone tries to add something if they do not have permission to add content to field. The input is then blank and somehow that cause errors:

 

INSERT INTO `ipb_cms_custom_database_31` ( `record_publish_date`, `record_last_comment`, `member_id`, `record_author_name`, `record_last_comment_by`, `record_last_comment_name`, `record_last_review`, `category_id`, `record_approved`, `record_locked`, `record_views`, `record_pinned`, `record_featured`, `record_future_date`, `record_comments`, `record_reviews`, `record_comments_queued`, `record_comments_hidden`, `field_348`, `field_355`, `field_349`, `field_350`, `field_351`, `field_356`, `field_353`, `field_352`, `field_354`, `record_saved`, `record_updated`, `record_allow_comments`, `record_dynamic_furl`, `record_static_furl` ) VALUES ( 1629739889, 1629739889, 64, 'JWSE', 64, 'JWSE', 1629739889, 426, 1, false, 0, 0, 0, 0, 0, 0, 0, 0, 'Help setting up Support Tickets', 'general', '<p>
	a
</p>
', 'new', 'medium', '', '', '', 'No Note', 1629739889, 1629739889, true, 'help-setting-up-support-tickets', NULL )
IPS\Db\Exception: Incorrect integer value: '' for column `jimiwikm_sirius`.`ipb_cms_custom_database_31`.`field_356` at row 1 (1366)
#0 /home/jimiwikm/public_html/system/Db/Db.php(936): IPS\_Db->preparedQuery('/*jimiwikm_siri...', Array)
#1 /home/jimiwikm/public_html/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('cms_custom_data...', Array)
#2 /home/jimiwikm/public_html/applications/cms/sources/Records/Records.php(1916): IPS\Patterns\_ActiveRecord->save()
#3 /home/jimiwikm/public_html/applications/cms/sources/Records/Records.php(1096): IPS\cms\_Records->save()
#4 /home/jimiwikm/public_html/system/Content/Item.php(402): IPS\cms\_Records->processForm(Array)
#5 /home/jimiwikm/public_html/applications/cms/sources/Records/Records.php(2382): IPS\Content\_Item::createFromForm(Array, Object(IPS\cms\Categories31), true)
#6 /home/jimiwikm/public_html/system/Content/Item.php(138): IPS\cms\_Records::createFromForm(Array, Object(IPS\cms\Categories31))
#7 /home/jimiwikm/public_html/applications/cms/modules/front/database/category.php(738): IPS\Content\_Item::create(Object(IPS\cms\Categories31))
#8 /home/jimiwikm/public_html/system/Dispatcher/Controller.php(90): IPS\cms\modules\front\database\_category->form()
#9 /home/jimiwikm/public_html/applications/cms/sources/Databases/Dispatcher.php(327): IPS\Dispatcher\_Controller->execute()
#10 /home/jimiwikm/public_html/applications/cms/widgets/Database.php(128): IPS\cms\Databases\_Dispatcher->run()
#11 /home/jimiwikm/public_html/applications/cms/sources/Pages/Page.php(1284): IPS\cms\widgets\_Database->render()
#12 /home/jimiwikm/public_html/applications/cms/sources/Pages/Page.php(2264): IPS\cms\Pages\_Page->getWidgets()
#13 /home/jimiwikm/public_html/applications/cms/modules/front/pages/page.php(227): IPS\cms\Pages\_Page->output()
#14 /home/jimiwikm/public_html/system/Dispatcher/Controller.php(90): IPS\cms\modules\front\pages\_page->__call('form', Array)
#15 /home/jimiwikm/public_html/applications/cms/modules/front/pages/page.php(33): IPS\Dispatcher\_Controller->execute()
#16 /home/jimiwikm/public_html/system/Dispatcher/Dispatcher.php(153): IPS\cms\modules\front\pages\_page->execute()
#17 /home/jimiwikm/public_html/index.php(13): IPS\_Dispatcher->run()
#18 {main}

Once I add the permission, but still does not set any date, it works.

Anyone else have that issue, or is it just me?

[Marc]

Thank you for reporting that. I have just taken a look and can replicate this myself. I've added a bug report so that this can be resolved in a future release 

[Jimi Wikman]

Thanks @Marc Stridgen, thought I was going mad 🙂

[Marc]

13 minutes ago, Jimi Wikman said:

Thanks @Marc Stridgen, thought I was going mad 🙂

No, not at all. I do enough for that for us all 😄