Question: Error Migrarting Database

Error Migrarting Database

************************************** * Application In Production! * ************************************** Do you really wish to run this command? (yes/no) [no]: > y Dro

G

Gent

Asked

  • Application In Production!     *
    

Do you really wish to run this command? (yes/no) [no]:

y

Dropped all tables successfully. Migration table created successfully. Loading stored database schema: /home/optikaas/bm/database/schema/mysql-schema.dump Loaded stored database schema. (2,278.35ms) Migrating: 2022_07_10_000000_create_price_groups_table

Illuminate\Database\QueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘price_groups’ already exists (SQL: create table price_groups (id char(36) not null, name varchar(255) not null, code varchar(255) null, details varchar(255) null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:716 712▕ // If an exception occurs when attempting to run a query, we’ll format the error 713▕ // message to include the bindings with SQL, which will make this exception a 714▕ // lot more helpful to the developer instead of just the database’s errors. 715▕ catch (Exception $e) { ➜ 716▕ throw new QueryException( 717▕ $query, $this->prepareBindings($bindings), $e 718▕ ); 719▕ } 720▕ }

  +9 vendor frames

10 database/migrations/2022_07_10_000000_create_price_groups_table.php:38 Illuminate\Support\Facades\Facade::__callStatic()

  +33 vendor frames

44 artisan:37 Illuminate\Foundation\Console\Kernel::handle() [optikaas@imba bm]$ php artisan migrate:status ±-----±----------------------------------------------------------------------±------+ | Ran? | Migration | Batch | ±-----±----------------------------------------------------------------------±------+ | Yes | 2017_02_21_070324_create_attachments_table | 1 | | Yes | 2017_03_17_070324_alter_attachments_table_extend_filetype | 1 | | Yes | 2017_08_21_201100_alter_attachments_table_add_group_column | 1 | | Yes | 2019_12_14_000001_create_personal_access_tokens_table | 1 | | Yes | 2021_10_07_000000_update_oid_user_id_unique_index_on_orders_table | 4 | | Yes | 2021_10_20_050000_unify_addresses_to_all_tables | 4 | | Yes | 2021_11_22_000000_drop_delivered_by_foreign_key_from_deliveries_table | 4 | | Yes | 2022_01_19_000000_modify_failed_jobs_table | 3 | | Yes | 2022_02_14_025831_update_modifier_options_table | 4 | | Yes | 2022_03_10_113257_add_event_column_to_activity_log_table | 3 | | Yes | 2022_03_10_113258_add_batch_uuid_column_to_activity_log_table | 3 | | Yes | 2022_03_29_162019_create_model_names_table | 2 | | No | 2022_07_10_000000_create_price_groups_table | | | No | 2022_07_16_000000_create_price_groups_related_table | | ±-----±----------------------------------------------------------------------±------+

  • MS

    Mian Saleem

    Answered

    Hello,

    Your composer file looks fine and has version 0.9.1

    Please share the link to your installation with credentials.

    Thank you

  • G

    Gent

    Answered

    Mian Saleem https://bm.optikaas.com

    user: gent pass : Assimeks1@

  • MS

    Mian Saleem

    Answered

    I am so sorry. I have found that the module was not included in the basic license file. I have updated the download file. Please download it now and you should be able to access the /port Thank you

  • Login to Reply