View Issue Details

IDProjectCategoryView StatusLast Update
15792Bug reportsInstallationpublic2020-02-05 08:54
Reportertbart Assigned Tocdorin  
PrioritynoneSeveritypartial_block 
Status assignedResolutionopen 
Product Version4.0.1 
Summary15792: Database upgrade errors DB version 359>425 (Incorrect string value, data too long for column)
Description

When executing the DB update, I get several errors.
The first one:
CDbCommand konnte das SQL-Statement nicht ausf├╝hren: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE2\x80\x8BWel...'
can be fixed by
update questions set question=replace(question,unhex('E2808B'),'');

These characters seem to stem from copying texts from word.

The next error,
Data too long for column 'code' at row
is not so easy to fix.

It seems we have longer "code"s than expected?
mysql> select code, length(code) as codelen from answers order by codelen desc limit 10;
+------+---------+
| code | codelen |
+------+---------+
| A1.2 | 4 |
| A1.1 | 4 |
| A1.3 | 4 |
| A1.4 | 4 |
| A1.5 | 4 |
| A1.6 | 4 |
| A19 | 3 |
| A14 | 3 |
| A18 | 3 |
| A17 | 3 |
+------+---------+
10 rows in set (0.01 sec)

The updater should fix both errors.
Or alternatively, how can I fix the DB in the meantime?

Steps To Reproduce

Update from 3.16.1 to 4.0.1 having mentioned code specifications and unicode characters in strings.

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.0.1
I will donate to the project if issue is resolvedNo
Browser
Database & DB-Versionmysql Ver 14.14 Distrib 5.7.29
Server OS (if known)Ubuntu 18.04.3 LTS
Webserver software & version (if known)
PHP VersionPHP 7.2.24

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-01-28 17:11 tbart New Issue
2020-02-05 08:54 cdorin Assigned To => cdorin
2020-02-05 08:54 cdorin Status new => assigned