FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Feed is Empty!? Debug=Success! View next topic
View previous topic
Post new topicReply to topic
Author Message
wilcosky



Joined: 28 Jun 2008
Posts: 11

PostPosted: Sat Jun 28, 2008 9:08 pm Reply with quoteBack to top

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
View user's profile
wilcosky



Joined: 28 Jun 2008
Posts: 11

PostPosted: Sat Jun 28, 2008 9:44 pm Reply with quoteBack to top

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!
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