Unable to create lists + quick addition of users to lists

Hi @rvola,

I’m sorry, but I can’t relate anything you described to a MailPoet interface. Are you sure you are referring to MailPoet lists?

First, let’s try to understand the problem of creating Segments.
the problem comes from the structure of my tables.
Oddly I have the same problem on another website with Mailpoet.

Here is an export of my “segment” structure for example:

CREATE TABLE'wp_mailpoet_segments' (
  'id' int(11) UNSIGNED NOT NULL,
  'name' varchar(90) DEFAULT NULL,
  'type' varchar(90) DEFAULT NULL,
  'description' varchar(250) DEFAULT NULL,
  'created_at' timestamp NULL DEFAULT NULL,
  'updated_at' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  'deleted_at' timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

and here is the one in the Migrator file:

 $attributes = [
      'id int(11) unsigned NOT NULL AUTO_INCREMENT,',
      'name varchar(90) NOT NULL,',
      'type varchar(90) NOT NULL DEFAULT "default",',
      'description varchar(250) NOT NULL DEFAULT "",',
      'created_at timestamp NULL,', // must be NULL, see comment at the top
      'updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,',
      'deleted_at timestamp NULL,',
      'PRIMARY KEY  (id),',
      'UNIQUE KEY name (name)',
    ];

the word default is missing

• This reply was modified 4 years, 8 months ago by RVOLA.
• This reply was modified 4 years, 8 months ago by RVOLA.

I solved my problem on my own.
Everything comes from the wrong format of my Mailpoet tables.

I do not know what happened (probably a migration error).

I had the problem on 2 sites using Mailpoet 3.
You should know that I use the InfiniteWP plugin to manage updates.
Maybe when he had to have SQL maintenance for Mailpoet, it is not done.

I solved my problem like this:
1. Make a clean install of Mailpoet (temp) on another database.
2. Empty all the tables in the Mailpoet database (temp)
3. Export data from Mailpoet (old) from the wrong table
4. Import the data into the Mailpoet talbe (temp)
5. Delete structures and data from Mailpoet (old)
6. Import structures and data from Mailpoet (temp)

@rvola thanks for the feedback.