HTTP ERROR 500 / Duplicate entry for key 'sessions_pkey'

Software Support
10

@cendocu sorry my last comment did not contain full possible solution so I have deleted it .

I have a theory about where it went wrong and what can fix it (unable to test it as unable to produce the problem itself in my 3.4 installation) , So need 2 file edit to test the theory as

  1. comment the line at pkp-lib/classes/session/SessionDAO.php at stable-3_4_0 · pkp/pkp-lib · GitHub. That is at the INSTALLATION_PATH/lib/pkp/classes/session/SessionDAO.php , has method insertObject which as a line as $this->updateObject($session); . comment it out as // $this->updateObject($session);
  2. At the pkp-lib/classes/session/SessionManager.php at stable-3_4_0 · pkp/pkp-lib · GitHub, e..g for method createSession(at the path INSTALLATION_PATH/lib/pkp/classes/session/SessionManager.php), modify it as follow
private function createSession(): void                                                                                                                          
{                                                                                                                                                               
    $existingSession = $this->sessionDao->getSession(session_id());
    if ($existingSession) {                                                                                                                                     
        $this->userSession = $existingSession;        
        return;                                                                                                                                                 
    }
                                                                                                                                                                
    $now = time();                                    

    $this->userSession = $this->sessionDao->newDataObject();                                                                                                    
    $this->userSession->setId(session_id());
    $this->userSession->setIpAddress($this->request->getRemoteAddr());                                                                                          
    $this->userSession->setUserAgent($this->request->getUserAgent());                                                                                           
    $this->userSession->setSecondsCreated($now);
    $this->userSession->setSecondsLastUsed($now);                                                                                                               
    $this->userSession->setDomain(ini_get('session.cookie_domain'));
    $this->userSession->setSessionData('');                                                                                                                     
                                                      
    $this->sessionDao->insertObject($this->userSession);                                                                                                        
}

see if this works .

Regrads
PKP Dev Team