Question

I get following error:

SQLSTATE[23,000]:廉正制约因素的违反:1052栏“定位”的定序条款是模糊的。

我拿着Magento 1.4版本,首先,我成功地将其升级为1.6.2,但当我尝试将其升级为1.7时,我就犯了上述错误。

请帮助

Answer 1

你可以尝试这一解决办法:

Locate table eav_attribute in phpmyadmin, which was related to catalog_eav_attribute. Located column position in table eav_attribute and dropped it.
清除所有海滩并重新确定所有数据
现在访问前页。现在,你可能会出现新的错误:

54STATE[42S22]:Column没有发现:1054个“不知”栏“主要” 页: 1

Locate and open file app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php

评论如下:267

->where(‘main_table.is_active = ?’, ’1′)
// ->where(‘main_table.include_in_menu = ?’, ’1′)
->order(‘main_table.position’);

You can find a step by step guide at: expertmagentodevelopers[dot]com/blog/how-to-upgrade-from-magento-1-6-1-to-1-7-0-using-connect-manager/

上述解决办法基于我自己的经验。