Problème WHERE

tofulm <[email protected]>
Newsgroups gmane.comp.web.spip.devel
Message-ID <[email protected]>
Bonjour,

lors d'un ajout de document via l'api action/ajouter_documents, je tombe 
sur cette erreur mysql (dans les logs)

2021-04-13 06:02:01 127.0.0.1 (pid 509) 
ecrire/base/connect_sql.php:L170:spip_sql_erreur()::Pub: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 'sql_quote('article')) GROUP BY auteurs.id_auteur /* 
BOUCLEauteurs @ | /spip....' at line 8 in 
/home/http/www/spip33/sngpckda.spip/ecrire/public/composer.php L941 
[sql_select(),calculer_select(),objet_test_si_publie(),inc_determiner_statut_document(),document_instituer(),medias_post_edition(),minipipe(),execute_pipeline_post_edition(),pipeline(),action_ajouter_un_document_dist(),action_ajouter_documents_dist(),inc_bigform_traiter_dist(),formulaires_admin_adherent_traiter_dist(),traiter_formulaires_dynamiques(),include()]

SELECT L3.id_auteur AS id_auteur

FROM `spip33_sngpckda`.spip_auteurs AS `auteurs`

INNER JOIN `spip33_sngpckda`.spip_auteurs_liens AS L3 ON ( L3.id_auteur 
= auteurs.id_auteur )

INNER JOIN `spip33_sngpckda`.spip_articles AS L4 ON ( L4.id_article = 
L3.id_objet AND L3.objet='article')

WHERE (L4.statut = 'publie')

     AND NOT((auteurs.statut = '5poubelle'))

     AND auteurs.id_auteur=21

     AND ('L3.objet' '=' sql_quote('article'))

GROUP BY auteurs.id_auteur


Le problème se situe : ('L3.objet' '=' sql_quote('article'))


Est qu'une personne aurait une idée ?



-- 
tofulm
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.