developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.
Opened 13 years ago
Closed 13 years ago
#631 closed bug (fixed)
Fichier SQL d'installation de jAcl2
| Reported by: | nuks | Owned by: | nuks |
|---|---|---|---|
| Priority: | normal | Milestone: | Jelix 1.1 beta 1 |
| Component: | jelix:acl | Version: | trunk |
| Severity: | normal | Keywords: | jAcl2 SQL PostGreSQL PgSQL |
| Cc: | Blocked By: | ||
| Blocking: | Documentation needed: | no | |
| Hosting Provider: | Php version: |
Description
Le fichier lib/jelix/core-modules/jelix/install/sql/install_jacl2.data.*.sql inclus deux enregistrement de groupes "admin" et "users" dans jacl2_group. Les id de ces enregistrements (id_aclgrp) sont spécifiés explicitement car réutilisés dans les enregistrements dans jacl2_rights. Le problème est que le fait de spécifié ces ids ne modifie pas la séquence sur postgresql. Ainsi, lors du prochain enregistrement dans jacl2_group sans spécifié explicitement l'id, la séquence va renvoyer l'id 1. La requête va alors être annulé car contradictoire avec la contrainte d'unicité de la colonne jacl2_group.
Attachments (1)
Change History (6)
comment:1 Changed 13 years ago by bballizlife
Changed 13 years ago by nuks
SELECT setval('table_row_seq', 2, true); or SELECT setval('table_row_seq', 3, false); ;)
comment:2 Changed 13 years ago by nuks
- Owner set to nuks
comment:3 Changed 13 years ago by bballizlife
- review set to review?
Thanks for the patch, i'll let someone knowing pgsql reviewing it.
comment:4 Changed 13 years ago by laurentj
- Milestone set to Jelix 1.1 beta 1
- review changed from review? to review+
- Version changed from 1.0.4 to trunk
It's ok for me.
comment:5 Changed 13 years ago by bastnic
- Resolution set to fixed
- Status changed from new to closed
commited
I don't know about postgresql so i can't fix this issue. do you know more and so can you make a proposal in order to have an install file working for postgresql ?