Pending sending :(

Teebox

Member
Hello there,
I made the MW update yesterday.
All seem to work fine but all my campaigns are in 'paused' mode. . .
I tried everything and even go to the ssh console to type the commands by hand and see the reaction MW but I do not understand.

Here are the details of the application log.
Can you help me ?

Code:
2016/06/02 09:13:53 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'. The SQL statement executed was: SELECT server_id, monthly_quota, hourly_quota FROM `mw_delivery_server_to_customer_group` `t` WHERE (group_id=:ycp109) AND (server_id NOT IN (:ycp110, :ycp111, :ycp112)).
2016/06/02 09:13:53 [error] [application] CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'
2016/06/02 09:13:53 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'. The SQL statement executed was: SELECT server_id, monthly_quota, hourly_quota FROM `mw_delivery_server_to_customer_group` `t` WHERE group_id=:ycp141.
2016/06/02 09:13:53 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'' in /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php:543
Stack trace:
#0 /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1356): CDbCommand->queryAll()
#2 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1475): CActiveRecord->query(Object(CDbCriteria), true)
#3 /home/boomrang/public_html/apps/common/models/DeliveryServer.php(1339): CActiveRecord->findAll(Object(CDbCriteria))
#4 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(280): DeliveryServer::pickServer(0, Object(Campaign), Array)
#5 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(233): SendCampaignsCommand->sendCampaignStep1('249', 0)
#6 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(177): SendCampaignsCommand->sendCampaignStep0(Array)
#7 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(108): SendCampaignsCommand->process()
#8 [internal function]: SendCampaignsCommand->actionIndex()
#9 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(SendCampaignsCommand), Array)
#10 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#11 /home/boomrang/public_html/apps/common/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#12 /home/boomrang/public_html/apps/common/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#13 /home/boomrang/public_html/apps/init.php(224): CApplication->run()
#14 /home/boomrang/public_html/apps/console/console.php(28): require_once('/home/boomrang/...')
#15 {main}
---
 

frm.mwz

Well-Known Member
Hello there,
I made the MW update yesterday.
All seem to work fine but all my campaigns are in 'paused' mode. . .
I tried everything and even go to the ssh console to type the commands by hand and see the reaction MW but I do not understand.

Here are the details of the application log.
Can you help me ?

Code:
2016/06/02 09:13:53 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'. The SQL statement executed was: SELECT server_id, monthly_quota, hourly_quota FROM `mw_delivery_server_to_customer_group` `t` WHERE (group_id=:ycp109) AND (server_id NOT IN (:ycp110, :ycp111, :ycp112)).
2016/06/02 09:13:53 [error] [application] CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'
2016/06/02 09:13:53 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'. The SQL statement executed was: SELECT server_id, monthly_quota, hourly_quota FROM `mw_delivery_server_to_customer_group` `t` WHERE group_id=:ycp141.
2016/06/02 09:13:53 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'' in /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php:543
Stack trace:
#0 /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1356): CDbCommand->queryAll()
#2 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1475): CActiveRecord->query(Object(CDbCriteria), true)
#3 /home/boomrang/public_html/apps/common/models/DeliveryServer.php(1339): CActiveRecord->findAll(Object(CDbCriteria))
#4 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(280): DeliveryServer::pickServer(0, Object(Campaign), Array)
#5 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(233): SendCampaignsCommand->sendCampaignStep1('249', 0)
#6 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(177): SendCampaignsCommand->sendCampaignStep0(Array)
#7 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(108): SendCampaignsCommand->process()
#8 [internal function]: SendCampaignsCommand->actionIndex()
#9 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(SendCampaignsCommand), Array)
#10 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#11 /home/boomrang/public_html/apps/common/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#12 /home/boomrang/public_html/apps/common/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#13 /home/boomrang/public_html/apps/init.php(224): CApplication->run()
#14 /home/boomrang/public_html/apps/console/console.php(28): require_once('/home/boomrang/...')
#15 {main}
---

try to
fix dbf (phpMyAdmin has that feature)
apply all patches for 1.3.6.4 til now
update again
revisit and reset (to the values you want) the quotas for customer groups, customers, etc
 

Teebox

Member
After verbose look at this please

Code:
[2016-06-02 11:56:43] - Exception thrown: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'
[2016-06-02 11:56:43] - Campaign Worker #0 looking into the campaign with ID: 249
[2016-06-02 11:56:43] - This campaign belongs to Niico (uid: ph897seosw108).
exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'' in /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php:543
 

Teebox

Member
Code:
[2016-06-02 12:01:23] - Exception thrown: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'
[2016-06-02 12:01:23] - Campaign Worker #0 looking into the campaign with ID: 249
[2016-06-02 12:01:23] - This campaign belongs to Niico (uid: ph897seosw108).
exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'monthly_quota' in 'field list'' in /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php:543
Stack trace:
#0 /home/boomrang/public_html/apps/common/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1356): CDbCommand->queryAll()
#2 /home/boomrang/public_html/apps/common/framework/db/ar/CActiveRecord.php(1475): CActiveRecord->query(Object(CDbCriteria), true)
#3 /home/boomrang/public_html/apps/common/models/DeliveryServer.php(1339): CActiveRecord->findAll(Object(CDbCriteria))
#4 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(280): DeliveryServer::pickServer(0, Object(Campaign), Array)
#5 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(233): SendCampaignsCommand->sendCampaignStep1('249', 0)
#6 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(177): SendCampaignsCommand->sendCampaignStep0(Array)
#7 /home/boomrang/public_html/apps/console/commands/SendCampaignsCommand.php(108): SendCampaignsCommand->process()
#8 [internal function]: SendCampaignsCommand->actionIndex()
#9 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(SendCampaignsCommand), Array)
#10 /home/boomrang/public_html/apps/common/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#11 /home/boomrang/public_html/apps/common/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#12 /home/boomrang/public_html/apps/common/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#13 /home/boomrang/public_html/apps/init.php(224): CApplication->run()
#14 /home/boomrang/public_html/apps/console/console.php(28): require_once('/home/boomrang/...')
 

twisted1919

Administrator
Staff member
The patch fixes the issue for sure.
if you have applied it correctly the issue should go away. try to rename the apps/common/runtime/cache folder in something else to force cache regeneation.
 

Teebox

Member
Ok, I have upload done the patch and no issue, it doesn't work anymore...
I renamed the file 'cache' and it does not change anything either.

all campaigns stay in 'sending 0%'
 
Top