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 12
query(array (
0 => '
SELECT
count(*) as acount
FROM
item
inner join category on item.category_id = category.id
inner join product on item.id = product.id
left outer join currency on product.currency_id = currency.id
WHERE
item.portal_id = "#viethung"
and item.type = "PRODUCT"
and item.status <> "HIDE"
and (`structure_id` >= and `structure_id` < 1000000000000000000)
and 1
',
)
) at packages/portal/includes/system/database.php:416,
fetch(array (
0 => '
SELECT
count(*) as acount
FROM
item
inner join category on item.category_id = category.id
inner join product on item.id = product.id
left outer join currency on product.currency_id = currency.id
WHERE
item.portal_id = "#viethung"
and item.type = "PRODUCT"
and item.status <> "HIDE"
and (`structure_id` >= and `structure_id` < 1000000000000000000)
and 1
',
)
) at packages/viethung/modules/VietHungProductList/db.php:51,
get_count(array (
0 => '13848',
1 => ' 1 ',
)
) at packages/viethung/modules/VietHungProductList/forms/list.php:63,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at packages/portal/includes/portal/module.php:160,
get_sub_regions(array (
0 => 'content',
)
) at packages/portal/modules/Frame/forms/list.php(50) : eval()'d code:9,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at packages/portal/includes/portal/module.php:160,
get_sub_regions(array (
0 => 'Column2',
)
) at packages/portal/includes/portal/form.php(221) : eval()'d code:34,
parse_layout(array (
0 => 'list',
)
) at packages/portal/modules/ColumnLayout/forms/list.php:10,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at cache/page_layouts/product_detail.portal=viethung.cache.php:895,
require_once(array (
0 => '/home/viethung/public_html/cache/page_layouts/product_detail.portal=viethung.cache.php',
)
) at packages/portal/includes/portal/generate_page.php:37,
generate() at packages/portal/includes/portal/portal.php:110,
run_page(array (
0 =>
array (
'id' => '10163',
'package_id' => '321',
'layout_id' => '0',
'layout' => 'packages/anphat/layouts/default.php',
'skin' => 'default',
'help_id' => '0',
'name' => 'product_detail',
'title_1' => 'Chi tiết Sản phẩm',
'title_3' => '',
'description_1' => '',
'description_3' => '',
'title_2' => '',
'description_2' => '',
'description' => '',
'customer_id' => '0',
'read_only' => '0',
'show' => '1',
'cachable' => '0',
'cache_param' => '',
'params' => 'portal=viethung',
'site_map_show' => '1',
'type' => 'SYSTEM',
'condition' => '',
'is_use_sapi' => '0',
'title' => 'Chi tiết Sản phẩm',
),
1 => 'product_detail',
2 => 'portal=viethung',
)
) at packages/portal/includes/portal/portal.php:88,
run() at index.php:21
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
ORDER BY
item.po...' at line 16
query(array (
0 => '
SELECT
item.id, item.name,item.image_url,item.brief,item.category_id,item.description,
item.status,item.meta,item.name_id,category.name_id as category_name_id,item.website_title,
product.price, product.currency_id,currency.exchange, product.manufactures,
product.capacity,product.future,item.position
FROM
item
inner join product on item.id = product.id
left outer join currency on product.currency_id = currency.id
inner join category on item.category_id = category.id
WHERE
item.portal_id = "#viethung"
and item.type = "PRODUCT"
and item.status <> "HIDE"
and (`structure_id` >= and `structure_id` < 1000000000000000000)
and 1
ORDER BY
item.position asc,item.id desc
LIMIT
0,4
',
)
) at packages/portal/includes/system/database.php:440,
fetch_all(array (
0 => '
SELECT
item.id, item.name,item.image_url,item.brief,item.category_id,item.description,
item.status,item.meta,item.name_id,category.name_id as category_name_id,item.website_title,
product.price, product.currency_id,currency.exchange, product.manufactures,
product.capacity,product.future,item.position
FROM
item
inner join product on item.id = product.id
left outer join currency on product.currency_id = currency.id
inner join category on item.category_id = category.id
WHERE
item.portal_id = "#viethung"
and item.type = "PRODUCT"
and item.status <> "HIDE"
and (`structure_id` >= and `structure_id` < 1000000000000000000)
and 1
ORDER BY
item.position asc,item.id desc
LIMIT
0,4
',
)
) at packages/viethung/modules/VietHungProductList/db.php:33,
get_products(array (
0 => '13848',
1 => 4,
2 => ' 1 ',
)
) at packages/viethung/modules/VietHungProductList/forms/list.php:71,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at packages/portal/includes/portal/module.php:160,
get_sub_regions(array (
0 => 'content',
)
) at packages/portal/modules/Frame/forms/list.php(50) : eval()'d code:9,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at packages/portal/includes/portal/module.php:160,
get_sub_regions(array (
0 => 'Column2',
)
) at packages/portal/includes/portal/form.php(221) : eval()'d code:34,
parse_layout(array (
0 => 'list',
)
) at packages/portal/modules/ColumnLayout/forms/list.php:10,
draw() at packages/portal/includes/portal/form.php:299,
on_draw() at packages/portal/includes/portal/module.php:53,
draw() at packages/portal/includes/portal/module.php:67,
on_draw() at cache/page_layouts/product_detail.portal=viethung.cache.php:895,
require_once(array (
0 => '/home/viethung/public_html/cache/page_layouts/product_detail.portal=viethung.cache.php',
)
) at packages/portal/includes/portal/generate_page.php:37,
generate() at packages/portal/includes/portal/portal.php:110,
run_page(array (
0 =>
array (
'id' => '10163',
'package_id' => '321',
'layout_id' => '0',
'layout' => 'packages/anphat/layouts/default.php',
'skin' => 'default',
'help_id' => '0',
'name' => 'product_detail',
'title_1' => 'Chi tiết Sản phẩm',
'title_3' => '',
'description_1' => '',
'description_3' => '',
'title_2' => '',
'description_2' => '',
'description' => '',
'customer_id' => '0',
'read_only' => '0',
'show' => '1',
'cachable' => '0',
'cache_param' => '',
'params' => 'portal=viethung',
'site_map_show' => '1',
'type' => 'SYSTEM',
'condition' => '',
'is_use_sapi' => '0',
'title' => 'Chi tiết Sản phẩm',
),
1 => 'product_detail',
2 => 'portal=viethung',
)
) at packages/portal/includes/portal/portal.php:88,
run() at index.php:21
Thêm vào giỏ hàng thành công