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

Started by leonardo.vitro, 10 November 2014, 13:56:54

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

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

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

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

#2
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.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

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

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

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.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]