Lemnocity / clean-crm

Minimum Laravel project with Venture Drake package installed. This will help use identify bugs that are not related to our main project.
0 stars 0 forks source link

php artisan laravelcrm:install migration error crm_users does not exist. #1

Open DCox2016 opened 11 months ago

DCox2016 commented 11 months ago

Laravel Version: 10.10

PHP Version: 8.1.14

Steps to reproduce

Expected results

CRM installed

Actual results

2023_09_15_103737_add_client_to_laravel_crm_deals_table ............................................................................... 153ms FAIL SQLSTATE[42S02]: Base table or view not found: 1146 Table 'crm-database.crm_users' doesn't exist (Connection: mysql, SQL: alter table crm_users add url varchar(255) null)

DCox2016 commented 11 months ago

This .stub creates the migrations that runs

image

I checked the Limnocity project and there is no crm_users table, so the db_table_prefix might be the issue.

DCox2016 commented 11 months ago

This different from what we have installed on limnocity project this stub on our project only creates the deals table. I am going to remove the laravel-crm.db_table_prefix which is controlled from the config file. I believe this should actual just be users and not crm_users

DCox2016 commented 11 months ago

That fixed it. So I need to point this out to VentureDrake

DCox2016 commented 11 months ago

Actual lets keep this open