MailPress stopped to work for me after upgrade

33 views
Skip to first unread message

Aleksey K

unread,
Jun 13, 2019, 12:48:14 PM6/13/19
to MailPress

andré renaut

unread,
Jun 14, 2019, 11:21:37 AM6/14/19
to mail...@googlegroups.com
thanks for posting on the google forum

wordpress.org do not send mail for any new support topic !

Le jeu. 13 juin 2019 à 18:48, Aleksey K <akont...@gmail.com> a écrit :

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to
mailpress+...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/91135f8e-0edb-4942-b960-6a37bbf5f17f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

Aleksey Kontsevich

unread,
Jun 15, 2019, 9:33:18 AM6/15/19
to mail...@googlegroups.com
My next message on moderator's hold for some reason. Doubling it here:

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.

-- 
Best regards,
Aleksey


пт, 14 июн. 2019 г. в 18:21, andré renaut <andre....@gmail.com>:
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CALSPOPayUidnDHXPs%2BqsnznuFiB0A%2BrN5WdxZd1O93QG5ruHeg%40mail.gmail.com.

andré renaut

unread,
Jun 15, 2019, 11:43:58 AM6/15/19
to mail...@googlegroups.com
hello
mailpress tables are created the same way wordpress does using a single string with this order

1) CREATE TABLE $wpdb->mp_mails
2) CREATE TABLE $wpdb->mp_mailmeta
3) CREATE TABLE $wpdb->mp_users
4) CREATE TABLE $wpdb->mp_usermeta
5) CREATE TABLE $wpdb->mp_stats

so it is very strange that tables 1), 3), and 5) are creted and not the 2) and 4)


do you have any access to those

" 2424 characters of unexpected output "

may be in the apache log ?

To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CAHJJ8TPfYnmH2cK9_yYU5tPp%2B8XiBWUBXK6n2cS6-v_E-htX4A%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Aleksey Kontsevich

unread,
Jun 15, 2019, 11:56:46 AM6/15/19
to mail...@googlegroups.com
Nothing there. Do You have some time for screensharing so I can show You my screen to try to discover the problem?

-- 
Best regards,
Aleksey


сб, 15 июн. 2019 г. в 18:43, andré renaut <andre....@gmail.com>:
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CALSPOPbCZN4BnRTp51W63rUfY8EV%3DUQGFkgGGhK2BjwmTg6hnw%40mail.gmail.com.

andré renaut

unread,
Jun 15, 2019, 5:52:32 PM6/15/19
to mail...@googlegroups.com
or send me user/pwd + link to your admin using contribute[at]mailpress[dot]org

To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CAHJJ8TPj6FBhbYQJ89BAh6NhLJsTc_RGqR1bFN%2B0jSs%2B%2BzegTg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Aleksey Kontsevich

unread,
Jun 16, 2019, 5:31:26 PM6/16/19
to mail...@googlegroups.com
Sorry, no: screenshare only :)

Some links with same error which may help to solve the problem:
https://www.toddlahman.com/the-plugin-generated-x-characters-of-unexpected-output-during-activation/
https://stackoverflow.com/questions/7725615/the-plugin-generated-xxx-characters-of-unexpected-output-during-activation
https://stackoverflow.com/questions/36499017/the-plugin-generated-x-characters-of-unexpected-output
https://stackoverflow.com/questions/30516499/the-plugin-generated-n-characters-of-unexpected-output-during-activation
https://stackoverflow.com/questions/10755464/the-plugin-generated-xxxx-characters-of-unexpected-output-during-activation-erro
https://stackoverflow.com/questions/4074477/the-plugin-generated-x-characters-of-unexpected-output-during-activation-wordpr
https://wordpress.stackexchange.com/questions/251388/plugin-generated-unexpected-output-during-activation-but-it-is-empty
https://wordpress.stackexchange.com/questions/224917/the-plugin-generated-xxx-characters-of-unexpected-output-during-activation
https://wordpress.stackexchange.com/questions/3533/the-plugin-generated-80-characters-of-unexpected-output

Any way to enable some WP logs to see the reason? I have access to all site files now.

-- 
Best regards,
Aleksey


вс, 16 июн. 2019 г. в 00:52, andré renaut <andre....@gmail.com>:

andré renaut

unread,
Jun 17, 2019, 5:50:31 AM6/17/19
to mail...@googlegroups.com

To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CAHJJ8TNF1-s4VE8PeEkH_6UpCjkJFT1eMRVpw92KFr4X_PjnwA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Aleksey Kontsevich

unread,
Jun 17, 2019, 6:03:57 AM6/17/19
to mail...@googlegroups.com
Tried to inspect, however there is no iframe there:

изображение.png

-- 
Best regards,
Aleksey


пн, 17 июн. 2019 г. в 12:50, andré renaut <andre....@gmail.com>:
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CALSPOPYM1L%3DrW_GbhGQsGd_L1er13jmq0ekE7EhZ4G8ThRDbsQ%40mail.gmail.com.

Aleksey Kontsevich

unread,
Jun 17, 2019, 6:11:30 AM6/17/19
to mail...@googlegroups.com
Some other:
https://wordpress.stackexchange.com/a/36435/170125
Never echo anything inside functions that are used on de-/activation/uninstall hooks. This will always result in the above mentioned error message.

And next answer:

the real solution for me was the following.

  1. at the end of the file which contains the header of the plugin i removed closing php ?> and the problem will be solved
  2. at the end of the plugin file which contains the header of the plugin remove the extra line breaks after the closing php ?>

my plugin file ended at line 69 and there were 7 more spaced after the last php code so in the editor the file was up to 66, my error was "The plugin generated 7 characters of unexpected...." when i removed extra lines up to 69 the was error gone,

Does it help?

-- 
Best regards,
Aleksey


пн, 17 июн. 2019 г. в 13:03, Aleksey Kontsevich <akont...@gmail.com>:

Aleksey K

unread,
Jun 21, 2019, 3:03:15 PM6/21/19
to MailPress
Is it possible error caused WP DB corrupted or some WP tables or installation files missed? Any way to check and fix without WP re-installation?

понедельник, 17 июня 2019 г., 13:11:30 UTC+3 пользователь Aleksey K написал:

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+unsubscribe@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+unsubscribe@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+unsubscribe@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+unsubscribe@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+unsubscribe@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+unsubscribe@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+unsubscribe@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+unsubscribe@googlegroups.com.

Aleksey Kontsevich

unread,
Jun 21, 2019, 3:31:23 PM6/21/19
to MailPress
Hi Andre again,

I was able to enable debug logs and catch the error on activation. See attached log file. Does it say something to You?

-- 
Best regards,
Aleksey


пт, 21 июн. 2019 г. в 22:03, Aleksey K <akont...@gmail.com>:

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailpress+...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to
mailpress+...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mailpress+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/eb275c4f-e87d-48f7-9c2c-e1d81d36d4fd%40googlegroups.com.
debug.log

Aleksey Kontsevich

unread,
Jun 21, 2019, 4:01:20 PM6/21/19
to MailPress
Some more info here: https://stackoverflow.com/a/1814594/630169

In comments:
The index limit is 767 bytes, not characters. And since Mysql's utf8mb4 character set (which the rest of the world calls utf8) needs (at most) 4 bytes per character you can only index up to VARCHAR(191). Mysql's utf8 character set (which the rest of the world calls broken) needs at most 3 bytes per character so if you are using that (which you shouldn't), you can index up to VARCHAR(255)

And here: https://support.membermouse.com/support/solutions/articles/9000063367-wordpress-database-error-specified-key-was-too-long

Your database is configured to use a collation known as utf8mb4_general_ci, which allows up to 4 bytes to be used to store characters. My understanding is that utf8mb4_general_ci allows for all of the characters stored by utf8_unicode_ci, but additionally emojis, special characters used in asian languages, etc. The problem comes in when using utf8mb4_general_ci with the InnoDB engine. A 255 character database field now requires 4 bytes per character to create an index. (255 * 4 = 1020 bytes). The maximum allowed by InnoDB is 767, so this causes a SQL error, like what you are seeing.


-- 
Best regards,
Aleksey


пт, 21 июн. 2019 г. в 22:30, Aleksey Kontsevich <akont...@gmail.com>:

andré renaut

unread,
Jun 21, 2019, 5:46:38 PM6/21/19
to mail...@googlegroups.com
thank you for the log file

your webhost has a limitation on index length (that i don't have on mine ...)

Specified key was too long; max key length is 1000 bytes for query

i will post a fix within a short time but not now !

To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CAHJJ8TN40A4wS%2BH98WD5p4Ph2O4BWeFqPSPHVECQp69kFWCGOQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Aleksey Kontsevich

unread,
Jun 21, 2019, 6:59:19 PM6/21/19
to MailPress
Thank You! Please do: blog is useless without mailing list :) Can I also ask my provider to remove this limitation? What should I say to them?

-- 
Best regards,
Aleksey


сб, 22 июн. 2019 г. в 00:46, andré renaut <andre....@gmail.com>:
To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CALSPOPbHyDWLMahDQeLZ84NrEeJPiab9HNtsAsrR9L3AnMMJ4A%40mail.gmail.com.

andré renaut

unread,
Jun 22, 2019, 10:15:57 AM6/22/19
to mail...@googlegroups.com
try this. to be copied in mailpress/mp-admin/includes/install



To view this discussion on the web visit https://groups.google.com/d/msgid/mailpress/CAHJJ8TORBUm2fZf1Rfv3Y87TXEj7LeAmEOt5MjuyKu3RS1wQFA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.
mailpress.php

Aleksey K

unread,
Jun 22, 2019, 12:11:58 PM6/22/19
to MailPress
Thanks!!! All works fine without errors!!! Also removed lines with `_MailPress_prior_to_install` in table `wordpresswp_postmeta` to send letters before MailPress install.

суббота, 22 июня 2019 г., 17:15:57 UTC+3 пользователь arena написал:
try this. to be copied in mailpress/mp-admin/includes/install



Le sam. 22 juin 2019 à 00:59, Aleksey Kontsevich <akont...@gmail.com> a écrit :
Thank You! Please do: blog is useless without mailing list :) Can I also ask my provider to remove this limitation? What should I say to them?

-- 
Best regards,
Aleksey


сб, 22 июн. 2019 г. в 00:46, andré renaut <andre...@gmail.com>:
пн, 17 июн. 2019 г. в 12:50, andré renaut <andre...@gmail.com>:
Le dim. 16 juin 2019 à 23:31, Aleksey Kontsevich <akont...@gmail.com> a écrit :
Sorry, no: screenshare only :)

Some links with same error which may help to solve the problem:

Any way to enable some WP logs to see the reason? I have access to all site files now.

-- 
Best regards,
Aleksey


вс, 16 июн. 2019 г. в 00:52, andré renaut <andre...@gmail.com>:
or send me user/pwd + link to your admin using contribute[at]mailpress[dot]org

Le sam. 15 juin 2019 à 17:56, Aleksey Kontsevich <akont...@gmail.com> a écrit :
Nothing there. Do You have some time for screensharing so I can show You my screen to try to discover the problem?

-- 
Best regards,
Aleksey


сб, 15 июн. 2019 г. в 18:43, andré renaut <andre...@gmail.com>:
пт, 14 июн. 2019 г. в 18:21, andré renaut <andre...@gmail.com>:
thanks for posting on the google forum

wordpress.org do not send mail for any new support topic !

Le jeu. 13 juin 2019 à 18:48, Aleksey K <akont...@gmail.com> a écrit :

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.


--
this mail was written by a human being
--
Homme libre, toujours tu chériras la mer !
La mer est ton miroir; tu contemples ton âme
Charles Baudelaire

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to a topic in the Google Groups "MailPress" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mailpress/mykBMxAxgeI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mail...@googlegroups.com.

--
--
=== Please Donate ! https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=andre%2erenaut%40gmail%2ecom&lc=US&item_name=MailPress&item_number=gg&amount=5%2e00&currency_code=EUR&currency_code=EUR&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHostedGuest ===
 
You received this message because you are subscribed to the Google
Groups "MailPress" group.
To post to this group, send email to mail...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/mailpress?hl=en

---
You received this message because you are subscribed to the Google Groups "MailPress" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mail...@googlegroups.com.

Aleksey Kontsevich

unread,
Jun 22, 2019, 12:55:59 PM6/22/19
to MailPress
Best plugin for mailing lists!изображение.png The only problem - English texts, need to help You to translate it to Russian.

Reply all
Reply to author
Forward
0 new messages