Since the transition to the new website format, some preexisting river page comments are duplicated up to 13 times. If you try to remove any of the duplicate comments, the original comment will also be removed so they all dissappear. If it is an important comment that needs to be saved, then we should probably copy it to the main body text of the river description. Then we can delete the comment without fear of losing the info.

I have added one comment to a page just now as a test, and it appears that new comments are fine and are not affected by this 13 copies problem. See:
[www.americanwhitewater.org]
for an example of my test comment that is not duplicated, an older comment that is duplicated 13 times, and an even older comment that is not duplicated. Strange.

In this example on the SF American, the comment that is duplicated is becoming dated, yet remains of historical interest. I would like to remove it as a comment and thus solve the duplication problem, but I don't think it is appropriate as a permanent part of the main river description. What I would like to do is convert it to an article and create a link to it. There have been other instances of information or stories that don't really fit in a river description but which should be linked to, or on a seperate page of a river description.

Paul Martzen

The previous web developer did not believe in primary keys on the comments table. This caused significant problems when I had a primary keyand found 24,000 duplicate records. The problem should be fixed now.