image category is not

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