Service Unavailable

General General Questions
1

I'm receiving the Service Unavailable screen when I click on the Products - Categories tab, this occured directly after an import of products, any ideas of how to fix? Details below:

			Message
	
	
		
			 
		
			Unknown column 'products_categories.category_id' in 'on clause' (1054)SELECT COUNT(DISTINCT products.product_id) FROM cscart_products AS products LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P' LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id WHERE 1=1 
	
	
		
			 
		
			 
	
	
		
			 
		
			Error at
	
	
		
			 
		
			app/Tygh/Database/Connection.php, line: 1155
	
	
		
			 
		
			 
	
	
		
			 
		
			Backtrace
	
	
		
			 
		
			File:app/Tygh/Database/Connection.php
	
	
		
			 
		
			Line:518
	
	
		
			 
		
			Function:throwError
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/Tygh/Database/Connection.php
	
	
		
			 
		
			Line:295
	
	
		
			 
		
			Function:query
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.database.php
	
	
		
			 
		
			Line:69
	
	
		
			 
		
			Function:getField
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.products.php
	
	
		
			 
		
			Line:3829
	
	
		
			 
		
			Function:db_get_field
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.categories.php
	
	
		
			 
		
			Line:1390
	
	
		
			 
		
			Function:fn_get_products_count
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/controllers/backend/categories.php
	
	
		
			 
		
			Line:413
	
	
		
			 
		
			Function:fn_get_categories_stats
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.control.php
	
	
		
			 
		
			Line:685
	
	
		
			 
		
			Function:include
	
	
		
			 
		
			 
	
	
		
			 
		
			File:app/functions/fn.control.php
	
	
		
			 
		
			Line:434
	
	
		
			 
		
			Function:fn_run_controller
	
	
		
			 
		
			 
	
	
		
			 
		
			File:dsav_admin.php
	
	
		
			 
		
			Line:27
	
	
		
			 
		
			Function:fn_dispatch


I'm receiving the Service Unavailable screen when I click on the Products - Categories tab, this occured directly after an import of products, any ideas of how to fix? Details below:

Message Unknown column 'products_categories.category_id' in 'on clause' (1054)SELECT COUNT(DISTINCT products.product_id) FROM cscart_products AS products LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P' LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id WHERE 1=1 Error at app/Tygh/Database/Connection.php, line: 1155 Backtrace File:app/Tygh/Database/Connection.php Line:518 Function:throwError File:app/Tygh/Database/Connection.php Line:295 Function:query File:app/functions/fn.database.php Line:69 Function:getField File:app/functions/fn.products.php Line:3829 Function:db_get_field File:app/functions/fn.categories.php Line:1390 Function:fn_get_products_count File:app/controllers/backend/categories.php Line:413 Function:fn_get_categories_stats File:app/functions/fn.control.php Line:685 Function:include File:app/functions/fn.control.php Line:434 Function:fn_run 
Message
Unknown column 'products_categories.category_id' in 'on clause' (1054)SELECT COUNT(DISTINCT products.product_id) FROM cscart_products AS products LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P'  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id   WHERE 1=1 

Error at

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


Backtrace

File:app/Tygh/Database/Connection.php

Line:518

Function:throwError


File:app/Tygh/Database/Connection.php

Line:295

Function:query


File:app/functions/fn.database.php

Line:69

Function:getField


File:app/functions/fn.products.php

Line:3829

Function:db_get_field


File:app/functions/fn.categories.php

Line:1390

Function:fn_get_products_count


File:app/controllers/backend/categories.php

Line:413

Function:fn_get_categories_stats


File:app/functions/fn.control.php

Line:685

Function:include


File:app/functions/fn.control.php

Line:434

Function:fn_run_controller


File:dsav_admin.php

Line:27

Function:fn_dispatch

_controller File:dsav_admin.php Line:27 Function:fn_dispatch

2

I can't tell you why but it's looking for the table 'products_categories' when it should be looking for the table 'cscart_products_categories' since your other tables are showing the prefix 'cscart_'.

3

Thank you - I've ascertained that the following addon has caused this issue and have now reached out to them - https://cs-market.com/cs-cart-addons/cs-cart-product-stickers-add-on.html