Advanced search  


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.

Pages: [1]   Go Down

Author Topic: Name All Topics and Descriptions  (Read 1475 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Name All Topics and Descriptions
« on: March 18, 2009, 02:04:07 am »

Greetings and thank you all very much for the support you offer. Your time is well appreciated.

My question is this: -- I have well over 6,000 Images at the moment. Is there a way to edit the Topic and Description fields of all of the Images within an Album, rather than clicking on "edit files" and editing them each with a Topic and Description?

It would seem that this would have to be possible, since the other way is so tedious.

Thank you for your time and efforts in maintaining this wonderful, free product.


Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
Re: Name All Topics and Descriptions
« Reply #1 on: March 18, 2009, 09:09:22 am »

There's no such method built into the user interface, so you'd have to perform that directly on the database, using a tool like phpMyAdmin and run a query like
Code: [Select]
UPDATE yourCoppermineTablePrefix_pictures SET title='foo' WHERE aid=5;Make sure to backup your db before performing such queries - if you make a mistake, you could ruin everything pretty easily. If you're not that much into mysql queries and you need a real-life example, provide more details, e.g. a link to your gallery (preferably to the album that you want to see edited) and the content you want to see added.
Pages: [1]   Go Up

Page created in 0.017 seconds with 20 queries.