search

JonathanReeve / docmap

A project for creating new themes and customization functionality for the Omeka content management system.
4 stars 0 forks source link

[Browse Exhibits by Tag: CDH2012] Exhibit "America's Bohemia" displayed twice #125

Closed JonathanReeve closed 11 years ago

JonathanReeve commented 11 years ago

Try this with other themes to see if this is a theme-specific issue.

JonathanReeve commented 11 years ago

Clicking on the exhibit tags from the exhibit descriptions brings up multiple copies of the same exhibit.

JonathanReeve commented 11 years ago

This appears to be happening with every theme, so the issue is probably somewhere in the database. It looks like certain exhibits got tagged with the same tag twice.

CathyHajo commented 11 years ago

Jon,

Good to know if is not with the theme! I've been trying to load a version of 2.0.3 on to play around with and lots of issues getting it running. Erg.

On the duplicate listings, is there a way to fix the database, compact it or whatever?

I entered the last of your hours for this grant so that we spend it all before it ends 6/15.

Cathy

Cathy Moran Hajo, Ph.D. Associate Editor/Assistant Director The Margaret Sanger Papers Project Department of History, New York University 53 Washington Square South New York, NY 10012 (212) 998-8666 (212) 995-4017 (fax) cathy.hajo@nyu.edu

Visit our website at: http://www.nyu.edu/projects/sanger

On Fri, May 31, 2013 at 3:16 PM, Jonathan Reeve notifications@github.comwrote:

This appears to be happening with every theme, so the issue is probably somewhere in the database. It looks like certain exhibits got tagged with the same tag twice.

— Reply to this email directly or view it on GitHubhttps://github.com/JonathanReeve/docmap/issues/125#issuecomment-18765950 .

JonathanReeve commented 11 years ago

A workaround for this issue is to remove duplicate entries in the database. I'll come up with a mySQL command to do this automatically.

sql-redundancy

CathyHajo commented 11 years ago

Sounds good!

Cathy Moran Hajo, Ph.D. Associate Editor/Assistant Director The Margaret Sanger Papers Project Department of History, New York University 53 Washington Square South New York, NY 10012 (212) 998-8666 (212) 995-4017 (fax) cathy.hajo@nyu.edu

Visit our website at: http://www.nyu.edu/projects/sanger

On Fri, May 31, 2013 at 3:30 PM, Jonathan Reeve notifications@github.comwrote:

A workaround for this issue is to remove duplicate entries in the database. Come up with a mySQL command to do this automatically.

[image: sql-redundancy]https://f.cloud.github.com/assets/1843676/592920/80047d7c-ca28-11e2-8f52-688893eaf699.png

— Reply to this email directly or view it on GitHubhttps://github.com/JonathanReeve/docmap/issues/125#issuecomment-18766774 .

JonathanReeve commented 11 years ago

Hi Cathy, I found a command that changes the database structure so that it ignores duplicate entries: ALTER IGNORE TABLE omeka_taggings ADD UNIQUE(relation_id, tag_id). I went ahead and ran this on the gvh site at aphdigital.org. Here's the new list of exhibits tagged CDH2012. Marking this issue as fixed.

CathyHajo commented 11 years ago

Hi Jon,

That is great! I may have to do it on the NJ site as well, but right now they are not showing up twice.

Cathy Moran Hajo, Ph.D. Associate Editor/Assistant Director The Margaret Sanger Papers Project Department of History, New York University 53 Washington Square South New York, NY 10012 (212) 998-8666 (212) 995-4017 (fax) cathy.hajo@nyu.edu

Visit our website at: http://www.nyu.edu/projects/sanger

On Fri, May 31, 2013 at 6:38 PM, Jonathan Reeve notifications@github.comwrote:

Hi Cathy, I found a command that changes the database structure so that it ignores duplicate entries: ALTER IGNORE TABLE omeka_taggings ADD UNIQUE(relation_id, tag_id). I went ahead and ran this on the gvh site at aphdigital.org. Here's the new list of exhibits tagged CDH2012http://gvh.aphdigital.org/exhibits/browse?tags=CDH2012. Marking this issue as fixed.

— Reply to this email directly or view it on GitHubhttps://github.com/JonathanReeve/docmap/issues/125#issuecomment-18775427 .