Erreur 1064 de mysql
Dans le log tmp/log/mysql.log
:
2024-10-01 05:59:03 172.18.0.7 (pid 28996) :Pri:ERREUR: Erreur 1064 de mysql: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '05:59:03
ORDER BY maj
LIMIT 0,11' at line 4
in /var/www/html/plugins/plugins/linkcheck/genie/linkcheck_tester_base.php L51 [sql_allfetsel(),genie_linkcheck_tester_base_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()]
SELECT *
FROM `db`.spip_linkchecks
WHERE etat='mort'
AND maj < 2024-09-01 05:59:03
ORDER BY maj
LIMIT 0,11
Le code en question : https://git.spip.net/spip-contrib-extensions/linkcheck/-/blob/master/genie/linkcheck_tester_base.php#L46 ; que l'on peut corriger ainsi :
- $where[] = "maj < " . date('Y-m-d H:i:s', time() - $config['periode']);
+ $where[] = "maj < '" . date('Y-m-d H:i:s', time() - $config['periode']) . "'";
MR à suivre.