I have linked this event component in Jsitemap Pro. It resolves it fine in Admin, but when displayed on front-end it says
There is a settings error for user defined data source 'Ohanah events', items can't be retrieved.
Please check data source settings and activate data source debug mode to get more details about the error.
Table 'berryvincenta_c.bv13_ohanah_dates' doesn't exist SQL=SELECT `bv13_ohanah_categories`.`ohanah_category_id` AS `jsitemap_category_id`, `bv13_ohanah_events`.`title`, `bv13_ohanah_events`.`ohanah_event_id` AS `id`, `bv13_ohanah_categories`.`title` AS `cattitle` FROM `bv13_ohanah_events` JOIN `bv13_ohanah_categories` ON `bv13_ohanah_events`.`ohanah_category_id` = `bv13_ohanah_categories`.`ohanah_category_id` JOIN `bv13_ohanah_dates` ON `bv13_ohanah_events`.`ohanah_event_id` = `bv13_ohanah_dates`.`ohanah_event_id` WHERE `bv13_ohanah_dates`.`enabled` = '1' ORDER BY `bv13_ohanah_categories`.`title` ASC, `bv13_ohanah_events`.`title` ASC
I did repair on DB and the table is there. Please Advise!
Also
I like to us K2 items for specific categories but I get others, this is the raw sql.
SELECT
`#__k2_items`.`title`,
`#__k2_items`.`modified`,
CONCAT_WS(':', `#__k2_items`.`id`, `#__k2_items`.`alias`) AS `id`,
`#__k2_items`.`catid` AS `55,56,57,58,59,60,61,62,10,22`,
`#__k2_items`.`publish_up`,
`#__k2_items`.`metakey`,
`#__k2_categories`.`name`
FROM `#__k2_items`
JOIN `#__k2_categories` ON `#__k2_items`.`catid` = `#__k2_categories`.`id`
WHERE
`#__k2_categories`.`published` = '1'
AND `#__k2_items`.`published` = '1'
AND `#__k2_items`.`access` IN {aid}
AND (`#__k2_items`.`language` = '*' OR `#__k2_items`.`language` = '' OR `#__k2_items`.`language` = {langtag})
AND `#__k2_items`.`trash` = '0'
AND (`#__k2_items`.`publish_down` > NOW() OR `#__k2_items`.`publish_down` = '0000-00-00 00:00:00'
ORDER BY
`#__k2_categories`.`name` ASC,
`#__k2_items`.`title` ASC