I just added a new block type to a matrix field. This caused the matrix field's 'Add block' button to fallback to the Craft default (presumably because I haven't added a preview image for the new field yet? Although I'm sure that didn't used to happen).
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'siteId' doesn't have a default value in /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Command.php:1299
Stack trace:
#0 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Command.php(1299): PDOStatement->execute()
#1 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Command.php(1099): yii\db\Command->internalExecute('INSERT INTO `ma...')
#2 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
#3 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/ActiveRecord.php(600): yii\db\Schema->insert('{{%matrixfieldp...', Array)
#4 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/ActiveRecord.php(566): yii\db\ActiveRecord->insertInternal(NULL)
#5 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/BaseActiveRecord.php(678): yii\db\ActiveRecord->insert(true, NULL)
#6 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/services/BaseBlockTypeConfigService.php(95): yii\db\BaseActiveRecord->save()
#7 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/controllers/SettingsController.php(152): weareferal\matrixfieldpreview\services\BaseBlockTypeConfigService->getOrCreateByFieldHandle('productAddition...')
#8 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/controllers/SettingsController.php(118): weareferal\matrixfieldpreview\controllers\SettingsController->_actionBlockTypes(Object(weareferal\matrixfieldpreview\services\MatrixBlockTypeConfigService), Object(weareferal\matrixfieldpreview\services\MatrixFieldConfigService), 'matrix-field-pr...')
#9 [internal function]: weareferal\matrixfieldpreview\controllers\SettingsController->actionMatrixBlockTypes()
#10 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#11 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#12 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Controller.php(190): yii\base\Controller->runAction('matrix-block-ty...', Array)
#13 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Module.php(534): craft\web\Controller->runAction('matrix-block-ty...', Array)
#14 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Application.php(274): yii\base\Module->runAction('matrix-field-pr...', Array)
#15 /Users/pete/www/saracen/vendor/yiisoft/yii2/web/Application.php(104): craft\web\Application->runAction('matrix-field-pr...', Array)
#16 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Application.php(259): yii\web\Application->handleRequest(Object(craft\web\Request))
#17 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Application.php(392): craft\web\Application->handleRequest(Object(craft\web\Request))
#18 /Users/pete/www/saracen/web/index.php(22): yii\base\Application->run()
#19 /Users/pete/.composer/vendor/laravel/valet/server.php(214): require('/Users/pete/www...')
#20 {main}
Next yii\db\Exception: SQLSTATE[HY000]: General error: 1364 Field 'siteId' doesn't have a default value
The SQL being executed was: INSERT INTO `matrixfieldpreview_blocktypes_config` (`description`, `fieldId`, `blockTypeId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('', 216, 20, '2021-02-15 11:56:48', '2021-02-15 11:56:48', '94c2019e-6a83-4667-bec7-1d2c48bed9aa') in /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Schema.php:678
Stack trace:
#0 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException(Object(PDOException), 'INSERT INTO `ma...')
#1 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Command.php(1099): yii\db\Command->internalExecute('INSERT INTO `ma...')
#2 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/Schema.php(433): yii\db\Command->execute()
#3 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/ActiveRecord.php(600): yii\db\Schema->insert('{{%matrixfieldp...', Array)
#4 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/ActiveRecord.php(566): yii\db\ActiveRecord->insertInternal(NULL)
#5 /Users/pete/www/saracen/vendor/yiisoft/yii2/db/BaseActiveRecord.php(678): yii\db\ActiveRecord->insert(true, NULL)
#6 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/services/BaseBlockTypeConfigService.php(95): yii\db\BaseActiveRecord->save()
#7 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/controllers/SettingsController.php(152): weareferal\matrixfieldpreview\services\BaseBlockTypeConfigService->getOrCreateByFieldHandle('productAddition...')
#8 /Users/pete/www/saracen/vendor/weareferal/matrix-field-preview/src/controllers/SettingsController.php(118): weareferal\matrixfieldpreview\controllers\SettingsController->_actionBlockTypes(Object(weareferal\matrixfieldpreview\services\MatrixBlockTypeConfigService), Object(weareferal\matrixfieldpreview\services\MatrixFieldConfigService), 'matrix-field-pr...')
#9 [internal function]: weareferal\matrixfieldpreview\controllers\SettingsController->actionMatrixBlockTypes()
#10 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#11 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#12 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Controller.php(190): yii\base\Controller->runAction('matrix-block-ty...', Array)
#13 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Module.php(534): craft\web\Controller->runAction('matrix-block-ty...', Array)
#14 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Application.php(274): yii\base\Module->runAction('matrix-field-pr...', Array)
#15 /Users/pete/www/saracen/vendor/yiisoft/yii2/web/Application.php(104): craft\web\Application->runAction('matrix-field-pr...', Array)
#16 /Users/pete/www/saracen/vendor/craftcms/cms/src/web/Application.php(259): yii\web\Application->handleRequest(Object(craft\web\Request))
#17 /Users/pete/www/saracen/vendor/yiisoft/yii2/base/Application.php(392): craft\web\Application->handleRequest(Object(craft\web\Request))
#18 /Users/pete/www/saracen/web/index.php(22): yii\base\Application->run()
#19 /Users/pete/.composer/vendor/laravel/valet/server.php(214): require('/Users/pete/www...')
#20 {main}
Additional Information:
Array
(
[0] => HY000
[1] => 1364
[2] => Field 'siteId' doesn't have a default value
)