lunar
lunar copied to clipboard
Postgres instalation error
- 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