View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13464 | Bug reports | RemoteControl | public | 2018-03-09 13:53 | 2018-03-15 13:41 |
Reporter | Erika3175 | Assigned To | ollehar | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.1.x | ||||
Fixed in Version | 3.5.x | ||||
Summary | 13464: Invalid SQL in "mail_registered_participants" RemoteControl API method | ||||
Description | When using "mail_registered_participants" (with no third argument at least) RemoteControl API method, the resulting SQL is not valid for PostgreSQL databases. It's currently resulting in : ...AND (emailstatus = "OK") ORDER BY tid The second form should be fine at least with MySQL and PostgreSQL, and probably with other SQL-compliant databases... | ||||
Steps To Reproduce | include_once 'vendor/autoload.php'; define( 'LS_BASEURL', 'https://localhost/limesurvey/'); // adjust this one to your actual LimeSurvey URL // the survey to process
} // release the session key | ||||
Additional Information | Fix can be done in application/helpers/remotecontrol/remotecontrol_handle.php at line 2339 | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 3.4.4 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | PostgreSQL 9.4.5 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache 2.4 | ||||
PHP Version | 5.6 | ||||
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=26719 |
|
Thanks for reporting! |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2018-03-09 13:53 | Erika3175 | New Issue | |
2018-03-12 10:37 | ollehar | Changeset attached | => LimeSurvey master 0d093781 |
2018-03-12 10:37 | ollehar | Note Added: 47009 | |
2018-03-12 10:37 | ollehar | Assigned To | => ollehar |
2018-03-12 10:37 | ollehar | Resolution | open => fixed |
2018-03-12 10:38 | ollehar | Status | new => resolved |
2018-03-12 10:38 | ollehar | Fixed in Version | => 3.5.x |
2018-03-12 10:38 | ollehar | Note Added: 47010 | |
2018-03-15 13:41 | ollehar | Status | resolved => closed |