Allow longer answer codes (and question codes, too)

More
6 months 2 weeks ago #187152 by jelo

oleggorfinkel wrote: So, what would be the "right" design?

The typical design is distributed via different tables with a maptable.

Depending on additional features, you end up with a handful of tables.

To get an impression, take a look at this here:
www.sawtoothsoftware.com/help/lighthouse...d_web_howstored.html

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Please Iniciar sessão or Create an account to join the conversation.

More
6 months 2 weeks ago #187154 by DenisChenu
Long answer code : bugs.limesurvey.org/view.php?id=7593#c52401

@ollehar open a mantis issue about separate database (in some condition)

I don't find it

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 .
An error happen ? Before make a new topic : remind the Debug mode .

Please Iniciar sessão or Create an account to join the conversation.

More
6 months 2 weeks ago #187167 by oleggorfinkel

jelo wrote:

oleggorfinkel wrote: So, what would be the "right" design?

The typical design is distributed via different tables with a maptable.

Depending on additional features, you end up with a handful of tables.

To get an impression, take a look at this here:
www.sawtoothsoftware.com/help/lighthouse...d_web_howstored.html

Yes, that's exactly what I was talking about as option #1 in my previous message.

Oleg G.

Please Iniciar sessão or Create an account to join the conversation.

More
4 weeks 2 days ago #192885 by blocka
I need to manually override the answer code length this for one of my surveys.

I see the table _answers has the column code varchar(5). I need to change this to varchar(8).

When I change it, I see that LS still restricts the length to varchar(5), so I'm guessing somewhere in the LS codebase, the max length of _answers.code is defined?

Can anyone point me to the location where max length of 5 is defined, so I can override it to 8?

Please Iniciar sessão or Create an account to join the conversation.

More
4 weeks 2 days ago #192890 by blocka
Digging a bit deeper into this, I've tested with these changes, and it appears to work:

/application/views/admin/survey/Question/subquestionsAndAnswers/_answer_option.twig : ln #53

/application/models/Answer.php : ln #75

/application/views/admin/labels/_labelviewtabcontent_view.php : ln #47

And update database columns:

ALTER TABLE `lime_answers` CHANGE `code` `code` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

ALTER TABLE `lime_labels` CHANGE `code` `code` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

Please Iniciar sessão or Create an account to join the conversation.

Começar agora!

Basta criar a sua conta e comece a usar o LimeSurvey hoje mesmo.

Registar agora
Subscreva o nosso boletim informativo!

Iniciar sessão