The mailing list for listmasters using Sympa

[Matthew Goebel <address@concealed>]

Looks similar to mine ...

MariaDB [sympa]> describe logs_table;

+-------------------+--------------+------+-----+---------+-------+

| Field             | Type         | Null | Key | Default | Extra |

+-------------------+--------------+------+-----+---------+-------+

| action_logs       | varchar(50)  | NO   |     | NULL    |       |

| client_logs       | varchar(100) | YES  |     | NULL    |       |

| daemon_logs       | varchar(10)  | NO   |     | NULL    |       |

| date_logs         | int(11)      | NO   |     | NULL    |       |

| error_type_logs   | varchar(150) | YES  |     | NULL    |       |

| list_logs         | varchar(50)  | YES  |     | NULL    |       |

| msg_id_logs       | varchar(255) | YES  |     | NULL    |       |

| parameters_logs   | varchar(100) | YES  |     | NULL    |       |

| robot_logs        | varchar(80)  | YES  |     | NULL    |       |

| status_logs       | varchar(10)  | NO   |     | NULL    |       |

| target_email_logs | varchar(100) | YES  |     | NULL    |       |

| user_email_logs   | varchar(100) | YES  |     | NULL    |       |

| usec_logs         | int(6)       | YES  |     | NULL    |       |

+-------------------+--------------+------+-----+---------+-------+

13 rows in set (0.006 sec)

Thanks,

Matt

On Wed, Feb 18, 2026 at 10:07 AM Ruud Baart <address@concealed> wrote:

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

--

Matthew Goebel : maddress@concealed : Unix Jockey @ EMU : Hail Eris
Neo-Student, Net Lurker, Donut consumer, and procrastinating medher...
 "Always with the negative waves, Moriarty" - Oddball
 "Comfort the troubled, and trouble the comfortable." - Dietrich Bonhoeffer