Quote:
|
SQL query : SELECT p.productid FROM xcart_products AS p LEFT JOIN wcm_cdseo AS cd ON p.productid = cd.cdseoReplaceID AND cd.cdseoType='product' WHERE 1 AND (pl.product LIKE '%right %' OR p.productcode LIKE '%right %') Error code : 1054 Description : Unknown column 'pl.product' in 'where clause'Request URI: /admin/cdseopro/index.php?search=right+&active=&limit=100&limitsta rt=200&cdseopage=productsBacktrace:/home/ink/public_html/include/func/func.db.php:309/home/ink/public_html/include/func/func.db.php:209/home/ink/public_html/include/func/func.db.php:489/home/ink/public_html/admin/cdseopro/includes/products.php:122/home/ink/public_html/admin/cdseopro/includes/products.php:74/home/ink/public_html/admin/cdseopro/index.php:168-------------------------------------------------
|
Any idea what's causing this? recently done a site transfer but getting SQL errors sent to my email address, need this fixed ASAP.
*update* seems it's just when i use the search function on CDSEO i get an SQL error, although the results show fine, seems very odd!