View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04350Bug reportsOtherpublic2010-05-18 20:322010-08-04 16:10
Reporterdexter971 Assigned To 
PriorityimmediateSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.87+ 
Summary04350: Activation of huge survey (more 1000 questions)
Description

I create huge survey (more 1000 questions). it's works on demo mode. when i activate survey, i have this following message :

Erreur de la base de données : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 3

id I NOTNULL AUTO PRIMARY,
submitdate T,
lastpage I,
startlanguage C(20) NOTNULL ,
token C(36),
datestamp T NOTNULL,
startdate T NOTNULL,
26983X245X1121 X,
26983X245X1122DAT01 C(5),
26983X245X1122DAT02 C(5),
26983X245X1122DAT03 C(5),
....

when i delete several questions (500) it's works.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)8518
I will donate to the project if issue is resolved
Browser
Database type & versionMYISAM utf8_unicode_ci
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.0
PHP VersionPHP Version 5.2.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2010-05-19 02:04

updater   ~11865

Thibault, is it possible that the sring holding all the to be created DB fields (26983X245X1122DAT01 C(5),26983X245X1122DAT02 C(5),26983X245X1122DAT03 C(5), ...) becomes too long?

Wouldn't there be a different error message if you run into MySQLs columns limit?
lemeur

lemeur

2010-05-21 12:08

developer   ~11895

I dunno,

We need a sample survey to test this.
dexter971

dexter971

2010-05-21 14:02

reporter   ~11897

i think that it's the MySQL columns limit. i remove several questions and he work.
lemeur

lemeur

2010-05-21 14:14

developer   ~11898

http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html
[QUOTE]There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table[/QUOTE]

Again, the only way to troubleshoot this is to have a sample survey to reproduce the pb.

Thibault
Mazi

Mazi

2010-05-26 14:07

updater   ~11972

Can you please attach your survey for further testing?!

You can mark this ticket "private" so only our develoeprs will be able to access the data.
lemeur

lemeur

2010-07-10 18:48

developer   ~12381

I'm about to close this ticket by lack of feedback.
c_schmitz

c_schmitz

2010-08-04 16:10

administrator   ~12550

Closing issue due to missing feedback.

Issue History

Date Modified Username Field Change
2010-05-18 20:32 dexter971 New Issue
2010-05-18 20:32 dexter971 Status new => assigned
2010-05-18 20:32 dexter971 Assigned To => user372
2010-05-19 02:04 Mazi Note Added: 11865
2010-05-19 02:04 Mazi Assigned To user372 => lemeur
2010-05-21 12:08 lemeur Note Added: 11895
2010-05-21 12:08 lemeur Status assigned => feedback
2010-05-21 14:02 dexter971 Note Added: 11897
2010-05-21 14:02 dexter971 Status feedback => assigned
2010-05-21 14:14 lemeur Note Added: 11898
2010-05-21 14:20 lemeur Status assigned => feedback
2010-05-26 14:07 Mazi Note Added: 11972
2010-07-10 18:48 lemeur Note Added: 12381
2010-08-04 16:10 c_schmitz Note Added: 12550
2010-08-04 16:10 c_schmitz Status feedback => closed
2010-08-04 16:10 c_schmitz Assigned To lemeur =>
2010-08-04 16:10 c_schmitz Resolution open => unable to reproduce
2010-10-25 00:21 c_schmitz Category Data Access => (No Category)