argument 'date' du pipeline optimiser_base_disparus
Hop,
dans mes logs j'ai ceci
2021-01-18 18:22:16 127.0.0.1 (pid 13677) :Pri:ERREUR: Erreur 1525 de mysql: Incorrect TIMESTAMP value: ''2021-01-17 18:22:16'' in /home/mrouquet/Sites/dev/localhost/plugins-dist/forum/forum_pipelines.php L308 [sql_delete(),forum_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()] DELETE FROM `spip_localhost`.spip_forum WHERE statut='redac' AND maj < '\'2021-01-17 18:22:16\'' 2021-01-18 18:22:16 127.0.0.1 (pid 13677) :Pri:ERREUR: Erreur 1525 de mysql: Incorrect TIMESTAMP value: ''2021-01-17 18:22:16'' in /home/mrouquet/Sites/dev/localhost/plugins-dist/mots/mots_pipelines.php L97 [sql_delete(),mots_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()] DELETE FROM `spip_localhost`.spip_mots WHERE length(titre)=0 AND maj < '\'2021-01-17 18:22:16\'' 2021-01-18 18:22:16 127.0.0.1 (pid 13677) :Pri:ERREUR: Erreur 1525 de mysql: Incorrect TIMESTAMP value: ''2021-01-17 18:22:16'' in /home/mrouquet/Sites/dev/localhost/plugins-dist/petitions/petitions_pipelines.php L58 [sql_delete(),petitions_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()] DELETE FROM `spip_localhost`.spip_petitions WHERE statut='poubelle' AND maj < '\'2021-01-17 18:22:16\'' 2021-01-18 18:22:16 127.0.0.1 (pid 13677) :Pri:ERREUR: Erreur 1525 de mysql: Incorrect TIMESTAMP value: ''2021-01-17 18:22:16'' in /home/mrouquet/Sites/dev/localhost/plugins-dist/sites/sites_pipelines.php L228 [sql_delete(),sites_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()] DELETE FROM `spip_localhost`.spip_syndic WHERE maj<'\'2021-01-17 18:22:16\'' AND statut='refuse' 2021-01-18 18:22:16 127.0.0.1 (pid 13677) :Pri:ERREUR: Erreur 1525 de mysql: Incorrect TIMESTAMP value: ''2021-01-17 18:22:16'' in /home/mrouquet/Sites/dev/localhost/plugins-dist/breves/breves_pipelines.php L298 [sql_select(),breves_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),action_forcer_job_dist(),traiter_appels_actions()] SELECT B.id_breve AS id FROM `spip_localhost`.spip_breves AS B LEFT JOIN `spip_localhost`.spip_rubriques AS R ON B.id_rubrique=R.id_rubrique WHERE R.id_rubrique IS NULL AND B.maj < '\'2021-01-17 18:22:16\''
Cela vient du fait que $flux['args']['date'] du pipeline optimiser_base_disparus est valeur qui est déjà passé par sql_quote(). (cf. fonction optimiser_base_disparus
du code, qui contient la ligne ($mydate = sql_quote(date("Y-m-d H:i:s", time() - $attente));
)
Or la plupart des plugin(-dist) qui utilise ce paramètre $flux['args']['date'] pour construire leur requete passe en sql_quote. Du couip double sql_quote.
La question que je me pose : faut-il corriger les plugins(-dist) ou le core ?