Mariano,

The table that holds the email address can contain more than one list, that the same email address may be subscribed to:

CREATE TABLE dada_subscribers ( email_id int4 not null primary key auto_increment, email text(320), list varchar(16), list_type varchar(64), list_status char(1) );

Therefore it is very possible that at first glance you could have duplicates, but check the 'list' field too, as this is the key that differentiates between one list and another

SELECT DISTINCT(email) FROM dada_subscribers WHERE list='LISTNAME'

The above query should give you a list of unique addresses from your subscriber table Subsitute LISTNAME for your own

Not tested or even ran the query myself though, as no access to a test dada host at present

H

On 11/09/2007, Mariano Absatz el.baby@PROTECTED wrote: >

Hi,

I have a very large list (about 5k addresses) and every now I then I find an address that is duplicated that is, there are two entries for it in the database

The only way to solve this is to erase the address and re-add it (since you can't erase only one)

This is possible because the address field is not "unique" in the database (and then, if it were, it could also happen because of different capitalization)

I think this shouldn't happen, but maybe the problem happened some time ago with a different version of dada (I did several upgrades and a couple of migrations in the middle, and I don't intend to find the culprit)

What I'd really like to know is if there's an option to list the duplicated addresses easily (or if I have to review my poor sql knowledge and do it by myself)

Does anyone have a script to check for duplicated addresses? (I'm ok with plain sql if that's the case)

TIA

-- Mariano Absatz - El Baby el (dot) baby (AT) gmail (dot) com el (punto) baby (ARROBA:@) gmail (punto) com

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive: http://mojo skazat com/cgi-bin/dada/mail cgi/archive/dadadev

Mailing List Powered by Dada Mail http://mojo skazat com/cgi-bin/dada/mail cgi/what_is_dada_mail/