sitenoob247

Hello @neosinner , that fixed the problem. Now the options-table contains 31 rows.
I activated the plugin, no dashboard errors anymore. Updated it, no errors.
The plugin is working perfect, all good now!!

Thx for the ongoing help, don’t know why especially this special mailpoet table has deselected A_I, so the problem with missing rows and an ID=0 existed in the table…

Again many thx also to all other peeps from support, that tried to fix the problem over the time!!
?? ??

//
SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ‘wordpress’
AND TABLE_NAME = ‘wp_mailpoet_newsletter_option_fields’;
//

MySQL returned an empty result, so no Auto_Increment set, I think…
——————————————————————————–
Here the asked screenshot from your earlier post:

Awaiting your answer and again thx for the support!! ??

Didn’t hear from you concerning my previous post…
Could it be an option to delete some issue-related tables and possibly MailPoet would then re-generate the deleted tables with correct settings during re-installing / updating the plugin?

I updated also to 5.3.5, see the screenshot by phpmyadmin
from the mentioned table to verify that it is ok:

Here the actual errors in my dashboard:

MailPoet Error: MailPoet\Doctrine\WPDB\Exceptions\QueryException: Duplicate entry '0' for key 'PRIMARY' in /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php:132
Stack trace:
#0 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(123): MailPoet\Doctrine\WPDB\Connection->handleQueryError()
#1 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(35): MailPoet\Doctrine\WPDB\Connection->runQuery()
#2 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Statement.php(71): MailPoet\Doctrine\WPDB\Connection->query()
#3 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(471): MailPoet\Doctrine\WPDB\Statement->execute()
#4 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Populator.php(528): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Populator.php(169): MailPoet\Config\Populator->populateNewsletterOptionFields()
#6 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#7 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#8 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Initializer.php(431): MailPoet\Config\Activator->activate()
#9 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator()
#10 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#11 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/plugin.php(517): WP_Hook->do_action()
#12 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-settings.php(704): do_action()
#13 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-config.php(88): require_once('/var/www/vhosts...')
#14 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-load.php(50): require_once('/var/www/vhosts...')
#15 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-admin/admin.php(34): require_once('/var/www/vhosts...')
#16 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-admin/index.php(10): require_once('/var/www/vhosts...')
#17 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: Duplicate entry '0' for key 'PRIMARY' in /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:48
Stack trace:
#0 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(821): MailPoetVendor\Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(793): MailPoetVendor\Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(475): MailPoetVendor\Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Populator.php(528): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement()
#4 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Populator.php(169): MailPoet\Config\Populator->populateNewsletterOptionFields()
#5 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#6 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#7 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-content/plugins/mailpoet/lib/Config/Initializer.php(431): MailPoet\Config\Activator->activate()
#8 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator()
#9 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
#10 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-includes/plugin.php(517): WP_Hook->do_action()
#11 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-settings.php(704): do_action()
#12 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-config.php(88): require_once('/var/www/vhosts...')
#13 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-load.php(50): require_once('/var/www/vhosts...')
#14 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-admin/admin.php(34): require_once('/var/www/vhosts...')
#15 /var/www/vhosts/trackdays.sina.hostkraft.de/html/trackdays/wp-admin/index.php(10): require_once('/var/www/vhosts...')
#16 {main}

Again my earlier asked question:
Why the versions work including 5.2.1 without any errors? It uses the same DB as the newer version.
With A_I activated or not…I can send newsletters, people are able to subscribe etc. etc.
So it must be something you changed from 5.2.1 to 5.2.2 ongoing in some php-files or how the plugin is communicating with the database…
I think your programmers have log files about the version changes etc. so it should be possible to solve the problem somehow and find out what is causing the errors.

I need to send newsletters for black friday and for christmas etc. and I will do it with 5.2.1 but at some time WordPress will not work anymore with the old version 5.2.1 and then I have a BIG problem…

Otherwise I need infos how to export my subscribers and my email layouts, then deleting all tables from Mailpoet with de-installing the plugin, re-installing it (that worked for a guy in another thread with almost same problems) and re-importing my exported data.

Update: I activated Auto Increment at line ID, so it looks like your pic above.
But nothing changed, errors are the same or do I have to do something else?

The Line ID is NOT set to Auto Increment.
The other lines are similar to your picture.
I clicked on edit line “ID” and detected, that the option “A_I” is NOT selected, but I haven’t changed it yet,
wanted to wait for your feedback.

Looks a bit like our issues in this Thread:
https://www.ads-software.com/support/topic/mailpoet-error-after-updated-to-5-2-2/

Only version that works without DB-errors: 5.2.1.
All newer versions do not work.

//or use a plugin like WP-Optimize to clean up the database
used the Optimize-plugin, no changes concerning my MailPoet errors.

//

SELECT * FROM wp_mailpoet_newsletters WHERE id = 0;
SELECT * FROM wp_mailpoet_subscribers WHERE id = 0;
SELECT * FROM wp_mailpoet_segments WHERE id = 0;
SELECT * FROM wp_mailpoet_scheduled_tasks WHERE id = 0;

I managed this with phpmyadmin, all queries returned nothing, so no duplicate entries.
??

I have updated to 5.3.4, not working, same errors as before.
Again: last working version for me: 5.2.1.

@support: thx for working on this issue! ??

I have tested the 2nd possible workaround, cleaned the _migration table, updated to 5.3.3,
after that the table has been filled again, but errors on dashboard are the same, plugin not working.
As I mentioned before: up to 5.2.1 the plugin works fine, no probs with DB etc.
So newer versions are accessing the DB perhaps in a different manner, causing that violent DB access?

// Hi there @sitenoob247 and @exatechgroup ,
// From these errors, it looks as though your database tables have become corrupted somehow.

My question: Why everything works fine until MailPoet 5.2.1???
Database works fine with this version.
I can setup my newsletter email, also subscribing works for the customers, all good…

I will try your suggestions tomorrow.

Same for me, tried 5.3.3 (Update via FTP + re-activating),
NOT working, same errors in WP dashboard as in my first post.
Had to fall back again to 5.2.1, that is working fine.

I have done this for updating already before, when I tested 5.1.0, 5.1.1, 5.2.0, 5.2.1 and 5.2.2.
Deleted old folder, copied new folder via ftp and re-activated the plugin.
Every version above 5.2.1 creates the above mentioned errors / plugin isn’t accessible.

5.3.1 not working for me…same error messages in Dashboard, Plugin not accessible.
Re-installed 5.2.1 via FTP, works, no errors on dashboard.

double post, sorry.

• This reply was modified 1 month, 1 week ago by sitenoob247.