DB Error: Duplicate entry for key 'sessions_pkey'

Software Support
1

Hello everybody!
i hve next error due to acess to site: DB Error: Duplicate entry for key ‘sessions_pkey’

  1. i have tryied to clean @sessions@ in my DB - no result
  2. i have tryied to repair tables in my DB server - no result
  3. i have tryied to add to .htaccess rows from one of topics at this forum - no result
  4. i have triyed to clean @cache@ folder - no result

version of OJS - 3.1.1-2
version of PHP - PHP 5.6.36-1+0~20180715024311.1+jessie~1.gbpa3dade (cli)
verison of apache - Server version: Apache/2.4.10 (Debian)
version of mysql server - Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
acess to php.ini file - http://uars.info/php.php

How to fix this error?

2 
[Sat Jul 21 13:33:12.781175 2018] [:error] [pid 1323] [client 192.168.1.105:61697] ojs2: DB Error: Duplicate entry '3sbl6oofs121jg1phjslvc3tt0' for key 'sessions_pkey'
[Sat Jul 21 13:33:12.949519 2018] [:error] [pid 1326] [client 192.168.1.105:61707] PHP Warning:  ini_set(): A session is active. You cannot change the session module's ini settings at this time in /web/sites/uars/lib/pkp/classes/session/SessionManager.inc.php on line 35
[Sat Jul 21 13:33:12.950258 2018] [:error] [pid 1326] [client 192.168.1.105:61707] PHP Warning:  ini_set(): A session is active. You cannot change the session module's ini settings at this time in /web/sites/uars/lib/pkp/classes/session/SessionManager.inc.php on line 36
[Sat Jul 21 13:33:12.951063 2018] [:error] [pid 1326] [client 192.168.1.105:61707] PHP Notice:  A session had already been started - ignoring session_start() in /web/sites/uars/lib/pkp/classes/session/SessionManager.inc.php on line 58
3
  1. tryied to restore DB from backup - no result
  2. tryied to replase OJS files - no result
  3. tryied to fix CHMOD to files and directories, - no result
4

Hi @redukr

Have you looked/try if there is any answer in this forum that might be a solution for you?
Unfortunately, I cannot help much, maybe @asmecher (when he is back again) can…

Best,
Bozana

5

Hi @redukr,

as i have the same issue with my system, i can just refer you to this thread DB Error: Duplicate entry 'xxxxxx' for key 'sessions_pkey' - #47 by mlfct - some solutions (mostly related to php settings) were offered there. Maybe you’re lucky and one of these will work for you…