I have recently upgraded OJS to 3.1.1, I did not realize our server was running php 5.5 instead of 5.6, I changed the php version to 5.6 and now have this error DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’ and the sessions log has over 37000 entries, I turned off the session check ip in the config.inc.php file however this did not help.
Hi @stinkjyo,
You should be able to delete all entries from the sessions table and all that will happen is that current users may need to log in again.
When you upgraded OJS, did you get a confirmation that the upgrade completed successfully?
Is anything relevant in your PHP error log?
Regards,
Alec Smecher
Public Knowledge Project Team
I did get a confirmation that OJS upgraded successfully, However some plugins where not working such as citation and the download graphing plugin. we upgraded the php version yesterday and now when i try to go to ojs on our website all it says is DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
the only thing the error log has in it is this: No response from subprocess ( (cpanel)): The subprocess reported error number 72057594037927935 when it ended. The process dumped a core file.
here is our part of our php error log[27-Mar-2018 19:18:46 America/Los_Angeles] PHP Warning: Illegal string offset ‘altText’ in /home/cluteins/public_html/ojs/cache/t_compile/c9d7d1e35ba0bd2f5750aac2209770bf43f51bc1^%%B9^B93^B932F2BF%%header.tpl.php on line 206
[27-Mar-2018 19:18:46 America/Los_Angeles] PHP Warning: Illegal string offset ‘altText’ in /home/cluteins/public_html/ojs/cache/t_compile/14d8e8a3a9e84d3b58ddc3d7fb2a72dc367d446d^%%0D^0DF^0DF1E0F5%%footer-journal.tpl.php on line 81
[27-Mar-2018 19:18:46 America/Los_Angeles] PHP Warning: Smarty error: unable to read resource: “frontend/components/footer-admin.tpl” in /home/cluteins/public_html/ojs/lib/pkp/lib/vendor/smarty/smarty/libs/Smarty.class.php on line 1094
[27-Mar-2018 19:18:48 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:48 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:18:52 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:18:53 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:53 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:55 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:18:55 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:56 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:57 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:18:58 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:18:58 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:00 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:00 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:01 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:01 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:03 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:06 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:07 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:08 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:09 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:10 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:13 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:16 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:16 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:17 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:18 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:18 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:19 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:22 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:25 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:25 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:28 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:28 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:28 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:29 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:31 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:36 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:36 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:37 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:37 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:37 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:38 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:40 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:43 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:43 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:46 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:49 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:52 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:54 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:54 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:54 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:54 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:19:57 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:19:58 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:01 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:03 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:04 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:05 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:05 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:07 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:07 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:09 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:10 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:10 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:11 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:13 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:16 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:19 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:22 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:24 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:27 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:27 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:29 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:30 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:30 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:30 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:31 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:34 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:34 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:38 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:38 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:40 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:40 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:42 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:43 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:45 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:46 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:46 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:48 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:48 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:49 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:51 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:51 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:51 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:20:52 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:55 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:20:58 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:21:01 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:21:01 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:21:04 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:21:04 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:21:07 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
[27-Mar-2018 19:21:07 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:21:07 America/Los_Angeles] ojs2: DB Error: Duplicate entry ‘NULL’ for key ‘sessions_user_id’
[27-Mar-2018 19:21:10 America/Los_Angeles] ojs2: DB Error: Can’t find record in ‘sessions’
Hi @stinkjyo,
What database server and version are you using?
Regards,
Alec Smecher
Public Knowledge Project Team
I am now using Database Server 5.6.38 and php 5.6.31
Hi @stinkjyo,
What database server is it? MariaDB/MySQL, or PostgreSQL?
Regards,
Alec Smecher
Public Knowledge Project Team
The database I am using is MySql
Hi @stinkjyo,
This looks like a MySQL issue – your sessions table probably needs repair. See e.g. this StackExchange thread.
Regards,
Alec Smecher
Public Knowledge Project Team