Error When Sending Newsletter

Another error today

Errore MailPoet: Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nthxtphnae.incontritransessualionline_wp_mailpoet_subscriber_segment’ doesn’t exist in /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Models/Model.php:373
Stack trace:
#0 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(352): MailPoet\Models\Model::__callStatic()
#1 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(234): MailPoet\Segments\WP->insertUsersToSegment()
#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(357): MailPoet\Segments\WP->synchronizeUsers()
#3 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#4 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#5 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#6 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()
#7 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()
#8 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
#9 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#10 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-includes/plugin.php(517): WP_Hook->do_action()
#11 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-settings.php(623): do_action()
#12 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-config.php(93): require_once(‘/home/624781.cl…’)
#13 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-load.php(50): require_once(‘/home/624781.cl…’)
#14 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-admin/admin.php(34): require_once(‘/home/624781.cl…’)
#15 {main}

And from server end

[Wed Apr 26 02:46:19.895220 2023] [proxy_fcgi:error] [pid 2932:tid 139649511024384] [client 114.108.219.181:0] AH01071: Got error ‘PHP message: WordPress database error Table ‘nthxtphnae.incontritransessualionline_wp_mailpoet_automations’ doesn’t exi…………n\\Engine\\Engine->initialize, MailPoet\\Automation\\Engine\\Engine->registerActiveTriggerHooks, MailPoet\\Automation\\Engine\\Storage\\AutomationStorage->getActiveTriggerKeys’, referer: https://incontritransessualionline.com/wp-admin/update-core.php

Edit

I’m forced to uninstall the plugin untill a fix is found. It is breaking my site. Maybe was the recent update of a few ours ago worsening the issue, can’t tell.

• This reply was modified 1 year, 11 months ago by andreadelriva.

Hi @andreadelriva,

Sorry to hear you’re having issues with the plugin.

We noticed that your tables’ names (e.g. nthxtphnae.incontritransessualionline_wp_mailpoet_automations) may be too long, which can cause an issue in the database. To fix this, here are some suggestions:

1. You can use WP filter mailpoet_db_prefix to reduce MailPoet DB prefix. e.g from mailpoet_ to mp_
2. Update the WordPress table prefix to switch from nthxtphnae.incontritransessualionline_wp to a smaller one. Here is a good article on how to do that:?https://help.one.com/hc/en-us/articles/360002107438-Change-the-table-prefix-for-WordPress-

Let us know if it helps!

Hi @andreadelriva,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Hi @bruberries

Thanks for the assitance. I’ll get to it right now and let you know as soon as I have news.

Update

I was able to sucecssfully renamed the DB prefix, however I still get the following error when sending a newsletter

An exception occurred while executing ‘INSERT IGNORE INTO inctsita_wp_mailpoet_scheduled_task_subscribers (task_id, subscriber_id, processed) SELECT DISTINCT ? as task_id, subscribers.id as subscriber_id, ? as processed FROM inctsita_wp_mailpoet_subscriber_segment relation JOIN inctsita_wp_mailpoet_subscribers subscribers ON subscribers.id = relation.subscriber_id WHERE subscribers.deleted_at IS NULL AND subscribers.status = ? AND relation.status = ? AND relation.segment_id IN (?)’ with params [133, 0, “subscribed”, “subscribed”, 1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nthxtphnae.inctsita_wp_mailpoet_scheduled_task_subscribers’ doesn’t exist

And from the Server Error Logs

Mon Jun 05 06:14:17.176788 2023] [proxy_fcgi:error] [pid 21588:tid 140257139857152] [client 114.108.219.10:0] AH01071: Got error ‘PHP message: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nthxtphnae.inctsita_wp_mailpoet_s…………oetVendor\\Doctrine\\DBAL\\Connection->executeQuery()\n#3 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/lib/Segments…’, referer: https://incontritransessualionline.com/wp-admin/admin.php?page=mailpoet-newsletters

The good news are, for at least it is not breaking my site this time.

• This reply was modified 1 year, 9 months ago by andreadelriva.

I’ve updated the topic as unresolved since I’m back at it, and reported a new issues.

Hi @andreadelriva,

Now it seems the table named nthxtphnae.inctsita_wp_mailpoet_scheduled_task_subscribers doesn’t exist in your database. Can you please access your database and confirm this table is there?

Also, can you confirm you have changed the prefix for all the other tables?

Hi @bruberries

No, it does not appear to be there

View post on imgur.com

And, I’m also unable to update the plugin, for the record. If I do it, the wordpress/thesite crashes

Hi @andreadelriva,

This means this table (and maybe others) are indeed missing. That’s also why you can’t update the plugin.

Could you please try to re-install it via FTP and let us know if it helps?

For reference: https://kb.mailpoet.com/article/258-re-installing-updating-the-plugin-via-ftp

Hi @bruberries

I did it trough FTP. Unfortunnately, that does not fix the problem. As soon as I activate the plugin the site crashes.

Here are the current error logs

[Tue Sep 26 05:16:45.686756 2023] [autoindex:error] [pid 27683:tid 140257559295744] [client 194.169.175.23:0] AH01276: Cannot serve directory /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/uploads/: No matching DirectoryIndex (index.php,default.php,index.html,default.html) found, and server-generated directory index forbidden by Options directive
[Tue Sep 26 07:10:55.219456 2023] [proxy_fcgi:error] [pid 19222:tid 140258138064640] [client 114.108.219.28:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nthxtp............vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...', referer: https://incontritransessualionline.com/wp-admin/update.php?action=upload-plugin
[Tue Sep 26 07:10:59.873445 2023] [proxy_fcgi:error] [pid 19228:tid 140256409822976] [client 114.108.219.28:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nthxtp............trine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...', referer: https://incontritransessualionline.com/wp-admin/options-general.php?page=wpsupercache&tab=contents
[Tue Sep 26 07:11:10.072215 2023] [proxy_fcgi:error] [pid 19228:tid 140256393037568] [client 114.108.219.28:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nthxtp............trine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...', referer: https://incontritransessualionline.com/wp-admin/options-general.php?page=wpsupercache&tab=contents
[Tue Sep 26 10:14:07.701311 2023] [proxy_fcgi:error] [pid 3246:tid 140256846243584] [client 2404:3c00:4a3f:b060:15c4:702d:f20c:f20a:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not f............nt/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...', referer: https://incontritransessualionline.com/wp-admin/plugins.php
[Tue Sep 26 10:17:32.158210 2023] [proxy_fcgi:error] [pid 3246:tid 140256510535424] [client 2404:3c00:4a3f:b060:15c4:702d:f20c:f20a:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not f............y()\n#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...'
[Tue Sep 26 10:17:47.182760 2023] [proxy_fcgi:error] [pid 3246:tid 140256409822976] [client 185.196.220.26:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nthxtph............y()\n#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...'
[Tue Sep 26 10:18:02.893387 2023] [proxy_fcgi:error] [pid 3241:tid 140256695174912] [client 157.55.39.49:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nthxtphna............y()\n#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...'
[Tue Sep 26 10:18:19.166493 2023] [proxy_fcgi:error] [pid 3246:tid 140256535713536] [client 2404:3c00:4a3f:b060:15c4:702d:f20c:f20a:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not f............y()\n#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...'
[Tue Sep 26 10:18:26.890634 2023] [proxy_fcgi:error] [pid 3246:tid 140256552498944] [client 2404:3c00:4a3f:b060:15c4:702d:f20c:f20a:0] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not f............y()\n#2 /home/624781.cloudwaysapps.com/nthxtphnae/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\\Doctrine\\DBAL\\Driver\\PDOConnection->query()\n#3 /home/624781.cloudwa...'

• This reply was modified 1 year, 6 months ago by andreadelriva.
• This reply was modified 1 year, 6 months ago by andreadelriva.
• This reply was modified 1 year, 6 months ago by andreadelriva.

Hi @bruberries

Have not heard you in a while. Any insight about the issues?

Hi there @andreadelriva,

Thank you for trying the reinstall, and sending over the error messages. Based on those errors, and your previous screenshot you shared, it seems there are several missing database tables (though the specific table names are missing from the error logs, replaced with …………)

The missing tables are likely due to having failed to be created when you installed the plugin during your migration, due to your long database prefix (nthxtphnae.incontritransessualionline_wp) being appended to the table names and exceeding the limit.

You previously mentioned that you “renamed the DB prefix” — were you referring to changing your site DB prefix to a shorter one? Or only changing the MailPoet prefix to be shorter using the filter that Bruna mentioned? If you haven’t already done so, I’d strongly recommend changing your site db prefix to be shorter using the guide previously linked: https://help.one.com/hc/en-us/articles/360002107438-Change-the-table-prefix-for-WordPress-

After that, the best next steps would be to:

1. Export your subscriber lists to CSV
2. Completely re-install the plugin using the “Reinstall from scratch” option under MailPoet > Settings > Advanced (this should recreate the database tables as well, which does not occur when just reinstalling the plugin files)
3. Re-import your subscriber lists: https://kb.mailpoet.com/article/126-importing-subscribers-with-csv-files

Please let me know if you have any questions. Thank you!

Hi @kellymetal

That has solved the problem, thanks. I also tought to try that out, but I prefered to hear yours account first.

There is still an issues, when I send a test email i get the green message that it was sent, but nothing arrives to my mail box. Nothing the spam folder or others… Any guess?

Hi again ????:!

Could you please contact us via https://www.mailpoet.com/support/sales-pre-sales-questions/ and include a link to this thread?

Your request will be triaged accordingly when we receive it and we’ll be able to provide you with more information there.

Cheers