500 Internal Server Error - FECHAS EXTREMAS

[Amilcar Sasso]

Hola,

instale Atom Release 2.6.4, en UBUNTU 20.04.5 LTS + PHP 7.4, si bien el entorno se encuentra instaldo y funcionando al cargar un fondo o coleccion, cuando ingreso las fechas extremas  en rango 1999-2000me sale error de rango de fechas. si cargo una fecha especifica no da error.

 adjunto el log de error

2022/09/23 20:31:01 [error] 751#751: *19 FastCGI sent in stderr: "PHP message: Unable to execute INSERT statement. [wrapped: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '1999-0-0' for column 'start_date' at row 1]" while reading response header from upstream, client: 192.168.0.104, server: _, request: "POST /index.php/informationobject/add HTTP/1.1", upstream: "fastcgi://unix:/run/php7.4-fpm.atom.sock:", host: "192.168.0.106", referrer: "http://192.168.0.106/index.php/informationobject/add"

[Dan Gillean]

Hi there, 

Two suggestions: 

First, AtoM 2.6 is intended to be installed using Ubuntu 18.04 and PHP 7.2. There are a few known incompatibilities in PHP 7.4, which we have addressed in the upcoming 2.7 release. These fixes required code changes in AtoM to resolve - so as we finalize the 2.7 release, trying to use PHP 7.4 with AtoM 2.6.x may be causing issues for you. Consider downgrading to PHP 7.2. 

Second: 

In most cases, the issue you describe is caused by not setting the correct SQL modes during installation. See the MySQL section in the installation documentation - the only SQL modes we recommend setting in a /etc/mysql/conf.d/mysqld.cnf configuration file are as follows: 

[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
optimizer_switch='block_nested_loop=off'

If this step is skipped then the NO_ZERO_IN_DATES sql mode may be set by default, which can cause problems. You can check and change your SQL mode setting with the following instructions: 

• https://www.accesstomemory.org/docs/2.6/admin-manual/maintenance/common-atom-queries/#check-server-sql-modes
  

Hopefully, making those two changes will resolve the issue. If not, let us know!

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/bb20b848-40ed-4750-9855-34408aefbf64n%40googlegroups.com.