J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
Problem creating a JReviews content (listings) sitemap (1 viewing) 
Go to bottom
TOPIC: Problem creating a JReviews content (listings) sitemap
#6041
TRAVEL.COM
Fresh Boarder
Posts: 7
User Offline
Problem creating a JReviews content (listings) sitemap Karma: 0  
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
 
Logged Logged  
  The administrator has disabled public write access.
#6042
John Dagelmore
Admin
Posts: 3716
User Online Now
Re:Problem creating a JReviews content (listings) sitemap Karma: 79  
Hi Rik,

please refer to these duplicated posts, you don't need a custom data source for JReviews:
http://storejextensions.org/forum/view/10-jsitemap/1691-re-sitemap-working-with-jreviews.html http://storejextensions.org/forum/view/10-jsitemap/448-re-jreviews-support-jsitemap-pro.html

The 'sitemapindex' that you get when exporting the sitemap means that you have enabled the 'splitting' feature and probably the sitemap is empty because you have no valid data sources published.

Thanks,
John
 
Logged Logged  
  The administrator has disabled public write access.
#6046
TRAVEL.COM
Fresh Boarder
Posts: 7
User Offline
Re:Problem creating a JReviews content (listings) sitemap Karma: 0  
Hi, John:

Thank you for your reply.

I'd already read those posts but still didn't understand where to go to start.

So for JReviews users just starting out, go to:
Sitemap Datasources -> Content (under the name column).

I guess that starting point is what I didn't understand. For anyone reading this, just ignore all of the query code stuff in my first post. The Content page is where you want to get started. There are no database queries to mess with at all. I guess I thought it was more complex. I'm glad to that it is really simple for JReviews.

Thanks again. -- Rik
 
Logged Logged  
  The administrator has disabled public write access.
Go to top