search

Bottelet / DaybydayCRM

DaybydayCRM an open-source CRM, to help you keep track of your daily workflow.
https://daybydaycrm.com
2.24k stars 752 forks source link

External_id error running migration #239

Closed kobeumut closed 3 years ago

kobeumut commented 3 years ago

if I want to install with PostgreSQL, I got a blow error;

DETAIL:  Failing row contains (1, null, payment-create, Add payment, Be able to add a new payment on a invoice, payment, 2021-04-01 13:13:37, 2021-04-01 13:13:37). (SQL: insert into "permissions" ("display_name", "name", "description", "grouping", "updated_at", "created_at") values (Add payment, payment-create, Be able to add a new payment on a invoice, payment, 2021-04-01 13:13:37, 2021-04-01 13:13:37) returning "id")
Screen Shot 2021-04-01 at 14 12 08

I think it's related to #186. Also I have succeeded to install it with MySQL. I've tried to change the nullable field for external_id in the migration folder but I've got another error with pgsql. You should definitely look into this problem, I actually wanted to use it with pgsql.

Bottelet commented 3 years ago

I haven't tried using Daybyday with a PostgreSQL database. I might try and get onto that at some point, but not for now, I'll gladly merge a PR if you find a fix. Else currently only MySQL is supported.