Hey, really nice handy module, but does not work with PostgreSQL.
Here is explanation why this happens:
http://www.postgresql.org/message-id/2493.1045885186@sss.pgh.pa.us
I`ve created the patch to fix the issue and tested it with PostgreSQL. No testing with MySQL was done, but I think it must work like a charm.

CommentFileSizeAuthor
postgresql_fix.patch1.69 KBRealGecko

Comments

  • Sami Radi committed 70c0656 on 7.x-1.x 
    * Issue #2137965: Duplicates search NOT case sensitive
* Issue #2425895...
sami radi’s picture

sami radi commented
Version: 7.x-1.2 » 7.x-1.3
Status: Patch (to be ported) » Fixed

Hello,

I've fixed the issue for PostgreSQL in the latest release, could you check it out.

Best regards.

sami radi’s picture

sami radi commented
Status: Fixed » Closed (fixed)
RealGecko’s picture

RealGecko commented

With version 1.3 I get the following error
PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "s.title" must appear in the GROUP BY clause or be used in an aggregate function LINE 7: (SELECT s.title AS title, COUNT(*) AS duplicate, md5(s.title... ^: SELECT n.nid AS nid, n.uid AS uid, n.status AS status, n.created AS created, n.changed AS changed, n.title AS title, u.name AS name FROM {node} n INNER JOIN {users} u ON n.uid = u.uid INNER JOIN (SELECT n.title AS title FROM (SELECT s.title AS title, COUNT(*) AS duplicate, md5(s.title) AS checksum FROM {node} s WHERE (s.type = :db_condition_placeholder_2) GROUP BY checksum) n WHERE (duplicate > :db_condition_placeholder_1) ) nn ON md5(n.title) = md5(nn.title) WHERE (n.type = :db_condition_placeholder_0) ORDER BY title ASC; Array ( [:db_condition_placeholder_0] => news [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => news ) в функции _remove_duplicates_get_nodes() (line 905 in remove_duplicates.module).

sami radi’s picture

sami radi commented

Hello,

Fixed in the latest commit, release will be out soon.

Best Regards.