/home/abizobindia/public_html/
Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.shop_id' in 'on clause' (SQL: select `shopkeeper_details`.*, `pc`.`name` as `product_category`, `product_sub_categorys`.`name` as `product_sub_category`, `pc`.`id` as `product_category_id`, `product_sub_categorys`.`id` as `product_sub_category_id` from `shopkeeper_details` left join `products` as `product` on `product`.`shop_id` = `shopkeeper_details`.`id` left join `product_categorys` as `pc` on `pc`.`id` = `product`.`product_cat_id` left join `product_sub_categorys` on `product_sub_categorys`.`id` = `product`.`product_sub_cat_id` where find_in_set(46, shopkeeper_details.shop_cat_id) and find_in_set(212, shopkeeper_details.shop_sub_cat_id) and `shopkeeper_details`.`home_devlivery` is null and `shopkeeper_details`.`deleted_at` is null group by `shopkeeper_details`.`id`)
Hide solutions

A column was not found

You might have forgotten to run your migrations. You can run your migrations using php artisan migrate.

Pressing the button below will try to run your migrations.

Loading...

    • 54
      vendor/laravel/framework/src/Illuminate/Database/Connection.php
      Illuminate\Database\Connection
      :712
    • 53
      Illuminate\Database\Connection
      :672
    • 52
      Illuminate\Database\Connection
      :376
    • 45
      app/Http/Controllers/EshoppingController.php
      App\Http\Controllers\EshoppingController
      :67
    • 1
      public/index.php
      :52
Illuminate\Database\Connection::runQueryCallback
vendor/laravel/framework/src/Illuminate/Database/Connection.php:712

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727 

     * @throws \Illuminate\Database\QueryException
     */
    protected function runQueryCallback($query, $bindings, Closure $callback)
    {
        // To execute the statement, we'll simply call the callback, which will actually
        // run the SQL against the PDO connection. Then we can calculate the time it
        // took to execute and log the query SQL, bindings and time in our memory.
        try {
            return $callback($query, $bindings);
        }
 
        // If an exception occurs when attempting to run a query, we'll format the error
        // message to include the bindings with SQL, which will make this exception a
        // lot more helpful to the developer instead of just the database's errors.
        catch (Exception $e) {
            throw new QueryException(
                $query, $this->prepareBindings($bindings), $e
            );
        }
    }
 
    /**
     * Log a query in the connection's query log.
     *
     * @param  string  $query
     * @param  array  $bindings
     * @param  float|null  $time
     * @return void
     */
    public function logQuery($query, $bindings, $time = null)
    {