Discuter de SPIP

Erreur mysql Au secours !

Boby_K (Boby K) Juin 25, 2008, 7:02 1

Bonjour à tous,

Depuis hier, mon site ne s'affiche plus (ou que de temps en temps) et me renvoie le plus souvent une erreur 500.
Je suis en SPIP 1.9.2d
J'ai fait avant-hier lundi les modif suivantes
- ajout du plugin diapo
- ajout d'une balise diapo dans un article
- création d'un nouvel article expliquant cette nouveauté
- modification de article.html pour que les documents d'un article de type images ne soient plus affichés sous l'article comme les autres documents.
<BOUCLE_portfolio(DOCUMENTS){id_article}{extension==jpg|png|gif}{mode=document}{doublons}>
</BOUCLE_portfolio>
J'ai testé toutes ces modif lundi, tout marchait.
Depuis hier mardi, par contre : erreur 500 !

Dans le fichier mysql.log, j'ai des erreurs du type :
Jun 25 08:40:30 66.249.70.92 (pid 1234) GET /spip.php?article16&diapo16=4
Jun 25 08:40:30 66.249.70.92 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:40:30 66.249.70.92 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Ce matin, je suis de nouveau arrivé à accéder à "ecrire" et ai donc désactivé le plugin diapo.

Mon site a l'air (pour le moment) de remarcher mais j'ait toujours des erreurs dans ce fichier (copie ci-dessous ainsi que copie de spip.log)

Pouvez-vous m'aider ?

Merci

Boby

spip.log
--------------------------------------
Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?article14

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?article14

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.18s) [./biospip/article] date_redac=‹ 2008-06-25 08:58:54 ›, date=‹ 2008-06-25 08:58:54 ›, id_article=‹ 14 › (7751 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 1/spip%3Farticle14.3e23df97 pour 3600 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [plugins/article_pdf/modeles/article_pdf] id_article=‹ 14 ›, lang=‹ fr ›, recurs=‹ 1 ›, fond=‹ modeles/article_pdf ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (232 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.03s) [plugins/outils_article/inc-barre-outils] fond=‹ inc-barre-outils ›, id_article=‹ 14 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (1601 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.02s) [./biospip/inc_menu] fond=‹ inc_menu ›, id_rubrique=‹ 10 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (1668 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache d/-inc_menu-10-fr.b44ede58 pour 3600 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [./biospip/inc-triurlrubrique] fond=‹ inc-triurlrubrique ›, id_rubrique=‹ 4 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (69 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 9/-inc_triurlrubrique-4-fr.95fd7215 pour 120 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [./biospip/inc-triurlrubrique] fond=‹ inc-triurlrubrique ›, id_rubrique=‹ 2 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (39 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 7/-inc_triurlrubrique-2-fr.7747ca80 pour 120 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [./biospip/inc-triurlrubrique] fond=‹ inc-triurlrubrique ›, id_rubrique=‹ 7 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (117 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache c/-inc_triurlrubrique-7-fr.78b46494 pour 120 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [./biospip/inc-triurlrubrique] fond=‹ inc-triurlrubrique ›, id_rubrique=‹ 12 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (117 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 6/-inc-12-fr.d2fd26f9 pour 120 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [./biospip/inc-triurlrubrique] fond=‹ inc-triurlrubrique ›, id_rubrique=‹ 13 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (40 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 9/-inc-13-fr.ff198d5e pour 120 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.03s) [./biospip/inc_hierarchie] fond=‹ inc_hierarchie ›, id_rubrique=‹ 10 ›, id_article=‹ 14 ›, lang=‹ fr ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (587 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Creation du cache 8/-inc_hierarchie-10-14-fr.5487e1e8 pour 3600 secondes
Jun 25 08:58:54 82.229.204.186 (pid 1234) calcul (0.00s) [plugins/boutons_admin_supp/formulaires/administration] action=‹ spip.php?article14 ›, divclass=‹ spip-admin-float ›, calcul=‹ calcul ›, popularite=‹ 2 ›, statistiques=‹ http://www.eco2scop.fr/ecrire/?exec=statistiques_visites&id_article=14 ›, visites=‹ 89 ›, id_article=‹ 14 ›, voir_article=‹ http://www.eco2scop.fr/ecrire/?exec=articles&id_article=14 ›, date=‹ 2008-06-25 08:58:54 ›, date_redac=‹ 2008-06-25 08:58:54 › (6246 octets)
Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=

Jun 25 08:58:54 82.229.204.186 (pid 1234) Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql.log
------------------------------------
Jun 25 06:51:27 82.229.204.186 (pid 1234) GET /
Jun 25 06:51:27 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 06:51:27 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 06:51:27 82.229.204.186 (pid 1234) GET /
Jun 25 06:51:27 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 06:51:27 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 06:51:27 82.229.204.186 (pid 1234) GET /
Jun 25 06:51:27 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 06:51:27 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:27 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:51:27 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:51:27 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:27 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:51:27 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:51:27 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:33 82.229.204.186 (pid 1234) GET /spip.php?article16
Jun 25 08:51:33 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:51:33 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:33 82.229.204.186 (pid 1234) GET /spip.php?article16
Jun 25 08:51:33 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:51:33 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:34 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:51:34 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:51:34 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:51:34 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:51:34 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:51:34 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:41 82.229.204.186 (pid 1234) GET /spip.php?article17
Jun 25 08:58:41 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:41 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:41 82.229.204.186 (pid 1234) GET /spip.php?article17
Jun 25 08:58:41 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:41 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:45 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:45 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:45 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:45 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:45 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:45 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:51 82.229.204.186 (pid 1234) GET /spip.php?rubrique4
Jun 25 08:58:51 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:51 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:51 82.229.204.186 (pid 1234) GET /spip.php?rubrique4
Jun 25 08:58:51 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:51 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?article14
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?article14
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_rubriques WHERE id_rubrique=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Jun 25 08:58:54 82.229.204.186 (pid 1234) GET /spip.php?page=jquery.js
Jun 25 08:58:54 82.229.204.186 (pid 1234) - SELECT id_secteur FROM `eco2scop`.spip_articles WHERE id_article=
Jun 25 08:58:54 82.229.204.186 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Payet_Teddy (Payet Teddy) Juin 25, 2008, 8:18 2

Bonjour,

Quelle est la boucle utilisée pour les articles? Puisqu’apparemment, l’erreur viendrait de la boucle article et non document…

Cordialement,

Teddy Payet

liste spip
spip@rezo.net - désabonnement : spip-off@rezo.net
Infos et archives : http://listes.rezo.net/mailman/listinfo/spip
Documentation de SPIP : http://www.spip.net/
irc://irc.freenode.net/spip
FAQ webmaster: http://www.spip.net/fr_article1054.html
FAQ technique: http://www.spip.net/fr_rubrique170.html
FAQ de l’administrateur: http://www.spip.net/fr_article1112.html

Le 25 juin 08 à 09:02, Boby K a écrit :

Bonjour à tous,

Depuis hier, mon site ne s’affiche plus (ou que de temps en temps) et me renvoie le plus souvent une erreur 500.
Je suis en SPIP 1.9.2d
J’ai fait avant-hier lundi les modif suivantes

ajout du plugin diapo

ajout d’une balise diapo dans un article

création d’un nouvel article expliquant cette nouveauté

modification de article.html pour que les documents d’un article de type images ne soient plus affichés sous l’article comme les autres documents.
<BOUCLE_portfolio(DOCUMENTS){id_article}{extension==jpg|png|gif}{mode=document}{doublons}>
</BOUCLE_portfolio>
J’ai testé toutes ces modif lundi, tout marchait.
Depuis hier mardi, par contre : erreur 500 !

Dans le fichier mysql.log, j’ai des erreurs du type :
Jun 25 08:40:30 66.249.70.92 (pid 1234) GET /spip.php?article16&diapo16=4
Jun 25 08:40:30 66.249.70.92 (pid 1234) - SELECT id_secteur FROM eco2scop.spip_articles WHERE id_article=
Jun 25 08:40:30 66.249.70.92 (pid 1234) 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ › at line 1

Ce matin, je suis de nouveau arrivé à accéder à « ecrire » et ai donc désactivé le plugin diapo.

Mon site a l’air (pour le moment) de remarcher mais j’ait toujours des erreurs dans ce fichier (copie ci-dessous ainsi que copie de spip.log)

Pouvez-vous m’aider ?

Merci

Boby