Recently updated a backend service from a Symfony 5.4 / php 7 to a Symfony 6.4 / php 8.3 config.
The database is using Postgresql 14.
Since the doctrine queries I have that include LOWER stopped working, for instance:
$qb->where(‘i.title ‘ . ‘LIKE LOWER(:keyWord)’)
I wrapped them in a try / catch but I don’t even have an error coming, just no response at all (another error introduced on purpose, like a misspell does send back an error).
As soon as I just remove the “LOWER” everything works fine. Seems like just the fact it’s written in the query blocks everything.
I must underline that it’s not similar to other cases I saw where LOWER is written but has no effect, in my case it’s like it’s stopping the whole process, nothing happens like the query isn’t sent.
I updated the database to Postgresql 17 but it had no effect.
Any help would… help!
Thanks
- Upgrade to Postgresql 17
- Clear various caches
- Try the SQL request directly in the database adminer (it works)
- Try the solution from “Doctrine Query Builder LOWER not working”