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

TOPIC: Database Error

Database Error 4 years 6 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 6 months ago #75198

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
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 developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
Last Edit: 4 years 6 months ago by DenisChenu.
The administrator has disabled public write access.

Database Error 4 years 6 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 6 months ago #75249

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5984
  • Thank you received: 368
  • 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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.269 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form