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
- How do you tell which table is the problem?
- 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’