Sending doesnt count

Ariel Blanco

New Member
Hi !
Im having a little trouble that i cant solve
Any of my customers have the counter working..

This is the "App log" that i have, im using Mailwizz v1.3.7.2:


2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('67')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/67
---
2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('78')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/78
---
2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('75')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/75
---
 

frm.mwz

Well-Known Member
Hi !
Im having a little trouble that i cant solve
Any of my customers have the counter working..

This is the "App log" that i have, im using Mailwizz v1.3.7.2:


2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('67')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/67
---
2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('78')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/78
---
2016/09/14 12:29:18 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'. The SQL statement executed was: INSERT INTO `mw_campaign_bounce_log` (`bounce_type`, `processed`, `campaign_id`, `subscriber_id`, `message`, `date_added`) VALUES :)yp0, :yp1, :yp2, :yp3, :yp4, NOW()).
2016/09/14 12:29:18 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '708-8655223' for key 'cid_sid00'' in /home/env/public_html/apps/common/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1 /home/env/public_html/apps/common/framework/db/ar/CActiveRecord.php(809): CActiveRecord->insert(NULL)
#2 /home/env/public_html/apps/frontend/controllers/DswhController.php(369): CActiveRecord->save()
#3 [internal function]: DswhController->processAmazonSes(Object(DeliveryServer), Object(DswhController))
#4 /home/env/public_html/apps/frontend/controllers/DswhController.php(49): call_user_func_array(Array, Array)
#5 [internal function]: DswhController->actionIndex('75')
#6 /home/env/public_html/apps/common/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DswhController), Array)
#7 /home/env/public_html/apps/common/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DswhController), Object(ReflectionMethod), Array)
#8 /home/env/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#9 /home/env/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#10 /home/env/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#11 /home/env/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('index')
#12 /home/env/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('dswh/index')
#13 /home/env/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#14 /home/env/public_html/apps/init.php(227): CApplication->run()
#15 /home/env/public_html/index.php(18): require_once('/home/env/pub...')
#16 {main}
REQUEST_URI=/index.php/dswh/75
---

Have you tried to check the dbf in phpMyAdmin?
 

frm.mwz

Well-Known Member
Thats the problem i never disabled it, i think is a database problem, but i dont know how to reach it.
try this:
change the respective settings, then save.
change them back, then save again.
sometimes saving can be forgotten or browsers/etc can cause settings not to stick (it is rare, but it happens).
 
Top