Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

APIv2 Error


#1

Hi,

I’m getting the following error when using the V2 get_plan API to retrieve a test plan:

send: b’GET /TestRail/index.php?/api/v2/get_plan/860 HTTP/1.1\r\nHost: localhost\r\nAccept-Encoding: identity\r\nContent-type: application/json\r\nAuthorization: Basic ***\r\n\r\n’
reply: ‘HTTP/1.1 500 Internal Server Error\r\n’
header: Content-Type header: Server header: X-Powered-By header: X-Powered-By
header: Date header: Content-Length <http.client.HTTPResponse object at 0x04C81310>
{“error”:"[Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘config’."}
’{“error”:"[Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘config’."}’

The plan (850) exists and as far as I can tell, the ‘runs’ table looks ok in the database (with config column present).

Any ideas why this is occurring?


#2

Hello,

Thanks for your posting. Yes, this is a known issue and will be fixed in the next TestRail update (3.0.1) which will be released shortly (likely tomorrow). I will make sure to email you once this is available.

Regards,
Tobias


#3

The new version is now available and can be downloaded from your customer portal account. The release notes can be found here:

http://forum.gurock.com/forum/5/general-discussion/

One thing I forgot to mention previously: please change your TestRail password as your forum posting contained your password (base64 encoded, but still). I’ve removed the password now but please make sure generate a new one nonetheless.

Regards,
Tobias


#4

Thanks. I’ve upgraded and it works great.


#5

Thanks for the confirmation!

Regards,
Tobias