View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
16251 | Bug reports | Installation | public | 2020-05-09 20:07 | 2020-06-22 23:00 |
Reporter | caitifty | Assigned To | cdorin | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | reopened | ||
Product Version | 4.2.2 | ||||
Fixed in Version | 4.3.1 | ||||
Summary | 16251: 4.2.2 stable release will not work with mysql 8.0.20, the default with Ubuntu 20.04 LTS | ||||
Description | The new (23 April 2020) 20.04 LTS release of ubuntu installs mysql 8.0.20 by default. As noted in previous issue 13010, 'group' is a reserved codeword in mysql 8.0+ leading to the following error on basic operations such as creating a new survey: 500: Internal Server Error | ||||
Steps To Reproduce | Install limesurvey 4.2.2 on a fresh install of ubuntu 20.04 LTS with mysql as the selected database. After logging in, create new survey, click save -> the error above will appear. | ||||
Additional Information | Cannot reproduce it (same system ; default ubuntu 20.04) -> could you please try once more the latest release? | ||||
Tags | No tags attached. | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | limesurvey4.2.2+200504 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | Firefox but identical error on vivaldi | ||||
Database type & version | mysql 8.0.20 | ||||
Server OS (if known) | ubuntu 20.04 | ||||
Webserver software & version (if known) | apache 2.4.41 | ||||
PHP Version | 7.4.3 | ||||
Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here. |
|
Here's the output from clicking 'create new survey', entering 'test' in the survey title, and clicking 'save'. Many thanks! -- CDbException 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 g JOIN questions q on q.gid=g.gid JOIN group_l10ns gls on gls.gid=g.gid ' at line 1. The SQL statement executed was: SELECT g., q., gls., qls., qa.attribute, qa.value FROM groups g JOIN questions q on q.gid=g.gid JOIN group_l10ns gls on gls.gid=g.gid JOIN question_l10ns qls on qls.qid=q.qid LEFT JOIN question_attributes qa ON qa.qid=q.qid AND qa.attribute='question_template' WHERE qls.language='en' and gls.language='en' AND g.sid=366299 AND q.parent_qid=0 ORDER BY group_order, question_order /var/www/test.overdoseresearch.org/limesurvey/framework/db/CDbCommand.php(543) 531 { Stack Trace 1388 if ($questionid !== false) { #2 3649 if(empty($this->surveyOptions)) { #3 4962 $LEM->em->StartProcessingGroup( #4 482 #5 104 elseif($param->isDefaultValueAvailable()) #7 81 $oMethod = new ReflectionMethod($this, $sDefault); #8 303 { #9 281 @see runAction #10 260 { #11 175 } #12 277 { #13 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) #14 180 public function run() #15 177 require_once APPPATH . 'core/LSYii_Application' . EXT; 2020-05-11 12:19:47 Apache/2.4.41 (Ubuntu) Yii Framework/1.1.22-dev |
|
I start to always use https://www.yiiframework.com/doc/api/1.1/CDbConnection#quoteColumnName-detail even when not really readed (submitddate, id, stardate , language …) Think it's a good idea ;) |
|
@DenisChenu The stacktrace mentions the event handler. |
|
Nah, never mind. |
|
I have a workaround for anyone else trying to get limesurvey working on a stock ubuntu 20.04: instead of installing the default mysql, install the default mariadb (10.3.22) instead. Same 'steps to reproduce' given above will no longer produce errors. |
|
weird, i couldn't reproduce it with the latest version (latest master). Anybody else can test on ubuntu 20.04? with default config? |
|
@cdorin : https://forums.limesurvey.org/forum/design-issues/121435-internal-server-error-when-i-try-to-create-a-new-survey#200567 Are you sure you setup mysql and not mariadb ? |
|
Ok, it should be solved in 4.3.1 (at least partially). The more issues reported (+ context how to reproduce them), the better. Therefore, I will close this one. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2020-05-09 20:07 | caitifty | New Issue | |
2020-05-11 09:36 | ollehar | Assigned To | => ollehar |
2020-05-11 09:36 | ollehar | Status | new => feedback |
2020-05-11 09:36 | ollehar | Note Added: 57650 | |
2020-05-11 21:23 | caitifty | Note Added: 57691 | |
2020-05-11 21:23 | caitifty | Status | feedback => assigned |
2020-05-12 07:59 | DenisChenu | Note Added: 57693 | |
2020-05-12 09:36 | ollehar | Note Added: 57695 | |
2020-05-12 09:47 | ollehar | Note Added: 57696 | |
2020-05-16 19:57 | caitifty | Note Added: 57852 | |
2020-05-17 15:32 | cdorin | Assigned To | ollehar => |
2020-05-17 15:32 | cdorin | Status | assigned => confirmed |
2020-05-17 15:32 | cdorin | Zoho Sprints | => |Yes| |
2020-05-17 15:33 |
|
Zoho Sprints ID | => 14469000000093001 |
2020-05-29 13:57 |
|
Zoho Sprints | Yes => |Yes| |
2020-05-29 13:57 |
|
Status | confirmed => resolved |
2020-05-29 15:30 | cdorin | Assigned To | => cdorin |
2020-05-29 15:30 | cdorin | Status | resolved => feedback |
2020-05-29 15:30 | cdorin | Resolution | open => reopened |
2020-05-29 15:30 | cdorin | Additional Information Updated | |
2020-05-29 15:30 | cdorin | Zoho Sprints | Yes => |Yes| |
2020-05-29 16:37 | cdorin | Note Added: 58100 | |
2020-06-04 10:35 | DenisChenu | Note Added: 58169 | |
2020-06-17 10:47 | c_schmitz | Assigned To | cdorin => c_schmitz |
2020-06-22 23:00 | cdorin | Assigned To | c_schmitz => cdorin |
2020-06-22 23:00 | cdorin | Status | feedback => closed |
2020-06-22 23:00 | cdorin | Fixed in Version | => 4.3.1 |
2020-06-22 23:00 | cdorin | Note Added: 58385 |