Erreur SQL : personnes et catégories
| Avancement | ![]() |
| Workflow | Besoin d'aide |
| Statut | Le problème a été enregistré |
Bonjour
En cliquant sur "personnes", j'obtiens le message :
SELECT * FROM yacs_users AS users WHERE (users.active='Y') ORDER BY users.posts DESC, users.edit_date DESC LIMIT -20,20
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 '-20,20' at line 1
En cliquant sur "catégories", j'obtiens le même genre de message :
SELECT categories.* FROM yacs_categories AS categories WHERE (categories.anchor='' OR categories.anchor is NULL) AND ((categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2008-09-28 12:14:13'))) ORDER BY categories.rank, categories.title, categories.edit_date DESC LIMIT -40,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 '-40,40' at line 1
Site chez 1and1
| YACS | 8.6beta30.31.31.8, |
| PHP | 4.4.9 |
| MySQL | 5.0.67-log |
