Justin

Apologies - the lateness of the hour etc. and I sent the wrong one - I reset the variables back to the original text based file.

I have changed the password (I forgot about that - I was going to change it anyway because it is not appropriate anyway).

Please find attached the backup file that actually reflects what was there when the error occured.  You will notice that I had already removed the vertical bars.

Best regards
--
Martyn Davison




> Date: Thu, 7 Jan 2010 22:06:23 -0500
> From: justin@PROTECTED
> To: martyndavison@PROTECTED
> Subject: [dadadev] Re: Program Error (Server Error 500)
>
>
> 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';
>
> If what you said is true - you're not using an outside config file, you're still not going to be using the SQL backend, unless you change these lines to:
>
> $SUBSCRIBER_DB_TYPE ||= 'SQL';
> $ARCHIVE_DB_TYPE ||= 'SQL';
> $SETTINGS_DB_TYPE ||= 'SQL';
> $SESSION_DB_TYPE ||= 'SQL';
> $BOUNCE_SCORECARD_DB_TYPE ||= 'SQL';
> $CLICKTHROUGH_DB_TYPE ||= 'SQL';
>
> If you still receive that error, try replacing the, "||=" with, "=", like this:
>
> $SUBSCRIBER_DB_TYPE = 'SQL';
> $ARCHIVE_DB_TYPE = 'SQL';
> $SETTINGS_DB_TYPE = 'SQL';
> $SESSION_DB_TYPE = 'SQL';
> $BOUNCE_SCORECARD_DB_TYPE = 'SQL';
> $CLICKTHROUGH_DB_TYPE = 'SQL';
>
> And see if that makes things work correctly.
>
> You may want to try to do the same with the %SQL_PARAMS variable, where it says something like,
>
>
> %SQL_PARAMS = (
>
> # a whole bunch of things,
>
> ) unless keys %SQL_PARAMS;
>
> Replace,
>
> unless keys %SQL_PARAMS;
>
> with just,
>
> ;
>
>
> --
> Justin J.
>
> Dada Mail - Write Once: Distribute Everywhere Software
> url: http://dadamailproject.com
>
> The Dada Mail Demo:
> http://demo.dadamailproject.com
>
> On Jan 7, 2010, at 7:24 PM, Martyn Davison wrote:
>
> > Justin
> >
> > Many 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
> > > From: justin@PROTECTED
> > > To: martyndavison@PROTECTED
> > > Subject: [dadadev] Re: Program Error (Server Error 500)
> > >
> > >
> > > > 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 schema:
> > >
> > > http://github.com/justingit/dada-mail/blob/master/dada/extras/SQL/mysql4_schema.sql
> > >
> > > Which should work well with MySQL ver 4 (or finicky ver. 5)
> > >
> > >
> > > > I have made the various essential changes to the config.pm file outlined in example_dada_config.txt
> > >
> > > Can you post your .dada_config file? You can stop right before the $ADMIN_MENY variable (for brevity!)
> > >
> > > I've been getting a lot of repots, just like yours, regarding this error:
> > >
> > > > Base class package "DADA::MailingList::Subscribers::" is empty.
> > > > (Perhaps you need to 'use' the module which defines that package first.)
> > > > at /DADA/MailingList/Subscribers.pm line 33
> > >
> > > Make sure you do have these variables set like this:
> > >
> > > $SUBSCRIBER_DB_TYPE = 'SQL';
> > > $ARCHIVE_DB_TYPE = 'SQL';
> > > $SETTINGS_DB_TYPE = 'SQL';
> > > $SESSION_DB_TYPE = 'SQL';
> > > $BOUNCE_SCORECARD_DB_TYPE = 'SQL';
> > > $CLICKTHROUGH_DB_TYPE = 'SQL';
> > >
> > > If you need to, see if setting it directly in the Config.pm helps.
> > >
> > > --
> > > Justin J.
> > >
> > > Dada Mail - Write Once: Distribute Everywhere Software
> > > url: http://dadamailproject.com
> > >
> > > The Dada Mail Demo:
> > > http://demo.dadamailproject.com
> > >
> > > On Jan 7, 2010, at 11:57 AM, Martyn Davison wrote:
> > >
> > > > Hi
> > > >
> > > > I 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 provided with a very useful interface to create the necessary tables.
> > > >
> > > > I have made the various essential changes to the config.pm file outlined in example_dada_config.txt
> > > >
> > > > When I try to access the mail program now I get the following error
> > > > Base class package "DADA::MailingList::Subscribers::" is empty.
> > > > (Perhaps you need to 'use' the module which defines that package first.)
> > > > at /DADA/MailingList/Subscribers.pm line 33
> > > > BEGIN failed--compilation aborted at /DADA/MailingList/Subscribers.pm line 33.
> > > > Compilation failed in require at <path omitted>/cgi-bin/dada/mail.cgi line 202.
> > > > BEGIN failed--compilation aborted at <path omitted>/cgi-bin/dada/mail.cgi line 202.
> > > > I guess that I am missing something essential, like a switch somewhere, other than setting the 'five' variables to SQL and setting the $SQL_PARAMS
> > > >
> > > > What have I missed. Any suggestions welcome.
> > > >
> > > > Thank you in advance.
> > > >
> > > >
> > > > Best regards
> > > > --
> > > > Martyn Davison
> > > >
> > > >
> > > >
> > > > View your other email accounts from your Hotmail inbox. Add them now.
> > > > Post:
> > > > mailto:dadadev@PROTECTED
> > > > Unsubscribe:
> > > > http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/
> > > > List Information:
> > > > http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dadadev
> > > > Archive:
> > > > http://dadamailproject.com/cgi-bin/dada/mail.cgi/archive/dadadev
> > > > Mailing List Powered by Dada Mail
> > >
> > >
> > >
> > > --
> > >
> > > Post:
> > > <mailto:dadadev@PROTECTED>
> > >
> > > Unsubscribe:
> > > <http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/>
> > >
> > > List Information:
> > > <http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dadadev>
> > >
> > > Archive:
> > > <http://dadamailproject.com/cgi-bin/dada/mail.cgi/archive/dadadev>
> > >
> > > Mailing List Powered by Dada Mail
> > > http://dadamailproject.com/cgi-bin/dada/mail.cgi/what_is_dada_mail/=
> >
> > View your other email accounts from your Hotmail inbox. Add them now.
> > Post:
> > mailto:dadadev@PROTECTED
> > Unsubscribe:
> > http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/
> > List Information:
> > http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dadadev
> > Archive:
> > http://dadamailproject.com/cgi-bin/dada/mail.cgi/archive/dadadev
> > Mailing List Powered by Dada Mail
> > <Config.pm>
>
>
>
> --
>
> Post:
> <mailto:dadadev@PROTECTED>
>
> Unsubscribe:
> <http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/>
>
> List Information:
> <http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dadadev>
>
> Archive:
> <http://dadamailproject.com/cgi-bin/dada/mail.cgi/archive/dadadev>
>
> Mailing List Powered by Dada Mail
> http://dadamailproject.com/cgi-bin/dada/mail.cgi/what_is_dada_mail/=

---

Post:
mailto:[list_settings.discussion_pop_email]

Unsubscribe:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/

List Information:
[PROGRAM_URL]/list/[list_settings.list]

Archive:
[PROGRAM_URL]/archive/[list_settings.list]

Mailing List Powered by Dada Mail