Sql Error in X-cart website

Hello

After our server reinstallation our x-cart website started giving the following error:

SQL query : SELECT [login to view URL], [login to view URL],

[login to view URL], [login to view URL], MIN([login to view URL]) AS

price, SUM(IF([login to view URL] IS NULL,0,1)) as product_options, IF

([login to view URL] IS NULL,'','Y') as is_product_options,

IF([login to view URL] IS NULL,'','Y') as is_variant FROM xcart_products,

xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN

xcart_classes ON [login to view URL] = [login to view URL] LEFT JOIN

xcart_variants ON [login to view URL] = [login to view URL] WHERE

xcart_products.productid=[login to view URL] AND

xcart_products_categories.categoryid=[login to view URL] AND

xcart_products.productid=[login to view URL] AND xcart_pricing.quantity=1

AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND

(xcart_categories.membership='' OR xcart_categories.membership='') AND

xcart_products.forsale='Y' AND [login to view URL] = 0 AND

xcart_products.sales_stats>0 GROUP BY [login to view URL] ORDER BY

xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5

Error code : 1054

Description :

Unknown column '[login to view URL]' in 'on clause'

Backtrace :

/home/XXXXXX/public_html/stores/include/[login to view URL]

/home/XXXXXX/public_html/stores/include/[login to view URL]

/home/XXXXXX/public_html/stores/include/[login to view URL]

/home/XXXXXX/public_html/stores/include/[login to view URL]

/home/XXXXXX/public_html/stores/modules/Bestsellers/[login to view URL]

/home/XXXXXX/public_html/stores/[login to view URL]

Thank you in advance

CMS PHP

Kitambulisho cha Mradi: #650133

Kuhusu mradi