商品筛选问题求解

2016-07-07 14:55 来源:www.chinab4c.com 作者:ecshop专家



如何使用这种的分类方式,我使用的商品属性筛选会出现错误。

另外想请问怎么再分类使用自订图片

这种>>>>http://fanti.thejamy.com/category.php?id=107


回答:
属性建成分类,商品添加扩展分类

使用了变成这样...出现错误

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT DISTINCT(b.goods_id) FROM `shopp_ec`.`qq_goods_attr` AS a, `shopp_ec`.`qq_goods_attr` AS b, `shopp_ec`.`qq_goods` AS g WHERE b.attr_value = a.attr_value AND b.attr_id = 313 AND a.goods_attr_id = 127649 ) [2] => Array ( [error] => The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay ) [3] => Array ( [errno] => 1104 ) )

不需要任何修改。这个就是后台设置属性规格筛选就OK了。