QuickAppsCMS/QuickApps-CMS — Issue #12: Issue with saving block if no roles are chosen
Author: drdouglasghd
Created: 2012-01-06 08:47:39+00:00
State: open

url: /admin/block/manage/edit/9

if no role is checked, when attempt to save... get this message.

Database Error
Error: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'user_role_id' at row 1
Notice: If you want to customize this error message, create C:\Users\Geoff\Sites\QA\QuickAppsCMS-QuickApps-CMS-284d2e8\View\Errors\pdo_error.ctp
Stack Trace
APP\Cake\Model\Datasource\DboSource.php line 2796 → PDOStatement->execute()
APP\Model\AppModel.php line 206 → DboSource->insertMulti(AppModel, array, array)
APP\Cake\Model\Model.php line 1717 → AppModel->_saveMulti(array, string, Mysql)
APP\Cake\Model\Model.php line 2157 → Model->save(array, array)
APP\Cake\Model\Model.php line 1994 → Model->saveAssociated(array, array)
APP\Plugin\Block\Controller\ManageController.php line 112 → Model->saveAll(array, array)
[internal function] → ManageController->admin_edit(string)
APP\Cake\Controller\Controller.php line 484 → ReflectionMethod->invokeArgs(ManageController, array)
APP\Cake\Routing\Dispatcher.php line 104 → Controller->invokeAction(CakeRequest)
APP\Cake\Routing\Dispatcher.php line 86 → Dispatcher->_invoke(ManageController, CakeRequest, CakeResponse)
CORE\QuickAppsCMS-QuickApps-CMS-284d2e8\webroot\index.php line 47 → Dispatcher->dispatch(CakeRequest, CakeResponse)