Archive for the ‘Uncategorized’ Category

Runaway Magento catalogindex_aggregation tables

Posted on Monday 12th April 2010 under Uncategorized by Adrian

I have received a large number of integrity contraint violation errors relating to the catalogindex_aggregation_to_tag table; it turns out that it is one of three tables are related to the Layered Navigation cache:

catalogindex_aggregation

catalogindex_aggregation_tag

catalogindex_aggregation_to_tag

which quickly become huge even if tagging is not actively used.
The solution is to Disable Cache Control (beta) Layered Navigation” i the admin panel under “Cache Management” and then refresh the cache.
All three tables are then emptied and perforamnce is significantly improved.
There is a lesson to be learnt about using beta code, I guess…

More fonts

Posted on Thursday 7th August 2008 under IT,Uncategorized by admin

Not sure why I haven’t come across this before, but a great source of free fonts;

dafont.com

Motiveauto Limited

Posted on Sunday 30th September 2007 under Uncategorized by admin

We have finally finished the MBO; Motiveauto Limited is now trading and the seven of us have transferred to the new company. We aim to be the implementation partner of first choice both in the UK and abroad for SAP’s DBM, and for second-tier parts distribution solutions.

Obviously we are all delighted and the feedback from both customers and others has been universally positive.

Contact details;

Motiveauto Limited website

Telephone: 08456 527240

Fax: 08456 527241