Hi! I'm a new user and am having a problem getting my first sitemap generated from my JReviews content.
Our links have the following structure:
http://www.travel.com/en/fast-foods/729798-burger-king
en = our Joomla root directory
fast-foods = jos_categories.alias
729798 = jos_content.id
burger-king = jos_content.alias
Querying MySQL directly, I can obtain all of the necessary fields as shown below from the following two tables:
t1 = jos_content
t2 = jos_categories
| Code: |
SELECT CONCAT(
t2.alias,
'/',
t1.id,
'-',
t1.alias
)
FROM jos_content as t1
LEFT JOIN jos_categories as t2
ON t1.catid = t2.id
|
If I alter the query above to the format used in JSitemap, the revised query looks as follows:
| Code: |
SELECT CONCAT(
`#__categories`.`alias`
'/',
`#__content`.`id`,
'-',
`#__content`.`alias`
)
FROM `#__content`
LEFT JOIN `#__categories`
ON `#__content`.`catid` = `#__categories`.`id`
|
However, when I attempt to export a sitemap and then look at it with "Show XML Standard Sitemap" I get a single file with the following contents:
| Code: |
<?xml version='1.0' encoding='UTF-8'?>
<sitemapindex xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>
</sitemapindex>
|
Any ideas what might I be doing wrong?
Thanks. -- Rik
