175g Oat flakes
150g Butter
85g Oatmeal
50g Caster sugar
40g Honey
Pinch Salt
Melt the butter, mix all of the ingredients together in a bowl to form a stiff dough. Roll out to 6mm thickness and cut out into rounds. Bake at 180 degrees C for approx 20 minutes or until browned. Cool on a wire rack.
375g plain flour
175g brown sugar
1 teaspoon baking powder
1 teaspoon cinnamon
Pinch of salt
150ml vegetable oil
2 eggs, beaten
250g carrots, grated
75g raisins
Preheat the oven to 180 degrees C.
Grease a 12 cup muffin tray.
Combine flour, sugar, baking powder, cinnamon and salt in a bowl.
Mix together vegetable oil and eggs, then add to dry ingredients. Fold in carrot and raisins; divide into muffin cups. Bake for 25 minutes or until a skewer comes out clean. Cool on a wire rack.
600g carrots, cut into batons
2 tablespoons butter
1 tablespoon honey
1 teaspoon orange juice
Pinch salt
Chopped parsley
Cook carrots as usual until tender, drain. Melt the butter in a pan and add honey and orange juice. Stir through the carrots and sprinkle with parsley to complete the dish.
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…
A quick how-to if you want to copy or move Magento to another database instance, e.g. to create a test site, or move test to live.
(1) Backup Magento using the built in backup tool. Download and uncompress the resulting SQL script. If changing the server or domain, search and replace “old.mysite.com” with “new.yoursite.com” Execute it to populate the new database instance.
(2) Copy all Magento files with the exception of the contents of the var/ directory.
(3) Edit app/etc/local.xml on the target instance and change the database, user and password, but not the encryption key. Also edit downloader/pearlib/pear.ini to correct the absolute paths it contains; no reason why these shouldn’t be relative to the Magento root directory, e.g. “./downloader/pearlib”.
(4) Execute the following SQL to prevent those nasty “Integrity constraint violation: 1062 Duplicate entry” errors from the log files when adding to the basket:
TRUNCATE `log_customer` ;
TRUNCATE `log_quote` ;
TRUNCATE `log_summary` ;
TRUNCATE `log_url` ;
TRUNCATE `log_url_info` ;
TRUNCATE `log_visitor` ;
TRUNCATE `log_visitor_info` ;
TRUNCATE `log_visitor_online` ;
Now tidy up permissions:
chmod o+w var var/.htaccess app/etc
chmod -R o+w media
That should be it.
London has up-to-the-minute signage, so much so that when Victoria’s friend took her photo the other weekend, it looked like this…
A project sponsored by the OS to relate photographs to each grid square.
How long before somebody finds a way of exploiting / monetising this?
Geograph.
Something searching for a use.
http://www.fliptextgenerator.com/
Uses apparently little-known character codes to invert most text (struggles with capitals).
Well done Fontis for integrating reCAPTCHA into Magento to prevent SPAM through the contact form and “social” pages. About time!
Well though-out and integrated beautifully into admin.
Keys are required from reCAPTCHA andthe extension can be installed through Magento Connect using the extention key on the Magento Extention page.
Randomly browsing, I found the legendary Van Halen rider, posted on The Smoking Gun. Yes, the “no brown M&Ms” line is there, and intriguingly a requirement that forks are not plastic and have four prongs. Did Eddie Van Halen have some terrible two-prong fork related accident as a child?