Developers of Sympa

[Olivier Salaun <address@concealed>]

> Straub Herbert wrote:
> [...]
> With postgresql i get in sympa.log the error:
> 
> May 23 09:50:48 koala postgres[10359]: [3] ERROR:  Attribute 
> 'comment_subscriber' not found
> May 23 09:50:48 koala sympa[10353]: Unable to execute SQL statement "SELECT 
> user_subscriber
> AS email, comment_subscriber AS gecos, reception_subscriber AS reception, 
> visibility_subscriber 
> AS visibility, bounce_subscriber AS bounce, 
> date_part('epoch',date_subscriber) AS date FROM
> subscriber_table WHERE (list_subscriber = 'alpha-l' ) ORDER BY email"
> : ERROR:
> 
> In which way i can do the upgrade with postgresql?

As told in the RELEASE_NOTES :
*****   New field in table subscriber_table : comment_subscriber
*****   You **MUST** change your database sctructure:
*****   ALTER TABLE subscriber_table ADD comment_subscriber varchar (150);

I don't know if this query works with Pg.
Please tell us, or provide corrections.


Regards

--
Olivier Salaün
Comité Réseau des Universités