A user has come to me with the following problem (error report) while attempting to upgrade OJS. Even though I asked, I was not informed what version it is. By the type of error you might know…
DAO.update(INSERT INTO notes (user_id, date_created, date_modified, title, contents, assoc_type, assoc_id) VALUES (?, '2016-02-..., Array)% line 212, file: /www/ojs/lib/pkp/classes/note/NoteDAO.inc.php
NoteDAO.insertObject(Object:Note)% line 1498, file: /www/ojs/classes/install/Upgrade.inc.php
Upgrade.convertQueries(Object:Upgrade, Array)% line 0, file:
<h1>DB Error: Data too long for column 'contents' at row 1</h1>ojs2: DB Error: Data too long for column 'contents' at row 1
I haven’t come across anything like this before.
Duplicate entries have been found and removed, I believe.
However, this kind of error makes me shiver and assume that exporting data may be a cleaner way to start fresh, even if some data loss may occur, which must be planned as we did.
Is there anything that can be done or starting fresh, exporting data and moving submissions manually seems the best solution at this point?