image category is not

Vaishali Agarwal · 17 Oct 2020, 08:43

@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 · 17 Oct 2020, 08:49

@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 · 17 Oct 2020, 08:51

@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 · 17 Oct 2020, 09:10

@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 · 17 Oct 2020, 09:16

@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 · 17 Oct 2020, 09:35

@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 · 17 Oct 2020, 09:53

@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 · 17 Oct 2020, 10:17

@Vaishali-Agarwal

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

regatds

Vaishali Agarwal · 17 Oct 2020, 10:47

@cmpengineers
I am using Linux server.

cmpengineers · 17 Oct 2020, 14:13

@Vaishali-Agarwal

Dear Vaishali

everything its working now but in production I cant upload category image

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