Greetings,
I recently updated to OJS version 3.2.2.0, an installation with MySQL setup. I tried to configure an article, and found an error when adding a file to a submission galley.
My PHP logs show
PHP Fatal error: Uncaught Exception: DB Error: Duplicate entry ‘59423-1187’ for key ‘submission_search_object_keywords_pkey’ Query: INSERT INTO submission_search_object_keywords (object_id, keyword_id, pos) VALUES (?, ?, ?)
Summary
in C:\xampp\htdocs\ojs-3.2.0-2\lib\pkp\classes\db\DAO.inc.php:703\nStack trace:\n#0 C:\xampp\htdocs\ojs-3.2.0-2\lib\pkp\classes\db\DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), ‘INSERT INTO sub…’)\n#1 C:\xampp\htdocs\ojs-3.2.0-2\lib\pkp\classes\search\SubmissionSearchDAO.inc.php(125): DAO->update(‘INSERT INTO sub…’, Array)\n#2 C:\xampp\htdocs\ojs-3.2.0-2\classes\search\ArticleSearchIndex.inc.php(309): SubmissionSearchDAO->insertObjectKeyword(‘59423’, ‘belonging’, 1187)\n#3 C:\xampp\htdocs\ojs-3.2.0-2\classes\search\ArticleSearchIndex.inc.php(113): ArticleSearchIndex->_indexObjectKeywords(‘59423’, ’ Uni…', 1187)\n#4 C:\xampp\htdocs\ojs-3.2.0-2\classes\search\ArticleSearchIndex.inc.php(156): ArticleSearchIndex->submissionFileChanged(9461, 128, 29368)\n#5 C:\xampp\htdocs\ojs-3.2.0-2\lib\p in C:\xampp\htdocs\ojs-3.2.0-2\lib\pkp\classes\db\DAO.inc.php on line 703, referer:http://localhost/ojs-3.2.0-2/index.php/pruebas/workflow/index/9461/1