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 | ||||
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 |