Dear @asmecher,
I have been able to fix our database problem while updating. When using the database recovery function in our web server configuration tool, the old database does not seem to be deleted properly, hence the error. So I manually deleted the old database before the backup, then uploaded the backup and assigned the user and rights. Then the update process ran for a few minutes. Unfortunately it did not work in the end. The error message that appears in the menu is
Duplicate entry '0-en_DE-subject' for key 'email_settings_pkey'
In our error message we have a few fatal errors. I post the entire error_log here, hoping that someone can help us. Thank you very much in advance!
[12-May-2020 04:49:01 UTC] PHP Fatal error: Uncaught Exception: DB Error: Access denied for user 'ojs'@'localhost' (using password: YES) Query: SELECT * FROM journals WHERE path = ? in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM j...')
#1 /home/suburban/public_html/sys/lib/pkp/classes/context/ContextDAO.inc.php(64): DAO->retrieve('SELECT * FROM j...', 'suburban')
#2 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath('suburban')
#3 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)
#4 /home/suburban/public_html/sys/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter('getContext', 1)
#5 /home/suburban/public_html/sys/lib/pkp/classes/template/PKPTemplateManager.inc.php(106): Request->getContext()
#6 /home/suburban/public_html/sys/classes/template/TemplateManager.inc.php(28) in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 04:49:23 UTC] PHP Fatal error: Uncaught Exception: DB Error: Access denied for user 'ojs'@'localhost' (using password: YES) Query: SELECT * FROM journals WHERE path = ? in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM j...')
#1 /home/suburban/public_html/sys/lib/pkp/classes/context/ContextDAO.inc.php(64): DAO->retrieve('SELECT * FROM j...', 'suburban')
#2 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath('suburban')
#3 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)
#4 /home/suburban/public_html/sys/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter('getContext', 1)
#5 /home/suburban/public_html/sys/lib/pkp/classes/template/PKPTemplateManager.inc.php(106): Request->getContext()
#6 /home/suburban/public_html/sys/classes/template/TemplateManager.inc.php(28) in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 04:49:45 UTC] PHP Fatal error: Uncaught Exception: DB Error: Access denied for user 'ojs'@'localhost' (using password: YES) Query: SELECT * FROM journals WHERE path = ? in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM j...')
#1 /home/suburban/public_html/sys/lib/pkp/classes/context/ContextDAO.inc.php(64): DAO->retrieve('SELECT * FROM j...', 'suburban')
#2 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath('suburban')
#3 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)
#4 /home/suburban/public_html/sys/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter('getContext', 1)
#5 /home/suburban/public_html/sys/lib/pkp/classes/template/PKPTemplateManager.inc.php(106): Request->getContext()
#6 /home/suburban/public_html/sys/classes/template/TemplateManager.inc.php(28) in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 04:51:00 UTC] PHP Fatal error: Uncaught Exception: DB Error: Access denied for user 'ojs'@'localhost' (using password: YES) Query: SELECT * FROM journals WHERE path = ? in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM j...')
#1 /home/suburban/public_html/sys/lib/pkp/classes/context/ContextDAO.inc.php(64): DAO->retrieve('SELECT * FROM j...', 'suburban')
#2 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath('suburban')
#3 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)
#4 /home/suburban/public_html/sys/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter('getContext', 1)
#5 /home/suburban/public_html/sys/lib/pkp/classes/template/PKPTemplateManager.inc.php(106): Request->getContext()
#6 /home/suburban/public_html/sys/classes/template/TemplateManager.inc.php(28) in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 04:51:13 UTC] PHP Fatal error: Uncaught Exception: DB Error: Access denied for user 'ojs'@'localhost' (using password: YES) Query: SELECT * FROM journals WHERE path = ? in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT * FROM j...')
#1 /home/suburban/public_html/sys/lib/pkp/classes/context/ContextDAO.inc.php(64): DAO->retrieve('SELECT * FROM j...', 'suburban')
#2 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRouter.inc.php(252): ContextDAO->getByPath('suburban')
#3 /home/suburban/public_html/sys/lib/pkp/classes/core/PKPRequest.inc.php(760): PKPRouter->getContext(Object(Request), 1)
#4 /home/suburban/public_html/sys/classes/core/Request.inc.php(64): PKPRequest->_delegateToRouter('getContext', 1)
#5 /home/suburban/public_html/sys/lib/pkp/classes/template/PKPTemplateManager.inc.php(106): Request->getContext()
#6 /home/suburban/public_html/sys/classes/template/TemplateManager.inc.php(28) in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 06:52:05 Europe/Berlin] PHP Fatal error: Uncaught Exception: DB Error: Table 'suburban_5.publications' doesn't exist Query: SELECT
o.submission_id,
MAX(s.context_id) AS journal_id,
MAX(i.date_published) AS i_pub,
MAX(p.date_published) AS s_pub,
COUNT(*) AS count
FROM
submissions s
JOIN publications p ON (p.publication_id = s.current_publication_id)
JOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId')
JOIN issues i ON (CAST(i.issue_id AS CHAR) = ps.setting_value)
JOIN submission_search_objects o ON (s.submission_id = o.submission_id)
NATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0
WHERE
s.status = 3 AND
i.published = 1 AND k0.keyword_text = ? AND (o.type & ?) != 0 AND i.journal_id = ?
GROUP BY o.submission_id
ORDER BY count DESC
LIMIT 500 in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php(135): in /home/suburban/public_html/sys/lib/pkp/classes/db/DAO.inc.php on line 703
[12-May-2020 06:52:15 Europe/Berlin] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'suburban_5.publications' doesn't exist in /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php:326
Stack trace:
#0 /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php(326): PDO->prepare('select * from `...')
#1 /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#2 /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#3 /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php(333): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#4 /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Query/Builder.php(2130): Illuminate\Database\C in /home/suburban/public_html/sys/lib/pkp/lib/vendor/illuminate/database/Connection.php on line 664
[12-May-2020 06:55:10 Europe/Berlin] WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
[12-May-2020 06:55:10 Europe/Berlin] WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
[12-May-2020 06:55:10 Europe/Berlin] WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
[12-May-2020 06:55:10 Europe/Berlin] WARNING: The StaticPage "Verein" uses a path (verein) that conflicts with an existing Custom Navigation Menu Item path. Skipping this StaticPage.
[12-May-2020 06:55:10 Europe/Berlin] Duplicate entry '0-de_DE-subject' for key 'email_settings_pkey'