Loading

Re: Database errors after deleting list

 
From: "Justin J justin@PROTECTED [Dada Mail Developers]" <dadadev@PROTECTED>
Subject: Re: Database errors after deleting list
In-Reply-To: (no subject)
Date: August 15th 2019

I have noticed a number of errors referencing a list that was requested deleted several weeks back in the errors.txt file (/usr/share/httpd/dada/.dada_files/.logs/errors.txt)

I would just remove any reference to this listshortname in the dada_settings table.

Justin J: Lead Dadaist.url: http://dadamailproject.com email: justin@PROTECTED twitter: @dadamail skype: leaddadaist

Dada Mail Announcements:http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dada_announce/

On Aug 12, 2019, at 12:55 PM, Spilker, Tyler spilkert@PROTECTED [Dada Mail Developers] dadadev@dadamailproject.com wrote:

From: spilkert@PROTECTED Hi everyone,

I have noticed a number of errors referencing a list that was requested deleted several weeks back in the errors.txt file (/usr/share/httpd/dada/.dada_files/.logs/errors.txt)

The list was called “ENGLISH-L” with a shortname of “ENGLISH”

[Mon Aug 12 11:45:14 2019] mail.cgi: listshortname in db, 'ENGLISH' does not match saved list shortname: '' at /var/www/html/dada//DADA/App/Guts.pm line 943.

[Mon Aug 12 11:45:14 2019] mail.cgi: Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at /var/www/html/dada//DADA/App.pm line 371.

[Mon Aug 12 11:45:14 2019] mail.cgi: listshortname in db, 'ENGLISH' does not match saved list shortname: '' at /var/www/html/dada//DADA/App.pm line 371.

[Mon Aug 12 11:45:14 2019] mail.cgi: running scheduled jobs at teardown @ Mon Aug 12 11:45:14 2019 at /var/www/html/dada//DADA/App.pm line 377.

[Mon Aug 12 11:45:16 2019] mail.cgi: Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at DADA/MailingList/Schedules.pm line 48.

[Mon Aug 12 11:45:16 2019] mail.cgi: listshortname in db, 'ENGLISH' does not match saved list shortname: '' at DADA/MailingList/Schedules.pm line 48.

[Mon Aug 12 11:45:16 2019] mail.cgi: Pro Dadamail 11.3.0 Stable 04/25/19 warning! listshortname isn't defined! list settings sql db possibly corrupted! at DADA/MailingList/Schedules.pm line 379.

[Mon Aug 12 11:45:18 2019] mail.cgi: Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at plugins/bridge line 954.

[Mon Aug 12 11:45:18 2019] mail.cgi: listshortname in db, 'ENGLISH' does not match saved list shortname: '' at plugins/bridge line 954.

[Mon Aug 12 11:45:19 2019] mail.cgi: Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at plugins/bridge line 1165.

[Mon Aug 12 11:45:19 2019] mail.cgi: listshortname in db, 'ENGLISH' does not match saved list shortname: '' at plugins/bridge line 1165.

DBD::Pg::st execute failed: ERROR: value too long for type character varying(255) at DADA/Logging/Clickthrough/baseSQL.pm line 777, line 1.

Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at /var/www/html/dada//DADA/App/Guts.pm line 943.

listshortname in db, 'ENGLISH' does not match saved list shortname: '' at /var/www/html/dada//DADA/App/Guts.pm line 943.

Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at /var/www/html/dada//DADA/App/Guts.pm line 943.

listshortname in db, 'ENGLISH' does not match saved list shortname: '' at /var/www/html/dada//DADA/App/Guts.pm line 943.

Pro Dadamail 11.3.0 Stable 04/25/19 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at /var/www/html/dada//DADA/App.pm line 371..

But it send lots and lots of similar errors. In addition, I see the following entry in the Admin interface and if I select it when logging in with the admin root password it will throw an error and ill be unable to access the admin interface (due to being logged in) without manually going through a specific list and selecting its Admin link.

I don’t see anywhere this list should still exist. I do see some entries in the database in dada_settings, dada_privacy_policies, dada_confirmation_tokens, dada_mass_mailing_event_log, and dada_consent_activity tables that reference the shortname but nothing that seems really suspicious. Any suggestions on how to clean this up? It was deleted through the standard way described in the docs and on the site FAQ.

Any suggestions on how to clean this up to help me eliminate some superfluous errors would be appreciated. Im getting reports of some users getting error messages and its tough to troubleshoot due to all the errors showing up or even tell if this is related to the issues they are seeing

Tyler Spilker Linux System Administrator Information Technology Services

Foley LL

www.gonzaga.edu

Dada Mail Developers Post to: Dada Mail Developers ( dadadev@PROTECTED )Manage Your Subscription Unsubscribe

  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)
  • Start a new thread, email:

    dadadev@dadamailproject.com

This mailing list is to discuss the nerdy programming development of Dada Mail -

If you are just looking for support Dada Mail, consult the message boards at:

http://dadamailproject.com/support/boards

To post to this list, send a message to:

 dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Some on topic... topics include:

  • Positive Crits on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own internal needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

At the moment, there aren't many people with CVS access for Dada Mail - if you would like CVS access, please first talk about the changes you propose and how it will affect the program. If the idea is sound and agreed upon, the change will be comitted. A good track record of this will allow you to have CVS access. Some reasons that patches will not be accepted is if the patch breaks compatibility with a previous version of the program, the patch is too centric to your own problem or the patch simply isn't very good.

Please, please please familiarize yourself with the documentation at:

 http://dadamailproject.com/support/documentation/

Since no one wants to answer the same question twice.

Another sneaky reason for this mailing list is to test out the discussion list capabilities of Dada Mail, since Dada Mail is used for the mailing list itself.

NOTE - because of this, there may be times that this list will be somewhat broken. Although we're not planning on breaking the program by using it, we're giving you the heads up that this may well happen anyways.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.

 

Unsubscribe at Anytime | Privacy Policy

Dada Mail Project

Download

Installation

Support