Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Can not activate survey

  • ashu123
  • ashu123's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago - 3 years 1 month ago #211840 by ashu123
Can not activate survey was created by ashu123
I am 

Not able to activate survey as hetting error 

Kindly help me 

 
Last edit: 3 years 1 month ago by DenisChenu. Reason: Attachment
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago - 3 years 1 month ago #211842 by DenisChenu
Replied by DenisChenu on topic Can not activate survey
Seems you have more question than possible with your DB

See manual.limesurvey.org/General_FAQ/en#...regarding_survey_size

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 .
I don't answer to private message.
Last edit: 3 years 1 month ago by DenisChenu.
The topic has been locked.
  • ashu123
  • ashu123's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago #211850 by ashu123
Replied by ashu123 on topic Can not activate survey
Kindly help me with this...
what alternative to go with same questionnaire count.


I m using MySql
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211852 by Joffm
Replied by Joffm on topic Can not activate survey
Hm, alternative?
You see, as this is a limitation of MySQL and there is this flat database structure of LimeSurvey you can not do anything on this level.

1st you may revise your questionnaire.
E.g. If there are long arrays(text) or arrays(number) with subquestion relevance you may use micro-tayloring to shorten this.
​​​​
2nd you may split the survey.
In the end-url of the first survey you link to the second one.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211853 by tpartner
Replied by tpartner on topic Can not activate survey
Split it into two surveys. The forum contains many examples of how to link two surveys.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • ashu123
  • ashu123's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 1 month ago #211922 by ashu123
Replied by ashu123 on topic Can not activate survey
If i switched to postgress....


Can this problem will b solved?

Kindly help
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211948 by holch
Replied by holch on topic Can not activate survey
There is no difference. If you reach the limit of your postgress table, you still need to split the survey if you reach the limit.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211958 by Joffm
Replied by Joffm on topic Can not activate survey
And as you followed Denis' link you saw:
  • MySQL ISAM: The sum of the lengths of the VARCHAR and CHAR columns in a table may be up to 64KB. (about 1570 columns)
  • MySQL InnoDB: Maximum number of 1000 columns
  • MS SQL Server 2000: Maximum number of 1024 columns
  • Postgres: Maximum number of 250-1600 columns depending on column types. The maximum number of columns can be quadrupled by increasing the default block size to 32k. See  Installation FAQ  and  PostgreSQL FAQ .

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 1 month ago #211961 by DenisChenu
Replied by DenisChenu on topic Can not activate survey

Joffm wrote:

  • MS SQL Server 2000: Maximum number of 1024 columns

With a war ning about MS SQL …

Sometimes : you can activate survey, all seems good, but for some user : they can not save their data : the reason is «Bytes per row in memory-optimized tables» maximum value is 8,060 for one row (one reponse)

See : docs.microsoft.com/en-us/sql/sql-server/...iew=sql-server-ver15

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 .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose