$sql = "SELECT goods_id, goods_name, goods_type, goods_sn, virtual_sales, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " .
" (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') ".
" As is_promote,b.brand_name FROM".$GLOBAs['ecs']->table('goods')."AS g".
" LEFT JOIN".$GLOBAs['ecs']->table('goods')."AS b on g.brand_id = b.brand_id".
" WHERE is_delete='$is_delete' $where" .
" ORDER BY $filter[sort_by] $filter[sort_order] ".
" LIMIT " . $filter['start'] . ",$filter[page_size]";报错
" (promote_price > 0 AND promote_start_date <= '$today' AND promote_end_date >= '$today') ".
" As is_promote,b.brand_name FROM".$GLOBAs['ecs']->table('goods')."AS g".
" LEFT JOIN".$GLOBAs['ecs']->table('goods')."AS b on g.brand_id = b.brand_id".
" WHERE is_delete='$is_delete' $where" .
" ORDER BY $filter[sort_by] $filter[sort_order] ".
" LIMIT " . $filter['start'] . ",$filter[page_size]";报错
A:一种可能是发送的SQL语句太长,以致超过了max_allowed_packet的大小,如果是这种原因,你只要修改my.cnf,加大max_allowed_packet的值即可。
A:建议这样:
1、(网站路径) 这里面确定是否有中文,是否有空格,这两都都会影响;
2、确定php.ini或php_admin_value 是否限制了目录
3、确定是否支持dir函数
4、dede不能装在虚拟目录