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 |