How can i fix SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" in heroku hosting

Question

I want to ask how to fix this error in laravel heroku hosting in my local I was using mysql but in heroku I switched to postgres and I get those errors while migrating.

In Connection.php line 678:

SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type. (SQL: alter table "functions" add constraint "functions_function_elements_unique" unique ("function_elements"))

In Connection.php line 471:

SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.

yeah i did in heroku this is why i think there is no reasen to do it in my local while i m using mysql can this be the reasen of the eroor — Zakariaa
– Zakariaa, Commented Mar 27, 2021 at 22:07

Basharmal · Accepted Answer · 2021-03-27 22:04:19Z

By default Laravel ships with MySQL. You may want to try out other SQL database type, changing that is very simple however there are some small configurations you have to make if your database of choice is postgres.

Installation Download PostgreSQL to your pc from https://www.postgresql.org/download/ Or directly here (for windows) https://get.enterprisedb.com/postgresql/postgresql-12.1-3-windows-x64.exe Then Install.
php.ini MySQL is the default therefore there’s need to activate PostgreSQL for use with PHP on your pc by editing the php.ini Search for these two lines within your php.ini and remove the “;” in front of each:

;extension=pdo_pgsql ;extension=pgsql

to (notice that “;” was removed)

extension=pdo_pgsql extension=pgsql

.env Change the following as appropriate within the Laravel’s .env file (all the defaults are ok except DB_DATABASE and DB_PASSWORD that you may have to change):

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=database_name
DB_USERNAME=postgres
DB_PASSWORD=your_choosen_password

Zakariaa · Accepted Answer · 2021-03-27 22:25:51Z

0

hello guys so i found the solution here :) ;

`
Schema::create('fdeg_functions', function (Blueprint $table) {
        $table->id();
        $table->timestamps();
        $table->Json("function_elements")->unique();
    });`

So , All what I shall do is to convert json to string and it worked too good ; and i think this will not have any bad effects to the application , tell me what you see , and i hope this will help other people :)

answered Mar 27, 2021 at 22:25

Zakariaa

291 silver badge4 bronze badges

Collectives™ on Stack Overflow

How can i fix SQLSTATE[42704]: Undefined object: 7 ERROR: data type json has no default operator class for access method "btree" in heroku hosting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related