Errors trying to update from 2.4.0 to 3.1.1.4 date_time value


#1

Hi,
I am trying to update my ojs from 2.4.0 to latest version.
My system is:
Apache/2.4.33 (Ubuntu)
Versión del cliente de base de datos: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
extensión PHP: mysqliDocumentación mbstringDocumentación
Versión de PHP: 5.6.39-1+ubuntu18.04.1+deb.sury.org+1

I’ve followed instructions of upgrade.doc
I have tried to uodate database from command line. and that is what I get:
php tools/upgrade.php upgrade
PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/lib/php/20131226/stomp.so’ - /usr/lib/php/20131226/stomp.so: cannot open shared object file: No such file or directory in Unknown on line 0
[pre-install]
[load: upgrade.xml]
[version: 3.1.1.4]

[code: Installer Installer::checkPhpVersion]

[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml]

[code: Installer Installer::removeReviewEntries]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
ERROR: Upgrade failed: DB: Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date_submitted’ at row 14

I’d apreciate any help
Thanks
I


#2

I have edited my database with phpmyadmin changing incorrect data values.
I have repeated the process and now I get this error:
Upgrade failed: DB: Duplicate entry ‘latin’ for key ‘submission_search_keyword_text’
How can I locate and change duplicates in my DB?
Thanks agnew


#3

Hi,
I’m going on trying to update. The errors are similar. I think the supposed duplicates are words like ‘uinión’ and ‘union’, which are not real duplicates, since the first has accent on the o.
For some reason update produces errors and in my Db there are more than 10.000 entries. So What can I do?
Thanks