Getting 500 Internal Server Error and DBSQ000 Error from the database

[Marcel LeBrun]

I'm doing a simple query that always worked and now it doesn't.

I noticed an older thread on this where it was a bug the devs were working on. Is there a problem still?

I query with a single where clause and get this response:

{
"status":"500 Internal Server Error",
"url":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"DBSQ000",
"description":"This wasn't supposed to happen but an error occurred. Please try again. If the error persists please let us know on the http://appery.io/forum or email us: a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a"
}
}

[Illya Stepanov]

Hi Marcel -

Can you show the query that you're using?
And also have you tried to test with curl command in DB collection window?
::http://docs.appery.io/documentation/b...

[Marcel LeBrun]

If I write a custom query using the "run query" button in the DB, it works.

However, my service is getting the 500 internal server error. It is fairly simple... bt strange. Here are screenshots of the service configuration and test.

[Marcel LeBrun]

and also here is the request config

[Illya Stepanov]

Hi Marcel -

Looks like it's a bug, will be reported.

For now try to remove 'sort' from request parameters or insert some value in it.

[Maryna Brodina]

Hello!

Please share your app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a.

[Marcel LeBrun]

Thanks Illya. That worked, so I created a clone without the sort parameter and the error went away.

I'm suspecting that there is a bug when a query has a sort parameter, but where it returns only one record in the result. Something to check out anyway.

[Kateryna Grynko]

Hi Marcel,

Could you please share the app and show that bug?

[Marcel LeBrun]

what email address should I share the app with?

[Marcel LeBrun]

Oh, NVM... a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a I assume.