FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 problem with installing SQL2RSS View next topic
View previous topic
Post new topicReply to topic
Author Message
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Tue Sep 06, 2016 9:50 am Reply with quoteBack to top

Hi,

I used the url: http://wwwexample.com/sql2rss.php?CONFIGFILE=mynewconfig.php I have a white screen, what did I wrong?
Thanx for the answer
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Tue Sep 06, 2016 10:02 am Reply with quoteBack to top

What is the link to your sql2rss.php script?

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Tue Sep 06, 2016 10:25 am Reply with quoteBack to top

www.agrarischevacaturebank.nl/sql2rss.php
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Tue Sep 06, 2016 10:43 am Reply with quoteBack to top

When using a file name as a variable in the CONFIGFILE= statement, it assumes that the file referenced is in the same location as the script. So, by using CONFIGFILE=mynewconfig.php, we're telling the script to look for http://www.agrarischevacaturebank.nl/mynewconfig.php

When I tried to go to http://www.agrarischevacaturebank.nl/mynewconfig.php, it said the page couldn't be found, so it's possible that your mynewconfig.php may be in a different location?

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Tue Sep 06, 2016 11:15 am Reply with quoteBack to top

No, I did Upload the configuration file, and put it into the same folder as your sql2rss.php file
View user's profile
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Tue Sep 06, 2016 1:52 pm Reply with quoteBack to top

What for a file name have I to give at the configurationfile? Can you give me the parameter? Thnx
Regards,
André
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Wed Sep 07, 2016 8:03 am Reply with quoteBack to top

Hm... the odd part is that I'm still receiving a "page cannot be found" when I try to access http://www.agrarischevacaturebank.nl/mynewconfig.php, which is what you're calling on. As silly as it may seem, can you double check the web server to see if the mynewconfig.php file is in your website's root web folder for hosting?

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Thu Sep 08, 2016 2:58 pm Reply with quoteBack to top

Halle,
I am sure, i can see the file in the root server. When I tried to go http://www.agrarischevacaturebank.nl/mynewconfig.php I said this on the page now Warning: Division by zero in C:\domains\agrarischevacaturebank.nl\wwwroot\mynewconfig.php on line 32

Warning: Division by zero in C:\domains\agrarischevacaturebank.nl\wwwroot\mynewconfig.php on line 32
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Fri Sep 09, 2016 9:15 am Reply with quoteBack to top

Hi Andre,

I'd like to take a look at your config file. Can you email a copy of it to
support @ notepage.com

Thanks

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Mon Sep 12, 2016 8:48 am Reply with quoteBack to top

Hi Andre,

Find the following line in your mynewconfig.php file:
Code:
$SQLQuery = "SELECT * FROM feedItems WHERE ItemTitle LIKE "%FeedForAll%" ORDER BY ItemPubDate_t DESC LIMIT 10";

and replace it with this line:
Code:
$SQLQuery = "SELECT * FROM feedItems WHERE ItemTitle LIKE '%FeedForAll%' ORDER BY ItemPubDate_t DESC LIMIT 10";

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Andre



Joined: 06 Sep 2016
Posts: 12
Location: Netherlands

PostPosted: Tue Sep 13, 2016 1:54 am Reply with quoteBack to top

It works, thanks!
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