A solution for "skipping duplicate resource URI for resource id"

- ☆ A M B ☆
- 2,475 Posts
Everett Reply #1, 13 years, 5 months ago
I've run into this on several sites -- my log files fill up with hundreds (thousands) of errors like this:
```
[2013-05-13 12:40:23] (ERROR @ /connectors/resource/index.php) Resource URI x/y/z.html already exists for resource id = 1356; skipping duplicate resource URI for resource id = 1357
```
I know that there are a handful of pages that are using the same uri (whoops -- due to some oversights in an import script).

The following MySQL query identifies the culprits:
```
mysql> SELECT uri,  GROUP_CONCAT(id), count(*) AS cnt 
FROM modx_site_content 
GROUP BY uri 
HAVING cnt > 2
```
I have followed some similar posts: https://forums.modx.com/forums/thread/15424/website-doesn-t-load-odd-error-messages#dis-post-83085

but I have not found an automated solution. Anyone have any ideas? [ed. note: Everettg_99 last edited this post 13 years, 5 months ago.]
Hosting stuff: http://fireproofsocks.com/
Coding stuff: http://craftsmancoding.com/
Blog stuff: http://tipsfor.us/
- ☆ A M B ☆
- 2,475 Posts
Everett Reply #2, 13 years, 5 months ago

Seems as though Articles trips this up specifically: you can update the alias after the fact, but the stored uri in the database won't budge after its been generated and stored. The problem seems to be that Articles doesn't flag the duplicate alias as problematic (the duplicate alias leads to a duplicate URI).
Hosting stuff: http://fireproofsocks.com/
Coding stuff: http://craftsmancoding.com/
Blog stuff: http://tipsfor.us/