rinvex / laravel-attributes

⚠️ [ABANDONED] Rinvex Attributable is a robust, intelligent, and integrated Entity-Attribute-Value model (EAV) implementation for Laravel Eloquent, with powerful underlying for managing entity attributes implicitly as relations with ease. It utilizes the power of Laravel Eloquent, with smooth and seamless integration.

MIT License

433 stars 104 forks source link

PostgreSQL error #73

Closed rez1dent3 closed 5 years ago

rez1dent3 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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

VladimirFrunza commented 5 years ago

@rez1dent3 I have Mariadb v10.2.14

VladimirFrunza commented 5 years ago

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

rez1dent3 commented 5 years ago

tired of waiting, made a pull request

rez1dent3 commented 5 years ago

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

IsraelOrtuno commented 5 years ago

tired of waiting, made a pull request

That's the way to go! 😉👍

VladimirFrunza commented 5 years ago

Thanks :)

rez1dent3 commented 5 years ago

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

Omranic commented 5 years ago

75 merged! Sorry for the long delay.