551700 - Comments are duplicated

Status: RESOLVED FIXED

(Websites Graveyard :: opentochoice.org, defect, P1)

Description

[Francois]

User-Agent:       Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6
Build Identifier: 

comments duplicated either in Dutch or as error message: "Machine translation failed. retry". Might be linked to bug 551290


Reproducible: Always

Comment 1

[Javier Morales]

I tried this in live and were able to replicate it on stage. It is not related with bug 551290. Apparently it is caused by a feature in WPML that enables the admin of a site to have the comments automatically translated to his own language. Those translations should not be shown to the not logged users, but for some reason they are being shown at the moment. 

You can see the problem replicated in stage2 at http://opentochoice2.stage.mozilla.com/2010/02/web-browser-choice-matters/

Comment 2

[Javier Morales]

Attachment: SQL script that removes the duplicated comments inserted by WPML

I discover the cause of the problem. When a registered user selects in his profile to see the comments translated to his language, and goes to the single view of an article, WPML contacts google to translate the comments and add a new comment on the Wordpress comments table. Using a WPML table call wp_icl_translations we can tell which comments were translated and delete them from the comments table. 

The attached script removes the duplicate comments, but please note that if another user selects to translate comments it might happen again and the script will have to be re-executed.

Comment 3

[Alex Buchanan [:abuchanan]]

(In reply to comment #2)
> Created an attachment (id=432002) [details]
> SQL script that removes the duplicated comments inserted by WPML
> 
> I discover the cause of the problem. When a registered user selects in his
> profile to see the comments translated to his language, and goes to the single
> view of an article, WPML contacts google to translate the comments and add a
> new comment on the Wordpress comments table. Using a WPML table call
> wp_icl_translations we can tell which comments were translated and delete them
> from the comments table. 
> 
> The attached script removes the duplicate comments, but please note that if
> another user selects to translate comments it might happen again and the script
> will have to be re-executed.

Filed bug 552438 to run the SQL on *stage*

Is there a way to disable this "feature" so it doesn't happen again?  We shouldn't fix this problem more than once :)

Comment 4

[Javier Morales]

I have not find a way to disable it Alex, I will revisit this later this week but we should run the script on production as soon as we can. 
I recommend creating a backup or a dump before running it just in case something goes wrong.

Comment 5

[Alex Buchanan [:abuchanan]]

file bug 552564 to run the SQL on production.

Thanks Javier

Comment 6

[Javier Morales]

No problem Alex :)

Comment 7

[Staś Małolepszy :stas]

Marking fixed and adding the [wiki] whiteboard status so that we remember to document this.