Accidentés accidenté: Guy Bilodeau

explications de Jobin-Vermette

SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'section:891') AND (members.anchor LIKE 'category:%')) AS ids, yacs_categories AS categories WHERE (categories.id = ids.target) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2024-10-23 13:00:10')) ORDER BY rank, title, edit_date DESC LIMIT 0,40
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 ', title, edit_date DESC LIMIT 0,40' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:891') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2024-10-23 13:00:10') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-10-23 13:00:10'))) ORDER BY rank, title LIMIT 0,50
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 ', title LIMIT 0,50' at line 1

11 novembre 2014

Fichiers

11novembre2014 sur 12pages no1.jpg

partagé par Carmen Fréchette le 13 mai 2019 à 15:18 GMT · 21 téléchargements · 581 824 octets · dans Explications de Jobin-Vermette

détails