We are trying to migrate our code from magento 1.7 to 1.9 and I have an issue when i build a request with magento 1.9. I wrote this for a column on the order grid :
$this->addColumn('id_po', array(
'header' => $helper->__('Commande / OP'),
'index' => 'id_po',
'filter_index' => "CONCAT(main_table.increment_id , CONCAT('|AP', LPAD(main_table.entity_id , 7, '0')), '0|', coalesce(main_table.order_id_lengow , ''))",
'renderer' => new Amixys_Pilot_Block_Adminhtml_Renderer_IdPo(),
));
But it returns an error
:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.
order_id_lengow , ''))
LIKE '%OFR00093036%')' at line 2, query was: SELECT COUNT(*) FROMsales_flat_order
ASmain_table
INNER JOINsales_flat_order_address
ASa
ON main_table.entity_id = a.parent_id AND a.address_type != 'shipping' WHERE (CONCAT(main_table
.increment_id , CONCAT('|AP', LPAD(main_table
.entity_id , 7, '0')), '0|', coalesce(main_table
.order_id_lengow , ''))
LIKE '%OFR00093036%')"
You can't see it on this page , but it added some unicode caracters U+0060 in wrong places as you can see on my screenshot
Do you have an idea to fix it?
Thanks a lot Thomas
main_table.order_id_lengow
? In MySQL, it allows the space not sure about MariaDB