image category is not

Vaishali Agarwal

@cmpengineers
may I know your Database version details.

cmpengineers

Dear all

sure

Screen Shot 2020-10-16 at 11.44.30 AM.png

I did create another database but for some reason I cant do PHP artisan migrate:fresh

Screen Shot 2020-10-16 at 11.47.18 AM.png

why is he looking for a base table or channels when I fleshing all the table from scratch ?

please advise

regards

cmpengineers

Dear all

why is always facing the problem I cloned the same project from my git hub still giving me the same error

Screen Shot 2020-10-17 at 10.28.15 AM.png

> @php artisan package:discover

In Connection.php line 669:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist (SQL: select * from `channels` where `hostname` in (drov112  
  .test, http://drov112.test, https://drov112.test))                           
                                                                               

In PDOConnection.php line 63:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist                                                              
                                                                               

In PDOConnection.php line 61:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist                                                              
                                                                               

Script @php artisan package:discover handling the post-autoload-dump event returned with error code 1
(base) drov112:

every time i do composer install i get this error

I'm tired from chasing your bugs , it would much quicker and even more faster i build my own ecommerce

regards

Vaishali Agarwal

@cmpengineers said in image category is not:

Base table or view not found

@cmpengineers
please go through with link https://forums.bagisto.com/topic/1563/error-while-installinghttps-forums-bagisto-com-post-2388/9
hope this will work for you.

cmpengineers

@Vaishali-Agarwal

its not working same error exactly

regards

cmpengineers

Hello

every time i do composr intall it give me the same error

Screen Shot 2020-10-17 at 10.58.42 AM.png

why is he looking for base table !!! and still I did not do migrate or seed !!!

regards

Vaishali Agarwal

@cmpengineers
if you have not run migrate command then please run
php artisan migrate , it will show you the exact error.

cmpengineers

@Vaishali-Agarwal

same error my dear what ever command for artisan it will give me the same error

regards

cmpengineers

@Vaishali-Agarwal

Screen Shot 2020-10-17 at 11.13.47 AM.png

cmpengineers

i found the solution

which is weird , i copy one table the channels and insert inside the database it work , then i did
php artisan migrate:fresh --seed

it work but i have problem with multi-vendor
so please check the image its not displaying

Screen Shot 2020-10-17 at 11.40.53 AM.png

regards

Vaishali Agarwal

@cmpengineers
once try to follow the below step:

go to the .env and check the database name should be valid
run the below command,
php artisan config:cache
php artisan migrate:refresh --seed

Vaishali Agarwal

@cmpengineers
link your storage folder

php artisan storage:link

you may also follow all the possible solution mention here
https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1

cmpengineers

@Vaishali-Agarwal

its already linked

Generated optimized autoload files containing 6627 classes
(base) drov112:pa s:l
The "public/storage" directory already exists.
(base) drov112:

Vaishali Agarwal

@Vaishali-Agarwal said in image category is not:

https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1

As already provided please check this link https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1 and follow the solutions

cmpengineers

@Vaishali-Agarwal

Dear Vaishali

i have already created more than 10+ project from laravel

i did exactly and still its not showing I'm using laravel valet

regards

Vaishali Agarwal

@cmpengineers

Inspect to the image and check the image path
could you please check whether products or categories images are showing at admin end or front end both?

You can see this issue does not exist at my end https://prnt.sc/v12iq9

cmpengineers

@Vaishali-Agarwal said in image category is not:

https://prnt.sc/v12iq9

everything is showing except for the multi-vendor
in production is working fine drov.app but in local its not working

regards

cmpengineers

@Vaishali-Agarwal

what local env you are using laravel valet ? homestead vapor ? xampp ?

regatds

Vaishali Agarwal

@cmpengineers
I am using Linux server.

cmpengineers

@Vaishali-Agarwal

Dear Vaishali

everything its working now but in production I cant upload category image
Screen Shot 2020-10-17 at 5.11.41 PM.png

Illuminate\Database\QueryException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION drovapp.get_url_path_of_category does not exist (SQL: update `categories` set `_lft` = case when `_lft` >= 18 then `_lft`+2 else `_lft` end, `_rgt` = case when `_rgt` >= 18 then `_rgt`+2 else `_rgt` end where (`_lft` >= 18 or `_rgt` >= 18))"

Stacktrace:
#62 Illuminate\Database\QueryException in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
#61 Doctrine\DBAL\Driver\PDOException in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
#60 PDOException in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#59 PDOStatement:execute in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#58 Doctrine\DBAL\Driver\PDOStatement:execute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:488
#57 Illuminate\Database\Connection:Illuminate\Database\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:662
#56 Illuminate\Database\Connection:runQueryCallback in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:629
#55 Illuminate\Database\Connection:run in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:495
#54 Illuminate\Database\Connection:affectingStatement in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
#53 Illuminate\Database\Connection:update in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2726
#52 Illuminate\Database\Query\Builder:update in /home/forge/drov.app/vendor/kalnoy/nestedset/src/QueryBuilder.php:603
#51 Kalnoy\Nestedset\QueryBuilder:makeGap in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:609
#50 Webkul\Category\Models\Category:insertNode in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:574
#49 Webkul\Category\Models\Category:insertAt in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:171
#48 Webkul\Category\Models\Category:actionAppendOrPrepend in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:102
#47 call_user_func_array in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:102
#46 Webkul\Category\Models\Category:callPendingAction in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:47
#45 Webkul\Category\Models\Category:Kalnoy\Nestedset\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:369
#44 Illuminate\Events\Dispatcher:Illuminate\Events\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:218
#43 Illuminate\Events\Dispatcher:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:191
#42 Illuminate\Events\Dispatcher:until in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php:188
#41 Illuminate\Database\Eloquent\Model:fireModelEvent in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:651
#40 Illuminate\Database\Eloquent\Model:save in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:764
#39 Webkul\Category\Models\Category:create in /home/forge/drov.app/packages/Webkul/Category/src/Repositories/CategoryRepository.php:47
#38 Webkul\Category\Repositories\CategoryRepository:create in /home/forge/drov.app/packages/Webkul/Category/src/Http/Controllers/CategoryController.php:102
#37 Webkul\Category\Http\Controllers\CategoryController:store in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#36 call_user_func_array in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#35 Illuminate\Routing\Controller:callAction in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#34 Illuminate\Routing\ControllerDispatcher:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#33 Illuminate\Routing\Route:runController in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#32 Illuminate\Routing\Route:run in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
#31 Illuminate\Routing\Router:Illuminate\Routing\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#30 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/packages/Webkul/User/src/Http/Middleware/Bouncer.php:27
#29 Webkul\User\Http\Middleware\Bouncer:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#28 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
#27 Illuminate\Routing\Middleware\SubstituteBindings:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
#25 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#24 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php:39
#23 Illuminate\Session\Middleware\AuthenticateSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#22 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#21 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#20 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#19 Illuminate\Pipeline\Pipeline:then in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
#18 Illuminate\Routing\Router:runRouteWithinStack in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
#17 Illuminate\Routing\Router:runRoute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
#16 Illuminate\Routing\Router:dispatchToRoute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
#15 Illuminate\Routing\Router:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
#14 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:65
#12 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#10 Illuminate\Session\Middleware\StartSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#8 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#6 Illuminate\Cookie\Middleware\EncryptCookies:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
#4 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#2 Illuminate\Pipeline\Pipeline:then in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:145
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:110
#0 Illuminate\Foundation\Http\Kernel:handle in /home/forge/drov.app/public/index.php:74

my SQL version is 5.7

I did alter the database still not working
ALTER DATABASE drovapp DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

I can add product image no problem only the category

regards