I am using Sitemap module 2.4 with ExpressionEngine 2.3.1. I have it installed and can generate a site map when just adding locations, but as soon as I include one of the Channels, I get the following error when I view the rendered sitemap.
Error Number: 1054
Unknown column ‘site_pages’ in ‘field list’
SELECT `site_pages` FROM (`exp_sites`) WHERE `site_id` = ‘1’
Line Number: 182
I have cleared the cache, reset the layouts, reinstalled the module, and optimized & repaired the database tables. Nothing worked. Any ideas?