Postgres error on Nuget search

[Guest]

Hello,

I'm getting the following error when I try to connect from Visual Studio to a Nuget feed hosted on a ProGet container running on a Linux server.

An error occurred processing a GET request to http://mydomain.com/nuget/testfeed/Search()?$filter=IsLatestVersion&searchTerm: 42601: query has no destination for result data

I've tried a couple of times and the error happens on a fresh container. Followed the installation instructions on the support article.

Error on Nuget package manager on VS 2017:
The V2 feed at 'http://mydomain.com:8081/nuget/testfeed/Search()?$filter=IsLatestVersion&searchTerm=''&targetFramework=''&includePrerelease=false&$skip=0&$top=26&semVerLevel=2.0.0' returned an unexpected status code '500 Internal Server Error'.

Info:

Full trace: https://pastebin.com/iuKvAcvh
OS: Debian GNU/Linux 9 (stretch) x86_64
Docker: Version 17.09.0-ce
Proget: latest docker image, Version 5.0.2 (Build 5)
License: ProGet Free
Postgres: tag 9.5

Thanks,

Javier

Product: ProGet
Version: 5.0.2

[ben]

Hello Javier,

There is an error in the PostgreSQL version of NuGetPackagesV2_GetLatestStable, which was introduced in the 5.0 beta. I've filed this as PG-1164 and submitted a fix for my co-workers to review.