View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06596 | Bug reports | Survey participants (Tokens) | public | 2012-09-27 09:27 | 2012-10-05 15:54 |
| Reporter | galthaus | Assigned To | trougakoss | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Fixed in Version | 2.00+ | ||||
| Summary | 06596: Cant send invitation email with SQL DB | ||||
| Description | Get an error when sending email: | ||||
| Steps To Reproduce | Generate token for Survey and send email invitation | ||||
| Additional Information | As i know the keyword LIMIT is not supported by MSSQL | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 120926 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | IE | ||||
| Database type & version | SQL 2008 | ||||
| Server OS (if known) | W2008 R2 | ||||
| Webserver software & version (if known) | IIS 7 | ||||
| PHP Version | 5.3.13 | ||||
| Git branch / Pull Request URL | |||||
|
Spiros, it would be much better to replace this with a ActiveRecord query which supports (non-DB specific) limit, too. Can you take care of this? |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9667 |
|
|
Very nice patch! Thank you very much. |
|
|
New build 1201006 released. |
|
|
LimeSurvey: master c3b88a52 2012-10-05 08:24 Details Diff |
Fixed issue 06596: Cant send invitation email with SQL DB Dev: Changed findUninvited function in Token_dynamic to use CActiveRecord (non-DB specific) Dev: Changed building of parameters to take into account the CActiveRecord |
Affected Issues 06596 |
|
| mod - application/controllers/admin/remotecontrol.php | Diff File | ||
| mod - application/controllers/admin/tokens.php | Diff File | ||
| mod - application/models/Tokens_dynamic.php | Diff File | ||
|
LimeSurvey: master 3cc692d6 2012-10-05 08:44 Details Diff |
Merge pull request #49 from trougakoss/Yii Fixed issue 06596: Can't send invitation email with SQL DB |
Affected Issues 06596 |
|
| mod - application/controllers/admin/remotecontrol.php | Diff File | ||
| mod - application/controllers/admin/tokens.php | Diff File | ||
| mod - application/models/Tokens_dynamic.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-09-27 09:27 | galthaus | New Issue | |
| 2012-09-27 10:14 | c_schmitz | Assigned To | => trougakoss |
| 2012-09-27 10:14 | c_schmitz | Status | new => assigned |
| 2012-09-27 10:17 | c_schmitz | Note Added: 20838 | |
| 2012-10-05 15:44 | trougakoss | Changeset attached | => LimeSurvey master c3b88a52 |
| 2012-10-05 15:44 | c_schmitz | Changeset attached | => LimeSurvey master 3cc692d6 |
| 2012-10-05 15:44 | c_schmitz | Note Added: 21088 | |
| 2012-10-05 15:44 | c_schmitz | Assigned To | trougakoss => c_schmitz |
| 2012-10-05 15:44 | c_schmitz | Resolution | open => fixed |
| 2012-10-05 15:45 | c_schmitz | Assigned To | c_schmitz => trougakoss |
| 2012-10-05 15:45 | c_schmitz | Status | assigned => resolved |
| 2012-10-05 15:45 | c_schmitz | Fixed in Version | => 2.00+ |
| 2012-10-05 15:45 | c_schmitz | Note Added: 21089 | |
| 2012-10-05 15:54 | c_schmitz | Note Added: 21092 | |
| 2012-10-05 15:54 | c_schmitz | Status | resolved => closed |
| 2016-12-08 10:39 | c_schmitz | Category | Tokens => Survey participants (Tokens) |