Imported From: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/1f8419085ca8ca76#
...
This might be a new bug in 5.1.1-B2
I have submitted a Comment (old review) on the Front-end for a Link
and it's perfectly fine except I do NOT see it in the Admin ->
Comments grid.
Here is the SQL and looks like we get FALSE in WHERE which fails to
return the list.
| Code Block | ||
|---|---|---|
| ||
SELECT inp_ItemReview.*, (IF( ISNULL(pu.Login), IF |
...
(inp_ItemReview.CreatedById = -1, 'root', IF |
...
(inp_ItemReview.CreatedById = -2, 'Guest', 'n/a')), pu.Login )) AS |
...
`ReviewedBy`, (item_table.l1_Name) AS `CatalogItemName`, |
...
(item_table.LinkId) AS `CatalogItemId`,(ci.CategoryId) AS |
...
`CatalogItemCategory`, (inp_ItemReview.CreatedOn) AS `CreatedOn_date`, |
...
(inp_ItemReview.CreatedOn) AS `CreatedOn_time` |
...
FROM inp_ItemReview |
...
LEFT JOIN inp_PortalUser pu ON pu.PortalUserId = |
...
inp_ItemReview.CreatedById |
...
LEFT JOIN inp_Link item_table ON item_table.ResourceId = |
...
inp_ItemReview.ItemId |
...
LEFT JOIN inp_CategoryItems ci ON item_table.ResourceId = |
...
ci.ItemResourceId AND ci.PrimaryCat = 1 |
...
WHERE ((FALSE) AND (inp_ItemReview.ItemType = 4)) |
...
ORDER BY `inp_ItemReview`.`Priority` |
...
desc,`inp_ItemReview`.`CreatedOn` desc,`inp_ItemReview`.`ReviewText` |
...
asc LIMIT 0,11 |
...
I believe it's related to the earlier task about 746: Remove useless
filters from "View Menu" or I might be wrong.
|
Can anyone else repeat this?
DA.
Related Tasks
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|