Vox Populi(x) forum

Alexandria Book Library => Supporto (Support) => Topic started by: leonardo.vitro on 10 November 2014, 13:56:54

Title: Browsing category (404 or wrong record) [front-end]
Post by: leonardo.vitro on 10 November 2014, 13:56:54
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
Title: Re: Browsing category (404 or wrong record) [front-end]
Post by: leonardo.vitro on 12 November 2014, 15:11:54
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
Title: Re: Browsing category (404 or wrong record) [front-end]
Post by: federica on 12 November 2014, 18:14:09
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.
Title: Re: Browsing category (404 or wrong record) [front-end]
Post by: leonardo.vitro on 12 November 2014, 20:48:03
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
Title: Re: Browsing category (404 or wrong record) [front-end]
Post by: federica on 12 November 2014, 21:49:21
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.