View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
08873 | Bug reports | Central participant database | public | 2014-03-18 12:20 | 2014-03-20 14:52 |
Reporter | reizformation | Assigned To | c_schmitz | ||
Priority | high | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.05+ | ||||
Fixed in Version | 2.05+ | ||||
Summary | 08873: csv export for participants fails if "all attributes" selected - CDbCommand failed to execute the SQL statement | ||||
Description | csv export for participants fails if "all attributes" selected. if explicit attributes selected the csv export is functional. Error: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm' in 'on clause' An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you. | ||||
Additional Information | PHP warning Illegal string offset 'attribute_id' /var/www/limesurvey/application/models/Participant.php(292) 280 $selectValue[] = "luser.users_name as username"; Stack Trace #1 #2 #3 #5 #6 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | Version 2.05+ Build 140317 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | Firefox 27.01, Chrome 32.0.1700.102, Safari 7.0.2 (9537.74.9) | ||||
Database type & version | 5.5.35-0+wheezy1, | ||||
Server OS (if known) | Debian 3.2.54-2 x86_64 | ||||
Webserver software & version (if known) | Apache/2.2.22 (Debian) | ||||
PHP Version | PHP Version 5.4.4-14+deb7u7 | ||||
if one attribute explicit selected (functional) mysql.log entry follow: 140318 17:12:53 134 Connect root@localhost on lime02 |
|
when using "select all" (attributes) (not functional) mysql.log shows: 140318 17:15:52 136 Connect root@localhost on lime02 |
|
Browser shows: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm' in 'on clause' the difference i found is: LEFT JOIN lime_participant_attribute attributem ON attributem.participant_id=p.participant_id AND attributem.attribute_id=m LEFT JOIN lime_participant_attribute attribute1 ON attribute1.participant_id=p.participant_id AND attribute1.attribute_id=1 |
|
reproducing the sql-query: SELECT shows: #1054 - Unknown column 'attributem.value' in 'field list' |
|
$('#exportcsv').dialog({ |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14037 |
|
Thank you for your donation - that's very much appreciated! |
|
2.05+ Build 140320 released |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2014-03-18 12:20 | reizformation | New Issue | |
2014-03-18 12:20 | reizformation | File Added: exporttocsv_01.png | |
2014-03-18 12:21 | reizformation | Issue Monitored: reizformation | |
2014-03-18 17:15 | reizformation | Note Added: 29351 | |
2014-03-18 17:17 | reizformation | Note Added: 29352 | |
2014-03-18 17:19 | reizformation | Note Added: 29353 | |
2014-03-18 17:34 | reizformation | Note Added: 29355 | |
2014-03-18 19:37 | reizformation | Note Added: 29359 | |
2014-03-18 20:25 | reizformation | Issue End Monitor: reizformation | |
2014-03-18 20:27 | reizformation | Issue Monitored: reizformation | |
2014-03-19 12:19 | c_schmitz | Assigned To | => c_schmitz |
2014-03-19 12:19 | c_schmitz | Status | new => assigned |
2014-03-19 12:31 | c_schmitz | Changeset attached | => LimeSurvey master c5a4103f |
2014-03-19 12:31 | c_schmitz | Note Added: 29395 | |
2014-03-19 12:31 | c_schmitz | Resolution | open => fixed |
2014-03-19 12:31 | c_schmitz | Status | assigned => resolved |
2014-03-19 12:31 | c_schmitz | Fixed in Version | => 2.05+ |
2014-03-19 14:34 | c_schmitz | Note Added: 29401 | |
2014-03-20 14:52 | c_schmitz | Note Added: 29451 | |
2014-03-20 14:52 | c_schmitz | Status | resolved => closed |
2021-08-03 10:29 | guest | Bug heat | 4 => 6 |