View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05438 | Bug reports | Survey editing | public | 2011-08-31 16:46 | 2011-10-20 15:35 |
| Reporter | TMSWhite | Assigned To | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00a1 | ||||
| Summary | 05438: can't modify questions or help if they contain single quotes | ||||
| Description | And sometimes embedded double quotes also cause problems. Those fields don't have their quotes escaped prior to creation of the database insert string | ||||
| Additional Information | Here is a sample error: A Database Error Occurred Error Number: 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 't this fail?', gid='2', other='N', mandatory='N'WHERE sid='18577' AND qid='44' A' at line 1 UPDATE lime_questions SET type='Y', title='showAny', question='Do you want to display any of the questions on the next page? Will this "work?"', preg='', help='Won't this fail?', gid='2', other='N', mandatory='N'WHERE sid='18577' AND qid='44' AND language='en' Filename: C:\xampp\htdocs\limesurvey_ci\system\database\DB_driver.php Line Number: 330 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 10906 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | Mysql 5.3 | ||||
| Server OS (if known) | Windows XP | ||||
| Webserver software & version (if known) | Apache 2 | ||||
| PHP Version | 5.2 | ||||
| Git branch / Pull Request URL | |||||
|
TMSWhite: Can you check again? |
|
|
I can now add the following string to everything except for questions: Can't I add "double quotes"? However, when I try to make any change to a Question (even just adding a space), I get this error message: ( ! ) Fatal error: Call to undefined method CI_DB_mysqli_result::Recordcount() in C:\xampp\htdocs\limesurvey_ci\application\controllers\admin\database.php on line 591 Call Stack Time Memory Function Location1 0.0008 362664 {main}( ) ..\index.php:0 |
|
|
OK, it's working as of revision 10991 |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-08-31 16:46 | TMSWhite | New Issue | |
| 2011-09-01 18:46 | c_schmitz | Assigned To | => magiclko |
| 2011-09-01 18:46 | c_schmitz | Status | new => assigned |
| 2011-09-01 19:20 |
|
Note Added: 16189 | |
| 2011-09-07 11:11 |
|
Status | assigned => feedback |
| 2011-09-07 21:43 | TMSWhite | Note Added: 16247 | |
| 2011-09-07 21:43 | TMSWhite | Status | feedback => assigned |
| 2011-09-15 16:02 | TMSWhite | Note Added: 16280 | |
| 2011-10-20 15:35 |
|
Status | assigned => closed |
| 2011-10-20 15:35 |
|
Resolution | open => fixed |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |