View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06138 | Bug reports | Survey participants (Tokens) | public | 2012-05-27 14:47 | 2012-07-19 23:34 |
| Reporter | adoubleu | Assigned To | DenisChenu | ||
| Priority | normal | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00RC1 | ||||
| Fixed in Version | 2.00RC5 | ||||
| Summary | 06138: Undefined index: count(tid) in Tokens_dynamic.php(85) | ||||
| Description | Undefined index: count(tid), see attachement for details of php output | ||||
| Steps To Reproduce | Install YII version from git such as described in http://docs.limesurvey.org/Accessing+the+source+code&structure=LimeSurvey+development
| ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 1 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | any | ||||
| Database type & version | postgres 9 | ||||
| Server OS (if known) | ubuntu | ||||
| Webserver software & version (if known) | apache 2.2 | ||||
| PHP Version | 5.3 | ||||
| Git branch / Pull Request URL | |||||
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8580 |
|
|
2.0RC3 released |
|
|
Can you please have another look at this. You seems have implemented DB type specific SQL and completely breaking MSSQL (and maybe Postgres). |
|
|
Zut, I have a look at http://weblogs.asp.net/wilczynski/archive/2008/06/03/sum-case-in-sql.aspx before put this patch. Use the old method then. (and tested with pgsql) |
|
|
Carsten, And if i look to MSSQL documentation, SUM(CASE() have to work. Denis (and after assign it to me) |
|
|
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]The data types text and varchar are in the equal to-Operator incompatible.. The SQL statement executed was: SELECT COUNT(*) as tkcount, FROM [lime_tokens_167949] |
|
|
OK, Can you test with:
Replace by SUM(CASE WHEN (emailstatus like 'OptOut%') THEN 1 ELSE 0 END) as tkoptout, Tested with mysql and pgsql Thanks |
|
|
Yes, works fine, even SUM(CASE WHEN (emailstatus like 'OptOut') THEN 1 ELSE 0 END) as tkoptout, works. No % needed. |
|
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8856 |
|
|
2.00RC6 released. |
|
|
LimeSurvey: Yii 3336fac3 2012-05-30 09:41 Details Diff |
Fixed issue 06138 : Undefined index: count(tid) in Tokens_dynamic.php with postgresql Dev: remove queryX from Tokens_dynamic::model($sid)->summary(); Dev: use SUM(CASE WHEN : tested with pgsql/mysql. |
Affected Issues 06138 |
|
| mod - application/controllers/admin/tokens.php | Diff File | ||
| mod - application/models/Tokens_dynamic.php | Diff File | ||
| mod - application/views/admin/token/tokensummary.php | Diff File | ||
|
LimeSurvey: Yii 249c832c 2012-06-23 11:40 Details Diff |
Fixed issue 06138 : crash MSSQL in token information Dev : keep % to have information with token admin edit |
Affected Issues 06138 |
|
| mod - application/models/Tokens_dynamic.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-05-27 14:47 | adoubleu | New Issue | |
| 2012-05-27 14:49 | adoubleu | File Added: phpNotice.pdf | |
| 2012-05-28 18:31 | c_schmitz | Assigned To | => DenisChenu |
| 2012-05-28 18:31 | c_schmitz | Status | new => assigned |
| 2012-05-30 16:43 | DenisChenu | Changeset attached | => LimeSurvey Yii 3336fac3 |
| 2012-05-30 16:43 | DenisChenu | Note Added: 19003 | |
| 2012-05-30 16:43 | DenisChenu | Resolution | open => fixed |
| 2012-05-30 16:45 | DenisChenu | Status | assigned => resolved |
| 2012-05-30 16:45 | DenisChenu | Fixed in Version | => 2.00RC3 |
| 2012-06-20 14:05 | c_schmitz | Note Added: 19379 | |
| 2012-06-20 14:05 | c_schmitz | Status | resolved => closed |
| 2012-06-21 13:46 | c_schmitz | Note Added: 19437 | |
| 2012-06-21 13:46 | c_schmitz | Status | closed => feedback |
| 2012-06-21 13:46 | c_schmitz | Resolution | fixed => reopened |
| 2012-06-21 14:48 | DenisChenu | Note Added: 19443 | |
| 2012-06-21 14:48 | DenisChenu | Note Edited: 19443 | |
| 2012-06-21 15:16 | DenisChenu | Assigned To | DenisChenu => c_schmitz |
| 2012-06-21 15:16 | DenisChenu | Status | feedback => assigned |
| 2012-06-21 15:16 | DenisChenu | Note Added: 19445 | |
| 2012-06-21 15:22 | c_schmitz | Note Added: 19446 | |
| 2012-06-21 15:23 | c_schmitz | Note Edited: 19446 | |
| 2012-06-21 15:59 | DenisChenu | Note Added: 19447 | |
| 2012-06-23 17:11 | c_schmitz | Note Added: 19519 | |
| 2012-06-23 17:11 | c_schmitz | Assigned To | c_schmitz => DenisChenu |
| 2012-06-23 18:42 | DenisChenu | Changeset attached | => LimeSurvey Yii 249c832c |
| 2012-06-23 18:42 | DenisChenu | Note Added: 19528 | |
| 2012-06-23 18:50 | DenisChenu | Status | assigned => resolved |
| 2012-06-23 18:50 | DenisChenu | Fixed in Version | 2.00RC3 => 2.00RC5 |
| 2012-06-23 18:50 | DenisChenu | Resolution | reopened => fixed |
| 2012-07-19 23:34 | c_schmitz | Note Added: 19838 | |
| 2012-07-19 23:34 | c_schmitz | Status | resolved => closed |
| 2016-12-08 10:39 | c_schmitz | Category | Tokens => Survey participants (Tokens) |