Fatal Error when activating MailPoet 3

  • James Maiden

    (@reallygreenjames)


    5 years, 7 months ago

    Hi there,

    When i install and activate the plugin, I get this error

    Fatal error: Uncaught Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘last_name’ at row 1 in /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Models/Model.php:373 Stack trace: #0 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Segments/WP.php(210): MailPoet\Models\Model::__callStatic(‘rawExecute’, Array) #1 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Segments/WP.php(118): MailPoet\Segments\WP::updateLastNames() #2 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Config/Populator.php(343): MailPoet\Segments\WP::synchronizeUsers() #3 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Config/Populator.php(162): MailPoet\Config\Populator->createDefaultSegment() #4 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Config/Activator.php(27): MailPoet\Config\Populator->up() #5 /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(180): MailPoet\Config\Activator->activate() in /home/spanprop/public_html/dev/wp-content/plugins/mailpoet/lib/Models/Model.php on line 373

    And from my error_log

    [15-Oct-2020 18:37:57 UTC] PHP Fatal error: Uncaught Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘last_name’ at row 3 in /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Models/Model.php:373
    Stack trace:
    #0 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(210): MailPoet\Models\Model::__callStatic(‘rawExecute’, Array)
    #1 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(118): MailPoet\Segments\WP::updateLastNames()
    #2 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(343): MailPoet\Segments\WP::synchronizeUsers()
    #3 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(162): MailPoet\Config\Populator->createDefaultSegment()
    #4 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(27): MailPoet\Config\Populator->up()
    #5 /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(180): MailPoet\Config\Activator->activate()
    #6 /home/spanprop/public_ht in /home/spanprop/public_html/wp-content/plugins/mailpoet/lib/Models/Model.php on line 373

    I can’t figure out why. I have installed MailPoet on 2 other sites on the same server with no problem. The server is high spec using PHP 7.4

    I have tried copying the database tables from a clean working install onto the problematic site, but still the same error.

    I tried activating the plugin with the defaul WP theme and with all other plugins deactivated, but still the same error.

    Can you please help?

Viewing 1 replies (of 1 total)
  • Wysija

    (@wysija)

    5 years, 5 months ago

    Hi James,

    This is probably because when migrating your subscribers from MailPoet 2 to MailPoet 3, all the WordPress Users have been automatically added as subscribers to the WordPress Users list.

    And if you had fake sign-ups using long names or URLs instead of name and last name, they’re breaking your tables, as you see the error message Data too long for column ‘last_name’ at row

    You’d need to delete these subscribers as Users from the plugin or directly from the database.

Viewing 1 replies (of 1 total)

The topic ‘Fatal Error when activating MailPoet 3’ is closed to new replies.