View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 15678 | Bug reports | Other | public | 2019-12-19 12:43 | 2020-02-22 20:54 |
| Reporter | feridbedru | Assigned To | cdorin | ||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.20.x | ||||
| Summary | 15678: Unable to create survey | ||||
| Description | While trying to create a survey, SQL error occurs and can not proceed any further. | ||||
| Steps To Reproduce |
| ||||
| Additional Information | 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 'groups as question_groups WHERE questions.gid=question_groups.gid AND questions' at line 1. The SQL statement executed was: SELECT * FROM questions as questions, groups as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=497122 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order in /var/www/survey/framework/db/CDbCommand.php(543) Stack Trace 1570 if ($questionid !== false) { #2 3631 if(empty($this->surveyOptions)) { #3 4927 $LEM->em->StartProcessingGroup( #4 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 3.20.2 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MySQL 8 | ||||
| Server OS (if known) | Ubuntu 18.04.3 | ||||
| Webserver software & version (if known) | apache 2.4.25 | ||||
| PHP Version | PHP 7.2 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-19 12:43 | feridbedru | New Issue | |
| 2020-01-15 17:47 | cdorin | Note Added: 55306 | |
| 2020-01-15 17:47 | cdorin | Assigned To | => cdorin |
| 2020-01-15 17:47 | cdorin | Status | new => feedback |
| 2020-02-22 20:54 | cdorin | Status | feedback => closed |
| 2020-02-22 20:54 | cdorin | Resolution | open => no change required |
| 2020-02-22 20:54 | cdorin | Note Added: 56155 |