Ticket #406 (closed defect: invalid)
Installation nicht möglich
| Reported by: | fuxi@… | Owned by: | somebody |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | userboardactivity | Version: | |
| Keywords: | Cc: |
Description
Fatal error: Invalid SQL: SELECT wbb1_1_board.boardID, x.c, wbb1_1_board.title, IF(wbb1_1_board.posts>0 AND c>0,ROUND((100/wbb1_1_board.posts)*c),0) AS percentBoard, IF(wbb1_1_board.posts>0 AND c>0,ROUND((100/wbb1_1_user.posts)*c),0) AS percentPersonal FROM ( SELECT wbb1_1_post.userID, wbb1_1_thread.boardID, COUNT(wbb1_1_post.postID) AS c FROM wbb1_1_post INNER JOIN wbb1_1_thread USING(threadID) WHERE wbb1_1_post.userID = 1 AND boardID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,25,27,32,40,78,79,80,81,82,85,86,87,88,89,90,91) GROUP BY wbb1_1_thread.boardID ORDER BY c DESC LIMIT 5 ) x INNER JOIN wbb1_1_board USING(boardID) INNER JOIN wbb1_1_user USING(userID)
Change History
Note: See
TracTickets for help on using
tickets.
