Magento common problems and solutions

When I first came into contact with magento, I encountered many problems. Most of them were magento configuration and operation problems, because soon after I got in touch with magento, I was unfamiliar with these problems and did not know how to deal with them. According to the technical guidance of the template Hall and related examples on the Internet, here are some common troubleshooting methods for magento operations?
　　
　　
　　
The background homepage has a 404 error.
　　
> Check whether the template is not in the background-system configuration-design configuration Template
　　
> Because the path of the backend entry has been modified in/etc/local. XML, the system reports the 404 error after logging on to the background successfully.
　　
Check and find that the default admin portal is always added in front of the new path in the background.
　　
For example: http: // localhost/magento/index. php/admin/newadmin
　　
This is a URL issue.
　　
Solution: In the background-system-configuration-web-URL options-add store code to URLs, set the value of add store code to URLs to No.
　　
The front-end homepage has a 404 error.> the magento front-end homepage has a 404 error after URL rewriting.
　　
Solution: back-end-system-configuration-web-default pages -- CMS, select home page, and select the correct home page.
　　
Foreground products cannot be displayed
　　
> Product information is also recorded in the product database in the background, but no added product is displayed on the foreground page.
　　
Solution: magento data index problem: Go to the background-system-index management, select all indexes for repair, and then clear the cache and refresh the front-end. OK.
　　
Batch import error when using magento import all products profile to import product data, the following error message is displayed:
　　
Skipping import row, required field "SKU" is not defined.
Skip import row, required field "Store" not defined solution:
　　
1. Check whether the field values such as "SKU" and store are left blank;
2. Check whether the key field values are valid (for example, English commas and double quotation marks)
3.at last I put the batch imported. CSV file encoding format to save in UTF-8 encoding, re-import, OK!
When the following prompt appears, it indicates that this record already exists in the database.
Invalid method mage_catalog_model_product_option_value: deletue (Array ([0] => *))
If the SKU is a unique inventory number, the import program will skip it directly. * Is the products ID.
　　
Solution:
　　
Getstatus ()?>
　　
Updated:
　　
_ (Ucfirst ($ _ item-> getstatus ()?>
　　

　　
After the local installation is successful, you cannot enter the background. The password and user name are correct.
　　
Solution:
　　
1. This is a cookie problem. To fix this problem, locate:
　　
APP/code/CORE/MAGE/CORE/model/session/abstract/varien. php. You can see something similar in around 70 rows:
　　
// Set session cookie Params
Session_set_cookie_params (
$ This-> getcookie ()-> getlifetime (),
$ This-> getcookie ()-> getpath () // comment out or delete it.
// $ This-> getcookie ()-> getdomain (),
// $ This-> getcookie ()-> issecure (),
// $ This-> getcookie ()-> gethttponly ()
); 2. Use an IP address instead of a common localhost such as http: // 127.0.0.1/to replace http: // localhost
　　
An error occurred while migrating the entire site:
　　
Undefined index: 0 in **** \ app \ code \ core \ mage \ core \ model \ mysql4 \ config. php on line 92 ";"
#0 *** \ app \ code \ core \ mage \ core \ model \ mysql4 \ config. PHP (92): magecoreerrorhandler (8, 'undefined index... ', 'd: \ xx24578 \ www \ mym... ', 92, array)
#1 **** \ app \ code \ core \ mage \ core \ model \ config. php (344): mage_core_model_mysql4_config-& gt; loadtoxml (Object (mage_core_model_config) cause:
　　
MySQL tool (such as PHPmyAdmin/MySQL-front/navicat for MySQL/sqlyogent) to overload the dump file (that is, re-import. SQL file), by default, a new serial number is generated when the value 0 is encountered during execution.
　　
The admin store_id of the core_store table of magento is 0; the default group_id of the core_store_group table is also 0.
　　
When importing the. SQL file, the original 0 is changed to a new serial number, which destroys the original data of magento.
　　
Solution:
　　
1. Execute the following statement.
　　
Set foreign_key_checks = 0;
Update 'core _ store' set store_id = 0 where code = 'admin ';
Update 'core _ store_group 'set group_id = 0 where name = 'default ';
Update 'core _ website' set website_id = 0 where code = 'admin ';
Update 'customer _ group' set mermer_group_id = 0 where customer_group_code = 'not logged in ';
Set foreign_key_checks = 1; 2. Add "set SQL _mode = no_auto_value_on_zero" at the beginning of the exported. SQL file;
　　
Supplement:
MySQL mode: no_auto_value_on_zero
　　
This item affects the processing of the auto_increment column.
　　
Normally, when we insert 0 or null to the auto_increment column, the next serial number is generated.
　　
When mode = no_auto_value_on_zero, only null generates a new serial number, blocking 0.
　　
In this case, magento reports an error.
Notice: Undefined index: \ app \ code \ core \ mage \ core \ model \ mysql4 \ config. php on line 92
This problem is solved.
　　
No secondary or tertiary drop-down menu appears in the foreground navigation
　　
Solution: Go to the background and set the is anchor attribute to yes.
　　
Magento Chinese order PDF output garbled
　　
Problem Analysis: this is because the magento PDF Font is an English font and does not support Chinese characters, so the Chinese characters in the generated PDF cannot be displayed, only as a "mouth"
　　
Solution:
　　
APP \ code \ core \ mage \ sales \ model \ order \ PDF/abstract. php
　　
About 610th lines of the file,/lib/linlibertinefont/stsong. TTF.
　　
Modify the file name.
　　
Then add the stsong. TTF file to the linlibertinefont folder.
　　
PS: version updates are not affected.
　　
Out-of-stock products cannot be displayed
　　
Solution: System-> dynamic action-> Inventory-> Stock Options
Display out of stock products => Yes