#1221 – Duplicate URLs

Hello,

I use Raven Tools to audit all our sites, and I'm getting warnings for duplicate URLs that are not showing up in the URL manager. I'm wondering how can I resolve these duplicates.

Here's an example:

This is the correct url: http://www.xxxx.com/project-results/oil-gas/subsea-og-network-development-in-angola

This is the duplicate: http://www.xxxx.com/project-results/subsea-og-network-development-in-angola?catids=,10,

How do I eliminate the duplicates?

John

I figured it out, I didn't copy the SQL query over from another site using the same component for the sitemap (Jsitemap Pro). This fixed it:

SELECT
`#__bt_portfolios`.`title`,
`#__bt_portfolios`.`modified`,
`#__bt_portfolios`.`id`,
REPLACE(`#__bt_portfolios`.`catids`, ',', '') AS `catid_rel`
FROM `#__bt_portfolios`
WHERE
`#__bt_portfolios`.`published` = '1'
AND `#__bt_portfolios`.`access` IN {aid}
AND (`#__bt_portfolios`.`language` = '*' OR `#__bt_portfolios`.`language` = {langtag})
ORDER BY
`#__bt_portfolios`.`published` ASC