coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Paul333 on May 08, 2008, 03:27:30 PM

Title: Moving comments to Title field
Post by: Paul333 on May 08, 2008, 03:27:30 PM
Is there an easy way to move ALL comments from the "description" field to the "title" field for each image ?
Title: Re: Moving comments to Title field
Post by: Paul333 on May 08, 2008, 03:29:59 PM
Probably didn't explain that too well.

I've uploaded a lot of images and populated the "description" field with info rather than the "title" field. I now realise those comments don't show unless I enable display of all the file information ...... which I don't want to do.

Thought there may be a database move (SQL ?) that will shift the whole lot in one go.
Title: Re: Moving comments to Title field
Post by: Nibbler on May 08, 2008, 05:01:37 PM
UPDATE cpg_pictures SET title = caption

Change the prefix as appropriate.