Bagisto Forum

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

    SQL statement error

    General Discussion
    2
    3
    367
    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.
    • E
      elkadye last edited by

      Hello everyone.. I am getting a very strange error when I try to call categories through the api.. http://tresjolie.shop:8081/api/categories

      Illuminate\Database\QueryException thrown with message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'q' in 'where clause' (SQL: select count(*) as aggregate from categories where q in (/api/categories))"

      Stacktrace:
      #55 Illuminate\Database\QueryException in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
      #54 Doctrine\DBAL\Driver\PDOException in /var/www/shop/bagisto/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63
      #53 PDOException in /var/www/shop/bagisto/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61
      #52 PDO:prepare in /var/www/shop/bagisto/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61
      #51 Doctrine\DBAL\Driver\PDOConnection:prepare in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326
      #50 Illuminate\Database\Connection:Illuminate\Database{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657
      #49 Illuminate\Database\Connection:runQueryCallback in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
      #48 Illuminate\Database\Connection:run in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Connection.php:333
      #47 Illuminate\Database\Connection:select in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1963
      #46 Illuminate\Database\Query\Builder:runSelect in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1951
      #45 Illuminate\Database\Query\Builder:Illuminate\Database\Query{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2435
      #44 Illuminate\Database\Query\Builder:onceWithColumns in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1952
      #43 Illuminate\Database\Query\Builder:get in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2048
      #42 Illuminate\Database\Query\Builder:runPaginationCountQuery in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2021
      #41 Illuminate\Database\Query\Builder:getCountForPagination in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:710
      #40 Illuminate\Database\Eloquent\Builder:paginate in /var/www/shop/bagisto/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:429
      #39 Prettus\Repository\Eloquent\BaseRepository:paginate in /var/www/shop/bagisto/packages/Webkul/API/Http/Controllers/Shop/ResourceController.php:79
      #38 Webkul\API\Http\Controllers\Shop\ResourceController:index in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      #37 call_user_func_array in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      #36 Illuminate\Routing\Controller:callAction in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      #35 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      #34 Illuminate\Routing\Route:runController in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
      #33 Illuminate\Routing\Route:run in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Router.php:665
      #32 Illuminate\Routing\Router:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
      #31 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/packages/Webkul/Shop/src/Http/Middleware/Currency.php:46
      #30 Webkul\Shop\Http\Middleware\Currency:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #28 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/packages/Webkul/Shop/src/Http/Middleware/Theme.php:31
      #27 Webkul\Shop\Http\Middleware\Theme:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #25 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/packages/Webkul/Shop/src/Http/Middleware/Locale.php:50
      #24 Webkul\Shop\Http\Middleware\Locale:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #22 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
      #21 Illuminate\Pipeline\Pipeline:then in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Router.php:667
      #20 Illuminate\Routing\Router:runRouteWithinStack in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Router.php:642
      #19 Illuminate\Routing\Router:runRoute in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Router.php:608
      #18 Illuminate\Routing\Router:dispatchToRoute in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Router.php:597
      #17 Illuminate\Routing\Router:dispatch in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
      #16 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
      #15 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
      #14 Illuminate\Session\Middleware\StartSession:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #12 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      #11 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #9 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      #8 Illuminate\Cookie\Middleware\EncryptCookies:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #6 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62
      #5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
      #4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
      #3 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
      #2 Illuminate\Pipeline\Pipeline:then in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
      #1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /var/www/shop/bagisto/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
      #0 Illuminate\Foundation\Http\Kernel:handle in /var/www/shop/bagisto/public/index.php:74

      1 Reply Last reply Reply Quote 0
      • R
        rahul last edited by

        Hi @elkadye

        Can you tell me which version of bagisto , you are using ?

        Thanks

        1 Reply Last reply Reply Quote 0
        • E
          elkadye last edited by

          i tried it for 0.1.6 and 0.1.8. same results..

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