Welcome, Guest
Username: Password: Remember me

TOPIC: Database Error

Database Error 2 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.

Re: Database Error 2 years 6 months ago #75198

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6277
  • Thank you received: 801
  • Karma: 241
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
Last Edit: 2 years 6 months ago by DenisChenu.
The administrator has disabled public write access.

Re: Database Error 2 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.

Re: Database Error 2 years 6 months ago #75249

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5324
  • Thank you received: 294
  • Karma: 249
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.108 seconds
Donation Image