Skip to Content.
Sympa Menu

en - [en@sympa] error inserting data in sympa database

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.19+.

Top of Page