View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05757 | Bug reports | Survey taking | public | 2012-02-04 23:10 | 2012-03-14 21:08 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | urgent | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00a1 | ||||
| Fixed in Version | 2.00a2 | ||||
| Summary | 05757: Table name typo | ||||
| Description | There is an apostroph that leads to a crash fixed with $tkquery = "SELECT * FROM {{tokens_".$surveyid."}} WHERE token='".$token."' AND (completed = 'N' or completed='')"; | ||||
| Steps To Reproduce | Just filled out | ||||
| Additional Information | Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''tokens'228225 WHERE token='4f27c698bb023' AND (completed = 'N' or completed=''' at line 1. The SQL statement executed was: SELECT * FROM lime'tokens_'228225 WHERE token='4f27c698bb023' AND (completed = 'N' or completed='') | ||||
| Tags | No tags attached. | ||||
| Attached Files | SurveyAction.php.diff (796 bytes)
Index: controllers/SurveyAction.php
===================================================================
--- controllers/SurveyAction.php (revision 12350)
+++ controllers/SurveyAction.php (working copy)
@@ -427,7 +427,7 @@
if ($thissurvey['alloweditaftercompletion'] == 'Y' ) {
$tkquery = "SELECT * FROM {{tokens_".$surveyid."}} WHERE token='".$token."'";
} else {
- $tkquery = "SELECT * FROM {{'tokens_'".$surveyid."}} WHERE token='".$token."' AND (completed = 'N' or completed='')";
+ $tkquery = "SELECT * FROM {{tokens_".$surveyid."}} WHERE token='".$token."' AND (completed = 'N' or completed='')";
}
$tkresult = dbExecuteAssoc($tkquery); //Checked
$tokendata = $tkresult->read();
| ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 2 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | firefox | ||||
| Database type & version | Mysql | ||||
| Server OS (if known) | mac os x | ||||
| Webserver software & version (if known) | apache | ||||
| PHP Version | 5.3 | ||||
| Git branch / Pull Request URL | |||||
|
Hey Gurix, how about you join the LimeSurvey team and we give you direct subversion access? |
|
|
Fixed in rev 12352 |
|
|
Why not, there are a lot of issues. |
|
|
My username on sf is gliderenator |
|
|
2.00alpha 2 Build 120212 released |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-02-04 23:10 |
|
New Issue | |
| 2012-02-04 23:10 |
|
File Added: SurveyAction.php.diff | |
| 2012-02-05 11:23 | c_schmitz | Assigned To | => c_schmitz |
| 2012-02-05 11:23 | c_schmitz | Status | new => assigned |
| 2012-02-05 11:23 | c_schmitz | Note Added: 17229 | |
| 2012-02-05 11:23 | c_schmitz | Status | assigned => resolved |
| 2012-02-05 11:23 | c_schmitz | Fixed in Version | => 2.00a2 |
| 2012-02-05 11:23 | c_schmitz | Resolution | open => fixed |
| 2012-02-05 11:24 | c_schmitz | Note Added: 17230 | |
| 2012-02-05 12:05 |
|
Note Added: 17231 | |
| 2012-02-05 12:15 |
|
Note Added: 17232 | |
| 2012-03-11 16:32 | c_schmitz | Note Added: 17859 | |
| 2012-03-11 16:32 | c_schmitz | Status | resolved => closed |
| 2012-03-14 21:08 | c_schmitz | Changeset attached | => Import 2012-03-09 13:30:34 Yii 34ca6489 |