I’m frustrated

Duplicate Venues with Upgrade

I just upgraded gigpress. I only had 8 shows in the database (which means 8 venues) but the new version took those 8 and duplicated them into 37 pages (!) of duplicate venues. The only way to delete them I've found is one-by-one. Seriously?!
3 people have
this problem
+1
Reply
  • Sorry about that Ben, this is obviously no expected behaviour for most cases

    When upgrading, GigPress does a SELECT DISTINCT from the shows database to get venue info. If there are any differences at all in any of the venue fields (name, address, city, country, URL, or phone), they are treated as different venues. I can only assume this is what happened in your case (many small differences in venue info).

    If you have access to your database via phpMyAdmin, it may be faster and easier to make the changes directly on the database. I can walk you through this more if you like.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • I’m frustrated
    Well, as I stated, there were only 8 shows in the database to begin with. Each show had 1 venue so there were only 8 venues when it started. Somehow those 8 became 540+ all with duplicate names... EXACT duplicate names.

    I also only had one artist - it's a single artist website - but now there are 35 entries all with the single artist's name. All of the shows belong to a single entry but it created 34 more entries with the same name with no shows.

    Something is definitely broken.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • If you'd like Ben, maybe you could email me (derek@gigpress.com) an admin login for your site, and if possible phpMyAdmin access, so I can investigate why this might have happened. This is the first report I've had of this.

    Obviously this never happened in beta testing, or I wouldn't have pushed the update out the door.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • I’m frustrated
    Ok... so the "artists" table was easy to clean out because it only had 36 rows and all of the shows belonged to the version with ID of "1" according to the Artists tab... so I just deleted all of the other rows (which all had the same name).

    Now, though, in the Gigpress Admin under the "Artists" tab I still see 35 versions of the artist in the table.

    As far as the "venues" table goes... how do I know which version of each venue to leave so that Gigpress doesn't try to pull a row from the table that doesn't exist. The "Venues" tab doesn't tell me the venue's ID like the Artists tab did. Do I have to scrap all of my shows and start over?!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Have a look at the wp_gigpress_shows table, and make note of the show_venue_id column. Those are the IDs of the venues you should keep in the wp_gigpress_venues table.

    If all but one row in the wp_gigpress_artists table have been deleted, you definitely shouldn't have more than one entry on the Artists screen. Unless the problem we're facing is that the database version in your settings hasn't been properly updated, and GigPress is running the upgrade repeatedly.

    If you go back to the database now, do you still just have the 1 artist in the wp_gigpress_artists table?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • I’m thankful
    OK... thanks for working with me on this one. It's always bad news to wake up one morning and watch a live site go haywire so I'm playing catch-up and really do appreciate the help.

    I grabbed the venue_ids that were used in the shows database and deleted the other 535 duplicate entries in that table.

    I think the "ghost" artists showing up in the Admin was a local caching issue because they are gone now.

    While it wasn't a pretty solution, it's all fixed now. I just hope this was an isolated issue and you don't end up with a bunch of other people in this same position. :)

    Now I'm off to go learn the new templating system so I can get my pages back to normal.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Glad that worked out for you. Hopefully this is a very isolated incident. I'm marking this as "solved" for now, though if this pops up again and I can get to the root of it, I'll of course fix the upgrade if it needs it.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • I’m happy it's done.
    I had the same issue happen after an upgrade. I went into the tables using "Navicat" (Love that program) and left the oldest entries, and deleted the other duplicates. Took awhile, but fixed.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Sorry this happened to you as well Ri - glad you sorted it out. This is only the second reported instance of this happening, so I haven't been able to track down the cause. Hopefully by now, most folks have upgraded to 2.0+ at any rate.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Greetings Derek. I really like this plugin - thanks for your work!!

    I have a similar problem, though it's not anyone's fault buy my own. I upload a csv file to import all my shows. Then, because I was an idiot and did not have the date column formatted correctly, I deleted everything and started over, twice. However now as I look to the venue list, I have three copies of each venue.

    First, can you tell me where to edit the database (rather than clicking delete on each duplicate), and second, perhaps a nice update would be a checkbox style listing of the venues, like the shows. Then deleting old venues would be a snap....

    Thanks so much!!
    nathan
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • Hey Nathan - you can edit the venue table in the database by looking in the wp_gigpress_venues table. (use phpMyAdmin or whatever tool you prefer.)

    Will consider the mass-delete option for venues!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly