Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Apostrophe in Keyword  (Read 2493 times)

0 Members and 1 Guest are viewing this topic.

roaftech

  • Coppermine novice
  • *
  • Country: ro
  • Offline Offline
  • Gender: Male
  • Posts: 24
    • Romanian Aid Foundation
Apostrophe in Keyword
« on: September 22, 2015, 11:23:18 am »

I use a standardised form of keyword for my gallery, in the format "mmmyy";"subject".
I accidentally entered "Aug'14" (with apostrophe) instead of "Aug14".  I now have two keywords - "14" and "Aug&#039", and two problems.
 - The "14" now returns all the photos taken during 2014, although none of them actually has the keyword "14". I need to remove it from the keyword list without deleting all the files that it selects.
 - The second combination is immune to the standard delete keyword process - I can't find a way to get rid of it with the CPG processes. I presume that it could be deleted from the underlying database via php, but where is it located?

Any advice?
TIA

Album link: http://www.roaf.org/gallery/search.php
Logged
.
Steve Humphreys,
Help, Hope and Co-operation,
Asociatia Neemia, Dorohoi, Romania.
www.roaf.org/gallery

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Apostrophe in Keyword
« Reply #1 on: September 22, 2015, 03:59:49 pm »

Why don't you just rename the wrong keyword(s) in the affected file's "edit file information" page?
Logged

roaftech

  • Coppermine novice
  • *
  • Country: ro
  • Offline Offline
  • Gender: Male
  • Posts: 24
    • Romanian Aid Foundation
Re: Apostrophe in Keyword
« Reply #2 on: September 22, 2015, 08:57:05 pm »

Thanks Andre,
I did try to rename the keyword in the keyword manager, but without success.
However, by going through each of the files in the affected albums I was able to change each one separately, and all the offending keywords have now disappeared. Fortunately there were not too many files otherwise it might have been a long process.
Many thanks for the suggestion.

Now all I have to do is find that ellusive "solved" button !
Logged
.
Steve Humphreys,
Help, Hope and Co-operation,
Asociatia Neemia, Dorohoi, Romania.
www.roaf.org/gallery
Pages: [1]   Go Up
 

Page created in 0.03 seconds with 21 queries.