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

More
4 months 2 days ago #171119 by socius
socius created the topic: 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:


Attachment not found




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

Please Log in or Create an account to join the conversation.

More
4 months 2 days ago #171120 by socius
socius replied the topic: 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
Attachments:

Please Log in or Create an account to join the conversation.

More
4 months 2 days ago #171141 by DenisChenu
DenisChenu replied the topic: 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 .

Please Log in or Create an account to join the conversation.

More
4 months 2 days ago #171186 by socius
socius replied the topic: 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

Please Log in or Create an account to join the conversation.

More
4 months 1 day ago #171214 by DenisChenu
DenisChenu replied the topic: 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 .
The following user(s) said Thank You: socius

Please Log in or Create an account to join the conversation.

More
3 months 3 weeks ago #171536 by socius
socius replied the topic: 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

Please Log in or Create an account to join the conversation.

More
3 months 3 weeks ago #171553 by DenisChenu
DenisChenu replied the topic: 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 .
The following user(s) said Thank You: socius

Please Log in or Create an account to join the conversation.

More
2 months 4 weeks ago - 2 months 4 weeks ago #172516 by socius
socius replied the topic: 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


Attachments:
Last Edit: 2 months 4 weeks ago by socius.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!