[tags] Edit/renaming/merging tags
|
caddymob
Joined: 2007-01-30
Posts: 82 |
Posted: Sun, 2008-07-13 10:28
|
|
Tried to rename some tags and found that I can't name a tag if there is already a tag with that name... The reason I want to do this is clean up my tags and fix some errors... For example, I have a tag Dark1 and I want it just Dark. Only problem is there is already a tag Dark. Is it possible to fix tags like this? In otherwords, merge one tag name into another? Here is the error output: Quote:
Error (ERROR_STORAGE_FAILURE) ---and--- Quote:
Query: UPDATE g2_TagMap SET g_tagName='Dark' WHERE g_tagName='Dark1' failed. Duplicate entry 'Dark' for key 2 Thanks! |
|
Posts: 82
& bump! Any ideas? Really need to get in there and do some house cleaning... Just tried again --
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage.class at line 718 (GalleryCoreApi::error)
* in modules/core/classes/GalleryCoreApi.class at line 2885 (GalleryStorage::updateMapEntry)
* in modules/tags/classes/TagsHelper.class at line 342 (GalleryCoreApi::updateMapEntry)
* in modules/tags/AdminTags.inc at line 70 (TagsHelper::renameTag)
* in main.php at line 249 (AdminTagsController::handleRequest)
* in main.php at line 103
* in main.php at line 88
System Information
Gallery version 2.3-svn
PHP version 5.2.6 cgi-fcgi
Webserver Apache/2.2.9 (Unix) PHP/4.4.7 mod_ssl/2.2.9 OpenSSL/0.9.8c mod_fastcgi/2.4.6 DAV/2 SVN/1.4.2
Database mysqli 5.0.45-log
Toolkits ImageMagick, NetPBM, Gd
Operating system Linux dillinger 2.6.24.6-p4-modules-peon-grsec #1 SMP Thu May 15 22:08:43 PDT 2008 x86_64
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16
_______________________________________
Highly Dynamic Photography | Jason Corneveaux
Posts: 4342
No, the tags modules doesn't allow this. You can do it with some custom sql commands that you can run in PHPMyAdmin though.
Posts: 82
I was afraid of that... So, hope this isn't too much of a dunce question, but what would the sql comands be on my example of Dark1 --> Dark
Posts: 82
Guys, I am really at a loss here... I need to clean up the tags on my site and I just keep going in circles.
I thought I'd try to replace the images in my gallery with bad tags -- i just uploaded over the .jpgs in /gallery2/g2data/albums
The old tags are still showing up!! They are definitely gone, checked and double checked in exiftool... I even deleted the tag module and reinstalled, but somehow the OLD EXIF data is still buried somewhere.
For example, I cleaned up the tags in this album and loaded the 'clean' jpgs in the g2data/albums:
http://corneveaux.com/gallery2/v/xmas2007/white/
But, the old crappy tags are still showing up! Like this useless tag:
http://corneveaux.com/gallery2/main.php?g2_view=tags.VirtualAlbum&g2_tagName=8.64++Km+to+Cochran++in+Arizona+United+States
PLEASE!! How can I fix this? I have hundreds of photos, and 1 by 1 reupload just wont work...