Previous: PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]

Software Support
1

Hi,

OJS: 3.3.0-15

Facing the same issue here: PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry


[28-Aug-2023 19:44:37 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'sessions.sessions_pkey' in /ojs-uoh/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Stack trace:
#0 /ojs-uoh/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute(NULL)
#1 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('INSERT INTO ses...', Array)
#3 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /ojs-uoh/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic('affectingStatem...', Array)
#7 /ojs-uoh/lib/pkp/classes/session/SessionDAO.inc.php(59): DAO->update('INSERT INTO ses...', Array)
#8 /ojs-uoh/lib/pkp/classes/session/SessionManager.inc.php(91): SessionDAO->insertObject(Object(Session))
#9 /ojs-uoh/lib/pkp/classes/session/SessionManager.inc.php(131): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /ojs-uoh/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /ojs-uoh/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /ojs-uoh/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /ojs-uoh/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /ojs-uoh/index.php(68): PKPApplication->execute()
#15 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'sessions.sessions_pkey' in /ojs-uoh/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /ojs-uoh/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(121): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('INSERT INTO ses...', Array)
#3 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('INSERT INTO ses...', Array, Object(Closure))
#4 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('INSERT INTO ses...', Array, Object(Closure))
#5 /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement('INSERT INTO ses...', Array)
#6 /ojs-uoh/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic('affectingStatem...', Array)
#7 /ojs-uoh/lib/pkp/classes/session/SessionDAO.inc.php(59): DAO->update('INSERT INTO ses...', Array)
#8 /ojs-uoh/lib/pkp/classes/session/SessionManager.inc.php(91): SessionDAO->insertObject(Object(Session))
#9 /ojs-uoh/lib/pkp/classes/session/SessionManager.inc.php(131): SessionManager->__construct(Object(SessionDAO), Object(Request))
#10 /ojs-uoh/lib/pkp/classes/i18n/PKPLocale.inc.php(131): SessionManager::getManager()
#11 /ojs-uoh/lib/pkp/classes/i18n/PKPLocale.inc.php(290): PKPLocale::getLocale()
#12 /ojs-uoh/lib/pkp/classes/core/Dispatcher.inc.php(116): PKPLocale::initialize(Object(Request))
#13 /ojs-uoh/lib/pkp/classes/core/PKPApplication.inc.php(362): Dispatcher->dispatch(Object(Request))
#14 /ojs-uoh/index.php(68): PKPApplication->execute()
#15 {main}

Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'sessions.sessions_pkey' (SQL: INSERT INTO sessions
				(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
				VALUES
				(, 52.167.144.138, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/103.0.5060.134 Safari/537.36, 1693251877, 1693251877, 0, , )) in /ojs-uoh/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
2

Thank you for the reminder, and my apologies for reposting the same problem. I appreciate your help in pointing me back to the solution provided in the earlier post.