forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Blain on March 18, 2009, 02:04:07 am

Title: Name All Topics and Descriptions
Post by: Blain 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
Title: Re: Name All Topics and Descriptions
Post by: Joachim Müller 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.