Jimi Wikman Posted August 23, 2021 Share Posted August 23, 2021 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? Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted August 23, 2021 Solution Share Posted August 23, 2021 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 Ibai and Jimi Wikman 2 Link to comment Share on other sites More sharing options...
Jimi Wikman Posted August 23, 2021 Author Share Posted August 23, 2021 Thanks @Marc Stridgen, thought I was going mad 🙂 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted August 23, 2021 Share Posted August 23, 2021 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 😄 Jimi Wikman 1 Link to comment Share on other sites More sharing options...
Recommended Posts