Following an upgrade from Magento 1.5 to 1.6 the error:
Invalid backend model specified: customer_entity/address_attribute_backend_region
occurs during customer address edit or checkout address entry.
This is because in the eav_attribute table, backend_model values are incorrect. Fix with the following SQL:
1
2
| UPDATE `eav_attribute` SET `backend_model` = 'customer/entity_address_attribute_backend_street' WHERE `attribute_code` ='street' LIMIT 1 ;
UPDATE `eav_attribute` SET `backend_model` = 'customer/entity_address_attribute_backend_region' WHERE `attribute_code` ='region' LIMIT 1 ; |
Magento Invoice and Shipping (Despatch) PDF files are delivered with a reasonable layout, already suited toA4 printing, but benefit from some layout improvements, increasing font sizes, and lightening the greyscale boxes in the interests of readability.
Take a copy of the relevant core files and place them in:
/app/code/local/Mage/Sales/Model/Order/Pdf
The relevant files are Invoice.php & Shipment.php, but Abstract.php contains functions common to both, and the subdirectory Items contains formatting for the line items of each document type.
The following snippet can be used to format database values as currency values:
$formattedPrice = Mage::helper('core')->currency($Price,true,false);
Assuming that Magento is not actually in maintenance mode (i.e. downloader is not being used) then the following error is the result of a lock file not being removed, probably as the result of an ungraceful exit from the downloader:
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
To take Magento out of maintenance mode, just delete the file:
from the Magento root.
You have put the correct figures into both the Balance Sheet and P&L, but the Companies House abbreviated pages won’t balance (red errors) The problem is that the PDF is not recalculating correctly, you must save, quit and re-open the PDF.
If you have already got as far as “Accounts review” then that will re-calculate, but until you have balanced each section this entry in the contents list will not be active.
Problem:Eye-Fi center doesn’t appear when I click on it in the tool tray, following an upgrade.
Eye-Fi answer:
Your request (#27954) has been deemed solved.
________________________________________
Michal, Apr-20 05:25 (PDT):
Hello Adrian,
As discussed could you please do the following:
- format the card in your camera
- uninstall Eye-Fi software as well as Adobe AIR
- install the latest version of the Adobe AIR from the following link:
http://get.adobe.com/air/
- download and install the latest version of the Eye-Fi software:
http://support.eye.fi/support-resources/downloads/software/eye-fi-manager-desktop-software/
Please feel free to contact us again if you have questions or would like further assistance.
Kind regards,
Michal
Eye-Fi Customer Care
… or to put it another way, turn it off and turn it back on again!
Sometimes I think that things haven’t really changed since I did support back in the 1990s.
Update:
The correct solution is to uninstall & reinstall Adobe Air.
The upgrade to 1.5 has a number of “gotchas” so while I am debugging the process on the test / staging instance, here are a few notes.
Basic process
Empty some or all of the log tables as they are potentially huge and are not needed:
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`;
Backup the 1.3 instance using Magento’s built in backup.
Edit the resulting .sql file and uncomment the FOREIGN_KEY controls at the top and bottom of the file:
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
If the domain or subdomain is changing, do a search & replace e.g. replace www.myshop.com with test5.myshop.com
Create the new database instance, and execute the SQL from the previous step. Make sure it doesn’t time out, last table created is normally “wishlist_item”
Yoast Metarobots breaks product maintenance in Magento 1.4+, so remove relevant fields:
DELETE FROM `core_resource` WHERE `core_resource`.`code` = 'metarobots_setup';
DELETE FROM `eav_attribute` WHERE `eav_attribute`.`attribute_code` = 'meta_robots';
UPDATE eav_entity_type SET additional_attribute_table='catalog/eav_attribute',entity_attribute_collection='catalog/product_attribute_collection' WHERE entity_type_id=4;
Now FTP the Magento downloader.php onto the target site, check file permissions and execute it with http://test5.myshop.com/downloader.php
Follow the setup process including specifying the correct database name, user and password.
Use the same encryption key from the original site – find it in /app/etc/local.xml
If there are problems with the setup not accepting the admin user / password combination, simply re-run the installer by pointing your web browser at http://test5.myshop.com
Remember that the original admin user already exists in the database export, so create a temporary one and delete it later.
Fixing problems
Can’t access the admin site, gives 404 error
The database import will have incorrectly sequenced the sites, so run the following:
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
UPDATE core_website SET website_id="0" WHERE core_website.code="admin" LIMIT 1;
UPDATE core_store SET store_id="0" WHERE core_store.code="admin" LIMIT 1;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
Admin site is “white” i.e. CSS not working and plain HTML is displayed
Delete contents of /var/cache/
“There are no products matching the selection” when browsing front end
Wrong customer group ID for users that are no logged in. Execute the following SQL:
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
UPDATE `customer_group` SET `customer_group_id` = 0 WHERE `customer_group_code` LIKE 'NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
No product images
Check correct permissions and then copy the images directory structure from the source site eg:
cp /httpdocs/media/catalog/* /subdomains/test5/httpdocs/media/catalog/
Now login to admin site and run a re-index on everything, and update all of the caches.
Error File does not exist: … media/catalog/product/no_selection
Review the System Configuration and under Catalogue / Catalogue / Product Image Placeholders and add the missing placeholders. Add back in the watermarks too in General / Design / Product Image Watermarks.
This page has bidirectional binary – ASCII conversion. This is useful if you are following @cjsupercomputer.
Ingredients
2 kg boneless pork shoulder
2 tablespoon olive oil
300g mushrooms, thick sliced
1 onion, diced
2 carrots, diced
2 tbsp tomato paste
500ml stock, either chicken or vegetable
2 bay leaves
salt & ground pepper to season
Method
Salt and pepper a board, roll the meat on it. Heat 1 tbsp oil in the pressure cooker and brown meat all over. Temporarily remove meat. Fry onion and carrot in the remaining oil until softened. Add tomato paste, stock, and bay leaves. Place roast on top, add sliced mushrooms, cover and bring up to full pressure. Cook for 50 minutes. Reduce pressure using the natural method. Remove meat to rest for 10 minutes. Separate fat from stock and thicken with cornflour to make a gravy.
Here is a nice combination of Autumn flavours.
Ingredients
2 large onions, halved
3 large parsnips, peeled and halved
2 medium butter-nut squash, sliced in half lengthways, de-seeded
Small handful of lemon thyme
Olive oil
Salt and pepper
1.5 litres vegetable stock
2 tablespoons crème fraîche
Method
Place the vegetables on a baking tray, pour over some olive oil, season and add the thyme. Bake at 180 degrees Celsius for one hour.
Scrape the flesh from the squash, remove any twigs from the thyme, and blitz the cooked vegetables in a food processor adding the stock a third at a time.
Put in a pan and bring to a simmer, balance the seasoning, take off the heat and stir in the crème fraîche. Serve.
Ingredients
175g Oat flakes
150g Butter
85g Oatmeal
50g Caster sugar
40g Honey
Pinch Salt
Method
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.
