1. Here

  1. inside_if

  1. Array
(
    [dispatch] => tags.view
    [tag] => #gushmakeup\
    [extend] => Array
        (
            [0] => description
        )

)


  2. params

  1. Array
(
)


  2. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => description
            [4] => categories
            [5] => sales
            [6] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 24
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [dispatch] => tags.view
    [tag] => #gushmakeup\
    [runtime_company_id] => 0
    [hide_out_of_stock_products] => 
    [sort_by] => bestsellers
    [sort_order] => desc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [sort_order_rev] => asc
    [total_items] => 0
)


  1. selected_layout

  2. products_modern_list

Tygh\Exceptions\AException

Message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?:tags.status = 'A' ORDER BY cscart_pages.position asc, cscart_page_descriptio' at line 1 (1064)

SELECT cscart_pages.*, cscart_page_descriptions.page, cscart_tag_links.*, cscart_tags.tag, cscart_tags.tag_id, cscart_tags.timestamp, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' INNER JOIN cscart_tag_links ON cscart_pages.page_id = cscart_tag_links.object_id AND cscart_tag_links.object_type = 'A' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' WHERE 1 AND cscart_pages.status IN ('A') AND cscart_pages.company_id IN (0, 13) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P', 'G') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1760879236 AND (cscart_pages.avail_till_timestamp >= 1760879236 OR cscart_pages.avail_till_timestamp = 0))) AND (cscart_tags.tag = '#gushmakeup\\') AND ?:tags.status = 'A' ORDER BY cscart_pages.position asc, cscart_page_descriptions.page asc

Error at

app/Tygh/Database/Connection.php, line: 1540

Backtrace

File:app/Tygh/Database/Connection.php
Line:690
Function:throwError
File:app/Tygh/Database/Connection.php
Line:345
Function:query
File:app/functions/fn.database.php
Line:48
Function:getHash
File:app/functions/fn.cms.php
Line:334
Function:db_get_hash_array
File:app/addons/tags/controllers/frontend/tags.php
Line:66
Function:fn_get_pages
File:app/functions/fn.control.php
Line:726
Function:include
File:app/functions/fn.control.php
Line:465
Function:fn_run_controller
File:index.php
Line:39
Function:fn_dispatch