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`) ...Continue Reading

The schemas look fine, but what are you changing in terms of content/format? I will need to know if there is breakage in the Joomla bridge and, if so, plan a coordinated release. Thanks, Bruce Dada Mail (Justin Simoni) wrote: I was helping a client with a slow Dada Mail and we were thinking that the SQL table schema could do with an overhaul. Here are the current optimized schemas - most of the changes have been to manage the data type a bit more finely. Any one see any problems? Anyone add any useful indexes? (MySQ ...Continue Reading

On 9/10/07, Mariano Absatz wrote: > Thanx a lot Justin... > > I just modified Mail::Send.pm like this (patch attached). > > Tonight I have to send a message to a large list. I'll let you know how it went. Well... the patch had a bug (my own, a classical excess of copy&paste bug)... I attach the correct one. It worked as intended, indeed. ...Continue Reading

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 diffe ...Continue Reading

I was helping a client with a slow Dada Mail and we were thinking that the SQL table schema could do with an overhaul. Here are the current optimized schemas - most of the changes have been to manage the data type a bit more finely. Any one see any problems? Anyone add any useful indexes? (MySQL) CREATE TABLE dada_settings ( list varchar(16), setting varchar(64), value text ); CREATE TABLE dada_subscribers ( email_id ...Continue Reading

Hello everyone, Just a heads-up that I'll be moving my World Headquarters about 15 blocks to the North this week, starting tomorrow. I'm foreseeing problems getting the internet hooked up at the new place, so I may be offline at the WHQ for a day or so. So that's the downside. The bright side of the move is - you should see the kitchen! ...Continue Reading

Thanx a lot Justin... I just modified Mail::Send.pm like this (patch attached). Tonight I have to send a message to a large list. I'll let you know how it went. On 9/10/07, Dada Mail (Justin Simoni) wrote: > > On Sep 7, 2007, at 12:01 PM, Mariano Absatz wrote: > > > did you finally do this? can you send me a patch? or else... at least > > you have a good guess of where should I do what? > > OK, here's basically the deal. In the dada/DADA/Mail/Send.pm file, > you'll have to find the, _ma ...Continue Reading

On Sep 7, 2007, at 12:01 PM, Mariano Absatz wrote: > did you finally do this? can you send me a patch? or else... at least > you have a good guess of where should I do what? OK, here's basically the deal. In the dada/DADA/Mail/Send.pm file, you'll have to find the, _make_general_headers subroutine. There's 2 lines there: [snip] require HTTP::Date; $gh{Date} = HTTP::Date::time2str(); [/snip] You'll want to comment/remove those. Seems like there's probably a reason I explicitly set the Date: header, al ...Continue Reading

On Sep 7, 2007, at 12:01 PM, Mariano Absatz wrote: > did you finally do this? can you send me a patch? or else... at least > you have a good guess of where should I do what? Naw, I haven't looked at it, I'll try to tonight. It's one of those, "Could be plugged up in a bunch of places.. but where *should* it be..." kind of problems; ...Continue Reading

On 8/24/07, Dada Mail (Justin Simoni) wrote: > > On Aug 24, 2007, at 12:36 PM, Mariano Absatz wrote: > > IIRC, 2.10.0 didn't do this (or is/was it a configuration setting?). > > > > I see two pros and two cons to this approach: > > pros) > > 1) You can "fix" the message and re-use the same copy again and again > > for a slight performance increase (this is in fact not valid if you > > change the "To:" address in each message) > > 2) You know to ...Continue Reading