[#457] GetPromotionList giving error

API General
,
1

Migrated from Redmine #457 | Author: Monika Aggarwal
Status: New | Priority: High, I’m very impatient | Created: 2019-12-16

URL: https://user-api.simplybook.me/admin
Method: POST

Request:

{“id”:“1”,
“jsonrpc”:“2.0”,
“method”:“getPromotionList”,
“params”:[“yes”,“yes”,“discount”]
}

Response:
{
“error”: {
“code”: -32000,
“message”: “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘promo.is_public’ in ‘where clause’”,
“data”: null
},
“id”: “1”,
“jsonrpc”: “2.0”
}

2

Dmytro Bondarev wrote:

Hi! Please provide full RAW HTTP request.

3

Monika Aggarwal wrote:

POST /admin HTTP/1.1

Host: user-api.simplybook.me

Content-Type: application/json; charset=UTF-8

Content-Length: 139

Accept: application/json

Request:

{“id”:“1”,
“jsonrpc”:“2.0”,
“method”:“getPromotionList”,
“params”:[true,true,“discount”]
}

Response:
{
“error”: {
“code”: -32000,
“message”: “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘promo.is_public’ in ‘where clause’”,
“data”: null
},
“id”: “1”,
“jsonrpc”: “2.0”
}

4

Monika Aggarwal wrote:

Hi,

Can you please help in the above, it’s quite urgent.

Thanks!

5

Redmine Admin wrote:

Hi, issue is fixed.

(Short original content)

6

Monika Aggarwal wrote:

Okay,Thanks!

(Short original content)

7

Monika Aggarwal wrote:

Can you also please add some data into it?
For now we are getting empty array in each case.

8

Redmine Admin wrote:

Coupons & Gift cards additional feature is not enabled in your DB hdhomeservices