API fails w/SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

=====================================
We are calling the MailPoet API with the following data but it gives an error which doesn’t have any details as to why it is failing. This same code works on other sites using MailPoet 3 but not this particular install of MailPoet. I have reinstalled from scratch, delete and recreated mailing list, deactivate/activate plugins but same results. Can someone please give us some clue as to what it is really complaining about?

The Test Data
Array
(
[email] => tipstest123@yahooo.com
[first_name] => Tips
[last_name] => Tricks
)
Array
(
[list_ids] => Array
(
[0] => 5
)

)
When we make the call to the API:
$subscriber = \MailPoet\API\API::MP(‘v1’)->addSubscriber($subscriber_data, $lists, $options);
It returns the following error:
SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
Below is a dump of the full Exception thrown by MailPoet API call
——————————
object(MailPoetVendor\Doctrine\DBAL\Driver\PDOException)#5807 (10) {

[“errorCode”:”MailPoetVendor\Doctrine\DBAL\Driver\PDOException”:private]=>
int(0)

[“sqlState”:”MailPoetVendor\Doctrine\DBAL\Driver\PDOException”:private]=>
string(5) “HY093”
[“message”:protected]=>
string(68) “SQLSTATE[HY093]: Invalid parameter number: parameter was
not defined”
[“string”:”Exception”:private]=>
string(0) “”
[“code”:protected]=>
string(5) “HY093”
[“file”:protected]=>
string(136)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php”
[“line”:protected]=>
int(2)
[“trace”:”Exception”:private]=>
array(19) {
[0]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(520)
[“function”]=>
string(7) “execute”
[“class”]=>
string(48) “MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement”
[“type”]=>
string(2) “->”
}
[1]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(1924)
[“function”]=>
string(8) “_execute”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “::”
}
[2]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(733)
[“function”]=>
string(4) “_run”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[3]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(722)
[“function”]=>
string(10) “_find_many”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[4]=>
array(5) {
[“file”]=>
string(94)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Paris/paris.php”
[“line”]=>
int(164)
[“function”]=>
string(9) “find_many”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[5]=>
array(3) {
[“function”]=>
string(9) “find_many”
[“class”]=>
string(31) “MailPoetVendor\Paris\ORMWrapper”
[“type”]=>
string(2) “->”
}
[6]=>
array(3) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(2284)
[“function”]=>
string(20) “call_user_func_array”
}
[7]=>
array(5) {
[“file”]=>
string(86)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib/API/MP/v1/API.php”
[“line”]=>
int(136)
[“function”]=>
string(6) “__call”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[8]=>
array(5) {
[“file”]=>
string(86)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib/API/MP/v1/API.php”
[“line”]=>
int(307)
[“function”]=>
string(16) “subscribeToLists”
[“class”]=>
string(22) “MailPoet\API\MP\v1\API”
[“type”]=>
string(2) “->”
}
[9]=>
array(5) {
[“file”]=>
string(112)
“/var/www/clients/client13/web130/web/wp-content/plugins/emember-wysija-newsletter-addon/emember-wysija-addon.php”
[“line”]=>
int(102)
[“function”]=>
string(13) “addSubscriber”
[“class”]=>
string(22) “MailPoet\API\MP\v1\API”
[“type”]=>
string(2) “->”
}
[10]=>
array(5) {
[“file”]=>
string(112)
“/var/www/clients/client13/web130/web/wp-content/plugins/emember-wysija-newsletter-addon/emember-wysija-addon.php”
[“line”]=>
int(66)
[“function”]=>
string(50) “wysija_level_specific_autoresponder_signup_handler”
[“class”]=>
string(20) “EMEMBER_WYSIJA_ADDON”
[“type”]=>
string(2) “->”
}
[11]=>
array(5) {
[“file”]=>
string(66)
“/var/www/clients/client13/web130/web/wp-includes/class-wp-hook.php”
[“line”]=>
int(287)
[“function”]=>
string(11) “plugin_init”
[“class”]=>
string(20) “EMEMBER_WYSIJA_ADDON”
[“type”]=>
string(2) “->”
}
[12]=>
array(5) {
[“file”]=>
string(66)
“/var/www/clients/client13/web130/web/wp-includes/class-wp-hook.php”
[“line”]=>
int(311)
[“function”]=>
string(13) “apply_filters”
[“class”]=>
string(7) “WP_Hook”
[“type”]=>
string(2) “->”
}
[13]=>
array(5) {
[“file”]=>
string(59)
“/var/www/clients/client13/web130/web/wp-includes/plugin.php”
[“line”]=>
int(478)
[“function”]=>
string(9) “do_action”
[“class”]=>
string(7) “WP_Hook”
[“type”]=>
string(2) “->”
}
[14]=>
array(3) {
[“file”]=>
string(52) “/var/www/clients/client13/web130/web/wp-settings.php”
[“line”]=>
int(540)
[“function”]=>
string(9) “do_action”
}
[15]=>
array(4) {
[“file”]=>
string(50) “/var/www/clients/client13/web130/web/wp-config.php”
[“line”]=>
int(90)
[“args”]=>
array(1) {
[0]=>
string(52)
“/var/www/clients/client13/web130/web/wp-settings.php”
}
[“function”]=>
string(12) “require_once”
}
[16]=>
array(4) {
[“file”]=>
string(48) “/var/www/clients/client13/web130/web/wp-load.php”
[“line”]=>
int(37)
[“args”]=>
array(1) {
[0]=>
string(50) “/var/www/clients/client13/web130/web/wp-config.php”
}
[“function”]=>
string(12) “require_once”
}
[17]=>
array(4) {
[“file”]=>
string(55)
“/var/www/clients/client13/web130/web/wp-blog-header.php”
[“line”]=>
int(13)
[“args”]=>
array(1) {
[0]=>
string(48) “/var/www/clients/client13/web130/web/wp-load.php”
}
[“function”]=>
string(12) “require_once”
}
[18]=>
array(4) {
[“file”]=>
string(46) “/var/www/clients/client13/web130/web/index.php”
[“line”]=>
int(17)
[“args”]=>
array(1) {
[0]=>
string(55)
“/var/www/clients/client13/web130/web/wp-blog-header.php”
}
[“function”]=>
string(7) “require”
}
}
[“previous”:”Exception”:private]=>
object(PDOException)#4228 (8) {
[“message”:protected]=>
string(68) “SQLSTATE[HY093]: Invalid parameter number: parameter was
not defined”
[“string”:”Exception”:private]=>
string(0) “”
[“code”:protected]=>
string(5) “HY093”
[“file”:protected]=>
string(136)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php”
[“line”:protected]=>
int(2)
[“trace”:”Exception”:private]=>
array(20) {
[0]=>
array(5) {
[“file”]=>
string(136)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php”
[“line”]=>
int(2)
[“function”]=>
string(7) “execute”
[“class”]=>
string(12) “PDOStatement”
[“type”]=>
string(2) “->”
}
[1]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(520)
[“function”]=>
string(7) “execute”
[“class”]=>
string(48) “MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement”
[“type”]=>
string(2) “->”
}
[2]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(1924)
[“function”]=>
string(8) “_execute”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “::”
}
[3]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(733)
[“function”]=>
string(4) “_run”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[4]=>
array(5) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(722)
[“function”]=>
string(10) “_find_many”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[5]=>
array(5) {
[“file”]=>
string(94)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Paris/paris.php”
[“line”]=>
int(164)
[“function”]=>
string(9) “find_many”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[6]=>
array(3) {
[“function”]=>
string(9) “find_many”
[“class”]=>
string(31) “MailPoetVendor\Paris\ORMWrapper”
[“type”]=>
string(2) “->”
}
[7]=>
array(3) {
[“file”]=>
string(96)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php”
[“line”]=>
int(2284)
[“function”]=>
string(20) “call_user_func_array”
}
[8]=>
array(5) {
[“file”]=>
string(86)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib/API/MP/v1/API.php”
[“line”]=>
int(136)
[“function”]=>
string(6) “__call”
[“class”]=>
string(25) “MailPoetVendor\Idiorm\ORM”
[“type”]=>
string(2) “->”
}
[9]=>
array(5) {
[“file”]=>
string(86)
“/var/www/clients/client13/web130/web/wp-content/plugins/mailpoet/lib/API/MP/v1/API.php”
[“line”]=>
int(307)
[“function”]=>
string(16) “subscribeToLists”
[“class”]=>
string(22) “MailPoet\API\MP\v1\API”
[“type”]=>
string(2) “->”
}
[10]=>
array(5) {
[“file”]=>
string(112)
“/var/www/clients/client13/web130/web/wp-content/plugins/emember-wysija-newsletter-addon/emember-wysija-addon.php”
[“line”]=>
int(102)
[“function”]=>
string(13) “addSubscriber”
[“class”]=>
string(22) “MailPoet\API\MP\v1\API”
[“type”]=>
string(2) “->”
}
[11]=>
array(5) {
[“file”]=>
string(112)
“/var/www/clients/client13/web130/web/wp-content/plugins/emember-wysija-newsletter-addon/emember-wysija-addon.php”
[“line”]=>
int(66)
[“function”]=>
string(50) “wysija_level_specific_autoresponder_signup_handler”
[“class”]=>
string(20) “EMEMBER_WYSIJA_ADDON”
[“type”]=>
string(2) “->”
}
[12]=>
array(5) {
[“file”]=>
string(66)
“/var/www/clients/client13/web130/web/wp-includes/class-wp-hook.php”
[“line”]=>
int(287)
[“function”]=>
string(11) “plugin_init”
[“class”]=>
string(20) “EMEMBER_WYSIJA_ADDON”
[“type”]=>
string(2) “->”
}
[13]=>
array(5) {
[“file”]=>
string(66)
“/var/www/clients/client13/web130/web/wp-includes/class-wp-hook.php”
[“line”]=>
int(311)
[“function”]=>
string(13) “apply_filters”
[“class”]=>
string(7) “WP_Hook”
[“type”]=>
string(2) “->”
}
[14]=>
array(5) {
[“file”]=>
string(59)
“/var/www/clients/client13/web130/web/wp-includes/plugin.php”
[“line”]=>
int(478)
[“function”]=>
string(9) “do_action”
[“class”]=>
string(7) “WP_Hook”
[“type”]=>
string(2) “->”
}
[15]=>
array(3) {
[“file”]=>
string(52)
“/var/www/clients/client13/web130/web/wp-settings.php”
[“line”]=>
int(540)
[“function”]=>
string(9) “do_action”
}
[16]=>
array(4) {
[“file”]=>
string(50) “/var/www/clients/client13/web130/web/wp-config.php”
[“line”]=>
int(90)
[“args”]=>
array(1) {
[0]=>
string(52)
“/var/www/clients/client13/web130/web/wp-settings.php”
}
[“function”]=>
string(12) “require_once”
}
[17]=>
array(4) {
[“file”]=>
string(48) “/var/www/clients/client13/web130/web/wp-load.php”
[“line”]=>
int(37)
[“args”]=>
array(1) {
[0]=>
string(50)
“/var/www/clients/client13/web130/web/wp-config.php”
}
[“function”]=>
string(12) “require_once”
}
[18]=>
array(4) {
[“file”]=>
string(55)
“/var/www/clients/client13/web130/web/wp-blog-header.php”
[“line”]=>
int(13)
[“args”]=>
array(1) {
[0]=>
string(48) “/var/www/clients/client13/web130/web/wp-load.php”
}
[“function”]=>
string(12) “require_once”
}
[19]=>
array(4) {
[“file”]=>
string(46) “/var/www/clients/client13/web130/web/index.php”
[“line”]=>
int(17)
[“args”]=>
array(1) {
[0]=>
string(55)
“/var/www/clients/client13/web130/web/wp-blog-header.php”
}
[“function”]=>
string(7) “require”
}
}
[“previous”:”Exception”:private]=>
NULL
[“errorInfo”]=>
array(2) {
[0]=>
string(5) “HY093”
[1]=>
int(0)
}
}
[“errorInfo”]=>
array(2) {
[0]=>
string(5) “HY093”
[1]=>
int(0)
}
}
———————————————