Where clause is '' is invalid

I am referencing several Tables from Appgyver and they have stopped working.
Looking at the below, I am getting the search bar going pink;

And in the console, similar;

Thing is, I have never used Where clauses here…the field has always been blank. Totally nonplussed…I haven’t been working on these lately, but something seems to have changed.

Any ideas?
Thanks
Paul

Are you looking for help?

This is a support forum for reporting issues related to Backendless services. Please note that due to our support policy we cannot provide you help with debugging your code, consulting in regards to any language or third-party library usage. For this kind of questions we recommend using more appropriate forums like Stack Overflow.

In order to suggest you a quality solution, we shall usually ask you to provide the details mentioned below first. Including them into your topic right away helps us to start investigating your issue much faster.

In case you have a suggestion or an idea, the details below are not always required, though still any additional background is welcome.

Backendless Version (3.x / 5.x, Online / Managed / Pro )

Client SDK (REST / Android / Objective-C / Swift / JS )

Application ID

Expected Behavior

Please describe the expected behavior of the issue, starting from the first action.

Actual Behavior

Please provide a description of what actually happens, working from the same starting point.

Be descriptive: “it doesn’t work” does not describe what the behavior actually is – instead, say “the request returns a 400 error with message XXX”. Copy and paste your logs, and include any URLs.

Reproducible Test Case

Please provide a simple code that could be run in a new clean app and reproduce the issue.

If the issue is more complex or requires configuration, please provide a link to a project on Github that reproduces the issue.

Hi Paul,

What is your application ID?

Regards,
Mark

Hi Mark

DE9727E5-8683-E098-FF56-9D23955C8300

Thanks
Paul

Hi Paul,

The problem is caused by the name of one of the table columns: concat. It is a reserved word in the database and that’s what’s causing the problem. We will make an improvement to deny column creation with reserved words. For now, please rename the column to something else and the problem will go away. To rename the column, switch to the SCHEMA tab and change the column name.

Regards,
Mark

Thanks Mark

Will do, appreciate your help!

Thanks again
Paul