Announcement

Collapse
No announcement yet.

how do i delete an entore phrasegroup

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how do i delete an entore phrasegroup

    Please tell me an Sql querry to reove an entire Phrase group from my database. Thanks in advance
    Last edited by shadiguy1; Mon 21 Feb '05, 7:08am.

  • #2
    I don't know for sure if this will work, so use with caution...

    First you need to get the phrasetypeid of the phrase group in question. Look at the phrasetype.phrasetypeid field in your database to get this information.

    Then you would run these queries on your database (backup first). The first query will remove the group. The second query will remove its phrases:

    Code:
    DELETE FROM phrasetype WHERE phrasetypeid = [color=red]X[/color]
    Code:
    DELETE FROM phrase WHERE phrasetypeid = [color=red]X[/color]
    Where X is the phrasetypeid of the phrase group.

    Aftering running these queries, you will probably need to prompt a rebuild of your language cache. You can do this in your:

    Admin CP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X