Skip to Content.
Sympa Menu

en - [sympa-users] rebuilding the list_table DB getting error "(HY000) Field 'editors_list' doesn't have a default value".

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Dev List <address@concealed>
  • To: "address@concealed" <address@concealed>
  • Subject: [sympa-users] rebuilding the list_table DB getting error "(HY000) Field 'editors_list' doesn't have a default value".
  • Date: Thu, 9 May 2019 14:39:03 +0000

I am having difficulties rebuilding the "list_table" DB, getting error
"(HY000) Field 'editors_list' doesn't have a default value".


I set log_level to 4

# perl /home/sympa/bin/sympa.pl --version
Sympa 6.2.42

# perl /home/sympa/bin/sympa.pl --health_check
(no output)

# perl /home/sympa/bin/sympa.pl --sync_list_db --list="address@concealed"
(no output)

# tail /var/log/sympa/sympa.log

May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3
Sympa::Database::do_prepared_query() Will perform query "UPDATE list_table
SET status_list = ?, name_list = ?, robot_list = ?, family_list = ?,
creation_epoch_list = ?, creation_email_list = ?, update_epoch_list = ?,
update_email_list = ?, searchkey_list = ?, web_archive_list = ?, topics_list
= ? WHERE robot_list = ? AND name_list = ?"
May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3
Sympa::Database::do_prepared_query() Did not find prepared statement for
UPDATE list_table SET status_list = ?, name_list = ?, robot_list = ?,
family_list = ?, creation_epoch_list = ?, creation_email_list = ?,
update_epoch_list = ?, update_email_list = ?, searchkey_list = ?,
web_archive_list = ?, topics_list = ? WHERE robot_list = ? AND name_list = ?.
Doing it
May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3
Sympa::Database::do_prepared_query() Will perform query "INSERT INTO
list_table (status_list, name_list, robot_list, family_list,
creation_epoch_list, creation_email_list, update_epoch_list,
update_email_list, searchkey_list, web_archive_list, topics_list) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3
Sympa::Database::do_prepared_query() Did not find prepared statement for
INSERT INTO list_table (status_list, name_list, robot_list, family_list,
creation_epoch_list, creation_email_list, update_epoch_list,
update_email_list, searchkey_list, web_archive_list, topics_list) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?). Doing it
May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3
Sympa::Database::connect(Sympa::DatabaseDriver::MySQL
<db_host=localhost;db_name=sympa;db_port=3306;db_user=sympa>)
May 9 10:25:34 ET1772xubuntu sympa[2300]: debug3 Sympa::Database::connect()
Connection to database Sympa::DatabaseDriver::MySQL
<db_host=localhost;db_name=sympa;db_port=3306;db_user=sympa> already available
May 9 10:25:34 ET1772xubuntu sympa[2300]: err main::#1023 >
Sympa::List::_update_list_db#9260 > Sympa::Database::do_prepared_query#382
Unable to execute SQL statement "INSERT INTO list_table (status_list,
name_list, robot_list, family_list, creation_epoch_list, creation_email_list,
update_epoch_list, update_email_list, searchkey_list, web_archive_list,
topics_list) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)": (HY000) Field
'editors_list' doesn't have a default value
May 9 10:25:34 ET1772xubuntu sympa[2300]: err main::#1023 >
Sympa::List::_update_list_db#9292 Unable to update list Sympa::List
<address@concealed> in database


mysql> desc list_table;
+---------------------+----------------------------------------------------------------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+---------------------+----------------------------------------------------------------+------+-----+---------+-------+
| creation_email_list | varchar(100)
| NO | | NULL | |
| creation_epoch_list | int(11)
| YES | | NULL | |
| editors_list | varchar(100)
| NO | | NULL | |
| name_list | varchar(100)
| NO | PRI | NULL | |
| owners_list | varchar(100)
| NO | | NULL | |
| path_list | varchar(100)
| NO | | NULL | |
| robot_list | varchar(100)
| NO | PRI | NULL | |
| status_list |
enum('open','closed','pending','error_config','family_closed') | NO | |
NULL | |
| subject_list | varchar(100)
| NO | | NULL | |
| topics_list | varchar(255)
| YES | | NULL | |
| web_archive_list | tinyint(1)
| NO | | NULL | |
| family_list | varchar(50)
| YES | | NULL | |
| searchkey_list | varchar(255)
| YES | | NULL | |
| total_list | int(7)
| YES | | NULL | |
| update_email_list | varchar(100)
| YES | | NULL | |
| update_epoch_list | int(11)
| YES | | NULL | |
+---------------------+----------------------------------------------------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)


mysql> select * from list_table;
Empty set (0.00 sec)




Archive powered by MHonArc 2.6.19+.

Top of Page