Home Analyst Portal

Bulk-removal of comments and ratings

Leigh_KildayLeigh_Kilday Member Ninja IT Monkey ✭✭✭✭
In my test environment, truncating the KnowledgeArticle$Comment and KnowledgeArticle$Rating tables produced some errors when I tried to upgrade to 7.2.

Is there an easier way to bulk-delete these?

Comments

  • seth_coussensseth_coussens Member Ninja IT Monkey ✭✭✭✭
    What were the errors you were seeing? It's possible we store a few default values in those tables that are being looked at, but I'd have to see the errors to be able to tell you.
  • Leigh_KildayLeigh_Kilday Member Ninja IT Monkey ✭✭✭✭
    edited February 2017
    I should be able to find these again but I've forgotten where the installation logs go.

    From memory there was a duplicate key error and some other stuff.
Sign In or Register to comment.