search

krayin / laravel-crm

Free & Opensource Laravel CRM solution for SMEs and Enterprises for complete customer lifecycle management.
https://krayincrm.com
Open Software License 3.0
10.71k stars 702 forks source link

Migration error #1608

Closed SOG-web closed 1 week ago

SOG-web commented 3 weeks ago

A new setup

In Connection.php line 829:

SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "lead_stages"
LINE 1: update "lead_pipeline_stages" set "code" = lead_stages.code,...
^ (Connection: pgsql, SQL: update "lead_pipelinestages" set "code" = lead
stages.code, "name" = lead_stages.name where "ctid" in (select "lead_pipeline_stages"."ctid" from "lead_pipeline_stages" inner
join "lead_stages" on "lead_pipeline_stages"."lead_stage_id" = "lead_stages"."id"))

In Connection.php line 612:

SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "lead_stages"
LINE 1: update "lead_pipeline_stages" set "code" = lead_stages.code,...

php artisan krayin-crm:install

suraj-webkul commented 2 weeks ago

Hello @SOG-web,

At the moment, we do not offer support for PostgreSQL. All of our database migrations are tightly integrated with MySQL, and as such, Krayin is optimized specifically for MySQL environments.