Browsing category (404 or wrong record) [front-end]

[leonardo.vitro]

Hello,

I'm having trouble navigating the categories I had created.
When I click to navigate within some of my categories I encounter a 404 page or a totally different record.

I tried to solve the problem by performing the rebuild of the categories, but I believe the problem is the "#_assets" table.

any suggestions?

[]'s

[leonardo.vitro]

Hii again! =)

I solved part of my problem, creating the missing records in table "#_assets" and correcting some "alias" of my categories containing dots and spaces.

I am currently having problems with sub-categories, they still redirecting to the wrong records.


[]'s

[federica]

Hi leonardo,
If the categories are not hundreds you can try to delete all record related to "com_abook.category" like:
SELECT *
FROM `#_assets`
WHERE `name` LIKE '%com_abook.category%'
LIMIT 0 , 30

then open every category and save it again.

[leonardo.vitro]

federica hello! thanks for the reply =)

I have 550 categories and 47 sub-categories, if I delete the sub-categories and recreates them work?
Or would recreate all categories?

[]'s

[federica]

You have to delete only the record in the #_asset table!!! Then re-save every category. But 597 categories are too many to save them manually.
You can try to export all data to sql file using abook export tool then import the sql file. Remember to perform a backup before proceeding.