DB Error upgrade from OJS 3.0.2 to OJS 3.1.0.1

I am trying to upgrade from OJS 3.0.2 to OJS 3.1.0.1. Upgrade completed successfully but it is not working properly. This is one of the errors I can see. I have seen some solutions on forum but they dont seem to work.

`Notice: unserialize(): Error at offset 895 of 1759 bytes in C:\xampp\htdocs\tjapril1\lib\pkp\classes\db\DAO.inc.php on line 352`

My current OJS 3.0.2 was upgraded from OJS 2.4.8… and error is present in current version as well but most functions work so we never noticed this.

What can I do, I cannot go back to OJS 2.4.8 as it was upgraded 6 months ago.

Hi @Taz,

See e.g. BUG after upgrade 3.0.2 to 3.1.0.1 (menu bar is missing) - #5 by rafaelmansilha for a description of the cause of the unserialize notices.

Regards,
Alec Smecher
Public Knowledge Project Team

Fixed by changing coalition to latin1_swedish_ci. As this is what we have been using since start for some unknown reason.