SQL-Error
| Bug # | 242 | ||||
| Priorität | 1 (🔺 Sehr Hoch) | ||||
| Bereich | Commenting | ||||
| Title | SQL-Error | ||||
| Beschreibung | MySQL Error: 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 'AND user.id = comments.user_id GROUP BY comments.id' at line 1 SQL-Query: SELECT comments.*, UNIX_TIMESTAMP(comments.date) date, UNIX_TIMESTAMP(comments.date_edited) date_edited, user.clan_tag, user.username, count(c2.id) as numchildposts FROM comments, user LEFT JOIN comments as c2 ON (comments.id = c2.parent_id AND comments.board = c2.board) WHERE comments.id = AND user.id = comments.user_id GROUP BY comments.id FILE: /home/CME/z/zooomclan/www/includes/comments.res.php Line: 146 http://www.zooomclan.org/bugtracker.php?bug_id=95&parent_id=140#45884 ungelesene Kommentare Das hab ich jetzt si [z]deep:blue 14:59 Das hab ich jetzt si [z]deep:blue 15:00 hört da hüt nüm uf ? | ||||
| Reported by | freiländer @ | ||||
| Git Commit | |||||
| Assigned to | milamber @ 01.09.2004 15:19 | ||||
| Status | Resolved @ | ||||