View Issue Details

IDProjectCategoryView StatusLast Update
0000468WackoWikiinstallerpublic2018-01-17 22:41
Reporteradministrator Assigned Toadministrator  
PrioritynormalSeverityminorReproducibilitysometimes
Status resolvedResolutionfixed 
Product Version5.5.0 
Target Version5.5.2Fixed in Version5.5.2 
Summary0000468: Categories are not displayed after upgrade
DescriptionThis affects all categories related actions.
Steps To ReproduceSELECT 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 InformationHotfix:
UPDATE lab_category_assignment SET object_type_id = 1 WHERE object_type_id IS NULL OR object_type_id = 0;
TagsNo tags attached.

Issue History

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