Title: Corrupted Comment DB data
Last modified: August 21, 2016

---

# Corrupted Comment DB data

 *  [scottareed](https://wordpress.org/support/users/scottareed/)
 * (@scottareed)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/)
 * When reviewing visitor comments, I noticed when doing a Quick Edit on the comment,
   the visitors e-mail has a bunch of code appended to the actual e-mail address.
   This is consistent across comments. Looks like this for e-mail _[redacted]_. 
   Not sure where this comes from, buts it’s the same code every time. Maybe corrupted
   comment DB?
 * `sckangeles@hotmail.com/* <![CDATA[ */(function(){try{var s,a,i,j,r,c,l,b=document.
   getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('
   data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=
   2){c=parseInt(a.substr(j,2),16)^r;s+=String.fromCharCode(c);}s=document.createTextNode(
   s);l.parentNode.replaceChild(s,l);}}catch(e){}})();/* ]]> */`

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Thread Starter [scottareed](https://wordpress.org/support/users/scottareed/)
 * (@scottareed)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4024856)
 * One other thing – the bogus code at the end of the e-mail address in a comment
   is not visible until you perform a Quick Edit. Once you select Update Comment,
   the code becomes visible in the right pane of the comment.
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4024885)
 * Can you replicate the problem using the default Twenty Thirteen theme with **
   all** plugins deactivated?
 *  Thread Starter [scottareed](https://wordpress.org/support/users/scottareed/)
 * (@scottareed)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4025030)
 * Wow. That’s a pretty tall order. This is a pretty tightly strung Woo Theme that
   doesn’t tolerate tweaking very well. And the plugins are numerous.
 * Tell me this. From looking at the code above, what is it? Plain vanilla HTML?
   php? css? DB related code? A mixture of all these? I have suspected for some 
   time that my comment DB is corrupt and needs the intervention of an SQL expert.
   I clean it daily with the “Optimize Database after Deleting Revisions” version
   2.6 by CAGE Web Designs. Would upgrading to WP v3.6 be advisable? Been wanting
   to do that.
 * I neglected to post a link to the site earlier. [http://scottalanreed.com](http://scottalanreed.com).
 *  Thread Starter [scottareed](https://wordpress.org/support/users/scottareed/)
 * (@scottareed)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4025034)
 * Thinking a bit more about this problem – I use no plugins related to Comments.
   Suspect plugins that would touch comments are Akismet and WP Super Cache.
 * I’ve had a problem for several months with slow SQL queries. Virtually ALL of
   the slow queries are for Akismet or updates to the comment DB. An SQL INSERT 
   into the wp_comments DB takes 8.5 seconds. Example where Akismet took 16 seconds
   to update the spam count.
 * # Wed Aug 7 16:43:25 2013
    # Query_time: 15.923687 Lock_time: 0.000091 Rows_sent:
   0 Rows_examined: 1 use (admin login confidential); SET timestamp=1375915405; 
   UPDATE `wp_options` SET `option_value` = ‘53319’ WHERE `option_name` = ‘akismet_spam_count’
 * Related to comment corruption? I have a separate thread for this issue at [http://wordpress.org/support/topic/slow-sql-queries-1?replies=1](http://wordpress.org/support/topic/slow-sql-queries-1?replies=1)
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4025035)
 * > That’s a pretty tall order.
 * There is no magic bullet in these situations. This is just the start of basic
   troubleshooting and is a process of elimination deliberately designed to locate
   the root cause as quickly as possible by first removing the most obvious and 
   common culprits via a series of (often) temporary steps.
 * Do you want to locate and, hopefully, fix the problem on your site? If “yes”,
   then please help us to help you and carry out the changes that we suggest.
 * Your theme & plugin settings are saved in your database and should be retained
   for future use.
 *  Thread Starter [scottareed](https://wordpress.org/support/users/scottareed/)
 * (@scottareed)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4025041)
 * You are 100% correct. The best way to solve a problem is to break it down into
   its parts and reassemble.
 * However, before doing that, I would like to follow the evidence that I am seeing
   and see where it leads. Let’s close this issue for now while I do that. When 
   all else fails, we’ll tear the site down.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Corrupted Comment DB data’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [scottareed](https://wordpress.org/support/users/scottareed/)
 * Last activity: [12 years, 9 months ago](https://wordpress.org/support/topic/corrupted-comment-db-data/#post-4025041)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics