Duplicated Gallery items after upgrade from CB CB 1.9.1 to CB 2.0.14

After the upgrade from CB 1.9.1 to CB 2.0.14 I got the following weird behaviour. If a certain user had some gallery items before the upgrade, these items have been doubled after the upgrade....this looks as follows:




...so I started to analyse where to problem is. And I found that the responsible table for this is the table: 'jos_comprofiler_plugin_gallery_items'....




..here you can see that the corresponding user: 157 has 2 entries....one entry that shows really the Gallery item and the other entry that shows only an empty box on the gui....

...I think this behaviour happened because the 'old' CB Profile Gallery plugin has been replaced be the new CB Gallery plugin....

Of course: I could write a DELETE SQL Statement, which deletes the 'wrong' entries, but how can I recognize these wrong entries ?

regards

Probably due to CB Gallery migration of CB Profile Gallery. For some reason in your case it migrated twice. Note sure how that happened unless you installed it twice and CB Profile Gallery failed to remove during the first migration. Most likely the last entry of each duplicate is the only valid entry.

Another option is to install CB Profile Gallery (its database rows and files should still exist, please confirm this first), empty the gallery items table, then re-install CB Gallery and it should re-migrate. Please make a backup before doing this.