Error while installinghttps://forums.bagisto.com/post/2388



  • I got the following error during installation in windows 10 & xampp

    Illuminate\Database\QueryException thrown with message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'keyar.channels' doesn't exist (SQL: select * from channels where code = default)"

    Stacktrace:
    #48 Illuminate\Database\QueryException in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Connection.php:669
    #47 Doctrine\DBAL\Driver\PDOException in C:\xampp\htdocs\bagisto\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:63
    #46 PDOException in C:\xampp\htdocs\bagisto\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:61
    #45 PDO:prepare in C:\xampp\htdocs\bagisto\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:61
    #44 Doctrine\DBAL\Driver\PDOConnection:prepare in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Connection.php:331
    #43 Illuminate\Database\Connection:Illuminate\Database{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Connection.php:662
    #42 Illuminate\Database\Connection:runQueryCallback in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Connection.php:629
    #41 Illuminate\Database\Connection:run in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Connection.php:338
    #40 Illuminate\Database\Connection:select in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2149
    #39 Illuminate\Database\Query\Builder:runSelect in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2137
    #38 Illuminate\Database\Query\Builder:Illuminate\Database\Query{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2609
    #37 Illuminate\Database\Query\Builder:onceWithColumns in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2138
    #36 Illuminate\Database\Query\Builder:get in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:537
    #35 Illuminate\Database\Eloquent\Builder:getModels in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:521
    #34 Illuminate\Database\Eloquent\Builder:get in C:\xampp\htdocs\bagisto\vendor\prettus\l5-repository\src\Prettus\Repository\Eloquent\BaseRepository.php:521
    #33 Prettus\Repository\Eloquent\BaseRepository:findByField in C:\xampp\htdocs\bagisto\vendor\prettus\l5-repository\src\Prettus\Repository\Traits\CacheableRepository.php:281
    #32 Webkul\Core\Eloquent\Repository:findByField in C:\xampp\htdocs\bagisto\packages\Webkul\Core\src\Eloquent\Repository.php:26
    #31 Webkul\Core\Eloquent\Repository:findOneByField in C:\xampp\htdocs\bagisto\packages\Webkul\Core\src\Core.php:187
    #30 Webkul\Core\Core:getDefaultChannel in C:\xampp\htdocs\bagisto\packages\Webkul\Shop\src\Http\Middleware\Locale.php:44
    #29 Webkul\Shop\Http\Middleware\Locale:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #28 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php:41
    #27 Illuminate\Routing\Middleware\SubstituteBindings:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php:76
    #25 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #24 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Session\Middleware\AuthenticateSession.php:39
    #23 Illuminate\Session\Middleware\AuthenticateSession:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #22 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php:49
    #21 Illuminate\View\Middleware\ShareErrorsFromSession:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #20 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:105
    #19 Illuminate\Pipeline\Pipeline:then in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Routing\Router.php:683
    #18 Illuminate\Routing\Router:runRouteWithinStack in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Routing\Router.php:658
    #17 Illuminate\Routing\Router:runRoute in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Routing\Router.php:624
    #16 Illuminate\Routing\Router:dispatchToRoute in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Routing\Router.php:613
    #15 Illuminate\Routing\Router:dispatch in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:170
    #14 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:130
    #13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\barryvdh\laravel-debugbar\src\Middleware\InjectDebugbar.php:65
    #12 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:56
    #10 Illuminate\Session\Middleware\StartSession:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php:37
    #8 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php:66
    #6 Illuminate\Cookie\Middleware\EncryptCookies:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:63
    #4 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:171
    #3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:105
    #2 Illuminate\Pipeline\Pipeline:then in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:145
    #1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in C:\xampp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:110
    #0 Illuminate\Foundation\Http\Kernel:handle in C:\xampp\htdocs\bagisto\public\index.php:74



  • @venukeyar
    Is there any parameter set for DB_PREFIX in .env?





  • @venukeyar
    run the following command from the project root directory

    php artisan migrate
    php artisan db:seed

    I hope this will resolve the issue.



  • @Vaishali-Agarwal running the first shows the following error
    Capture.PNG



  • @Vaishali-Agarwal second command gave following errorCapture2.PNG



  • @venukeyar
    Could you tell me your MARIADB version?



  • @Vaishali-Agarwal Mariadb version 10.1.37



  • Hi @venukeyar
    Bagisto require MariaDB: 10.2.7 or Higher, as the lower version doesn't support the JSON format , you need to upgrade it to the latest version.

    you may also check this https://github.com/bagisto/bagisto/issues/1551
    Have a wonderful day!



  • @Vaishali-Agarwal Thank you. I now installed on WAMP server and it started working. But the initial screen is as given below.Capture3.png



  • @venukeyar
    run php artisan vendor:publish --force and then press 0 to continue


Log in to reply