Question: 500 Server Error Whoops

500 Server Error Whoops

In the log: Base table or view not found: 1146 Table 'mdb_mps09.price_groups' doesn't exist Ver: 0.8.0 I tried to find the shema of the table or use php artisan migrate but it doesnt wo

JC

Jorge Cadena

Asked
In the log:
Base table or view not found: 1146 Table 'mdb_mps09.price_groups' doesn't exist
Ver: 0.8.0

I tried to find the shema of the table or use php artisan migrate but it doesnt work...

Other question:
In the install was an option to use data like demo... How i can check if this works?
  • JC

    Jorge Cadena

    Answered
    The Ver. that i download and bought said (Tecdiary - Modern Point of Sale Solution v0.9.0) ... But i doesn´t the update ...

    I had SMA in the last version an di works .... but i dont know if this version is beta or unstable rightn now to put in production...

    The version after the install said 0.8.0
  • JC

    Jorge Cadena

    Answered
    Solved...
    I dont khnow how but after run
    1. Composer Install, then I upload a DB from previos copy of the original install ...
    2. php artisan migrate:status (Appear: ----->
    2022_07_10_000000_create_price_groups_table ......................................................................... Pending
    2022_07_16_000000_create_price_groups_related_table ................................................................. Pending
    3. php artisan migrate (It solved the problem...) strange!!!

    I will continue testing...
  • MS

    Mian Saleem

    Answered
    Hello,

    I am glad that you managed it.

    The demo data can be imported with installer or you can use [database seeder](https://laravel.com/docs/9.x/seeding#running-seeders)

    Thank you
  • JC

    Jorge Cadena

    Answered
    Using database seeder i have this err...

    [2022-07-29 16:03:26] production.ERROR: Unable to locate factory for [Modules\MPS\Models\Setting]. {"userId":"41854d93-e85b-4958-8535-ff16c1591815","exception":"[object] (InvalidArgumentException(code: 0): Unable to locate factory for [Modules\\MPS\\Models\\Setting]. at D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\legacy-factories\\src\\FactoryBuilder.php:273)
    [stacktrace]
    #0 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\legacy-factories\\src\\FactoryBuilder.php(296): Illuminate\\Database\\Eloquent\\FactoryBuilder->getRawAttributes(Array)
    #1 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Concerns\\GuardsAttributes.php(149): Illuminate\\Database\\Eloquent\\FactoryBuilder->Illuminate\\Database\\Eloquent\\{closure}()
    #2 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\legacy-factories\\src\\FactoryBuilder.php(304): Illuminate\\Database\\Eloquent\\Model::unguarded(Object(Closure))
    #3 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\legacy-factories\\src\\FactoryBuilder.php(223): Illuminate\\Database\\Eloquent\\FactoryBuilder->makeInstance(Array)
    #4 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\legacy-factories\\src\\FactoryBuilder.php(169): Illuminate\\Database\\Eloquent\\FactoryBuilder->make(Array)
    #5 D:\\Dev\\xampp\\htdocs\\MPS\\modules\\MPS\\Database\\Seeders\\MyDatabaseSeeder.php(19): Illuminate\\Database\\Eloquent\\FactoryBuilder->create(Array)
    #6 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Modules\\MPS\\Database\\Seeders\\MyDatabaseSeeder->run()
    #7 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
    #8 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
    #9 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
    #10 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
    #11 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(171): Illuminate\\Container\\Container->call(Array, Array)
    #12 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(180): Illuminate\\Database\\Seeder->Illuminate\\Database\\{closure}()
    #13 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(57): Illuminate\\Database\\Seeder->__invoke(Array)
    #14 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\View\\Components\\Task.php(36): Illuminate\\Database\\Seeder->Illuminate\\Database\\{closure}()
    #15 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(57): Illuminate\\Console\\View\\Components\\Task->render('Modules\\\\MPS\\\\Dat...', Object(Closure))
    #16 D:\\Dev\\xampp\\htdocs\\MPS\\modules\\MPS\\Database\\Seeders\\MPSDatabaseSeeder.php(13): Illuminate\\Database\\Seeder->call('Modules\\\\MPS\\\\Dat...')
    #17 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Modules\\MPS\\Database\\Seeders\\MPSDatabaseSeeder->run()
    #18 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
    #19 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
    #20 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
    #21 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
    #22 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(171): Illuminate\\Container\\Container->call(Array, Array)
    #23 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(180): Illuminate\\Database\\Seeder->Illuminate\\Database\\{closure}()
    #24 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(57): Illuminate\\Database\\Seeder->__invoke(Array)
    #25 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\View\\Components\\Task.php(36): Illuminate\\Database\\Seeder->Illuminate\\Database\\{closure}()
    #26 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(57): Illuminate\\Console\\View\\Components\\Task->render('Modules\\\\MPS\\\\Dat...', Object(Closure))
    #27 D:\\Dev\\xampp\\htdocs\\MPS\\database\\seeders\\DatabaseSeeder.php(64): Illuminate\\Database\\Seeder->call('Modules\\\\MPS\\\\Dat...')
    #28 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Database\\Seeders\\DatabaseSeeder->run()
    #29 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
    #30 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
    #31 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
    #32 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
    #33 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(171): Illuminate\\Container\\Container->call(Array, Array)
    #34 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Seeder.php(180): Illuminate\\Database\\Seeder->Illuminate\\Database\\{closure}()
    #35 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Seeds\\SeedCommand.php(81): Illuminate\\Database\\Seeder->__invoke()
    #36 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Concerns\\GuardsAttributes.php(155): Illuminate\\Database\\Console\\Seeds\\SeedCommand->Illuminate\\Database\\Console\\Seeds\\{closure}()
    #37 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Seeds\\SeedCommand.php(82): Illuminate\\Database\\Eloquent\\Model::unguarded(Object(Closure))
    #38 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Illuminate\\Database\\Console\\Seeds\\SeedCommand->handle()
    #39 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
    #40 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
    #41 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
    #42 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
    #43 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(139): Illuminate\\Container\\Container->call(Array)
    #44 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\symfony\\console\\Command\\Command.php(291): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Illuminate\\Console\\OutputStyle))
    #45 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(124): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Illuminate\\Console\\OutputStyle))
    #46 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Concerns\\CallsCommands.php(68): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Illuminate\\Console\\OutputStyle))
    #47 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Concerns\\CallsCommands.php(28): Illuminate\\Console\\Command->runCommand('db:seed', Array, Object(Illuminate\\Console\\OutputStyle))
    #48 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\FreshCommand.php(96): Illuminate\\Console\\Command->call('db:seed', Array)
    #49 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\FreshCommand.php(69): Illuminate\\Database\\Console\\Migrations\\FreshCommand->runSeeder(NULL)
    #50 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\FreshCommand->handle()
    #51 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
    #52 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
    #53 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
    #54 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(651): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
    #55 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(139): Illuminate\\Container\\Container->call(Array)
    #56 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\symfony\\console\\Command\\Command.php(291): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
    #57 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(124): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
    #58 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\symfony\\console\\Application.php(998): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #59 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\symfony\\console\\Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\FreshCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #60 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\symfony\\console\\Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #61 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(102): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #62 D:\\Dev\\xampp\\htdocs\\MPS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #63 D:\\Dev\\xampp\\htdocs\\MPS\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
    #64 {main}
    "}
  • MS

    Mian Saleem

    Answered
    Hello,

    Factories are not loaded in production. Please change the `APP_ENV` to `local` in `.env` file then try again.

    Thank you
  • JC

    Jorge Cadena

    Answered
    Working, my err was the APP_ENV...
    I am going to test. Thanks for the help.
  • MS

    Mian Saleem

    Answered
    Great! If you find any bugs/errors/issues, please let me know so that I can fix them in the next updates. Thank you
  • Login to Reply