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