Bagisto Forum

    Bagisto

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    image category is not

    Bug Report
    2
    21
    45612
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      cmpengineers last edited by 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

      1 Reply Last reply Reply Quote 0
      • First post
        Last post