The mailing list for listmasters using Sympa

[Emmanuel Bouthenot <address@concealed>]

On Sun, Jul 06, 2014 at 03:54:38PM -0300, Daniel Viñar Ulriksen wrote:
[...]

> First I'm triyng to install a clean 6.1.22 on a debian wheezy server.
/me also (I'm the maintainer of sympa in Debian and I made the
backport)

[...]

> Jul  6 15:42:29 watson wwsympa[32333]: err ::load() Unable to execute SQL 
> statement "SELECT id_session AS id_session, prev_id_session AS 
> prev_id,#012#011#011     date_session AS "date",#012#011#011     
> remote_addr_session AS remote_addr,#012#011#011     email_session AS 
> email,#012#011#011     data_session AS data, hit_session AS 
> hit,#012#011#011     start_date_session AS start_date,#012#011#011     
> refresh_date_session AS refresh_date#012#011      FROM 
> session_table#012#011      WHERE id_session = ? AND prev_id_session IS NOT 
> NULL OR#012#011#011    prev_id_session = ?" : ERROR:  no existe la columna 
> <AB>prev_id_session<BB>#012LINE 1: SELECT id_session AS id_session, 
> prev_id_session AS prev_id,#012                                         ^
> Jul  6 15:42:29 watson wwsympa[32333]: err 
> List::send_notify_to_listmaster() 
> List::send_notify_to_listmaster(failed_to_create_web_session,watson.csic.edu.uy)
>  : error on incoming parameter "$param", it must be a ref on HASH or a ref 
> on ARRAY
> Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] 
> [client 179.25.174.99] Failed to create session
> Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] 
> [session 35705656223149] [client 179.25.174.99] main::do_firstpasswd() 
> do_firstpasswd()
> Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] 
> [session 35705656223149] [client 179.25.174.99] main::do_renewpasswd() 
> do_renewpasswd()
> Jul  6 15:42:29 watson wwsympa[32333]: err SympaSession::store() Unable to 
> update session information in database while execute SQL statement "INSERT 
> INTO session_table#012#011      (id_session, prev_id_session,#012#011       
> date_session, refresh_date_session,#012#011       remote_addr_session, 
> robot_session,#012#011       email_session, start_date_session, 
> hit_session, data_session)#012#011      VALUES ('35705656223149', 
> '35705656223149', 1404672149, 1404672149, '179.25.174.99', 
> 'watson.csic.edu.uy', 'nobody', 1404672149, 1, 
> ';is_family_owner="";redirect_url="https://watson.csic.edu.uy/wws/firstpasswd/";data="";')"
>  : ERROR:  no existe la columna <AB>prev_id_session<BB> en la relaci<F3>n 
> <AB>session_table<BB>#012LINE 2:        (id_session, prev_id_session,#012   
>                          ^
Are you using sympa on top of a PostgreSQL database ?

M.

-- 
Emmanuel Bouthenot
  mail: kolter@{openics,debian}.org    gpg: 4096R/0x929D42C3
  xmpp: address@concealed          irc: kolter@{freenode,oftc}