View Issue Details

IDProjectCategoryView StatusLast Update
14729Bug reports[All Projects] ComfortUpdatepublic2019-05-31 13:01
ReporterDenisChenuAssigned Todominikvitt 
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version4.0.0dev 
Target VersionFixed in Version4.0.0dev 
Summary14729: Unable to upgrade
Description

I just copy my master DB to develop DB (after doing a checkintgrity)
Go to survey list : receive CDBerror tokenencryptionoptions is readonly (debug=0), at this time : no upgrade is done

Going to admin : redirect to upgrade : receive CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6155--0-0' for key 'PRIMARY'. The SQL statement executed was: ALTER TABLElime_defaultvaluesADD PRIMARY KEY (qid,specialtype,scale_id,sqid)

reload (i like to reload ;)

CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_question_l10ns' already exists. The SQL statement executed was: CREATE TABLE `lime_question_l10ns` (
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`qid` int(11) NOT NULL,
`question` text NOT NULL,
`help` text,
`language` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 
Steps To Reproduce

Do you want my database dump ?

Additional Information

If i don't make error the html file is the second one.

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.0.0 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Versionphp7.2

Activities

DenisChenu

DenisChenu

2019-04-03 15:47

developer  

CDbException.html (23,514 bytes)
DenisChenu

DenisChenu

2019-04-03 15:50

developer   ~51315

We still have in model

    /** @inheritdoc */
    public function primaryKey()
    {
        return array('qid', 'specialtype', 'language', 'scale_id', 'sqid');
    }

Seems we don't have a DefaultValueL10n ?

dominikvitt

dominikvitt

2019-04-03 17:23

developer   ~51319

Yes, it looks that DefaultValueL10n was planned, but never finished.
So, I would start to implemented it now.

DenisChenu

DenisChenu

2019-04-03 18:12

developer   ~51322

OK, thank you

dominikvitt

dominikvitt

2019-04-18 10:53

developer   ~51511

@DenisChenu:
DefaultValueL10n model is implemented.
Does upgrade script works now?

DenisChenu

DenisChenu

2019-04-18 10:56

developer   ~51512

I need to check …
Tomorrow if OK, you can close this one if you already check a sample upgrade (with demo survey for example)

Issue History

Date Modified Username Field Change
2019-04-03 15:47 DenisChenu New Issue
2019-04-03 15:47 DenisChenu Status new => assigned
2019-04-03 15:47 DenisChenu Assigned To => dominikvitt
2019-04-03 15:47 DenisChenu File Added: CDbException.html
2019-04-03 15:50 DenisChenu Note Added: 51315
2019-04-03 17:23 dominikvitt Note Added: 51319
2019-04-03 18:12 DenisChenu Note Added: 51322
2019-04-18 10:53 dominikvitt Note Added: 51511
2019-04-18 10:56 DenisChenu Note Added: 51512
2019-05-31 13:01 dominikvitt Status assigned => closed
2019-05-31 13:01 dominikvitt Resolution open => fixed
2019-05-31 13:01 dominikvitt Fixed in Version => 4.0.0dev