Error with contains

[fjacques_dutscher]

Wappler Version : 5.5.3
Operating System : Windows
Server Model: PHP
Database Type: PostgreSQL
Hosting Type: IIS

I had the following error early in the week.

CONTAINS being used instead of LIKE in places it shouldn't be used in database manager queries

We found the issue, it was indeed a bad mapping of contains that we added in Wappler 5.5.2 and it gives errors in the classic server models like PHP, ASP and ASP.NET. In NodeJS it is all fine. It will be fixed in the next update - probably tomorrow.

I cannot build query using ‘contains’ or ‘begins with’ without generating database error.

This bug is indicated to be solved in version 5.5.3. I installed this version.
There was no suggestion to update project files, so I did force update of all files in the menu.
However, I still get the error : Syntax error near ‘CONTAINS’.

[George]

You just have to reopen and save the query in the server action to fix the problem.

[fjacques_dutscher]

Thanks,

Only saving the query did not fix it.
I had to modify and save. Then revert modification and save again.

It works now