Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres instalation error #1483

Open
fulvio-diller opened this issue Jan 19, 2024 · 0 comments
Open

Postgres instalation error #1483

fulvio-diller opened this issue Jan 19, 2024 · 0 comments
Labels
1.x bug Something isn't working

Comments

@fulvio-diller
Copy link

  • 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 fulvio-diller added bug Something isn't working unconfirmed labels Jan 19, 2024
@glennjacobs glennjacobs added the 1.x label May 20, 2024 — with Linear
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1.x bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants