chandachewe10 / loan-management-system Goto Github PK

Help with the SQl.sql file

Fresh install of latest main:

php artisan migrate
Migration table created successfully.
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated: 2014_10_12_100000_create_password_resets_table (9.91ms)
Migrating: 2019_08_19_000000_create_failed_jobs_table
Migrated: 2019_08_19_000000_create_failed_jobs_table (8.00ms)
Migrating: 2019_12_14_000001_create_personal_access_tokens_table
Migrated: 2019_12_14_000001_create_personal_access_tokens_table (13.09ms)
Migrating: 2021_11_09_090003_create_transaction_histories_table
Migrated: 2021_11_09_090003_create_transaction_histories_table (3.16ms)
Migrating: 2021_11_18_093131_create_emailsubscriptions_table
Migrated: 2021_11_18_093131_create_emailsubscriptions_table (6.69ms)
Migrating: 2021_11_18_093532_create_messages_table
Migrated: 2021_11_18_093532_create_messages_table (7.31ms)
Migrating: 2021_12_09_235657_create_reg_employee_attachments_table

Illuminate\Database\QueryException

SQLSTATE[HY000]: General error: 1824 Failed to open the referenced table 'reg_employee_mst' (SQL: alter table reg_employee_attachments add constraint reg_employee_attachments_employee_id_foreign foreign key (employee_id) references reg_employee_mst (employee_id) on delete cascade)

Hello, I have an issue with the "php artisan migrate" command.

• OS: Debian 12 fresh install
• php8.2
• also tested with php8.1, same behaviour

The error is :

   Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'laravel' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕ 
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

      +39 vendor frames 

  40  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()

I have tried changing the value of DB_HOST from 127.0.0.1 to localhost but then I have another error which is :

   Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'laravel' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕ 
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

      +39 vendor frames 

  40  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()

Could you enlighten me please ?

By the way, in the .env file, I only changed the DB_PASSWORD value.

how can one install this in cpanel

Good day

Have followed steps until the copy .env.example file...

i cannot find this file in the LMS folder... kindly assist with steps

Good, for the moment I carried out all the indicated steps and everything worked correctly, it should be noted that to work while editing I created the sqlite database, and it did the migration and everything was fine, the detail is that when I wanted to do this step php artisan db :seed gave me this error that I see on the screen and if I start the server it does not allow me to start with any account it tells me an error in the pass anyway I need help in this part.

Please tell me where id the route of admin/wallets is defined. It is not in web.php
http://127.0.0.1:8000/admin/wallets

Please tell me the installation steps. Thank you.

Please help me to install this problem.

composer install --no-scripts
Deprecation Notice: Using ${var} in strings is deprecated, use {$var} instead in phar:///Users/mau/composer.phar/src/Composer/Autoload/AutoloadGenerator.php:879
Deprecation Notice: Using ${var} in strings is deprecated, use {$var} instead in phar:///Users/mau/composer.phar/src/Composer/Autoload/AutoloadGenerator.php:884
Installing dependencies from lock file (including require-dev)
Verifying lock file contents can be installed on current platform.
Deprecation Notice: Using ${var} in strings is deprecated, use {$var} instead in phar:///Users/mau/composer.phar/src/Composer/DependencyResolver/Problem.php:366
Your lock file does not contain a compatible set of packages. Please run composer update.

Problem 1
- phpspec/prophecy is locked to version 1.14.0 and an update of this package was not requested.
- phpspec/prophecy 1.14.0 requires php ^7.2 || ~8.0, <8.2 -> your php version (8.2.10) does not satisfy that requirement.
Problem 2
- phpspec/prophecy 1.14.0 requires php ^7.2 || ~8.0, <8.2 -> your php version (8.2.10) does not satisfy that requirement.
- phpunit/phpunit 9.5.10 requires phpspec/prophecy ^1.12.1 -> satisfiable by phpspec/prophecy[1.14.0].
- phpunit/phpunit is locked to version 9.5.10 and an update of this package was not requested.