View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06838 | Bug reports | RemoteControl | public | 2012-11-07 17:08 | 2012-11-15 16:27 |
Reporter | jweberhofer | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06838: export_responses gives a SQLSTATE[42000] | ||||
Description | rpcClient->export_responses( zavbtzpautzd4psezkbnnegrn7g86dk6, 712485, 'csv', 'de', 'all', 'full', 'long', 5, 5) Always returns in the following exception: | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 121106 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 16 | ||||
Database type & version | MySQL 5.5.25 | ||||
Server OS (if known) | opensuse 12.1 | ||||
Webserver software & version (if known) | Apache/2.2.21 | ||||
PHP Version | 5.3.8 | ||||
Can you set debug mode to 2 in application/config/config.php and see if you get a more detailed error message? |
|
Thank you for the debug-hint. Following your response I see that the following statement is executed; it's the "WHERE" line that is wrong. Executing the statement without that line runs smoothly!SELECT * |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10193 |
|
Wow, you are really fast. I've corrected that, and is looks good, but: Another problem occures when I set an offset, in my case, I'll start with record four. The correct syntax would be "LIMIT 4" instead of "OFFSET 4" ======= ======= When I try to limit the result to one line, that second parameter will be completely ignored in the SQL-Statement, but that might be handled within code, too. I can't see a handling in the completion state within the SQL statement. Is there a way to load exactly a specific token's result, too? |
|
if you want to start with record 4 then OFFSET 4 is the right statement? |
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10212 |
|
LimeSurvey: master 7bb8660c 2012-11-08 14:43 Details Diff |
Fixed issue 06838: RemoteControl export_responses returns an error |
Affected Issues 06838 |
|
mod - application/controllers/admin/remotecontrol.php | Diff File | ||
LimeSurvey: 2.1 bb2b2baa 2012-11-09 00:05 Details Diff |
Fixed issue 06838: RemoteControl export_responses returns an error |
Affected Issues 06838 |
|
mod - application/controllers/admin/remotecontrol.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-11-07 17:08 | jweberhofer | New Issue | |
2012-11-08 09:50 | c_schmitz | Note Added: 22005 | |
2012-11-08 09:50 | c_schmitz | Assigned To | => c_schmitz |
2012-11-08 09:50 | c_schmitz | Status | new => feedback |
2012-11-08 14:38 | jweberhofer | Note Added: 22016 | |
2012-11-08 14:38 | jweberhofer | Status | feedback => assigned |
2012-11-08 14:43 | c_schmitz | Changeset attached | => LimeSurvey master 7bb8660c |
2012-11-08 14:43 | c_schmitz | Note Added: 22018 | |
2012-11-08 14:43 | c_schmitz | Resolution | open => fixed |
2012-11-08 14:43 | c_schmitz | Status | assigned => resolved |
2012-11-08 14:43 | c_schmitz | Fixed in Version | => 2.00+ |
2012-11-08 23:13 | jweberhofer | Note Added: 22030 | |
2012-11-08 23:14 | jweberhofer | Status | resolved => feedback |
2012-11-08 23:14 | jweberhofer | Resolution | fixed => reopened |
2012-11-08 23:19 | c_schmitz | Note Added: 22032 | |
2012-11-09 00:07 | c_schmitz | Changeset attached | => LimeSurvey 2.1 bb2b2baa |
2012-11-09 00:07 | c_schmitz | Note Added: 22036 | |
2012-11-15 16:27 | c_schmitz | Status | feedback => closed |
2012-11-15 16:27 | c_schmitz | Resolution | reopened => fixed |