Subject: The mailing list for listmasters using Sympa
List archive
- From: Ruud Baart <address@concealed>
- To: address@concealed
- Subject: [en@sympa] error inserting data in sympa database
- Date: Wed, 18 Feb 2026 15:02:18 +0100
Hi,
I get an error logging:
err main::#241 > Sympa::Spindle::spin#83 >
Sympa::Spindle::ProcessIncoming::_twist#249 >
Sympa::Log::db_log#332 >
Sympa::DatabaseDriver::PostgreSQL::do_prepared_query#105 >
Sympa::Database::do_prepared_query#383 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_logs, status_logs, error_type_logs,
user_email_logs, client_logs, daemon_logs) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?)": (22001) ERROR: value too long for type
character varying(50)
The table logs_table:
Table "public.logs_table" Column | Type | Collation | Nullable | Default -------------------+------------------------+-----------+----------+--------- date_logs | integer | | not null | robot_logs | character varying(80) | | | list_logs | character varying(50) | | | action_logs | character varying(50) | | not null | parameters_logs | character varying(100) | | | target_email_logs | character varying(100) | | | user_email_logs | character varying(100) | | | msg_id_logs | character varying(255) | | | status_logs | character varying(10) | | not null | error_type_logs | character varying(150) | | | client_logs | character varying(100) | | | daemon_logs | character varying(10) | | not null | usec_logs | integer | | |
So it must be column list_logs or action_logs. Perhaps this: in table list_table the column name_list is character varying(100). I suppose the column logs_table.list_logs should be of the same type.
Cordialement,
R.J. Baart
-
[en@sympa] error inserting data in sympa database,
Ruud Baart, 02/18/2026
-
Re: [en@sympa] error inserting data in sympa database,
Matthew Goebel, 02/18/2026
- Re: [en@sympa] error inserting data in sympa database, Phil Stracchino, 02/19/2026
-
Re: [en@sympa] error inserting data in sympa database,
Matthew Goebel, 02/18/2026
Archive powered by MHonArc 2.6.19+.