MailPress stopped to work for me after upgrade

P.S. I see there is no _MailPress_published record in wordpresswp_postmeta table for latest posts. (according to this post: https://buildyourblog.net/email/mailpress/how-resend-existing-post-your-mailpress-newsletter)

Tried to export users to csv, reinstalled. Tried to re-import them again, I’ve got multiple
SELECT meta_value FROM wordpresswp_mailpress_usermeta WHERE mp_user_id = 3 AND meta_key = '_MailPress_newsletter'
errors after user import in users list. Error happen only if I enable Newsletter add-on.

What is the reason for this? How to fix? I think mailpress addons activation order matter. What plugins should be activated and in what order to import users successfully send new email on every new post?

• This reply was modified 5 years, 5 months ago by tantrido.

In Mails tab see following errors:

WordPress DB error: [Table 'wordpresswp_mailpress_mailmeta' doesn't exist]
SELECT meta_value FROM wordpresswp_mailpress_mailmeta WHERE mp_mail_id = 1 AND meta_key = '_mailinglist_desc'

WordPress DB error: [Table 'wordpresswp_mailpress_mailmeta' doesn't exist]
SELECT meta_value FROM wordpresswp_mailpress_mailmeta WHERE mp_mail_id = 1 AND meta_key = '_MailPress_replacements'

WordPress DB error: [Table 'wordpresswp_mailpress_mailmeta' doesn't exist]
SELECT * FROM wordpresswp_mailpress_mailmeta WHERE mp_mail_id = 1 AND meta_key = '_MailPress_attached_file' ORDER BY meta_key, meta_id

Any fixes?

Often get following error as well:

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in wp-content/plugins/mailpress/mp-content/add-ons/MailPress_mailinglist.php on line 156

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in wp-content/plugins/mailpress/mp-content/add-ons/MailPress_mailinglist.php on line 171

apparently mailpress_mailmeta was not created on install or upgrade

which is weired, sometimes it works, sometimes it doesn’t…

i think this is related to some specific technical choices on specific webhost.

Who is your webhost please

Do You need my domain or my provider? My hosting provider is https://www.reg.ru/

ok, not speaking russian !

try to fix the mailpress_mailmeta issue by
* deactivate/activate mailpress plugin
* creating it by yourself (code is in mailpress\mp-admin\includes\install\mailpress.php)

English version: https://www.reg.com ??

1. On activation WP print following output:

The plugin generated 2424 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

3 tables created only:

• wordpresswp_mailpress_mails,
• wordpresswp_mailpress_stats,
• wordpresswp_mailpress_users.

Any way to see the logs to cause the reason?

2. Not clear: creation script in PHP (not specialist in it), and seems many tables creation missed:

CREATE TABLE $wpdb->mp_usermeta (
meta_id bigint(20) unsigned NOT NULL auto_increment,
mp_user_id bigint(20) unsigned NOT NULL default '0',
meta_key varchar(255) NOT NULL default '',
meta_value longtext,
PRIMARY KEY (meta_id),
KEY mp_user_id (mp_user_id,meta_key),
KEY meta_key (meta_key)
) $charset_collate;
CREATE TABLE $wpdb->mp_stats (
sdate date NOT NULL,
stype char(1) NOT NULL,
slib varchar(45) NOT NULL,
scount bigint NOT NULL,
PRIMARY KEY (stype,sdate,slib)
) $charset_collate;\n";

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta( $mp_tables );

// some clean up
$wpdb->query( "DELETE FROM $wpdb->mp_mails    WHERE status = '' AND theme <> '';" );
$wpdb->query( "DELETE FROM $wpdb->mp_mailmeta WHERE mp_mail_id NOT IN ( SELECT id FROM $wpdb->mp_mails );" );
$wpdb->query( "DELETE FROM $wpdb->mp_usermeta WHERE mp_user_id NOT IN ( SELECT id FROM $wpdb->mp_users );" );
$wpdb->query( "DELETE FROM $wpdb->mp_usermeta WHERE meta_value NOT IN ( SELECT id FROM $wpdb->mp_mails ) AND meta_key = '_MailPress_mail_sent' ;" );
$wpdb->query( "DELETE FROM $wpdb->mp_stats    WHERE scount = 0 ;" );

$wpdb->query( "UPDATE $wpdb->mp_mailmeta SET meta_key = '_MailPress_attached_file' WHERE meta_key = '_mp_attached_file';" );

Seems error somewhere on creation.

• This reply was modified 5 years, 5 months ago by tantrido.
• This reply was modified 5 years, 5 months ago by tantrido.

to be continued on google forum