Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
The Old Man Posted February 7 Posted February 7 (edited) Hi, When editing guest Search Flood Control, I get and uncaught exception: UPDATE `ib_core_groups` `core_groups` SET `g_view_board`=true,`g_dohtml`=false,`g_search_flood`=3.0,`g_access_offline`=false,`g_topic_rate_setting`=1,`g_mod_post_unit`=NULL,`g_avoid_flood`=false,`g_avoid_q`=false,`g_mod_preview`=false,`g_bypass_badwords`=false,`g_can_report`=0,`g_view_displaynamehistory`=false,`g_download_original`=true,`g_movies`=false,`idm_view_approvers`=false,`idm_view_downloads`=false,`idm_linked_files`=false,`idm_import_files`=false,`idm_bulk_submit`=false,`g_blog_allowcomment`=false WHERE g_id=2 IPS\Db\Exception: Column 'g_mod_post_unit' cannot be null (1048) #0 /home/millen29/public_html/tiwwa/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*millen29_ipst...', Array) #1 /home/millen29/public_html/tiwwa/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`ib_core_groups...', '`g_view_board`=...', 'WHERE g_id=?') #2 /home/millen29/public_html/tiwwa/applications/core/modules/admin/members/groups.php(229): IPS\Patterns\_ActiveRecord->save() #3 /home/millen29/public_html/tiwwa/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\members\_groups->form() #4 /home/millen29/public_html/tiwwa/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute() #5 /home/millen29/public_html/tiwwa/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute() #6 /home/millen29/public_html/tiwwa/admin/index.php(13): IPS\_Dispatcher->run() #7 {main} Edited February 7 by The Old Man v4.7.15
The Old Man Posted February 7 Author Posted February 7 (edited) Interesting thanks for that. I just checked and I'm using 10.11.7-MariaDB and apparently strict mode is enabled: Quote STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Edited February 7 by The Old Man Marc 1
Recommended Posts