FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 "an error in your SQL syntax" View next topic
View previous topic
Post new topicReply to topic
Author Message
ivan_slavchev



Joined: 12 Feb 2008
Posts: 11

PostPosted: Fri Feb 15, 2008 8:39 am Reply with quoteBack to top

hi

I achieved success with step

15) You will need the admin username and password from step #2, they are case sensitive.

but now when i add a new feed i get this error message:

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 ('http://sports.yahoo.com/nascar/rss.xml','60','1')' at line 1

Any idea how can i solve this problem?

Thank you in advanced!
View user's profile
ivan_slavchev



Joined: 12 Feb 2008
Posts: 11

PostPosted: Tue Feb 19, 2008 7:03 am Reply with quoteBack to top

Is there somebody who can really help me, because i was wondering, I have posted my question 5 days ago and there is nobody who can answer. I'm already thinkig that these scripts are not very common,

Ok i try one more time.

When i try to add new feed and click submit i get these message:

//// 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 ('http://sports.yahoo.com/nascar/rss.xml','60','1')' at line 1 ////

my build_config.php:

<?php

$config["DBuser"]= "root";
$config["DBpassword"] = "admin";
$config["DBmachine"] = "localhost";
$config["DBdatabase"] = "feeds";
$config["DBtype"] = "mysql";

$config["AdminUsername"] = "rss2sql_Admin";
$config["AdminPassword"] = "3hXTRCK=93";


?>


my rss2sql_config.php:

<?PHP

$config["DBconfigFile"] = "rss2sql_DBconfig.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["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";

?>

And all other files i have let them so without changing






Image

Ist there something that i'm making not correcct?

PLS Help!!![/img]
View user's profile
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Feb 24, 2008 7:28 am Reply with quoteBack to top

ivan_slavchev wrote:
Is there somebody who can really help me, because i was wondering, I have posted my question 5 days ago and there is nobody who can answer. I'm already thinkig that these scripts are not very common,

Ok i try one more time.

When i try to add new feed and click submit i get these message:

//// 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 ('http://sports.yahoo.com/nascar/rss.xml','60','1')' at line 1 ////

my build_config.php:

<?php

$config["DBuser"]= "root";
$config["DBpassword"] = "admin";
$config["DBmachine"] = "localhost";
$config["DBdatabase"] = "feeds";
$config["DBtype"] = "mysql";

$config["AdminUsername"] = "rss2sql_Admin";
$config["AdminPassword"] = "3hXTRCK=93";


?>


my rss2sql_config.php:

<?PHP

$config["DBconfigFile"] = "rss2sql_DBconfig.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["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";

?>

And all other files i have let them so without changing






Image

Ist there something that i'm making not correcct?

PLS Help!!![/img]


Every thing looks good from here. But, I will look a little more.

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:34 am Reply with quoteBack to top

I am getting the same error, all my syntax looks fine.
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