Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Can't import group anymore

  • ludogre
  • ludogre's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 5 months ago #207495 by ludogre
Can't import group anymore was created by ludogre
Hi!

I can't duplicate survey and group anymore, because of group duplication error:

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23505]: Unique violation: 7 ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « lime_groups_pkey »
DETAIL: La clé « (gid)=(9) » existe déjà.

.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 5 months ago #207502 by DenisChenu
Replied by DenisChenu on topic Can't import group anymore
Your LimeSurvey version ?

You try to import a simple survey or it's a specific survey
Did you try check intergrity

etc (mean : give more information …)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • ludogre
  • ludogre's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 5 months ago - 3 years 5 months ago #207610 by ludogre
Replied by ludogre on topic Can't import group anymore
Hi!
I've just upgraded to 4.3.23 from 4.3.22 and check integrity.

I've retried to import an exported group of my previous survey to the new one and error is now:

500 : Erreur interne au serveur
CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23505]: Unique violation: 7 ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « lime_groups_pkey »
DETAIL: La clé « (gid)=(11) » existe déjà.


If I try to duplicate my previous survey, I've got this error:

500 : Erreur interne au serveur
CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23505]: Unique violation: 7 ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « lime_groups_pkey »
DETAIL: La clé « (gid)=(12) » existe déjà.


Note that the gid key is incremented as I try another way to copy my survey.

Sorry for my too brief previous post.
Last edit: 3 years 5 months ago by ludogre. Reason: Incomplete
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 5 months ago #207620 by DenisChenu
Replied by DenisChenu on topic Can't import group anymore
If you can reproduce with a
1. export lss
2. try to import lss

Best is to report the issue on mantis.
If survey muts be keep secret : you can set bug report as private.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose