Purge (Delete) all comments

NC Software · **Purge (Delete) all comments -** 11-08-2008, 08:16 PM

Spam'd like crazy thanks to having no way to turn off comments in the Knowledgebase, etc., how do I purge comments from my database to clear them now that 3.30 has captcha on comments?

P.S. I'd still like the option to disable comments altogether!!!

**Jamie Edwards** · 09:57 PM

Hi Neal,

A simple

Code:

delete * from swcommentdata;
delete * from swcomments;

should do the trick.

NC Software · 11-08-2008, 09:49 PM

DELETE FROM swcomments
DELETE FROM swcommentdata

**Jamie Edwards** · 11-08-2008, 09:57 PM

Whoops, left the first out. Corrected.

**bear** · 12-08-2008, 01:02 PM

How do I get the "count" to go away? I'd disabled commenting long ago, but it still shows the number of comments as it was when I removed them from the DB. Is that taken from the auto-increment field for one of those two tables?

supportskins · 12-08-2008, 05:56 PM

You mean the count displayed in the Staff CP?

**bear** · 12-08-2008, 06:07 PM

Yes, that one. I find it kind of annoying.

Comments (39) <- make that vanish, since there are no comments at all.

**Jamie Edwards** · 12-08-2008, 06:18 PM

Hi bear,

Try clear out all of the .js files inside of your /files/ and /cache/ folders.

**bear** · 12-08-2008, 09:22 PM

Done, no change. The file in cache that contains it is 'staffcpmenuclick.js'. Removed it (as well as all cached pages), reloaded staffcp...it's back, as is the comment count. Any idea where it's getting this number from?
The two tables related to KB comments are autoincrement, and have no content (truncated). I tried adding a comment, it set the count to 1. Deleted, emptied cache, still 39.
Like I mentioned, frustrating.

NC Software · 14-08-2008, 02:16 PM

Same here, ran the SQL to purge the nonsense, how do I get my toolbar counters to reset? It's not the cache!

**Jamie Edwards** · 14-08-2008, 02:25 PM

Please try and run: /staff/index.php?_ca=rebuildcache

The numbers may have been cached in the database (swregistry). This command should refresh it.

NC Software · 14-08-2008, 02:36 PM

Quote:

Originally Posted by Jamie Edwards

Please try and run: /staff/index.php?_ca=rebuildcache

The numbers may have been cached in the database (swregistry). This command should refresh it.

No change. Rather than hunting and pecking, tell me exactly where the information comes from, i.e. RESEARCH with your developers, and then offer a solution.

Thank you.

NC Software · 23-08-2008, 12:36 PM

Still waiting on the reply so we can clear the counters from our toolbars.

**Jamie Edwards** · 23-08-2008, 01:15 PM

Please submit a support ticket and one of our technicians will investigate why the cached comment count isn't being rebuilt.

NC Software · 23-08-2008, 01:19 PM

You can submit it, multiple people have identified the problem.

Thank you for your customer service and handling this on OUR behalf.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Logged (SWIFTFOUR-431) Delete Comments Spam	Kamran	Commenting and social features	8	14-12-2009 07:01 PM
Disabling comments and stopping comment spam	bear	Developers & Code	12	18-04-2008 08:55 AM
Unapproved COmments in Manage News » Comments	mwerts	SupportSuite, eSupport and LiveResponse	1	22-02-2008 10:07 PM
How do I delete comments in eSupport?	kbandrews	How do I?	1	25-11-2007 02:43 AM

NC Software Offline Member Posts: 568 Join Date: Dec 2005 Location: Sitting	Purge (Delete) all comments - 11-08-2008, 08:16 PM Spam'd like crazy thanks to having no way to turn off comments in the Knowledgebase, etc., how do I purge comments from my database to clear them now that 3.30 has captcha on comments? P.S. I'd still like the option to disable comments altogether!!! Neal Culiner NC Software, Inc. Visual Basic .NET Forums 3.70

NC Software Offline Member Posts: 568 Join Date: Dec 2005 Location: Sitting	11-08-2008, 09:49 PM DELETE FROM swcomments DELETE FROM swcommentdata Neal Culiner NC Software, Inc. Visual Basic .NET Forums 3.70

Jamie Edwards Offline Operations Manager Posts: 7,373 Join Date: Jan 2006 Location: England, UK	11-08-2008, 09:57 PM Whoops, left the first out. Corrected. Jamie Edwards (jamie.edwards ]at[ kayako.com) ------------------------------------------------------------------- Connect with Kayako on: Twitter, Facebook and LinkedIn Receive technical support via the members area The ultimate V4 FAQ thread.

bear Offline Community Moderator Posts: 730 Join Date: Jan 2005	12-08-2008, 01:02 PM How do I get the "count" to go away? I'd disabled commenting long ago, but it still shows the number of comments as it was when I removed them from the DB. Is that taken from the auto-increment field for one of those two tables? ...read me...

supportskins Offline Senior Member Posts: 5,247 Join Date: Aug 2006 Location: Mumbai, India	12-08-2008, 05:56 PM You mean the count displayed in the Staff CP? Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ - NEW SKIN ADDED!! SupportSkins.com - http://www.supportskins.com/

bear Offline Community Moderator Posts: 730 Join Date: Jan 2005	12-08-2008, 06:07 PM Yes, that one. I find it kind of annoying. Comments (39) <- make that vanish, since there are no comments at all. ...read me...

NC Software Offline Member Posts: 568 Join Date: Dec 2005 Location: Sitting	14-08-2008, 02:16 PM Same here, ran the SQL to purge the nonsense, how do I get my toolbar counters to reset? It's not the cache! Neal Culiner NC Software, Inc. Visual Basic .NET Forums 3.70

NC Software Offline Member Posts: 568 Join Date: Dec 2005 Location: Sitting	23-08-2008, 12:36 PM Still waiting on the reply so we can clear the counters from our toolbars. Neal Culiner NC Software, Inc. Visual Basic .NET Forums 3.70

NC Software Offline Member Posts: 568 Join Date: Dec 2005 Location: Sitting	23-08-2008, 01:19 PM You can submit it, multiple people have identified the problem. Thank you for your customer service and handling this on OUR behalf. Neal Culiner NC Software, Inc. Visual Basic .NET Forums 3.70