- Posts: 3
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Can not activate survey
- ashu123
- Topic Author
- Offline
- New Member
Less
More
3 years 1 month ago - 3 years 1 month ago #211840
by ashu123
Can not activate survey was created by ashu123
Last edit: 3 years 1 month ago by DenisChenu. Reason: Attachment
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
3 years 1 month ago - 3 years 1 month ago #211842
by DenisChenu
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.
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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
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
what alternative to go with same questionnaire count.
I m using MySql
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12790
- Thank you received: 3940
3 years 1 month ago #211852
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
3 years 1 month ago #211853
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
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
Can this problem will b solved?
Kindly help
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11758
- Thank you received: 2753
3 years 1 month ago #211948
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12790
- Thank you received: 3940
3 years 1 month ago #211958
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
3 years 1 month ago #211961
by DenisChenu
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.
Replied by DenisChenu on topic Can not activate survey
With a war ning about MS SQL …Joffm wrote:
- MS SQL Server 2000: Maximum number of 1024 columns
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.