Duplicate ratings and reviews

Help Discussion in 'BeerAdvocate Talk' started by koakley, Mar 9, 2014.

Thread Status:
Not open for further replies.
  1. koakley

    koakley Initiate (0) Nov 27, 2013 California

    I don't know when the site was last updated but I've been seeing a lot of duplicates being saved to the database. I don't know if there is an issue with the INSERT queries, Primary key..or whatever but I thought I'd mention it.

    Anyone else notice this?
     
    #1 koakley, Mar 9, 2014
  2. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    Thanks for point this out. It's from a change the other week. I'm working on this now; removing the dupes and locking it down.
     
    #2 Todd, Mar 9, 2014
  3. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    Just ran a test. Less than 400 duplicates were created. They'll be removed shortly.
     
    #3 Todd, Mar 9, 2014
    koakley likes this.
  4. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    The update query has been run. Duplicated have been removed. Unique key is back in place. Stats will be updated shortly.

    Thanks again for bringing this to our attention.
     
    #4 Todd, Mar 9, 2014
Thread Status:
Not open for further replies.