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 | ||||
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 |
|
LimeSurvey: Yii 34ca6489 2012-02-05 02:23:15 Details Diff |
Fixed issue 05757: Table name typo - patch by gurix git-svn-id: file:///Users/Shitiz/Downloads/lssvn/source/limesurvey_yii@12352 b72ed6b6-b9f8-46b5-92b4-906544132732 |
Affected Issues 05757 |
|
mod - application/controllers/SurveyAction.php | Diff File |
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 |