Abandoned Cart Report not updating

[Brihaspati_dev]

Thanks a lot

save my lots of time

[filimm]

Same here, after a few days the issue came back.

[filimm]

Where exactyl I insert the NULL ?

[ideepercreare]

HOW MUCH MUST MODIFY LINE 209?

[ideepercreare]

I also have the same problem with version 1.9.3 how can i fix ??? What should I change?

[hruivo]

Hi,

Like stated previously, you need to override: app/code/core/Mage/Reports/Model/Resource/Quote/Collection.php

and edit line 209 or 217 depends on your Magento version, find a line that reads like:

        ->joinInner(
                array('cust_mname' => $attrMiddlenameTableName),
                implode(' AND ', array(
                    'cust_mname.entity_id = main_table.customer_id',
                    $adapter->quoteInto('cust_mname.attribute_id = ?', (int) $attrMiddlenameId),
                )),
                array('middlename' => 'cust_mname.value')
            )

And change it to look like:

            ->joinLeft(
                array('cust_mname' => $attrMiddlenameTableName),
                implode(' AND ', array(
                    'cust_mname.entity_id = main_table.customer_id',
                    $adapter->quoteInto('cust_mname.attribute_id = ?', (int) $attrMiddlenameId),
                )),
                array('middlename' => 'cust_mname.value')
            )

Resuming changing the joinInner to joinLeft

Cheers,