[URGENT] Campaign stuck in Pending-sending after cloned Mailwizz to another host server

Allen Zhu

New Member
Hi,
I have used Mailwizz for already 2 years, and everything went okay, until I cloned it to another new server on Cloudways 3 days ago. Since that, mailwizz couldn't send campaigns, it shows Pending-sending.

Cloudways clones all my applications to a new server, makes everything seems totally same as last server, including the folder name and path.
I've checked https://kb.mailwizz.com/articles/my-campaigns-dont-send-theyre-stuck-in-pending-sending-status/, and also many other similar issues in forum, here is what I have done to solve,

1, First, I checked the php binary, and my PHP is located in /usr/bin/php, it is version php7.2. So this is same path and version as in previous server.
2, Then I thought maybe it is the console.php file is not update. So I download the Mailwill 1.9.16 and overwrite to update via SFTP over SSH. It took one night, and I also overwrote the console.php manually, so the console.php is up-to-date. But still pend-sending.
3, I checked the backend->settings->cron, I saw the "Adjust campaigns at once" is Yes, but "campaigns at once" is set to 0, so I set to 100. But seems no difference, still not sending.
4, I contacted my server host, and add and delete cron jobs several times, but no difference, still not sending. This is the cron path: /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php, I set call-up per minute in the server.
5, Then I went to https://kb.mailwizz.com/articles/debug-send-campaigns-command, deleted the cron job in the server, access my host server via SSH, and run below line,
/usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php send-campaigns --verbose=1
Then the campaign (a test to my own email address) were sent, and I received the mail immediatly. I can also see the success result in Xshell (use this to access server via SSH). So this means the cron is okay for use in debug mode, but not triggered when I creat a new campaign, right?
6, I copied the test campaign and it didn't send out, no matter I add/delete the cron job in my host server, always stuck in either Pending-sending or Sending(0%).
7, And I also checked backend->misc->cron job lists, and all are fine, the path is correct, like below,

Campaigns sender, runs each minute.* * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php send-campaigns >/dev/null 2>&1
Transactional email sender, runs once at 2 minutes.*/2 * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php send-transactional-emails >/dev/null 2>&1
Bounce handler, runs once at 10 minutes.*/10 * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php bounce-handler >/dev/null 2>&1
Feedback loop handler, runs once at 20 minutes.*/20 * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php feedback-loop-handler >/dev/null 2>&1
Delivery/Bounce processor, runs once at 3 minutes.*/3 * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php process-delivery-and-bounce-log >/dev/null 2>&1
Various tasks, runs each hour.0 * * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php hourly >/dev/null 2>&1
Daily cleaner, runs once a day.0 0 * * * /usr/bin/php -q /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/console/console.php daily >/dev/null 2>&1

And my sending server quota is also set to 0, which means no limit. And set Api Status and Site Status both online in settings->common.

8, Now I check the APP log in the backend->misc, and find this, (thanks for reading here, too many lines)

---------------lots of same errors on 2020/11/17, but at this time Mailwizz were okay to send, probably is because my previous host server were down--------------
.....
2020/11/17 13:36:34 [error] [exception.CDbException] [51.91.28.12] SQLSTATE[HY000] [2002] Connection refused
2020/11/17 13:36:34 [error] [exception.CDbException] [51.91.212.23] SQLSTATE[HY000] [2002] Connection refused
2020/11/17 13:36:34 [error] [exception.CDbException] [51.91.212.23] CDbException: CDbConnection failed to open the DB connection. in /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/db/CDbConnection.php:405
.....
---------------------------------------- and below is what happens these days ------------------------------------------------
2020/12/16 03:18:35 [error] [exception.CDbException] [119.237.87.168] SQLSTATE[HY000] [2002] No such file or directory
2020/12/16 03:18:39 [error] [exception.CDbException] [119.237.87.168] SQLSTATE[HY000] [2002] No such file or directory
2020/12/16 03:18:39 [error] [exception.CDbException] [119.237.87.168] CDbException: CDbConnection failed to open the DB connection. in /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/db/CDbConnection.php:405
Stack trace:
#0 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/db/CDbConnection.php(347): CDbConnection->open()
#1 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/db/CDbConnection.php(325): CDbConnection->setActive(true)
#2 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CModule.php(394): CDbConnection->init()
#3 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CModule.php(103): CModule->getComponent('db')
#4 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/components/managers/OptionsManager.php(164): CModule->__get('db')
#5 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/components/managers/OptionsManager.php(80): OptionsManager->loadCategory('site_status')
#6 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/components/init/SystemInit.php(48): OptionsManager->get('system.common.s...')
#7 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CComponent.php(561): SystemInit->_runOnBeginRequest(Object(CEvent))
#8 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CApplication.php(212): CComponent->raiseEvent('onbeginrequest', Object(CEvent))
#9 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CApplication.php(183): CApplication->onBeginRequest(Object(CEvent))
#10 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/apps/init.php(229): CApplication->run()
#11 /home/198604.cloudwaysapps.com/zffymauvdu/public_html/customer/index.php(18): require_once('/home/198604.cl...')
#12 {main}

REQUEST_URI=/customer/index.php/lists/index
HTTP_REFERER=http://edm.solarwon.com/customer/index.php
---
2020/12/16 03:18:39 [error] [exception.CDbException] [119.237.87.168] SQLSTATE[HY000] [2002] No such file or directory
2020/12/19 03:51:17 [error] [exception.CHttpException.503] [113.185.43.158] CHttpException: Application currently offline. Try again later! in /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/frontend/controllers/SiteController.php:48
Stack trace:
#0 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/actions/CInlineAction.php(49): SiteController->actionOffline()
#1 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#2 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#3 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#4 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/CWebApplication.php(282): CController->run('offline')
#5 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('site/offline')
#6 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#7 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/apps/init.php(231): CApplication->run()
#8 /home/519265.cloudwaysapps.com/zffymauvdu/public_html/index.php(18): require_once('/home/519265.cl...')
#9 {main}

REQUEST_URI=/index.php/site/offline
---

198604.cloudwaysapps.com is previous host server,
519265.cloudwaysapps.com is server for now.

Really exhausted and need a BIG HELP here.
Could someone make a help?
Thanks in advance.
 
Back
Top