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

venukeyar · 20 Jul 2020, 14:27

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

Vaishali Agarwal · 20 Jul 2020, 15:53

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

venukeyar · 21 Jul 2020, 05:36

@Vaishali-Agarwal
No

Vaishali Agarwal · 21 Jul 2020, 05:57

@venukeyar
run the following command from the project root directory

php artisan migrate
php artisan db:seed

I hope this will resolve the issue.

venukeyar · 21 Jul 2020, 06:08

@Vaishali-Agarwal running the first shows the following error

venukeyar · 21 Jul 2020, 06:36

@Vaishali-Agarwal second command gave following error

Vaishali Agarwal · 21 Jul 2020, 07:03

@venukeyar
Could you tell me your MARIADB version?

venukeyar · 21 Jul 2020, 07:30

@Vaishali-Agarwal Mariadb version 10.1.37

Vaishali Agarwal · 21 Jul 2020, 07: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!

venukeyar · 22 Jul 2020, 05:28

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

Vaishali Agarwal · 22 Jul 2020, 06:16

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