Dolphiq / craft3-plugin-sitemap

A craft 3 plugin that provides an easy way to enable and manage an XML sitemap for search engines like Google
MIT License
28 stars 18 forks source link

DB exception thrown #59

Closed dorothyDorothy closed 3 years ago

dorothyDorothy commented 3 years ago

I cannot see the sitemap.xml on the site or access the settings. How can I rectify this error?

Context

Error thrown

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hrjlaws.craft_dolphiq_sitemap_entries' doesn't exist
The SQL being executed was: SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, count(DISTINCT entries.id) AS `entryCount`, count(DISTINCT elements.id) AS `elementCount`, `sitemap_entries`.`id` AS `sitemapEntryId`, `sitemap_entries`.`changefreq` AS `changefreq`, `sitemap_entries`.`priority` AS `priority`
FROM `craft_sections` `sections`
LEFT JOIN `craft_structures` `structures` ON `structures`.`id` = `sections`.`structureId`
INNER JOIN `craft_sections_sites` `sections_sites` ON `sections_sites`.`sectionId` = `sections`.`id` AND `sections_sites`.`hasUrls` = 1
LEFT JOIN `craft_entries` `entries` ON `sections`.`id` = `entries`.`sectionId`
LEFT JOIN `craft_elements` `elements` ON `entries`.`id` = `elements`.`id` AND `elements`.`enabled` = 1
LEFT JOIN `craft_dolphiq_sitemap_entries` `sitemap_entries` ON `sections`.`id` = `sitemap_entries`.`linkId` AND `sitemap_entries`.`type` = "section"
WHERE `sections`.`dateDeleted` IS NULL
GROUP BY `sections`.`id`
ORDER BY `type`
Error Info: Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'hrjlaws.craft_dolphiq_sitemap_entries' doesn't exist
)
↵
Caused by: PDOException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hrjlaws.craft_dolphiq_sitemap_entries' doesn't exist
in /media/dorothy/Data/websites/fl/deploy/vendor/yiisoft/yii2/db/Command.php at line 1299