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

Mehr
4 Monate 6 Tage her #171119 von socius
socius erstellte das Thema 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:


Anhang nicht gefunden




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

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
4 Monate 6 Tage her #171120 von socius
socius antwortete auf das Thema: 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
Anhang:

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
4 Monate 6 Tage her #171141 von DenisChenu
DenisChenu antwortete auf das Thema: 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 .

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
4 Monate 6 Tage her #171186 von socius
socius antwortete auf das Thema: 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

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
4 Monate 5 Tage her #171214 von DenisChenu
DenisChenu antwortete auf das Thema: 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 .
Folgende Benutzer bedankten sich: socius

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
3 Monate 4 Wochen her #171536 von socius
socius antwortete auf das Thema: 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

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
3 Monate 4 Wochen her #171553 von DenisChenu
DenisChenu antwortete auf das Thema: 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 .
Folgende Benutzer bedankten sich: socius

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
3 Monate 2 Tage her - 3 Monate 2 Tage her #172516 von socius
socius antwortete auf das Thema: 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


Anhang:
Letzte Änderung: 3 Monate 2 Tage her von socius.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha