FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 incorrect URL View next topic
View previous topic
Post new topicReply to topic
Author Message
dadoonan



Joined: 15 Dec 2007
Posts: 8

PostPosted: Sun Dec 16, 2007 12:13 pm Reply with quoteBack to top

Yesterday's installation problem has been resolved. One more issue still to go.

The url link from the feed is incorrect, http://www.gp.org/~~~http://localhost/GP/press/sql2rss/sql2rss.php~~~


The page in question can be found here: feed://www.gp.org/press/sql2rss/sql2rss.php

Safari is displaying an incorrect link, and Firefox has no links.

thanks,
david
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Dec 16, 2007 12:30 pm Reply with quoteBack to top

dadoonan wrote:
Yesterday's installation problem has been resolved. One more issue still to go.

The url link from the feed is incorrect, http://www.gp.org/~~~http://localhost/GP/press/sql2rss/sql2rss.php~~~


The page in question can be found here: feed://www.gp.org/press/sql2rss/sql2rss.php

Safari is displaying an incorrect link, and Firefox has no links.

thanks,
david


What is generating that? Can you show your config file?

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
dadoonan



Joined: 15 Dec 2007
Posts: 8

PostPosted: Sun Dec 16, 2007 12:56 pm Reply with quoteBack to top

sql2rss_DBconfig.inc.php =

Code:

<?php
//
// sql2rss.php RSS feed generation from SQL Sample Configuration
//
// Copyright 2006-2007 NotePage, Inc.
// http://www.feedforall.com
//
// NotePage, Inc. grants registerd users of our FeedForAll and/or
// FeedForAll Mac product(s) the right to install and use the
// sql2rss.php script free of charge.
// Please refer to the EULA included in the download for full license
// terms and conditions.
//
// $Id: sql2rss_DBconfig.inc.php.sample,v 3.0 2007/04/16 14:23:05 housley Exp $
//

// Database configuration
$config["DBuser"]       = "******";   // Database User Name
$config["DBpassword"]   = "******";   // Database Password
$config["DBmachine"]    = "localhost";  // Name of machine with the database
$config["DBdatabase"]   = "******";    // Name of the database
$config["DBtype"]       = "mysql";      // Type of the database
                                        // "mysql" or "mssql"

?>


---------------

config.php =

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 = "sql2rss_DBconfig.inc.php";

//
// $SQLQuery is a valid database query for your database
$SQLQuery = "SELECT * FROM PressRelease  ORDER BY PR_Date DESC LIMIT 10";

//
// 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");
}

?>


------------------

[b]sql2rss_SampleConfig.php = [/code]


Code:


<?php

//
// sql2rss.php RSS feed generation from SQL Sample Configuration
//
// Copyright 2006-2007 NotePage, Inc.
// http://www.feedforall.com
//
// NotePage, Inc. grants registerd users of our FeedForAll and/or
// FeedForAll Mac product(s) the right to install and use the
// sql2rss.php script free of charge. 
// Please refer to the EULA included in the download for full license
// terms and conditions.
//
// $Id: sql2rss_SampleConfig.php,v 3.2 2007/07/02 10:43:25 housley Exp $
//

//
// Enable the caching for the resulting XML file.  Since it may take time to
// process multiple RSS feeds and may be noticed by visitors to your
// website this is highly recommended.  During development and testing set
// this to 0 so you can see the results of your changes.
$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 = 60;      //cache files for 1 minute
$outputCacheTTL = 3600;    //cache files for 1 hour
// $outputCacheTTL = 86400;   //cache files for 1 day

//
// $ChannelTemplate is the XML file that contains the outer, <channel>, items
// for the produced feed.  This MUST be a valid RSS 2.0 feed without any
// <item>'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 <item>.
// This MUST be a valid RSS 2.0 feed <item>.  It must also specify "UTF-8"
// encoding, since all the produced items will be in UTF-8.
$ItemTemplate  = "sql2rss_ItemTemplate.xml";

//
// $SQLQuery is a valid database query for your database
$SQLQuery = "SELECT * FROM PressRelease  ORDER BY PR_Date DESC LIMIT 10";

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

//
// $debugLevel controls the amount of debugging information that is shown, if any.
//   0 = NONE (default)
//   1 = MySQL errors
//   2 =
//   3 = Informaiton for every step
//
$debugLevel = 0;

//
// 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");
}

?>
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Dec 16, 2007 4:14 pm Reply with quoteBack to top

You have hard coded that into your item template

Code:

<link>~~~http://www.GP/press/sql2rss/sql2rss.php~~~</link>


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
dadoonan



Joined: 15 Dec 2007
Posts: 8

PostPosted: Sun Dec 16, 2007 4:47 pm Reply with quoteBack to top

What should it be?

david



MacSupport wrote:
You have hard coded that into your item template

Code:

<link>~~~http://www.GP/press/sql2rss/sql2rss.php~~~</link>


Jim
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Dec 16, 2007 8:59 pm Reply with quoteBack to top

dadoonan wrote:
What should it be?

david



MacSupport wrote:
You have hard coded that into your item template

Code:

<link>~~~http://www.GP/press/sql2rss/sql2rss.php~~~</link>


Jim


Either
Code:
<link>http://www.GP/press/sql2rss/sql2rss.php</link>

if you always want http://www.GP/press/sql2rss/sql2rss.php. Or
Code:
<link>~~~YouDBFieldName~~~</link>

if you want it substituted with a field in your DB.

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