Check out the LimeSurvey source code on GitHub!

Database Error

More
4 years 11 months ago #75010 by Manisha
Hi,

I have put up a survey with 82 questions.
My survey has a lot of array of textbox type of questions due to which the database is showing an ERROR "Too many columns"

Please help !!

Please Log in to join the conversation.

More
4 years 11 months ago - 4 years 11 months ago #75198 by DenisChenu
Hello,

There aren't good solution for this ...

You can have a look at :
docs.limesurvey.org/General+FAQ&#regarding_survey_size

Can you change the survey ? Can you split the survey ?

What is your actual SQL server ?

Denis

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).
Last Edit: 4 years 11 months ago by DenisChenu.

Please Log in to join the conversation.

More
4 years 11 months ago #75200 by Manisha
Hi

Thanks for the reply.

I have MySQL ISAM in which columns in a table may be up to 64KB.
So I tried splitting up the survey into two survey 1 and survey 2 and it worked :)

But I wanted to bind both surveys in any way, So I included a question in survey 2 which is always hidden and then passed a value from survey 1 to that question using a php file in between :) :) Now its working fine :)

Please Log in to join the conversation.

More
4 years 11 months ago #75249 by Mazi
You're welcome :-)

If our hints have been helpful and you enjoy limesurvey please consider a donation to the team .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form