|
|
 |
« Yanıtla #3 : Mayıs 10, 2007, 22:55:41 ÖS » |
Teşekkür Et
|
ERROR: Database error. Cannot execute the query: SELECT m.posterTime AS lastPosterTime, m.ID_TOPIC, m.ID_MSG, m.ID_MEMBER, m.smileysEnabled, m2.ID_MEMBER AS ID_FIRST_MEMBER, m2.subject, m2.posterTime, m2.body, t.ID_BOARD, t.ID_LAST_MSG, t.numReplies, t.numViews, b.name AS bName, IFNULL(mem2.realName, m2.posterName) AS posterName, t.ID_FIRST_MSG, IFNULL(mem.realName, m.posterName) AS lastPosterName, t.ID_LAST_MSG FROM (DBPREFIXmessages AS m, DBPREFIXmessages AS m2, DBPREFIXtopics AS t, DBPREFIXboards AS b) LEFT JOIN DBPREFIXmembers AS mem ON (mem.ID_MEMBER = m.ID_MEMBER) LEFT JOIN DBPREFIXmembers AS mem2 ON (mem2.ID_MEMBER = m2.ID_MEMBER) WHERE m2.ID_MSG = t.ID_FIRST_MSG AND m.ID_MSG = t.ID_LAST_MSG AND t.ID_TOPIC = m.ID_TOPIC AND m.ID_MSG >= 0 AND b.ID_BOARD = t.ID_BOARD AND GROUP BY m.ID_TOPIC ORDER BY t.ID_LAST_MSG DESC LIMIT 10 MySql Error returned: 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 'GROUP BY m.ID_TOPIC ORDER BY t.ID_LAST_MSG DESC LIMIT 10' at line 16 MySql Error code: 1064
Diye hata veriyor ilgilenirseniz memnun olurum lazım.
|