Unable to open the ChannelTemplate, sql2rss_Template.xml

serkanserttop · Joined: 27 Feb 2007 Posts: 3

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?

MacSupport · Joined: 24 Feb 2005 Posts: 2805

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

serkanserttop · Joined: 27 Feb 2007 Posts: 3

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]

MacSupport · Joined: 24 Feb 2005 Posts: 2805

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

serkanserttop · Joined: 27 Feb 2007 Posts: 3

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.

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

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