FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Can't Cope With This !!!! View next topic
View previous topic
Post new topicReply to topic
Author Message
poppisue



Joined: 02 Sep 2007
Posts: 15

PostPosted: Sun Mar 30, 2008 12:49 pm Reply with quoteBack to top

Jim,

I have spent the entire day 8 plus hours trying to get this thing to work.

The instructions are very unclear!

I have followed the instructions exactly, but they leave steps out, etc.

I uploaded files to server

I did install

I created my database login info

I saved it as rss2sql_DBconfig.inc

I uploaded to server

I did mydomain/rss2sql.php?buildConfig

It says to save new config as ?XXXXX This is very unclear and bad instructions.

I installed the tables on my database and the they are fine.

Admin is not working just giving me blank page.

What do i save the new configuration as and what happens to the original DB configuration file

I remember about a year ago trying to do this and it was exactly the same, never could get it going.

Yet i purchased another product that does the same type of database installation via php and the instructions were exact and perfect. Had it working and installed perfectly and the database populated within 5 minutes.

Why cant you guys do cleared instructions

cookies are enabled, i am using the correct pass word and username, admin box shows up but when i log in nothing happens, just back to the admin screen
View user's profile
poppisue



Joined: 02 Sep 2007
Posts: 15

PostPosted: Sun Mar 30, 2008 3:29 pm Reply with quoteBack to top

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(,,) VALUES

This error occurs when I try to add a datafeed, finally got the admin to login, now getting this error
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Mar 30, 2008 7:30 pm Reply with quoteBack to top

poppisue wrote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(,,) VALUES

This error occurs when I try to add a datafeed, finally got the admin to login, now getting this error


That means there is a mistake in your setup. If you email me the config files I can take a look.

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
poppisue



Joined: 02 Sep 2007
Posts: 15

PostPosted: Mon Mar 31, 2008 12:37 am Reply with quoteBack to top

<?php

$config["DBuser"]= "changed for security";
$config["DBpassword"] = "changed for security";
$config["DBmachine"] = "myhost";
$config["DBdatabase"] = "changed for security";
$config["DBtype"] = "mysql";

$config["AdminUsername"] = "rss2sql_Admin";
$config["AdminPassword"] = "<<<<<<<";


?>


Ok, above is the dbconfig of course i took out my details

and here is the rss2sql config

<?PHP

$config["DBconfigFile"] = "rss2sqlDBconfig.inc.php";

$config["feedInfo"] = "feedInfo";
$config["feedID"] = "feedID";
$config["feedActive"] = "feedActive";
$config["feedURL"] = "feedURL";
$config["updateInterval"] = "updateInterval";
$config["lastUpdate"] = "lastUpdate";
$config["nextUpdate"] = "nextUpdate";
$config["updateStatus"] = "updateStatus";
$config["updateStatusCount"] = "updateStatusCount";

$config["ItemTable"] = "feedItems";
$config["itemID"] = "itemID";
$config["UniqueItemID"] = "CreatedUniqueID";
$config["ItemAddedTime"] = "ItemAddedTime";
$config["ItemTitle"] = "ItemTitle";
$config["ItemDescription"] = "ItemDescription";
$config["ItemContentEncoded"] = "ItemContentEncoded";
$config["ItemLink"] = "ItemLink";
$config["ItemPubDate"] = "ItemPubDate";
$config["ItemPubDate_t"] = "ItemPubDate_t";
$config["ItemEnclosureUrl"] = "ItemEnclosureUrl";
$config["ItemEnclosureType"] = "ItemEnclosureType";
$config["ItemEnclosureLength"] = "ItemEnclosureLength";
$config["ItemGuid"] = "ItemGuid";
$config["ItemAuthor"] = "ItemAuthor";
$config["ItemComments"] = "ItemComments";
$config["ItemSource"] = "ItemSource";
$config["ItemSourceUrl"] = "ItemSourceUrl";
$config["ItemCategory"] = "ItemCategory";
$config["ItemCategoryDomain"] = "ItemCategoryDomain";
$config["ItemCreativeCommons"] = "ItemCreativeCommons";
$config["ItemITunesSubtitle"] = "ItemITunesSubtitle";
$config["ItemITunesSummary"] = "ItemITunesSummary";
$config["ItemITunesDuration"] = "ItemITunesDuration";
$config["ItemITunesKeywords"] = "ItemITunesKeywords";
$config["ItemITunesAuthor"] = "ItemITunesAuthor";
$config["ItemITunesExplicit"] = "ItemITunesExplicit";
$config["ItemITunesBlocked"] = "ItemITunesBlocked";
$config["ItemTrackBackPing"] = "ItemTrackBackPing";
$config["ItemTrackBackAbout"] = "ItemTrackBackAbout";
$config["ItemDCTitle"] = "ItemDCTitle";
$config["ItemDCDescription"] = "ItemDCDescription";
$config["ItemDCDate"] = "ItemDCDate";
$config["ItemDCSubject"] = "ItemDCSubject";
$config["ItemDCCreator"] = "ItemDCCreator";
$config["ItemDCPublisher"] = "ItemDCPublisher";
$config["ItemDCContributor"] = "ItemDCContributor";
$config["ItemDCLanguage"] = "ItemDCLanguage";
$config["ItemDCRights"] = "ItemDCRights";
$config["ItemDCType"] = "ItemDCType";
$config["ItemDCFormat"] = "ItemDCFormat";
$config["ItemDCIdentifier"] = "ItemDCIdentifier";
$config["ItemDCSource"] = "ItemDCSource";
$config["ItemDCRelation"] = "ItemDCRelation";
$config["ItemDCCoverage"] = "ItemDCCoverage";
$config["ItemITMSArtist"] = "ItemITMSArtist";
$config["ItemITMSArtistLink"] = "ItemITMSArtistLink";
$config["ItemITMSAlbum"] = "ItemITMSAlbum";
$config["ItemITMSAlbumLink"] = "ItemITMSAlbumLink";
$config["ItemITMSAlbumPrice"] = "ItemITMSAlbumPrice";
$config["ItemITMSCoverArt53"] = "ItemITMSCoverArt53";
$config["ItemITMSCoverArt60"] = "ItemITMSCoverArt60";
$config["ItemITMSCoverArt100"] = "ItemITMSCoverArt100";
$config["ItemITMSFeatureArt"] = "ItemITMSFeatureArt";
$config["ItemITMSSong"] = "ItemITMSSong";
$config["ItemITMSSongLink"] = "ItemITMSSongLink";
$config["ItemITMSRank"] = "ItemITMSRank";
$config["ItemITMSRights"] = "ItemITMSRights";
$config["ItemITMSReleaseDate"] = "ItemITMSReleaseDate";

?>


Here is the rss2sql_admin config

<?php
//
// rss2sql.php Store RSS feeds into SQL
//
// 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
// rss2sql.php script free of charge.
// Please refer to the EULA included in the download for full license
// terms and conditions.
//
// $Id: rss2sql_admin.php,v 3.1 2007/05/26 00:31:04 housley Exp $
//



// ==========================================================================
// Below this point of the file there are no user editable options. Your
// are welcome to make any modifications that you wish to any of the code
// below, but that is not necessary for normal use.
// ==========================================================================

$ConfigFilename = "rss2sql_DBconfig.inc.php";

if (isset($_REQUEST["CONFIGFILE"])) {
if (stristr($_REQUEST["CONFIGFILE"], "file"."://")) {
// Not allowed
;
}
elseif (stristr($_REQUEST["CONFIGFILE"], "://")) {
// Not allowed
;
} else {
// It is local and must be in the same directory
$ConfigFilename = basename($_REQUEST["CONFIGFILE"]);
}
}

//
// Read in the configuration file
$config = Array();
ob_start();
@include_once($ConfigFilename);
@include_once($config["DBconfigFile"]);

@include_once("FeedForAll_database.inc.php");
ob_end_clean();

// SESSION VARIABLES
//
// Make sure "transparent sid" support is enabled
//
if (ini_get("session.use_trans_sid") == 0) {
ini_set("session.use_trans_sid", "1");
}
ini_set("session.gc_maxlifetime", "14400");

session_name("rss2sql_admin");
session_start();

Function StoreLogin( $username, $password, $delete = 0 ) {
$_SESSION["session_username"] = $username;
$_SESSION["session_password"] = $password;
if( $delete ) {
unset($_SESSION["session_username"]);
unset($_SESSION["session_password"]);
}
}

Function ProcessLogin() {
GLOBAL $config;

if (empty($_SESSION["session_username"]) || empty($_SESSION["session_password"])) {
if (!isset($_POST["login_username"]) && !isset($_POST["login_password"])) {
StoreLogin("","","",1);
} else {
if (($config["AdminUsername"] == $_POST["login_username"]) && ($config["AdminPassword"] == $_POST["login_password"])) {
StoreLogin($_POST["login_username"], $_POST["login_password"]);
} else {
StoreLogin("","","",1);
}
}
}
}

ProcessLogin();

if (!empty($_SESSION["session_username"]) && !empty($_SESSION["session_password"])) {
echo "<FORM METHOD=\"POST\" ACTION=\"$_SERVER[PHP_SELF]\">\n";
echo "<input type=\"Submit\" name=\"logout\" value=\"Logout\">\n";
echo "</form>";

if (FeedForAll_database_connect($config)) {
if (isset($_POST["submit"])) {
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if ($_REQUEST["mode"] == "feed") {
if ($_REQUEST["edit"] == -1) {
FeedForAll_database_query($config, "INSERT INTO $config[feedInfo] ($config[feedURL],$config[updateInterval],$config[feedActive]) VALUES ('$_POST[URL]','$_POST[updateInterval]','$_POST[active]')");
echo mysql_error()."<br>\n";
$_REQUEST["mode"] = "";
} else {
FeedForAll_database_query($config, "UPDATE $config[feedInfo] SET $config[feedURL]='$_POST[URL]',$config[updateInterval]='$_POST[updateInterval]',$config[feedActive]='$_POST[active]' WHERE $config[feedID]='$_REQUEST[edit]'");
}
}
}
}

if (isset($_REQUEST["mode"])) {
if ($_REQUEST["mode"] == "feed") {
if (isset($_REQUEST["delete"])) {
FeedForAll_database_query($config, "DELETE FROM $config[feedInfo] WHERE $config[feedID]='$_REQUEST[delete]'");
}
elseif (isset($_REQUEST["approve"])) {
FeedForAll_database_query($config, "UPDATE $config[feedInfo] SET $config[feedActive]='1',nextUpdate='0' WHERE $config[feedID]='$_REQUEST[approve]'");
}
elseif (isset($_REQUEST["reject"])) {
FeedForAll_database_query($config, "UPDATE $config[feedInfo] SET $config[feedActive]='0' WHERE $config[feedID]='$_REQUEST[reject]'");
}

$feedURL = "";
$updateInterval = 86400;
$lastUpdate = 0;
$nextUpdate = 0;
$updateStatus = "";
$updateStatusCount = "";
$active = 1;
if (isset($_REQUEST["edit"]) && ($_REQUEST["edit"] != "-1")) {
if (($sql = FeedForAll_database_query($config, "SELECT * FROM $config[feedInfo] WHERE $config[feedID]='$_REQUEST[edit]'")) !== FALSE) {
if (($rv = FeedForAll_database_fetch($config, $sql)) !== FALSE) {
$feedURL = $rv[$config["feedURL"]];
$updateInterval = $rv[$config["updateInterval"]];
$lastUpdate = $rv[$config["lastUpdate"]];
$nextUpdate = $rv[$config["nextUpdate"]];
$updateStatus = $rv[$config["updateStatus"]];
$active = $rv[$config["feedActive"]];
}
}
}
if (isset($_REQUEST["edit"])) {
echo "<h3>Work with a feed</h3>\n";
echo "<form method=\"post\" action=\"$_SERVER[PHP_SELF]?mode=feed&amp;edit=$_REQUEST[edit]\">\n";
echo "<table border=\"0\">\n";
echo "<tr><td>Feed URL:</td><td><input type=\"text\" name=\"URL\" value=\"$feedURL\" size=\"64\" maxlength=\"250\"></td></tr>\n";
echo "<tr><td>Update Interval:</td><td><input type=\"text\" name=\"updateInterval\" value=\"$updateInterval\" size=\"12\"> in seconds (86400 is one day)</td></tr>\n";
echo "<tr><td>Next Update:</td><td>$nextUpdate</td></tr>\n";
echo "<tr><td>Last Update:</td><td>$lastUpdate</td></tr>\n";
echo "<tr><td>Update Status:</td><td>$updateStatus";
if (($updateStatusCount != "") && ($updateStatusCount != 0)) echo " x $updateStatusCount";
echo "</td></tr>\n";
echo "<tr><td>Status:</td><td>";
echo "Active <input type=\"radio\" name=\"active\" value=\"1\"";
if ($active) {
echo " CHECKED";
}
echo "> ";
echo "Disabled <input type=\"radio\" name=\"active\" value=\"0\"";
if (!$active) {
echo " CHECKED";
}
echo "> ";
echo "</td></tr>\n";
echo "</table>\n";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit\">";
echo "</form>\n";
}
echo "<p>&nbsp;</p>\n";

}
}
echo "<h3>Actions</h3>\n";
echo "<a href=\"$_SERVER[PHP_SELF]?mode=feed&amp;edit=-1\">Add New Feed</a><br><br>\n";
echo "<table border=\"1\">\n";
echo "<tr><th>Activate</th><th>Delete</th><th>Feed Info</th><th># Items</th><th>Edit/Details</th></tr>\n";
if (($sql = FeedForAll_database_query($config, "SELECT * FROM $config[feedInfo] ORDER BY $config[feedActive]")) !== FALSE) {
while (($rv = FeedForAll_database_fetch($config, $sql)) != FALSE) {
echo "<tr><td align=\"top\">";
if ($rv[$config["feedActive"]]) {
echo "<a href=\"$_SERVER[PHP_SELF]?mode=feed&amp;reject=".$rv[$config["feedID"]]."\">Deactivate</a>";
} else {
echo "<a href=\"$_SERVER[PHP_SELF]?mode=feed&amp;approve=".$rv[$config["feedID"]]."\">Activate</a>";
}
echo "</td><td align=\"top\"><a href=\"$_SERVER[PHP_SELF]?mode=feed&amp;delete=".$rv[$config["feedID"]]."\">Delete</a></td>";
echo "<td>".$rv[$config["feedURL"]]."";
if (($rv["updateStatusCount"] != "") && ($rv["updateStatusCount"] != 0)) {
echo "<br>&quot;<span style=\"color: red;\">$rv[updateStatus]&quot; x $rv[updateStatusCount]</span>";
}
$numItems = "&nbsp;";
if (($sql2 = FeedForAll_database_query($config, "SELECT COUNT(*) AS _count FROM $config[ItemTable] WHERE $config[feedID]='".$rv[$config["feedID"]]."'")) !== FALSE) {
if (($rv2 = FeedForAll_database_fetch($config, $sql2)) != FALSE) {
$numItems = $rv2["_count"];
}
}
echo "</td><td>$numItems</td>";
echo "<td align=\"top\"><a href=\"$_SERVER[PHP_SELF]?mode=feed&amp;edit=".$rv[$config["feedID"]]."\">Edit/Details</a></td></tr>\n";
}
}
echo "</table>\n";
} else {
echo "<p style=\"color: red; font-weight: bolder; font-size: larger;\">Database connection failed. Please recheck all settings</p>\n";
}
} else {
StoreLogin("","","","",1);
//
// Main view: Login
//
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="POST">
<DIV ALIGN="CENTER">
<table border="1"><tr><td>
<table border="0" cellspacing="0">
<tr><td BGCOLOR="#C0C0C0" colspan="2">Please enter your user information</td></tr>
<tr>
<td align="right">Username:</td>
<td><input name="login_username"></td>
</tr>
<tr>
<td align="right">Password:</td>
<td><input name="login_password" type=password></td>
</tr>
<tr>
<td colspan="2" align="center">
<HR>
<input type="submit" name="AuthValues" value="Log In">
</td>
</tr>
</table>
</td></tr></table>
</DIV>
</FORM>
<?php
}

?>
<BR>
<BR>
</BODY>
</HTML>
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Mon Mar 31, 2008 6:30 am Reply with quoteBack to top

poppisue wrote:
<?php

$config["DBuser"]= "changed for security";
$config["DBpassword"] = "changed for security";
$config["DBmachine"] = "myhost";
$config["DBdatabase"] = "changed for security";
$config["DBtype"] = "mysql";

$config["AdminUsername"] = "rss2sql_Admin";
$config["AdminPassword"] = "<<<<<<<";


?>


That all looks good with the one question of do the filenames match, including case?

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
poppisue



Joined: 02 Sep 2007
Posts: 15

PostPosted: Mon Mar 31, 2008 9:00 am Reply with quoteBack to top

File names match including case, yes. The only difference in the case is when you configure dbconfig, it supplies you with login of rss2sql_Admin with an UPPER CASE "A", but the actual file is in lower case rss2sql_admin.

I dont know if this makes a difference
View user's profile
poppisue



Joined: 02 Sep 2007
Posts: 15

PostPosted: Mon Mar 31, 2008 9:19 am Reply with quoteBack to top

I have the login interface, am able to login now to insert feed links, but getting that syntax error and cant logut. When i go to logout, just goes back to insert a feed. If this helps to get to the root of the problem
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