aimeos-core icon indicating copy to clipboard operation
aimeos-core copied to clipboard

Postgresql index Error after setup

Open MahmoudDevo opened this issue 3 years ago • 1 comments

Hi aimeos, I use : PostgreSQL 14 "laravel/framework": "^9.2",

"php": "^7.3|^8.0", "aimeos/aimeos-laravel": "~2022.04", "aimeos/ai-cms-grapesjs": "2022.04.1", "fruitcake/laravel-cors": "^2.0", "guzzlehttp/guzzle": "^7.0.1", "laravel/framework": "^9.2", "laravel/jetstream": "^2.2", "laravel/sanctum": "^2.6", "laravel/tinker": "^2.5", "livewire/livewire": "^2.0", "phing/phing": "^2.16"

After update to the version 2022.04 : when i run php artisan aimeos:setup i get :

  Checking table "mshop_index_attribute": 
  Checking table "mshop_index_catalog": 
  Checking table "mshop_index_price": 
  Checking table "mshop_index_supplier": 
  Checking table "mshop_index_text": 
Remove old indexes from mshop_index_* tables
Creating index schema
In ExceptionConverter.php line 78:                                                                                                                                       
  An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "idx_msindte_content" already    
  exists 
In Exception.php line 30:
  SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "idx_msindte_content" already exists  
In Connection.php line 34:
  SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "idx_msindte_content" already exists  

Thank you

MahmoudDevo avatar Apr 12 '22 00:04 MahmoudDevo

The bug has been already fixed in master and 2022.04 branch but not yet tagged. Please execute:

composer req aimeos/aimeos-core:2022.04.x-dev

If it works for you too, we will tag another release.

aimeos avatar Apr 12 '22 07:04 aimeos