forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: MarkP on January 25, 2007, 05:44:01 pm

Title: Ok I searched and read for around a hour keyword question
Post by: MarkP on January 25, 2007, 05:44:01 pm

I want to edit some keywords....I cannot find where they are stored...it is to labor intensive to edit them thry the admin panel...I want to use My SQL to download into Excel or something else and re-upload. Which tables hold the keywords....I found the dict table but it only has a few keywords in it.

Title: Re: Ok I searched and read for around a hour keyword question
Post by: Nibbler on January 25, 2007, 05:46:14 pm

They are in the {prefix}_pictures table.

Title: Re: Ok I searched and read for around a hour keyword question
Post by: MarkP on January 25, 2007, 06:00:59 pm

Thanks for the quick reply!

Am I correct to assume I only edit that table then? What exactly does the dict table do?

Title: Re: Ok I searched and read for around a hour keyword question
Post by: Nibbler on January 25, 2007, 06:08:18 pm

Only edit that table (backup first) and then regenerate the keyword list from within CPG. It keeps a list of all keywords instead of having to read them from the db, process them, remove duplicates etc. each time they are needed.

Title: Re: Ok I searched and read for around a hour keyword question
Post by: MarkP on January 25, 2007, 06:11:06 pm

Thank you