Recent Topics

Error while adding Categories image



  • Hi,
    I am facing below error while adding image to the category.

    Illuminate\Database\QueryException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION kartofart.get_url_path_of_category does not exist (SQL: update categories set image = category/7/gCVqIPocTGSkZWoFvuTg3SeGH0YhTkul3TlSWlYo.png, categories.updated_at = 2020-11-04 08:26:09 where id = 7)"

    Stacktrace:
    #54 Illuminate\Database\QueryException in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
    #53 Doctrine\DBAL\Driver\PDOException in /var/www/html/kartofart/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
    #52 PDOException in /var/www/html/kartofart/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
    #51 PDOStatement:execute in /var/www/html/kartofart/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
    #50 Doctrine\DBAL\Driver\PDOStatement:execute in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:489
    #49 Illuminate\Database\Connection:Illuminate\Database{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    #48 Illuminate\Database\Connection:runQueryCallback in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:631
    #47 Illuminate\Database\Connection:run in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:496
    #46 Illuminate\Database\Connection:affectingStatement in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Connection.php:429
    #45 Illuminate\Database\Connection:update in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2860
    #44 Illuminate\Database\Query\Builder:update in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:800
    #43 Illuminate\Database\Eloquent\Builder:update in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:808
    #42 Illuminate\Database\Eloquent\Model:performUpdate in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:723
    #41 Illuminate\Database\Eloquent\Model:save in /var/www/html/kartofart/packages/Webkul/Category/src/Repositories/CategoryRepository.php:219
    #40 Webkul\Category\Repositories\CategoryRepository:uploadImages in /var/www/html/kartofart/packages/Webkul/Category/src/Repositories/CategoryRepository.php:175
    #39 Webkul\Category\Repositories\CategoryRepository:update in /var/www/html/kartofart/packages/Webkul/Category/src/Http/Controllers/CategoryController.php:133
    #38 Webkul\Category\Http\Controllers\CategoryController:update in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    #37 call_user_func_array in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    #36 Illuminate\Routing\Controller:callAction in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    #35 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Route.php:239
    #34 Illuminate\Routing\Route:runController in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Route.php:196
    #33 Illuminate\Routing\Route:run in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Router.php:685
    #32 Illuminate\Routing\Router:Illuminate\Routing{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128
    #31 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/packages/Webkul/User/src/Http/Middleware/Bouncer.php:27
    #30 Webkul\User\Http\Middleware\Bouncer:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
    #28 Illuminate\Routing\Middleware\SubstituteBindings:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #27 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:77
    #26 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #25 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php:39
    #24 Illuminate\Session\Middleware\AuthenticateSession:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
    #22 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #21 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103
    #20 Illuminate\Pipeline\Pipeline:then in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Router.php:687
    #19 Illuminate\Routing\Router:runRouteWithinStack in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Router.php:662
    #18 Illuminate\Routing\Router:runRoute in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Router.php:628
    #17 Illuminate\Routing\Router:dispatchToRoute in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Routing/Router.php:617
    #16 Illuminate\Routing\Router:dispatch in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:165
    #15 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128
    #14 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:67
    #13 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #12 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:116
    #11 Illuminate\Session\Middleware\StartSession:handleStatefulRequest in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:62
    #10 Illuminate\Session\Middleware\StartSession:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
    #8 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67
    #6 Illuminate\Cookie\Middleware\EncryptCookies:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    #4 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
    #3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103
    #2 Illuminate\Pipeline\Pipeline:then in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:140
    #1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /var/www/html/kartofart/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:109
    #0 Illuminate\Foundation\Http\Kernel:handle in /var/www/html/kartofart/public/index.php:74



  • Wanted to add it is happening when I am selecting parent category while adding category.


Log in to reply