Forum | Appery.io

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"
}
}

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...

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.

and also here is the request config

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.

Hello!

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

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.

Hi Marcel,

Could you please share the app and show that bug?

what email address should I share the app with?

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