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

PSQL Migrate Error (Sail) #134

Closed
egekibar opened this issue Dec 4, 2023 · 2 comments
Closed

PSQL Migrate Error (Sail) #134

egekibar opened this issue Dec 4, 2023 · 2 comments

Comments

@egekibar
Copy link

egekibar commented Dec 4, 2023

Pulse Version

1.0.0

Laravel Version

10.33.0

PHP Version

8.3

Database Driver & Version

Laravel Sail with PostgreSQL

Description

> sail php artisan migrate
 
    INFO  Running migrations.  

  2014_10_12_000000_create_users_table ................................................................................................... 14ms DONE
  2014_10_12_100000_create_password_reset_tokens_table .................................................................................... 4ms DONE
  2019_08_19_000000_create_failed_jobs_table .............................................................................................. 7ms DONE
  2019_12_14_000001_create_personal_access_tokens_table ................................................................................... 5ms DONE
  2023_06_07_000001_create_pulse_tables ................................................................................................... 3ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...(16) not null generated always as (unhex(md5(`key`))), "valu...
                                                             ^ (Connection: pgsql, SQL: create table "pulse_values" ("timestamp" integer not null, "type" varchar(255) not null, "key" text not null, "key_hash" char(16) not null generated always as (unhex(md5(`key`))), "value" text not null))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:822
    818▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    819▕                 );
    820▕             }
    821▕ 
  ➜ 822▕             throw new QueryException(
    823▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    824▕             );
    825▕         }
    826▕     }

      +35 vendor frames 

  36  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()
@jbrooksuk
Copy link
Member

Pulse is only compatible with MySQL currently. https://laravel.com/docs/10.x/pulse#installation

@jbrooksuk
Copy link
Member

@egekibar Postgres support was added in v1.0.0-beta4.

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

No branches or pull requests

2 participants