Skip to content
This repository has been archived by the owner on Feb 16, 2022. It is now read-only.

PostgreSQL error #73

Closed
rez1dent3 opened this issue Oct 31, 2018 · 10 comments
Closed

PostgreSQL error #73

rez1dent3 opened this issue Oct 31, 2018 · 10 comments

Comments

@rez1dent3
Copy link
Contributor

I'm trying to use your library with pgsql. No luck so far!

   Illuminate\Database\QueryException  : SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: text ->> unknown
LINE 1: ...tes" where 0 = 1 order by "sort_order" asc, "name"->>'$en' a...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "attributes" where 0 = 1 order by "sort_order" asc, "name"->>'$en' asc)
@VladimirFrunza
Copy link

I have the same problem, also I have problems with MariaDB. As mentioned in another issue. I hope in closest future someone will fix this issue, cause I can not wait to use this awesome laravel-attributes repository :)

@rez1dent3
Copy link
Contributor Author

rez1dent3 commented Nov 8, 2018

@VladimirFrunza upgrade mariadb to 10.2 or install mysql/percona 5.7

@VladimirFrunza
Copy link

@rez1dent3 I have Mariadb v10.2.14

@VladimirFrunza
Copy link

I installed Mysql 5.7 and it works :) But anyway that is uncomfortable

@rez1dent3
Copy link
Contributor Author

tired of waiting, made a pull request

@rez1dent3
Copy link
Contributor Author

rez1dent3 commented Nov 29, 2018

@VladimirFrunza I made a pull request #75 , make edits on mariadb.
I do not have a server with mariadb at the moment

@IsraelOrtuno
Copy link
Collaborator

tired of waiting, made a pull request

That's the way to go! 😉👍

@VladimirFrunza
Copy link

Thanks :)

@rez1dent3
Copy link
Contributor Author

@IsraelOrtuno The idea is to add a condition to sqlite. Since this database will not work.

Omranic added a commit that referenced this issue Dec 21, 2018
@Omranic
Copy link
Member

Omranic commented Dec 21, 2018

#75 merged! Sorry for the long delay.

@Omranic Omranic closed this as completed Dec 21, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants