Trying to log into admin and get service unavailable, edited config.local to see error message, any help please.
Thanks
John
Not unique table/alias: 'popularity' (1066)
SELECT SQL_CALC_FOUND_ROWS 1 FROM cscart_products AS products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_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 LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id 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_popularity as popularity ON popularity.product_id = products.product_id LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id WHERE 1 AND products.status IN ('A') AND prices.usergroup_id IN (0)GROUP BY products.product_id
Error at
app/Tygh/Database/Connection.php, line: 855
Backtrace
File:
app/Tygh/Database/Connection.php
Line:
454
Function:
error
File:
app/functions/fn.database.php
Line:
129
Function:
query
File:
app/controllers/backend/index.php
Line:
102
Function:
db_query
File:
app/functions/fn.control.php
Line:
699
Function:
include
File:
app/functions/fn.control.php
Line:
455
Function:
fn_run_controller
File:
poloshirt.php
Line:
27
Function:
fn_dispatch