Could you please change your password? Since you just gave it to me in the file... > I have actually done just that and put the settings that you mention in the config.pm file (attached). Where? I'm having trouble seeing where you might have configured the SQL stuff. All I found was: $SUBSCRIBER_DB_TYPE ||= 'PlainText'; $ARCHIVE_DB_TYPE ||= 'Db'; $SETTINGS_DB_TYPE ||= 'Db'; $SESSION_DB_TYPE ||= 'Db'; $BOUNCE_SCORECARD_DB_TYPE ||= 'Db'; $CLICKTHROUGH_DB_TYPE ||= 'Db'; I ...Continue Reading

JustinMany thanks for the email.I am glad (sort of) that I am not the only one getting these errors.I have actually done just that and put the settings that you mention in the config.pm file (attached).Currently I am only running with the config.pm file as I have not yet sorted out the new features.  When I get this phase working I may well go down the separate configuration file if only to have the luxury of not having to reconfigure every time.Best regards--*/Martyn/*> Date: Thu, 7 Jan 2010 14:26:18 -0500> ...Continue Reading

> I have got the mySQL database configured (after a load of error messages - perhaps because my database is mySQL 4.1.22 and not the latest one). I have followed the instructions in "configuration-sql_backend.html" given that I do not have access to cPanel and myPHP latest does not work because I have an earlier version on my host package - a version of myPHP is provided with a very useful interface to create the necessary tables. If you have problems on another install, check out this version of the sche ...Continue Reading

HiI have been using the 'basic' DADAMail for some time in one location but another application requires more complex subscribing using the SQL back end.I have got the mySQL database configured (after a load of error messages - perhaps because my database is mySQL 4.1.22 and not the latest one). I have followed the instructions in "configuration-sql_backend.html" given that I do not have access to cPanel and myPHP latest does not work because I have an earlier version on my host package - a version of myPHP is ...Continue Reading

Here are the direct downloads: * tar.gz http://cloud.github.com/downloads/justingit/dada-mail/dada-4_0_1.tar.gz * zip http://cloud.github.com/downloads/justingit/dada-mail/dada-4_0_1.zip Changes: Changes 4.0.1 New Documentation The following topics were added to the documentation: * Converting from Default to SQL Backend http://dadamailproject.com/support/documentation/FAQ-default_2_SQL_backend.pod.html * Converting from a Basic to Advanced Installation http://dadamailproject.com/support/documentation/FA ...Continue Reading

On Dec 9, 2009, at 4:59 PM, Frans Gouverne wrote: > So It should look something like: > > 1. get all email addresses which have a list type "sub_confirm_list" or "unsub_confirm_list" > 2. remove this email address only if the same email address with list type "list" is present > > Guess I have to add this API myself to baseSQL, or? > This script will give you a good start on something like that, #!/usr/bin/perl use lib ( . / ./DADA/perllib ); use DADA::App::G ...Continue Reading

2009/12/9 Justin J <justin@PROTECTED> On Dec 9, 2009, at 1:57 PM, Frans Gouverne wrote: > When adding subscribers, remove status "waiting for confirmation" (this will slow down the process for large lists) I'm fearing a potentially large number of people working with Dada Mail are not going to know what the heck that means :) > OR: > > Add a table-clean feature which can be run from a cron job at night. Here's what that would look like: #!/usr/bin/perl use lib (./ ./DADA/perllib) use DAD ...Continue Reading

On Dec 9, 2009, at 1:57 PM, Frans Gouverne wrote: > When adding subscribers, remove status "waiting for confirmation" (this will slow down the process for large lists) I'm fearing a potentially large number of people working with Dada Mail are not going to know what the heck that means :) > OR: > > Add a table-clean feature which can be run from a cron job at night. Here's what that would look like: #!/usr/bin/perl use lib (./ ./DADA/perllib) use DADA::App::Guts; use DADA::MailingList::Sub ...Continue Reading

2009/12/8 Justin J <justin@PROTECTED> > �When following next two steps, an email address will be added twice to the SQL subscribers data base: > � � � � Add an email address by means of the default subscriber screen. The email address will be added to the data base with list_type = "sub_confirm_list". > � � � � Do not confirm the subscription, but add the same email address by means of the admin control panel: the email address will be added for the second time but now with list_type="lis ...Continue Reading

2009/12/8 Justin J <justin@PROTECTED> > �For at least the following two template files: > > error_already_sent_sub_confirmation_screen.tmpl > error_already_sent_unsub_confirmation_screen.tmpl > > the tmpl_var: > > <!-- tmpl_var list_settings.list_owner_email --> > > must be changed into: > > <!-- tmpl_var subscriber.email --> Huh, why? What the screens are saying is to add the list owner email address to your whitelist/address book, not your own address - right?Sor ...Continue Reading