Unserialize Errors

We continue to get unserialize errors in the logs. Other comments suggest that a database table may have data in the wrong data format. Questions please:

OJS V3.3.0.13

  1. How do you tell which table is the problem?
  2. How do you convert that table to update old data along with new data?
    Thanks in advance for any help!

A small sampling of the php error log is below.

[Mon Feb 19 13:29:34.750784 2024] [proxy_fcgi:error] [pid 13658:tid 140114346219264] [remote 207.46.13.54:26175] AH01071: Got error ‘PHP message: PHP Notice: unserialize(): Error at offset 87 of 95 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 60 of 98 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 87 of 95 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 60 of 98 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254’
[Mon Feb 19 13:30:05.984274 2024] [proxy_fcgi:error] [pid 13658:tid 140114287470336] [remote 151.141.112.185:57310] AH01071: Got error ‘PHP message: PHP Notice: unserialize(): Error at offset 152 of 250 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 152 of 250 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254’, referer: https://pubmed.ncbi.nlm.nih.gov/
[Mon Feb 19 13:31:06.890394 2024] [proxy_fcgi:error] [pid 13920:tid 140114581214976] [remote 51.222.253.18:30958] AH01071: Got error ‘PHP message: PHP Notice: unserialize(): Error at offset 90 of 96 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 90 of 96 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254’
[Mon Feb 19 13:31:42.073808 2024] [proxy_fcgi:error] [pid 13920:tid 140114572822272] [remote 207.46.13.54:26098] AH01071: Got error ‘PHP message: PHP Notice: unserialize(): Error at offset 146 of 298 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254PHP message: PHP Notice: unserialize(): Error at offset 146 of 298 bytes in /home/radjr1/domains/wmpllc.org/public_html/ojs/lib/pkp/classes/db/DAO.inc.php on line 254’

Hi @radjr,

I’ve added some general guidance on dealing with unserialize errors on your other thread.

Regards,
Alec Smecher
Public Knowledge Project Team

This topic was automatically closed after 13 days. New replies are no longer allowed.