Developers of Sympa

[Amos <address@concealed>]

Ah, that's OK.  After all this was a test system I was attempting to upgrade.

BTW, I re-created the Pg db and started things up.  When it tries to
mail out a message, I get:

Jun  3 15:30:25 localhost wwsympa[26191]: err Bulk::store() Unable to
add packet in bulkmailer_table "INSERT INTO bulkmailer_table
(messageidekey_bulkmailer,messageid_bulkmailer,packetid_bulkmailer,receipients_bulkmailer,returnpath_bulkmailer,robot_bulkmailer,listname_bulkmailer,
verp_bulkmailer, merge_bulkmailer, priority_message_bulkmailer,
priority_packet_bulkmailer,
reception_date_bulkmailer,delivery_date_bulkmailer) VALUES
('1f1d0efad4689742fb3e8e423450df9d',NULL,'a53a0c447013812c46483662ce2547d9','address@concealed','address@concealed','tlists.example.edu','stest1','0','','1','5','1275597025','1275597025')";
error : ERROR:  invalid input syntax for integer: ""

The problem appears to be with:

        verp_bulkmailer         smallint,
        merge_bulkmailer        smallint,
        priority_message_bulkmailer     int4,
        priority_packet_bulkmailer      int4,
        reception_date_bulkmailer       int4,
        delivery_date_bulkmailer        int4,




On Thu, Jun 3, 2010 at 2:37 PM, David Verdin <address@concealed> wrote:
> That's - unfortunately - normal. Sympa does the automatic upgrade for MySQL
> and SQLite only.
> For PostreSQL, you need to use the query you will find in the source
> directory in src/etc/script/ named create_db.Pg.
>
> Apply this query to your database and it will add the required column.
>
> Regards,
>
> david
>
> PS : Side note: one of our developper is currently working on a unified
> handling of database creation / upgrade. It should allow automatic creation
> and upgrade for all the supported RDBMS. So keep a stiff upper lip! :-)
>
> Amos a écrit :
>
> I thought I'd upgrade a test instance of sympa from 6.0.2 to 6.1b2.
> When I ran the "sympa.pl --upgrade" command, this is what I got:
>
> # /opt/sympa/bin/sympa.pl --upgrade
>
> info Configuration file read, default log level 0
> notice Sympa 6.1b.2 started
> notice Conf::checkfiles() Updating static CSS file
> /opt/sympa/static_content/css/style.css ; previous file renamed
> notice Conf::checkfiles() Updating static CSS file
> /opt/sympa/static_content/css/print.css ; previous file renamed
> notice Conf::checkfiles() Updating static CSS file
> /opt/sympa/static_content/css/fullPage.css ; previous file renamed
> notice Conf::checkfiles() Updating static CSS file
> /opt/sympa/static_content/css/print-preview.css ; previous file
> renamed
> DBD::Pg::st execute failed: ERROR:  column "wrong_login_count_user"
> does not exist
> LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...
>                                                              ^ at
> /opt/sympa/bin/List.pm line 4811.
> err List::get_user_db() Unable to execute SQL statement "SELECT
> email_user AS email, gecos_user AS gecos, password_user AS password,
> cookie_delay_user AS cookie_delay, lang_user AS lang , attributes_user
> AS attributes, data_user AS data, last_login_date_user AS
> last_login_date, wrong_login_count_user AS wrong_login_count,
> last_login_host_user AS last_login_host FROM user_table WHERE
> email_user = 'address@concealed,address@concealed,address@concealed' " : ERROR:
>  column "wrong_login_count_user" does not exist
> LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...
>                                                              ^
> notice Upgrade process...
> err Current version : 6.1b.2 ; no upgrade is required.
>