Feed is Empty!? Debug=Success!

wilcosky · Joined: 28 Jun 2008 Posts: 11

Hello,

Just bought and downloads sql2rss for my site. I installed everything without any issues. I even set the debug level to 3 like another thread suggested, but everything said SUCCESS. It connects to the database fine, the sql query is valid... but, there is no feed. I will paste all my code below, could someone help me figure out why my feed is empty?

Code:

<?PHP

//
// Enable the caching for the resulting XML file. Since it may take time to
$useOutputCaching = 0;

//
// The variable $outputCacheTTL controls how many seconds a cached copy of
// resulting RSS feed can be used before it must be recreated.
$outputCacheTTL = 3600;

//
// $ChannelTemplate is the XML file that contains the outer, , items
// for the produced feed. This MUST be a valid RSS 2.0 feed without any
// 's. It must also specify "UTF-8" encoding, since all the produced
// items will be in UTF-8.
$ChannelTemplate = "sql2rss_ChannelTemplate.xml";

//
// $ItemTemplate is the ITEM file that contains the the template for .
// This MUST be a valid RSS 2.0 feed . It must also specify "UTF-8"
// encoding, since all the produced items will be in UTF-8.
$ItemTemplate = "sql2rss_ItemTemplate.xml";

//
// $configFile is the configuration file with the database username and
// password
$DBconfigFile = "config.php";

//
// $SQLQuery is a valid database query for your database
$SQLQuery = 'SELECT * FROM events WHERE active="1" AND date_time > NOW() AND flagged < 50 ORDER BY date_time ASC LIMIT 50';

//
// Since we are calling sql2rss.php from here, we don't want
// to include a separate config file.
$ConfigFilename = "DO_NOT_INCLUDE_CONFIG";
if (!isset($_REQUEST["buildConfig"])) {
@include_once("sql2rss.php");
}

?>

Code:

<item>
<title>~~~event_name~~~</title>
<link>http://indieshows.net/event/~~~id~~~</link>
<description>~~~description~~~</description>
<pubDate>~~~RSSDATE(fieldname)~~~</pubDate>
</item>

If you need to see any other code let me know... my feed is located at:

http://indieshows.net/rss/rss.php

wilcosky · Joined: 28 Jun 2008 Posts: 11

Nevermind, even though it was showing "success" in debug mode.. the truth is the sql query was still not correct!

So, I fixed my problem.

This always happens to me. I post a support question, then 5 mins. later I fix my problem. GAH.

Well, thanks for the great script!