The mailing list for listmasters using Sympa

[Attila Bardi <address@concealed>]

Hey,

I made a backup from the sqlite database file, then used the procedure:

https://sympa-community.github.io/manual/install/setup-database-sqlite.html

After that: sympa.pl --sync_list_db

Now it seems fine.

--
Attila Bardi

On 2020. Feb 15., at 20:04, Attila Bárdi <address@concealed> wrote:

Dears,

after updated sympa (to 6.2.40~dfsg-1) on my debian (debian updated also from 9 to 10) I’m unable to create new list, or add user to existing list.

When I create a new list I’m unable to add the owner, and the receiving email from sympa:

No owner is defined for list test-l.
The list status has been set to error_config.
Check the Sympa log files for more information.

In the logs I have this message:

Feb 15 13:39:58 moretus sympa_msg[30996]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::ToList::_twist#128 > Sympa::Log::db_log#320 > Sympa::DatabaseDriver::SQLite::do_prepared_query#581 >
Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "INSERT INTO logs_table (date_logs, usec_logs, robot_logs, list_logs, action_logs, parameters_logs, target_email_logs, msg_id_log
s, status_logs, error_type_logs, user_email_logs, client_logs, daemon_logs) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)": (S1000) NOT NULL constraint failed: logs_table.id_logs
Feb 15 13:39:58 moretus sympa_msg[30996]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::ToList::_twist#128 > Sympa::Log::db_log#334 Unable to insert new db_log entry in the database


I would appreciate any advice/hint/solution.
Worst case I will try to reinstall it from scratch.

Thanks!

Cheers,
Attila