Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
None
-
None
Description
I have a COManage 1.0.6 test installation with MySql, and have been having errors with Extended Attributes. I added several attributes of type Integer, one at a time, because sometimes the values have disappeared after saving them. I had 4 attributes added and decided to delete them to start from scratch, and the next one I attempted to add got this error:
Database Error
|
|
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int1 INTEGER' at line 2
|
|
SQL Query: ALTER TABLE cm_co3_person_extended_attributes ADD COLUMN int1 INTEGER
|
|
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
|
Stack Trace
|
|
CORE/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)
|
CORE/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)
|
CORE/Cake/Model/Datasource/DboSource.php line 669 → DboSource->execute(string, array, array)
|
CORE/Cake/Model/Datasource/DboSource.php line 540 → DboSource->fetchAll(string)
|
[internal function] → DboSource->query(string)
|
CORE/Cake/Model/Model.php line 3456 → call_user_func_array(array, array)
|
APP/Controller/CoExtendedAttributesController.php line 275 → Model->query(string)
|
APP/Controller/StandardController.php line 128 → CoExtendedAttributesController->checkWriteDependencies(array)
|
[internal function] → StandardController->add()
|
CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(CoExtendedAttributesController, array)
|
CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)
|
CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(CoExtendedAttributesController, CakeRequest)
|
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)
|
I had enabled debug level 2 in app/Config/core.php because of the saving problems, in case that matters. It printed a bunch of SQL queries but not the one that failed so I'm not sure they're relevant.
I went to try again to add another extended attribute and got a different error this time:
Database Error
|
|
Error: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cm_co3_person_extended_attributes' already exists
|
|
SQL Query: CREATE TABLE cm_co3_person_extended_attributes ( id SERIAL PRIMARY KEY, co_person_role_id INTEGER REFERENCES cm_co_person_roles(id), created TIMESTAMP, modified TIMESTAMP );
|
|
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
|
Stack Trace
|
|
CORE/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)
|
CORE/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)
|
CORE/Cake/Model/Datasource/DboSource.php line 669 → DboSource->execute(string, array, array)
|
CORE/Cake/Model/Datasource/DboSource.php line 540 → DboSource->fetchAll(string)
|
[internal function] → DboSource->query(string)
|
CORE/Cake/Model/Model.php line 3456 → call_user_func_array(array, array)
|
APP/Controller/CoExtendedAttributesController.php line 249 → Model->query(string)
|
APP/Controller/StandardController.php line 128 → CoExtendedAttributesController->checkWriteDependencies(array)
|
[internal function] → StandardController->add()
|
CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(CoExtendedAttributesController, array)
|
CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)
|
CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(CoExtendedAttributesController, CakeRequest)
|
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)
|