I'm getting errors with MageWorx Order Management extension v2.2.4
If I filter for example payment methods and select Paypal payment (
Для просмотра ссылки Войди или Зарегистрируйся), I get this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.main_table.payment_method' in 'where clause', query was: SELECT COUNT(*) FROM `mageworx_ordersgrid_order_grid` AS `main_table` WHERE (`main_table`.`main_table`.`payment_method` = 'paypal_standard') AND (main_table.order_group_id = '0')";i:1;s:7200:"#0 /home/45989-36684.cloudwaysapps.com/cefpmrumvz/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110
Zend_Db_Statement_Pdo->_execute(Array)
There is no "payment_method" table in mysql created by that extension, while observer calls it:
case 'payment_method':
if (in_array($column, $listColumns)) {
/**
@var MageWorx_OrdersGrid_Model_System_Config_Source_Payment_Methods $sourcePaymentMethods */
$sourcePaymentMethods = Mage::getSingleton('mageworx_ordersgrid/system_config_source_payment_methods');
$block->addColumn('payment_method', array(
'renderer' => 'mageworx_ordersgrid/adminhtml_sales_order_grid_renderer_payment',
'type' => 'options',
'options' => $sourcePaymentMethods->toArray(),
'header' => $helper->__('Payment Method'),
'index' => 'payment_method',
'filter_index' => 'main_table.payment_method',
'align' => 'center'
));
}
break;
This error is also persistant if I choose to filter any other column, example I want to filter by customer email:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.main_table.customer_email' in 'where clause', query was: SELECT COUNT(*) FROM `mageworx_ordersgrid_order_grid` AS `main_table` WHERE (`main_table`.`main_table`.`customer_email` LIKE '%samo%') AND (main_table.order_group_id = '0')";i:1;s:7200:"#0 /home/45989-36684.cloudwaysapps.com/cefpmrumvz/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110
Zend_Db_Statement_Pdo->_execute(Array)
Any help would be appreciated