Au cas où, je vous transmets le dernier message de mon hébergeur,
cela vous parlera sûrement plus qu'à moi...

"-----------
Je constate quelques erreurs dans les fichiers de logs de votre instance concernant votre galerie :

[19-Feb-2026 09:31:46 UTC] PHP Fatal error:  Uncaught mysqli_sql_exception: Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_creation' at row 219 in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
#1 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(654): pwg_query()
#2 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance_actions.php(151): do_maintenance_all_tables()
#3 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance.php(121): include('...')
#4 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin.php(407): include('...')
#5 {main}
  thrown in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php on line 132

[19-Feb-2026 09:13:22] WARNING: [pool www] child 25688, script '/srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/picture.php' (request: "GET /URB_Photos/picture.php?/30550/search/psk-20250318-L18PZtbuys&slideshow=") execution timed out (205.039852 sec), terminating

---------"

merci

Dernière modification par URB Benoit (2026-02-23 17:00:08)

Environnement

Piwigo 16.2.0 Dernière version ?
Installé le 20 mars 2017, il y a 8 ans 11 mois 3 jours
Système d'exploitation: Linux (container)
PHP: 8.2.29 (Montrer les informations) [2026-02-23 17:16:42]
MySQL: 5.7.23-23-log [2026-02-23 17:16:42]
Bibliothèque graphique: External ImageMagick 6.9.11-60
Taille du cache 858.18 Mo   calculé il y a 2 jours Rafraîchir

Liste des plugins activés 7

Admin Tools
Batch Downloader
Download by Size
Language Switch
LocalFiles Editor
Perso Footer
Take A Tour of Your Piwigo


suspense ...

sur réparer et optimiser la base de données
j'ai une erreur

Fatal error: Uncaught mysqli_sql_exception: Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_creation' at row 219 in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(654): pwg_query() #2 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance_actions.php(151): do_maintenance_all_tables() #3 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance.php(121): include('...') #4 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin.php(407): include('...') #5 {main} thrown in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php on line 132

le reste est ok

ok,
j'imagine qu'une réinstallation ne suffira pas.
J'attends donc l'avis de l'expert.

En tout cas merci pour votre patience !

Bonjour

est-ce que les images sont organisées par ordre de date chronologique ?

A très vite

J'ai toujours mon problème de BDD en cliquant sur "sur réparer et optimiser la base de données"
Je suis allé dans PhpMySql pour réparer les tables,
sur certaines j'ai ce message "Note : Ce type de table ne supporte pas les repair"

Fatal error: Uncaught mysqli_sql_exception: Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_creation' at row 219 in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(654): pwg_query() #2 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance_actions.php(151): do_maintenance_all_tables() #3 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance.php(121): include('...') #4 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin.php(407): include('...') #5 {main} thrown in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php on line 132

si vous avez une idée...
merci d'avance !

Merci pour votre réponse,

J'ai regardé dans la table piwigo_image :
- je n'ai pas d'id 219, (cela passe de 218 à 220)
- j'ai relevé une douzaine de dates de création à 0000-00-00 00:00:00 dans la colonne date_creation
- je les ai modifié
- j'ai vidé les caches
- j'ai repassé "sur réparer et optimiser la base de données"

mais j'ai toujours :

Fatal error: Uncaught mysqli_sql_exception: Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_creation' at row 219 in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php(654): pwg_query() #2 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance_actions.php(151): do_maintenance_all_tables() #3 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin/maintenance.php(121): include('...') #4 /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/admin.php(407): include('...') #5 {main} thrown in /srv/data/web/vhosts/www.planete-urb.com/htdocs/URB_Photos/include/dblayer/functions_mysqli.inc.php on line 132

J'ai regardé dans les autres tables images, sans voir d'id à 219 !!!

Mise à jour faite,
caches vidés,
et toujours même erreur "sur réparer et optimiser la base de données"