I am using the PHP client at https://github.com/ems-api/php-client. I am using MailWizz v2.2.7. The following code...
...throws this error...
Here is what the application log says:
Code:
$endpoint = new EmsApi\Endpoint\ListSubscribers();
$response = $endpoint->createUpdate('LIST-UNIQUE-ID', array(
'EMAIL' => $email,
));
...throws this error...
Code:
O:13:"EmsApi\Params":2:{s:20:"EmsApi\Params_data";a:2:{s:6:"status";s:5:"error";s:5:"error";s:156:"CDbCommand failed to execute the SQL statement: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1";}s:24:"EmsApi\Params_readOnly";b:0;}
Here is what the application log says:
Code:
2023/02/15 17:57:48 [error] [system.db.CDbCommand] [ip address] CDbCommand::execute() failed: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1. The SQL statement executed was: INSERT INTO `mw_list_field_value` (`field_id`, `subscriber_id`, `value`, `date_added`, `last_updated`) VALUES (:yp0, :yp1, :yp2, NOW(), NOW()).
2023/02/15 17:57:48 [error] [exception.CDbException] [ip address] CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1 in /home/xxx/public_html/vendor/yiisoft/yii/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/xxx/public_html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1083): CDbCommand->execute()
#1 /home/xxx/public_html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(811): CActiveRecord->insert(NULL)
#2 /home/xxx/public_html/apps/api/controllers/List_subscribersController.php(976): CActiveRecord->save()
#3 [internal function]: List_subscribersController->actionUpdate('LISTUID', 'SUBUID')
#4 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/actions/CAction.php(115): ReflectionMethod->invokeArgs(Object(List_subscribersController), Array)
#5 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(List_subscribersController), Object(ReflectionMethod), Array)
#6 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#7 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#8 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40): CFilterChain->run()
#9 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CController.php(1148): CFilter->filter(Object(CFilterChain))
#10 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(Object(CFilterChain))
#11 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#12 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40): CFilterChain->run()
#13 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#14 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CController.php(291): CFilterChain->run()
#15 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#16 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): CController->run('update')
#17 /home/xxx/public_html/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController('list_subscriber...')
#18 /home/xxx/public_html/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()
#19 /home/xxx/public_html/apps/init.php(218): CApplication->run()
#20 /home/xxx/public_html/api/index.php(18): require_once('/home/xxx/pub...')
#21 {main}
REQUEST_URI=/api/lists/LISTUID/subscribers/SUBUID
---
Last edited: