Sitemap 4.4.5 bug
Code:
SQL query : SELECT COUNT(xcart_products.productid) FROM xcart_products
LEFT JOIN xcart_variants ON
xcart_variants.productid=xcart_products.productid WHERE
xcart_products.forsale = 'Y' AND IFNULL(xcart_variants.avail,
xcart_products.avail)>0 GROUP BY id LIMIT 1
Error code : 1054
Description : Unknown column 'id' in 'group statement'
Request URI: /admin/configuration.php?option=Sitemap
Backtrace:
/public_html/include/func/func.db.php:303
/public_html/include/func/func.db.php:203
/public_html/include/func/func.db.php:554
/public_html/modules/Sitemap/func.php:258
/public_html/modules/Sitemap/func.php:1203
/public_html/modules/Sitemap/func.php:812
/public_html/modules/Sitemap/init.php:72
/public_html/init.php:1225
/public_html/admin/auth.php:60
/public_html/admin/configuration.php:63
In /home/flycloth/public_html/modules/Sitemap/func.php find
$group_by[] = 'id';
replace with
$group_by[] = "$sql_tbl[products].productid";