[Dexterflamez]

Database (error)
Error: 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 'products.product_id NOT IN('') AND (companies.status = 'A' OR products.compan...' at line 1 <b>(1064)</b>
Query: SELECT products.company_id, COUNT(DISTINCT products.product_id) as products_count FROM mcoves_products as products LEFT JOIN mcoves_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN mcoves_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN mcoves_companies AS companies ON companies.company_id = products.company_id INNER JOIN mcoves_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN mcoves_categories ON mcoves_categories.category_id = products_categories.category_id AND (mcoves_categories.usergroup_ids = '' OR FIND_IN_SET(0, mcoves_categories.usergroup_ids) OR FIND_IN_SET(1, mcoves_categories.usergroup_ids)) AND mcoves_categories.status IN ('A', 'H') LEFT JOIN mcoves_supplier_links ON mcoves_supplier_links.object_id = products.product_id AND mcoves_supplier_links.object_type = 'P' WHERE 1=1AND products.product_id NOT IN('') AND (companies.status = 'A' OR products.company_id = 0) AND products.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.product_type != 'D' AND products.company_id IN (17) GROUP BY products.company_id
Backtrace››

index.php (fn_dispatch): 25
app/functions/fn.control.php (fn_run_controller): 433
app/functions/fn.control.php (include): 684
app/controllers/frontend/companies.php (fn_get_companies_active_products_count): 157
app/functions/fn.companies.php (db_get_hash_single_array): 1785
app/functions/fn.database.php (getSingleHash): 107
app/Tygh/Database/Connection.php (call_user_func_array): 374
app/Tygh/Database/Connection.php (query): 518

[johnbol1]

Try and run a database check/repair in phpmyadmin

 then maybe turn on dev mode and see any erros in front end.

 

https://www.thoughtc...myadmin-2693966

[tbirnseth]

Some addon (or core change) is not properly formatting their addtion to the SQL statement:

WHERE 1=1AND products.product_id NOT IN('')

Should be

WHERE 1 AND products.product_id NOT IN('')

I would search your addons directory for that syntax, then disable the addon that's associated with it.

grep -R app/addons "AND products.product_id NOT IN('')"

[eComLabs]

Try to disable 3rd party addons one-by-one