Error When Sending Newsletter

  • andreadelriva

    (@andreadelriva)


    12 months ago

    Hi

    I was able to finally migrate successfully from Mp2 to Mp3 on this site. Thanks also to the suggestion given by Miss Bruna in this previous conversation related

    https://wordpress.org/support/topic/php-error-when-migrating-from-mp-2-to-mp3/#post-15983614

    After editding the few lenghty tables i dimed gulty of causing the issue I was able to import also the subscribers. The rest of set up went on smoohtly untill is submit the first “test” newletter to myself, and got the following error

    An exception occurred while executing 'INSERT IGNORE INTO incontritransessualionline_wp_mailpoet_scheduled_task_subscribers (task_id, subscriber_id, processed) SELECT DISTINCT ? as task_id, subscribers.id as subscriber_id, ? as processed FROM incontritransessualionline_wp_mailpoet_subscriber_segment relation JOIN incontritransessualionline_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 [25, 0, "subscribed", "subscribed", 5]: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'incontritransessualionline_wp_mailpoet_scheduled_task_subscribers'

    My guess is, the lenghty tables may be once again the cause. Any guess, solution?

Viewing 15 replies - 1 through 15 (of 16 total)
1 2
  • Thread Starter andreadelriva

    (@andreadelriva)

    12 months ago

    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}

    Thread Starter andreadelriva

    (@andreadelriva)

    12 months ago

    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.

    Plugin Support Bruna a11n

    (@bruberries)

    11 months, 2 weeks ago

    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!

    Plugin Support Bruna a11n

    (@bruberries)

    10 months, 4 weeks ago

    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.

    Thread Starter andreadelriva

    (@andreadelriva)

    10 months, 3 weeks ago

    Hi @bruberries

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

    Thread Starter andreadelriva

    (@andreadelriva)

    10 months, 3 weeks ago

    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 10 months, 3 weeks ago by andreadelriva.
    Thread Starter andreadelriva

    (@andreadelriva)

    7 months ago

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

    Plugin Support Bruna a11n

    (@bruberries)

    7 months ago

    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?

    Thread Starter andreadelriva

    (@andreadelriva)

    7 months ago

    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

    Plugin Support Bruna a11n

    (@bruberries)

    7 months ago

    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

    Thread Starter andreadelriva

    (@andreadelriva)

    7 months ago

    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...'

    Thread Starter andreadelriva

    (@andreadelriva)

    6 months, 3 weeks ago

    Hi @bruberries

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

    Plugin Support kellymetal a11n

    (@kellymetal)

    6 months, 3 weeks ago

    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!

    Thread Starter andreadelriva

    (@andreadelriva)

    6 months, 2 weeks ago

    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?

    Plugin Support Dani F. a11n

    (@danielinhou)

    6 months, 1 week ago

    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

Viewing 15 replies - 1 through 15 (of 16 total)
1 2
  • You must be logged in to reply to this topic.