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: Ok I searched and read for around a hour keyword question  (Read 2454 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.017 seconds with 20 queries.