Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Database Error

Database Error 4 years 9 months ago #75010

  • Manisha
  • Manisha's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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 !!
The administrator has disabled public write access.

Database Error 4 years 9 months ago #75198

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9572
  • Thank you received: 1374
  • Karma: 390
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 (use private message).
Last Edit: 4 years 9 months ago by DenisChenu.
The administrator has disabled public write access.

Database Error 4 years 9 months ago #75200

  • Manisha
  • Manisha's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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 :)
The administrator has disabled public write access.

Database Error 4 years 9 months ago #75249

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6028
  • Thank you received: 373
  • Karma: 260
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'"
The administrator has disabled public write access.
Time to create page: 0.233 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form