Danh mục sản phẩm

Bạn nên biết

Tags

Video

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and `structure_id` < 1000000000000000000) AND 1' at line 8
fetch(

array (
  0 => '
            SELECT
                count(*) AS total
            FROM
                product
                LEFT OUTER JOIN category ON product.category_id = category.id
                LEFT OUTER JOIN manufacturer ON manufacturer.id = product.manufacturer_id
            WHERE
                product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >=  and `structure_id` < 1000000000000000000) AND 1
        ',
  1 => 'total',
)
) at packages/frontend/modules/ItemsList/db.php:48,
get_total_item(
array (
  0 => 'product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >=  and `structure_id` < 1000000000000000000)',
  1 => '1',
)
) at packages/frontend/modules/ItemsList/forms/list.php:89,
parse_layout(
array (
  0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/da-xanh-reu-ha-trung.portal=default.cache.php:1587,
run() at index.php:18

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and `structure_id` < 1000000000000000000) AND product.status != "HIDE" AND 1 ...' at line 17
fetch_all(

array (
  0 => '
            SELECT
                product.id,
                product.name_id,
                product.name_1 AS name,
                product.status,
                product.image,
                product.position,
                product.price,
                product.hitcount,
                product.info_1 AS info,
                category.name_id AS category_name_id,
                category.name_1 AS category_name
            FROM
                product
                LEFT OUTER JOIN category ON product.category_id = category.id
            WHERE 
                product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >=  and `structure_id` < 1000000000000000000) AND product.status != "HIDE" AND 1
            ORDER BY
                product.position DESC,product.id DESC
            LIMIT
                
        ',
)
) at packages/frontend/modules/ItemsList/db.php:28,
get_items(
array (
  0 => 'product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >=  and `structure_id` < 1000000000000000000)',
  1 => '!= "HIDE"',
  2 => '1',
  3 => 'product.position DESC,product.id DESC',
  4 => false,
)
) at packages/frontend/modules/ItemsList/forms/list.php:114,
parse_layout(
array (
  0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/da-xanh-reu-ha-trung.portal=default.cache.php:1587,
run() at index.php:18

Warning: Invalid argument supplied for foreach() in /home/marblestonemanhtrang.com/public_html/packages/frontend/modules/ItemsList/db.php on line 30

Warning: Invalid argument supplied for foreach() in /home/marblestonemanhtrang.com/public_html/packages/frontend/modules/ItemsList/forms/list.php on line 115

Đối tác