FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Unable to open the ChannelTemplate, sql2rss_Template.xml View next topic
View previous topic
Post new topicReply to topic
Author Message
serkanserttop



Joined: 27 Feb 2007
Posts: 3

PostPosted: Tue Feb 27, 2007 2:06 pm Reply with quoteBack to top

I am getting this error
Unable to open the ChannelTemplate, sql2rss_Template.xml

when I try reaching

http://localhost/mysite/sql2rss/sql2rss.php?CONFIGFILE=sql2rss_DBconfig.inc.php

after the installation steps are over. I am trying to get this working offline first. I think I may be omitting something from the htaccess file. I kept the file names exactly the same in order to make sure that would not cause a problem. Is rss2html required to be installed for this to work? I started straight from this, wondering if that may also be the problem. I was first getting blank pages with other url addresses I tried, so I think it is good that I am getting this error at least, am I right? At least the path must be right?
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Tue Feb 27, 2007 2:43 pm Reply with quoteBack to top

serkanserttop wrote:
I am getting this error
Unable to open the ChannelTemplate, sql2rss_Template.xml

when I try reaching

http://localhost/mysite/sql2rss/sql2rss.php?CONFIGFILE=sql2rss_DBconfig.inc.php

after the installation steps are over. I am trying to get this working offline first. I think I may be omitting something from the htaccess file. I kept the file names exactly the same in order to make sure that would not cause a problem. Is rss2html required to be installed for this to work? I started straight from this, wondering if that may also be the problem. I was first getting blank pages with other url addresses I tried, so I think it is good that I am getting this error at least, am I right? At least the path must be right?


rss2html.php is not required. Are you sure the "sql2rss_Template.xml" file is in the same directory as sql2rss.php?

Jim

_________________
Be sure to check out the FeedForAll Mac tutorials at: http://www.FeedForAll.com/tutorials/

FeedForAll Mac and rss2html.php
support@FeedForAll.com
View user's profileVisit poster's website
serkanserttop



Joined: 27 Feb 2007
Posts: 3

PostPosted: Tue Feb 27, 2007 4:12 pm Reply with quoteBack to top

This is what I have for my Item Template xml.

<item>
<title>~~~price~~~</title>
<link>http://localhost/mysite/index.php?action=listingview&listingID=~~~listingsdb_id~~~</link>
<description>~~~full_desc~~~</description>
<pubDate>~~~RSSDATE(date_entry)~~~</pubDate>
</item>

I realized that error asked for sql2rss_Template.xml , I had sql2rss_ItemTemplate.xml. Changed it, now I have Unable to open the ITEMTemplate, error. I have copied the xml files and renamed them in couple various ways to see if they may work but could not get it to work yet. I will send you the snapshots of the file folder via email as well. [/img]
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Tue Feb 27, 2007 5:03 pm Reply with quoteBack to top

serkanserttop wrote:
This is what I have for my Item Template xml.

<item>
<title>~~~price~~~</title>
<link>http://localhost/mysite/index.php?action=listingview&listingID=~~~listingsdb_id~~~</link>
<description>~~~full_desc~~~</description>
<pubDate>~~~RSSDATE(date_entry)~~~</pubDate>
</item>

I realized that error asked for sql2rss_Template.xml , I had sql2rss_ItemTemplate.xml. Changed it, now I have Unable to open the ITEMTemplate, error. I have copied the xml files and renamed them in couple various ways to see if they may work but could not get it to work yet. I will send you the snapshots of the file folder via email as well. [/img]


The file names are case sensitive. Is that the cause of your error?

Jim

_________________
Be sure to check out the FeedForAll Mac tutorials at: http://www.FeedForAll.com/tutorials/

FeedForAll Mac and rss2html.php
support@FeedForAll.com
View user's profileVisit poster's website
serkanserttop



Joined: 27 Feb 2007
Posts: 3

PostPosted: Tue Feb 27, 2007 5:51 pm Reply with quoteBack to top

I missed something very basic along the install procedure, now the page shows up. I was playing around with the mysql queries to get it right but I found out that someone else wrote a good rss extension for the open source software that I am using, so I will examine how those sql queries work there and will compare if I can accomplish the same with sql2rss. I also want to use rss2sql to do automatic uploads to my database as well and will definitely try rssmesh. I will come back if I am stuck somewhere. Thanks for the help.
View user's profile
HarryJohon



Joined: 20 Dec 2014
Posts: 3
Location: United states

PostPosted: Sat Dec 20, 2014 7:37 am Reply with quoteBack to top

I realized that error asked for sql2rss_Template.xml , I had sql2rss_ItemTemplate.xml. Changed it, now I have Unable to open the ITEMTemplate, error. I have copied the xml files and renamed them in couple various ways to see if they may work but could not get it to work yet. I will send you the snapshots of the file folder via email as well.


NoorAlamShahzad
View user's profile
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme