View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000468 | WackoWiki | installer | public | 2018-01-17 19:53 | 2018-01-17 22:41 |
| Reporter | administrator | Assigned To | administrator | ||
| Priority | normal | Severity | minor | Reproducibility | sometimes |
| Status | resolved | Resolution | fixed | ||
| Product Version | 5.5.0 | ||||
| Target Version | 5.5.2 | Fixed in Version | 5.5.2 | ||
| Summary | 0000468: Categories are not displayed after upgrade | ||||
| Description | This affects all categories related actions. | ||||
| Steps To Reproduce | SELECT c.category_id, c.category_lang, c.category, COUNT(c.category_id) AS number FROM stable_category c INNER JOIN stable_category_assignment ca ON (c.category_id = ca.category_id) INNER JOIN stable_page p ON (ca.object_id = p.page_id) WHERE c.category_lang = 'en' AND ca.object_type_id = 1 AND p.deleted <> 1 GROUP BY c.category ORDER BY c.category ASC; Zero results from query. Reason: object_type_id was not set (0) | ||||
| Additional Information | Hotfix: UPDATE lab_category_assignment SET object_type_id = 1 WHERE object_type_id IS NULL OR object_type_id = 0; | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-01-17 19:53 | administrator | New Issue | |
| 2018-01-17 19:53 | administrator | Status | new => assigned |
| 2018-01-17 19:53 | administrator | Assigned To | => administrator |
| 2018-01-17 19:55 | administrator | Status | assigned => resolved |
| 2018-01-17 19:55 | administrator | Resolution | open => fixed |
| 2018-01-17 19:55 | administrator | Fixed in Version | => 5.5.2 |
| 2018-01-17 19:55 | administrator | Note Added: 0000975 | |
| 2018-01-17 19:57 | administrator | Summary | Categories are not displayed => Categories are not displayed after upgrade |
| 2018-01-17 22:41 | administrator | Steps to Reproduce Updated | |
| 2018-01-17 22:41 | administrator | Additional Information Updated |