The mailing list for listmasters using Sympa

["Kissman, Paul (BLC)" <address@concealed>]

Folks,

 

A couple of weeks ago I sent out a call for help since our subscribers could not change their email through the “My preferences” option (User Preferences form).

 

At the time I conflated some of the errors having to do with reporting out to a web page with the actual transaction error itself.

 

Here is what is really going on.  I hope someone has some ideas.

 

I am on version 6.2.14.

 

User logs in and selects “My preferences”.

 

User enters new email address and submits.

 

The system generates a ticket and sends an email to the NEW EMAIL ADDRESS as per usual.

 

The user follows the link provided in the email message.

 

Error ensues.

 

I’ve added a bunch of debugging statements into wwsympa.fcgi, Sympa/User.pm, and Sympa/Database.pm to see where things are breaking.

 

1)      It looks like the first thing that happens is that wwsympa.fcgi tries to to a global_user_update for the user record of the NEW EMAIL ADDRESS

 

UPDATE user_table SET last_login_date_user=1461157811,last_login_host_user='146.243.180.XXX' WHERE (address@concealed')"

 

Since the new user record doesn’t exist in user_table yet, the update is quietly ignored.

 

2)      Then wwsympa.fcgi deletes any existing record for the NEW EMAIL ADDRESS, I guess so that the update doesn’t overwrite a pre-existing record.

3)      Finally,  wwsympa.fcgi tries to update the user record again

UPDATE user_table SET address@concealed' WHERE (address@concealed')"

 

The SQL looks fine.  When I execute it directly from the mysql command line, it does exactly what it is supposed to do.

 

However, when it runs from wwsympa.fcgi, it just breaks.

 

Apr 20 09:10:11 mblc wwsympa[14163]: err main::#1647 > main::do_change_email#20882 > Sympa::Report::reject_report_web#308 > Sympa::send_notify_to_listmaster#886 > Sympa::Spindle::new#39 > Sympa::Message::Template::new#121 DIED: Can't use string ("address@concealed"...) as a HASH ref while "strict refs" in use at /usr/local/sympa/bin/Sympa/Message/Template.pm line 121.

 

Or, a related message:

 

Sympa::Report::reject_report_web('intern', 'update_user_db_failed', HASH(0x6ca46a0), 'change_email', '', 'address@concealed', 'mblc.state.ma.us') called at /usr/local/sympa/bin/wwsympa.fcgi line 20882

 

And finally,  when I go to look at the user_table,  neither the old user nor the new user record exists.

 

So it feels as if the old user record got deleted somewhere, and therefore the sql update fails.  But I can’t figure out if this is actually what is going on, or when it is happening.

 

Any help would be appreciated.

 

 

 

Paul J. Kissman

Library Information Systems Specialist

Massachusetts Board of Library Commissioners

98 N. Washington St., Suite 401

Boston, MA  02114

address@concealed

mass.gov/mblc or mblc.state.ma.us

Phone: (617)725-1860 . (800)952-7403 (in-state)

Fax: (617)725-0140