Joey_M Posted December 10, 2021 Posted December 10, 2021 INSERT INTO `cms_blocks` ( `block_position`, `block_type`, `block_active` ) VALUES ( 52, 'custom', 1 ) IPS\Db\Exception: Field 'block_key' doesn't have a default value (1364) #0 /home/server/public_html/system/Db/Db.php(938): IPS\_Db->preparedQuery('/*...', Array) #1 /home/server/public_html/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('cms_blocks', Array) #2 /home/server/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save() #3 /home/server/public_html/applications/cms/sources/Blocks/Block.php(1014): IPS\Node\_Model->save() #4 /home/server/public_html/applications/cms/sources/Blocks/Block.php(744): IPS\cms\Blocks\_Block->save() #5 /home/server/public_html/system/Node/Controller.php(419): IPS\cms\Blocks\_Block->formatFormValues(Array) #6 /home/server/public_html/system/Dispatcher/Controller.php(90): IPS\Node\_Controller->form() #7 /home/server/public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute() #8 /home/server/public_html/applications/cms/modules/admin/pages/blocks.php(44): IPS\Node\_Controller->execute() #9 /home/server/public_html/system/Dispatcher/Dispatcher.php(153): IPS\cms\modules\admin\pages\_blocks->execute() #10 /home/server/public_html/admin/index.php(13): IPS\_Dispatcher->run() #11 {main}+ When I try to create any type of block with IP.Pages, I get the above error. My details for the site and FTP are correct.
Solution Jim M Posted December 10, 2021 Solution Posted December 10, 2021 You will want to disable strict mode on your MySQL server as currently, it is requiring default values for all fields but this one does not have one. Joey_M 1
Recommended Posts