Details
-
Bug
-
Resolution: Fixed
-
Critical
-
COmanage Registry 3.2.1 (Contact)
Description
POST-ing to /telephone_numbers.json:
{
|
"RequestType":"TelephoneNumbers", |
"Version":"1.0", |
"TelephoneNumbers": |
[
|
{
|
"Version":"1.0", |
"Number": "1234567890", |
"Description":"work phone", |
"Person": |
{
|
"Type": "CoRole", |
"Id": <a CoPersonRole.Id> |
}
|
}
|
]
|
}
|
Getting result:
comanage | 2019-03-27 22:17:08 Error: [PDOException] SQLSTATE[42703]: Undefined column: 7 ERROR: column CoPersonRole.co_id does not exist |
comanage | LINE 1: SELECT "CoPersonRole"."co_id" AS "CoPersonRole__co_id" FROM ... |
comanage | ^
|
comanage | HINT: Perhaps you meant to reference the column "CoPersonRole.cou_id". |
comanage | Request URL: /registry/telephone_numbers.json
|
comanage | Stack Trace:
|
comanage | #0 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(489): PDOStatement->execute(Array) |
comanage | #1 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(455): DboSource->_execute('SELECT "CoPerso...', Array) |
comanage | #2 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(702): DboSource->execute('SELECT "CoPerso...', Array, Array) |
comanage | #3 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(1213): DboSource->fetchAll('SELECT "CoPerso...', Array) |
comanage | #4 /srv/comanage-registry/lib/Cake/Model/Model.php(3040): DboSource->read(Object(CoPersonRole), Array) |
comanage | #5 /srv/comanage-registry/lib/Cake/Model/Model.php(3012): Model->_readDataSource('first', Array) |
comanage | #6 /srv/comanage-registry/lib/Cake/Model/Model.php(1666): Model->find('first', Array) |
comanage | #7 /srv/comanage-registry/app/Controller/Component/ApiComponent.php(91): Model->field('co_id', Array) |
comanage | #8 /srv/comanage-registry/app/Controller/StandardController.php(63): ApiComponent->checkRestPost() |
comanage | #9 [internal function]: StandardController->add() |
comanage | #10 /srv/comanage-registry/lib/Cake/Controller/Controller.php(491): ReflectionMethod->invokeArgs(Object(TelephoneNumbersController), Array) |
comanage | #11 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction(Object(CakeRequest)) |
comanage | #12 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(TelephoneNumbersController), Object(CakeRequest)) |
comanage | #13 /srv/comanage-registry/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse)) |
comanage | #14 {main} |
comanage | 172.18.0.5 - sim [27/Mar/2019:22:17:08 +0000] "POST /registry/telephone_numbers.json HTTP/1.1" 500 2260 "-" "python-requests/2.19.1" |