lunar icon indicating copy to clipboard operation
lunar copied to clipboard

Postgres instalation error

Open fulvio-diller opened this issue 1 year ago • 0 comments

  • Lunar version: 1.x-dev
  • Laravel Version: 10.10
  • PHP Version: 8.2.14
  • Database Driver & Version: postgres 16

Expected Behaviour:

Finish instalation

Actual Behaviour:

  2024_01_16_100010_update_product_option_relations ...................................................................................... 13ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42803]: Grouping error: 7 ERROR:  column "lunar_products.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select "lunar_products"."id" as "product_id", "lunar_product...
               ^ (Connection: pgsql, SQL: select "lunar_products"."id" as "product_id", "lunar_product_options"."id" as "product_option_id", "lunar_product_options"."position" from "lunar_product_option_value_product_variant" inner join "lunar_product_variants" on "lunar_product_option_value_product_variant"."variant_id" = "lunar_product_variants"."id" inner join "lunar_product_option_values" on "lunar_product_option_value_product_variant"."value_id" = "lunar_product_option_values"."id" inner join "lunar_product_options" on "lunar_product_option_values"."product_option_id" = "lunar_product_options"."id" inner join "lunar_products" on "lunar_product_variants"."product_id" = "lunar_products"."id" group by "product_id", "product_option_id" order by "product_id" asc limit 2 offset 0)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:822
    818▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    819▕                 );
    820▕             }
    821▕ 
  ➜ 822▕             throw new QueryException(
    823▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    824▕             );
    825▕         }
    826▕     }

      +47 vendor frames 

  48  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()

Steps To Reproduce:

composer create-project laravel/laravel .
composer require lunarphp/lunar:1.x-dev -W
->change .env with db credentials
php artisan lunar:install

fulvio-diller avatar Jan 19 '24 13:01 fulvio-diller