Advanced search  

News:

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.
[more]

Pages: [1]   Go Down

Author Topic: Ok I searched and read for around a hour keyword question  (Read 2508 times)

0 Members and 1 Guest are viewing this topic.

MarkP

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Ok I searched and read for around a hour keyword question
« 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.
« Last Edit: January 25, 2007, 06:13:31 pm by GauGau »
Logged

Nibbler

  • Guest
Re: Ok I searched and read for around a hour keyword question
« Reply #1 on: January 25, 2007, 05:46:14 pm »
They are in the {prefix}_pictures table.
Logged

MarkP

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Ok I searched and read for around a hour keyword question
« Reply #2 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?
Logged

Nibbler

  • Guest
Re: Ok I searched and read for around a hour keyword question
« Reply #3 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.
Logged

MarkP

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Ok I searched and read for around a hour keyword question
« Reply #4 on: January 25, 2007, 06:11:06 pm »
Thank you
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.019 seconds with 15 queries.