I would like to add Categories to Albums. Followed the steps https://unacms.com/wiki/Browseable-categories but get stuck on the part how to insert the correct data into the database.
I named my list: Albums categories. Placed this code in the "service" block
add this to the database
The block is showing on the Albums Home page, but it's not showing any categories.
What did i do wrong?
Comments
Hello @Ronald !
Could you plz specify if your site has the content with any categories from the new categories list? If yes, then PM me in messenger.
UPDATE: According to the task to get the browseable categories for the Albums app, the MySQL query foe the object categories should have the following look:
INSERT INTO `sys_objects_category` SET
`object` = 'my_custom_category',
`search_object` = 'bx_albums',
`form_object` = 'bx_albums',
`list_name` = 'Albumcat',
`table` = 'bx_albums_albums',
`field` = 'albumcat',
`join` = 'INNER JOIN `sys_profiles` ON (`sys_profiles`.`content_id` = `bx_albums_albums`.`author`)',
`where` = 'AND `sys_profiles`.`status` = ''active''',
`override_class_name`= '',
`override_class_file` = '';
This worked 😀