商品名称的长度设置变成字符数,而不是原来的字节数了?
今天发现我的店的商品名称的长度超长了,发现在后台的商品名称的长度设置的数量变成了字符数了,即不论中文英文,都只显示字符数,而不是原来的字节数,现在变成了中文的商品名称比英文的商品名称不一样长,看看http://www.buyeshop.cn/另外产品的分类列表偶尔会出现这样的错误:
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.attr_id, a.attr_value, COUNT(g.goods_id) AS goods_num FROM `buyeshop`.`by_goods_attr` AS a, `buyeshop`.`by_goods` AS g WHERE a.goods_id = g.goods_id AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('1','3','22','23','24','25','26','27','28','2','29','30','31','32','33','34','4','35','36','37','38','39','40','41','42','43','44','45','5','46','47','48','49','50','51','52','6','74','75','76','77','78','79','80','81','82','83','84','90','7','8','9','85','86','87','88','89','10','11','12','53','54','55','56','57','13','14','15','16','58','59','60','61','62','63','64','65','66','17','18','19','67','68','69','70','71','72','73','91','20','21') OR g.goods_id IN ('') ) AND a.attr_id='8' GROUP BY a.attr_value ) [2] => Array ( [error] => Got error 28 from table handler ) [3] => Array ( [errno] => 1030 ) )
http://www.buyeshop.cn/category.php?id=1 天啊 晕咯1~!~! 数字 这么多的数字 有没有人知道是什么问题呢?
页:
[1]