I'm upgrade 3.1.0 to 3.1.0-1 it ERROR

Software Support
1

I’m use php7+nginx
This ERROR →

PHP Warning: Declaration of OpenAIREDAO::setOAI(&$oai) should be compatible with PKPOAIDAO::setOAI($oai) in /web/thaijo2/plugins/generic/openAIRE/OpenAIREDAO.inc.php on line 19
PHP Warning: Declaration of SubmissionFileDAO::fromRow($row) should be compatible with PKPSubmissionFileDAO::fromRow($row, $fileImplementation) in /web/thaijo2/classes/article/SubmissionFi
leDAO.inc.php on line 23
[pre-install]
[load: upgrade.xml]
[version: 3.1.0.0]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
[schema: lib/pkp/xml/schema/metadata.xml]

[schema: lib/pkp/xml/schema/reviews.xml]
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
[schema: lib/pkp/xml/schema/reviewForms.xml]
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
[schema: lib/pkp/xml/schema/controlledVocab.xml]
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
PHP Notice: Only variables should be passed by reference in /web/thaijo2/lib/pkp/lib/adodb/adodb-xmlschema.inc.php on line 267
ERROR: Upgrade failed: DB: Duplicate entry ‘submissionKeyword-1048585-7941’ for key ‘controlled_vocab_symbolic’

How to clean it?

thankyou.
OhnO395

2

Hi @OhnO395,

It looks to me like you controlled_vocabs table contains some bad data – have you modified this table or its definition in the past? The table definition hasn’t changed appreciably since it was introduced in around OJS 2.3.2.

Regards,
Alec Smecher
Public Knowledge Project Team

3

I’m do not change any thing.
please descript “submissionKeyword-1048585-7941”.
It mean submissionKeyword=symbolic, 1048585 = ?, 7941=?

thank you.
OhnO395

4

Hi @OhnO395,

Try running this query in your OJS 3.1.0 database (before you try running the upgrade):

 SELECT symbolic, assoc_type, assoc_id FROM controlled_vocabs GROUP BY symbolic, assoc_type, assoc_id HAVING count(*) > 1;

And also:

SHOW INDEXES FROM controlled_vocabs;

Regards,
Alec Smecher
Public Knowledge Project Team