Delete attributes from token table to start attribute_ID at "attribute_1" again

Plus d'informations
il y a 4 mois 1 semaine #171119 par socius
socius a créé le sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
Hi everybody,

I have a question concerning deleting attributes from a token table:

I created a csv file with my tokentable for upload to the central patricipant database (CPD). The table contains lots of additional attributes.

I played around, changed the table, deleted the CPD and uploaded this table several times. Everytime I also used the CPD to add participants, i.e. fill the token table of one of my surveys and so created the attributes from the CPD also in the token table of this survey.

Now the problem is, that although I deleted the attributes in this survey each time before adding participants from the CPD, the attribute_ID went higher and higher:


La pièce jointe est absente ou indisponible




What can I do here? I'd like to delete all the attributes and also start the attribute_ID at attribute_1. Is there a way to do this from the Limesurvey Interface (I still use LS 2.6.7LTS) or would I have to delete these directly from the MySQL-DB?

Thanks for your time!

Best,
G

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 4 mois 1 semaine #171120 par socius
socius a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
The screenshot got lost in the upload ("Flood Protection"?). Here it is.



Best,
G
Pièces jointes :

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 4 mois 6 jours #171141 par DenisChenu
DenisChenu a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
Did you try with : delete token table directly ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 4 mois 6 jours #171186 par socius
socius a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
Thanks for your response, Denis!

Yes, I deleted the attributes, the whole token table more than once. Everytime I import from the CPD the attribute_IDs increased - now after some import/export/delete its 250+ ;-)

But: I just noticed, that if I manually add attributes to the surveys the attribute_ID starts with attribute_1 again... the solution seems to be to manually create attributes and map these to the CPD (and not create them by copying participants from the CPD to the survey token tables...

Best, G

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 4 mois 5 jours #171214 par DenisChenu
DenisChenu a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
You mean
- Auto adding attribute via CPDB : start at 'last done'
- Adding via token attribute management : start at first one

If yes : maybe you can report the issue :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Les utilisateur(s) suivant ont remercié: socius

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 3 mois 4 semaines #171536 par socius
socius a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
Hi Denis,

I just reported this issue, s. bugs.limesurvey.org/view.php?id=13893 . Unfortunately the subject was not finished yet - now it's just "2.6.7 LTS" which is not overly informative - sorry. Could someone edit this subject? (I think I can't do this, right?) to: "Via CPDB created attributes: attribute_ID does not start at 1".

Thanks and all the best,
G

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 3 mois 4 semaines #171553 par DenisChenu
DenisChenu a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
No such fix on 2.6.7 lts …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Les utilisateur(s) suivant ont remercié: socius

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 3 mois 2 jours - il y a 3 mois 2 jours #172516 par socius
socius a répondu au sujet : Delete attributes from token table to start attribute_ID at "attribute_1&qu
Hi,

about a month ago I had some troubles with attribute_IDs that did not start with "1" even after deleting a token table and all the attributes. After some failed attempts to import tokens with attributes (sometimes it worked, sometimes the fields stayed empty) the attribute_ID started with 200+, but it still worked. (I use LS2.6.7LTS)

Now I have an error I do not want to ignore, a duplicate attribute_ID

<h1>PHP Error [500]</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'attribute_266'</p>

For a screenshot s. below.

Unfortunately I'd really need the functionality of the CPDB and fill multiple survey token tables with the same respondents + multiple attributes. The question is:
  • Did anybody experience this before?
  • Is that a known bug in LS2.6.7LTS?
  • Could/should I delete the attribute fields directly in the database to start anew with the attribute_IDs (despite the problems with importing)?
  • Was the CPDB improved in more recent versions? I.e. would I have to abandon 2.6.7LTS to get this functionality?

Thanks for your time and help!
Best, G


Pièces jointes :
Dernière édition: il y a 3 mois 2 jours par socius.

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!