developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Opened 12 years ago

Closed 12 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)

patch.diff (920 bytes) - added by nuks 12 years ago.
SELECT setval('table_row_seq', 2, true); or SELECT setval('table_row_seq', 3, false); ;)

Download all attachments as: .zip

Change History (6)

comment:1 Changed 12 years ago by bballizlife

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 ?

Changed 12 years ago by nuks

SELECT setval('table_row_seq', 2, true); or SELECT setval('table_row_seq', 3, false); ;)

comment:2 Changed 12 years ago by nuks

  • Owner set to nuks

comment:3 Changed 12 years ago by bballizlife

  • review set to review?

Thanks for the patch, i'll let someone knowing pgsql reviewing it.

comment:4 Changed 12 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 12 years ago by bastnic

  • Resolution set to fixed
  • Status changed from new to closed

commited

Note: See TracTickets for help on using tickets.