Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

Blain

  • 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.

-Blain
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
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.
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 20 queries.