Does not work for PostgreSQL v15

[zdravstvuy1714]

.env

database config

validation rule

result

In the end, I settled on using version 3.5.0. It would be nice to have this fixed for 4 ver.

[ivanvermeyen]

Hi,

Thanks for reporting this.
The cause of this issue is probably the same as #23.

I never used other databases than MySQL and SQLite, so I'm not exactly experienced with PostgreSQL.
I do know that even SQLite doesn't support the JSON syntax.
Maybe this is also the case for PostgreSQL?

I would be happy to improve compatibility, but I'll need some help with that.

[ivanvermeyen]

Can you see if it works with 4.1.0?
Changed back to a LIKE query instead of JSON syntax.
https://github.com/codezero-be/laravel-unique-translation/releases/tag/4.1.0

[zdravstvuy1714]

Yes, the bug has been fixed in version 4.1.0 of the package for PostgreSQL 15. Thank you!

[zdravstvuy1714]

It is possible to make a slight improvement, depending on the database (MySQL or PostgreSQL) to use LIKE when using MySQL, and ILIKE when using PostgreSQL at findTranslation method:

[ivanvermeyen]

Thanks, I will add this 👍

[ivanvermeyen]

Tagged in 4.1.2 🚀