Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using UrlHum with Postgres results in internal server errors #29

Closed
davidolrik opened this issue May 14, 2019 · 2 comments
Closed

Using UrlHum with Postgres results in internal server errors #29

davidolrik opened this issue May 14, 2019 · 2 comments
Labels
enhancement Enhancement of existing feature

Comments

@davidolrik
Copy link

When using PostgreSQL as database, all pages that use queries with IFNULL results in internal an server error as this is a MySQL only function.

As a temporary workaround I have changed it to COALESCE locally.

I suggest moving this logic into the application and handle the possibility of null in code using something like $value ?? "default".

@optiroot
Copy link
Member

Hello!
Thank you for opening the issue.
Yes, actually UrlHum doesn't work with PostgreSQL, but it is planned. As you can see in the docs it is stated that UrlHum has been tested with mySQL only.
I will update the project soon to be able to work with PostgreSQL.
Thanks!

@optiroot optiroot added the enhancement Enhancement of existing feature label May 14, 2019
@optiroot
Copy link
Member

Fixed this! Also, I managed to clean up some code using Laravel Relationships.
Now the project is cleaner and works perfectly with PostgreSQL too!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Enhancement of existing feature
Projects
None yet
Development

No branches or pull requests

2 participants