RE: Dada Mail Developers Digest

 
From: "Spilker, Tyler spilkert@PROTECTED [Dada Mail Developers]" <dadadev@PROTECTED>
In-Reply-To: (no subject)
Date: August 16th 2019

I am not seeing the mountain of errors referencing that list by removing the two matching lines in the table you mentioned it also has resolved the issue where it was showing the deleted list in the dropdown menu on Admin and the switch menu. For reference, it seems that doing a list delete doesn’t purge the following settings which causes the previous issues.

 

dadadb=> select * from dada_settings where list='ENGLISH';

  list   |          setting           |   value

---------+----------------------------+------------

ENGLISH | scheduled_jobs_last_ran    | 1565968596

ENGLISH | schedule_last_checked_time | 1565969811

(2 rows)

 

j

From: dadadev@PROTECTED <dadadev@PROTECTED> On Behalf Of Dada Mail Developers
Sent: Friday, August 16, 2019 8:30 AM
To: Spilker, Tyler <spilkert@PROTECTED>
Subject: [dadadev] Dada Mail Developers Digest

 

 

From: justin@PROTECTED

1 Message(s)

Date: Thu Aug 15 16:05:03 2019
From: justin@PROTECTED
Subject: Re: Database errors after deleting list

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@PROTECTED 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

 

                                                           

rss/atom
‹ Re: Database errors after deleting list
Index
Re: Dada Mail Developers Digest ›
  • 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 is the developer discussion mailing list for Dada Mail.

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

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

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

Topics that are welcome:

  • Constructive critiques 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 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 -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

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.