DISQUS's WordPress Plugin and Duplicate Comments

1. I've installed DISQUS's WordPress plugin. I had tried it once before years ago.

Back then, I had export/import comment issues and ended up with duplicate comments in my WordPress database that I cleaned out myself.

Apparently though, another table in the database was still holding duplicate info from DISQUS even up to yesterday.

I followed the instructions over at DISQUS, and fortunately, when I synced the commenting systems here and there, all the DISQUS duplicates disappeared here but not over on DISQUS. DISQUS had imported the duplicates. It was a vicious circle (sort of).

I considered killing the blog and database table at DISQUS but opted rather to semi-manually delete only all the comments. I uninstalled everything about DISQUS here on the blog right down to cleaning the Options table, which DISQUS didn't do when I ran its uninstaller.

Early this morning (very early), I reinstalled and then did the export of all the comments here back to DISQUS. Currently, all of those comments are sitting somewhere in DISQUS's database under the status "Queued for import." Yesterday, they imported nearly instantly. Today, it's been many hours. DISQUS is indicating that 0% have been sucked in yet.

I'm hesitant to do anything because I don't want to trigger the duplicates issue if what I've done so far will have cleaned it up.

Anyway, this comment [was a test comment that I subsequently deleted] will at least test the system a bit in the interim and also serve to let those who look know that I haven't deleted every comment on this blog. They're all still there in the WordPress database. I can see them all via the admin dashboard.


2. Everything is working so far.

I think I like this system enough that even if there are duplicates, I'll get DISQUS's support involved to get to the bottom of it.

I did notice that the time-stamp on the duplicates and the text formatting was different. The time-stamp was 14 hours earlier than this blogs time. All the paragraphs were there but without any line spaces between them on a number of the dups.

I'm already missing the HTML-coding info of the old commenting system though.


3. Okay, DISQUS just finished importing 100%. It synced back to the blog, so the two comments above [were text comments that I simply copied over into this blog post] actually are in the WordPress database too. However, because all of the imported comments are still sitting in DISQUS's database as "deleted" (but can still be called back up), I believe it is clear that I must delete the blog and all comments over on DISQUS.

There's a one-button solution for that over there.

Then, I'll "uninstall" over here again and try to export from here and import over there. If all of this doesn't work, I'll get the support team involved.


4. DISQUS asked me why I'm deleting the blog and all comments from DISQUS. My answer:

I've had the duplicate-comment problem. I believe deleting and then recreating may help. Syncing got rid of all the duplicates in the WordPress database (it's a long story) but not on DISQUS. I manually deleted all the comments on DISQUS, but exporting from WordPress didn't overwrite those with approved comments.

I'm trying to fix this myself before bothering you all for help, which I will if this doesn't work.

After clicking delete, DISQUS said, "Please allow up to 48 hours for this website to be completely removed." Ugh.


5. Everything exported and imported fine with the exception of 6 comments that exceeded the 25,000 character limit. I just created 6 new comments with links to the old comments' text. That was a pain, but I didn't want to re-export/import for fear of re-creating the duplicate-comment problem.

As for that problem, just deleting the blog and comments on DISQUS wasn't enough. By the way, you do that at the bottom of Settings > General.

In addition to deleting the blog and comments on DISQUS (and waiting as explained above), I had to uninstall and reinstall the DISQUS plugin to get it to fetch the new API key. You uninstall on the Advanced Options settings page in your blog. Just go to Comments > DISQUS and click on Advanced Options. Scroll down, and you'll see "Uninstall." Concerning uninstalling, I had to click update the database and then do the "Uninstall" again before it actually showed that it had uninstalled. Then I simply hit the reinstall link, and the new API key was imported.

Lastly, I updated the DISQUS widgets I had installed previously. In the widget scripting code, I had to change the short name of the blog from "realliberalchristianchurch" to "rlcc," since I took the opportunity to change that name after I deleted the blog on DISQUS. I wanted to be sure that I wouldn't pick up any legacy database tables at DISQUS. That would have been highly unlikely, but I just figured making sure was so easy that it made no sense not to. Besides, "rlcc" is easier.

Why might this not work for you? Well, my duplicates came from exporting and importing twice impatiently many months ago. If memory serves, my system went down in mid-process. Your duplicates may be due to a different mistake.

There are some formatting problems, but a number of those are due to WordPress version changes over the years. WordPress hasn't always been backward compatible regarding html in comments and posts. I don't obsess about such things the way I used to.

Let me know via a comment if this helped you.

Donate


The following should appear at the end of every post:

According to the IRS, "Know the law: Avoid political campaign intervention":

Tax-exempt section 501(c)(3) organizations like churches, universities, and hospitals must follow the law regarding political campaigns. Unfortunately, some don't know the law.

Under the Internal Revenue Code, all section 501(c)(3) organizations are prohibited from participating in any political campaign on behalf of (or in opposition to) any candidate for elective public office. The prohibition applies to campaigns at the federal, state and local level.

Violation of this prohibition may result in denial or revocation of tax-exempt status and the imposition of certain excise taxes. Section 501(c)(3) private foundations are subject to additional restrictions.

Political Campaign Intervention

Political campaign intervention includes any activities that favor or oppose one or more candidates for public office. The prohibition extends beyond candidate endorsements.

Contributions to political campaign funds, public statements of support or opposition (verbal or written) made by or on behalf of an organization, and the distribution of materials prepared by others that support or oppose any candidate for public office all violate the prohibition on political campaign intervention.

Factors in determining whether a communication results in political campaign intervention include the following:

  • Whether the statement identifies one or more candidates for a given public office
  • Whether the statement expresses approval or disapproval of one or more candidates' positions and/or actions
  • Whether the statement is delivered close in time to the election
  • Whether the statement makes reference to voting or an election
  • Whether the issue addressed distinguishes candidates for a given office

Many religious organizations believe, as we do, that the above constitutes a violation of the First Amendment of the US Constitution.

Congress shall make no law respecting an establishment of religion, or prohibiting the free exercise thereof; or abridging the freedom of speech, or of the press; or the right of the people peaceably to assemble, and to petition the Government for a redress of grievances.

That said, we make the following absolutely clear here:

  • The Real Liberal Christian Church and Christian Commons Project not only do not endorse any candidate for any secular office, we say that Christianity forbids voting in such elections.
  • Furthermore, when we discuss any public-office holder's position, policy, action or inaction, we definitely are not encouraging anyone to vote for that office holder's position.
  • We are not trying to influence secular elections but rather want people to come out from that entire fallen system.
  • When we analyze or discuss what is termed "public policy," we do it entirely from a theological standpoint with an eye to educating professing Christians and those to whom we are openly always proselytizing to convert to authentic Christianity.
  • It is impossible for us to fully evangelize and proselytize without directly discussing the pros and cons of public policy and the positions of secular-office holders, hence the unconstitutionality of the IRS code on the matter.
  • We are not rich and wouldn't be looking for a fight regardless. What we cannot do is compromise our faith (which seeks to harm nobody, quite the contrary).
  • We render unto Caesar what is Caesar's. We render unto God what is God's.
  • When Caesar says to us that unless we shut up about the unrighteousness of Caesar's policies and practices, we will lose the ability of people who donate to us to declare their donations as deductions on their federal and state income-tax returns, we say to Caesar that we cannot shut up while exercising our religion in a very reasonable way.
  • We consider the IRS code on this matter as deliberate economic duress (a form of coercion) and a direct attempt by the federal government to censor dissenting, free political and religious speech.
  • It's not freedom of religion if they tax it.

And when they were come to Capernaum, they that received tribute money came to Peter, and said, Doth not your master pay tribute? He saith, Yes. And when he was come into the house, Jesus prevented him, saying, What thinkest thou, Simon? of whom do the kings of the earth take custom or tribute? of their own children, or of strangers? Peter saith unto him, Of strangers. Jesus saith unto him, Then are the children free. (Matthew 17:24-26)

  • Subscribe


  • Tom Usher

    About Tom Usher

    Employment: 2008 - present, website developer and writer. 2015 - present, insurance broker. Education: Arizona State University, Bachelor of Science in Political Science. City University of Seattle, graduate studies in Public Administration. Volunteerism: 2007 - present, president of the Real Liberal Christian Church and Christian Commons Project.
    This entry was posted in Uncategorized. Bookmark the permalink.
    •  
      I'm testing the DISQUS commenting system now that things seem to be working.
       

      • The moderation dashboard is a bit quirky. I had to click the following options several times and in different sequences before all of the most recent comments showed up properly: 

        Approved 
        Unapproved
        Flagged
        Spam

    • Нина Федоренко

      A program Disqus I did not like (some imported from blogger comments with distortion). So I removed the Disqus. And back to the form of a blogger. But all the comments that Iimported in the Discus, did not return back! Even the form to fill in comments ...Although, if you look at the settings, all comments are displayed ... How can I return everything. Please, help me...

      • Hello Nina,

        If you have not yet deleted your blog and all comments in Disqus's system, I would reinstall the plugin and run it's syncing feature, which you should find in the "Advanced Options" on your blog (if the blogger set-up is similar to that for WordPress, which I use). I would select "Remove all imported Disqus comments before syncing."

        If that doesn't work, I would suggest you contact Disqus's support team for help.

        I'm sorry I couldn't reply sooner, but I was working all day.

        Let me know if my suggestions work.

        Peace,

        Tom

      • Anonymous

        Thank you for your reply. But no blogger in the settings of these functions, you are talking about.A customer service Disqus I talk. But they can not (or will not?) to help me. The basic meaning of their messages - advertising services Disqus (!!!!)I am very disappointed ...

        • I'm sorry you are having problems with the Disqus system. I looked around a bit and have found that http://[your short name here].disqus.com/admin/tools/import/platform/blogger/ shows the following:

          "Keep new comments synced

          Enable this to keep comments on Disqus synced with Blogger."

          However, it does say "new." Therefore, enabling it now likely will not sync all comments on Disqus. Regardless, I am assuming that you did have that enabled but that it just hasn't worked for some reason.

          Unfortunately, everywhere I looked, I could find nothing about importing comments-only into Blogger. There is an export/import feature in Blogger, but unless they've updated it, it only works for whole Blogger blogs and not just the comments and not just some comments.

          If they have updated that feature, then on http://[your short name here].disqus.com/admin/tools/import/, you will find the XML export feature. The issue there though is avoiding creating duplicate comments in Blogger. Before importing into Blogger, I would manually edit the XML file so that only the non-synced comments remain in the file.

          If you have many comments and really want them in your Blogger blog, you might consider the following:

          1. Create a WordPress blog for free at WordPress.com.

          2. Export your Blogger into it.

          3. Import the Disqus comments into it too.

          4. Import WordPress blog into Blogger.

          I don't know how up-to-date this is, but it may give you ideas: http://a1posts.blogspot.com/2009/07/import-wordpress-into-blogger-blogger.html

          Let me add that I do not use WordPress.com for my blog. Mine is a standalone WordPress installation. To my understanding, WordPress.com bloggers don't have the option of installing plugins. Therefore, I really can't tell you exactly what import/export features there are on WordPress.com blogs. You'd have to create one to look at that aspect. That's where I'd start. If it can't import the export formats (there's more than one) available on Disqus, there would be no point in doing anything further with the idea.

          I hope this helps you. Let me know.

    • How did you guys detect and delete the duplicate comments without going into each one individually?  I've got like 10K comments and I cant figure out how to detect them and remove duplicates without doing it manually.  Would love it if anyone has a mySQL query or another method for how to remove the duplicate comments...  Thanks in advance. 

      • Hello Mark,

        Your comment went to spam via Disqus. I didn't see it until just now. It didn't strike me as spam, and neither does your Disqus "activity" (comments on other sites) in general.

        Well, I have to admit that I don't remember what it was about the Disqus comments that I used in MySQL to clean them out. It's been a long, long time -- I think years now.

        I wish I could have been of help. I do remember it was a royal pain.

        phpMyAdmin does let you increase the number of posts you can see from the default 30 to many hundreds. I've never pushed it to it's limits though. The loading time is a factor, but you can limit the fields to just the comment text. From there, you're tabbing and space barring I guess to do it manually -- not fun.

        I don't remember if that's how I did it, but I have used that method before for other problems.

    • I appreciate you for giving such a informative portal. Your site is not
      just informative but also very creative too. I Myself went over several
      websites to find information about this.I will check back often!!