Subscribe: FeedForAll
http://www.feedforall.com/forum/rss.php
Preview: FeedForAll

FeedForAll



FeedForAll Support Forum



Last Build Date: Wed, 26 Apr 2017 03:54:54 GMT

 



SQL2RSS (MySQL to RSS Feed Creator) - RE: Warning: Division by zero in /home/etc.
Author: Tech Support
Posted: Tue Apr 25, 2017 12:13 pm (GMT -5)

I think it's a quote problem. One of the below should help:

$SQLQuery = "SELECT * FROM posts WHERE post_status LIKE '%1%' ORDER BY post_title DESC LIMIT 25";

$SQLQuery = 'SELECT * FROM posts WHERE post_status LIKE "%1%" ORDER BY post_title DESC LIMIT 25';
_________________
Create RSS Feeds
Audio Recording and Editing



SQL2RSS (MySQL to RSS Feed Creator) - Warning: Division by zero in /home/etc.
Author: FallColours
Subject: Warning: Division by zero in /home/etc.
Posted: Mon Apr 24, 2017 7:27 pm (GMT -5)

I have run the query that I set in the config file, now named myfeed.php and it returns exactly what I asked it to when I do a query via phpadmin at the database, but when I try to access the feed via http:/mywebsite.com/myfeed.php I continually receive the following error- Warning: Division by zero in /home/socialinterests/public_html/Feeds/myfeed.php on line 32.

I've looked this issue up at stackoverflow and other places but it makes no sense to me. Could you give me any help? This is the statement on line 32.

$SQLQuery = "SELECT * FROM posts WHERE post_status LIKE "%1%" ORDER BY post_title DESC LIMIT 25";

Any help would be greatly appreciated.

Thanks (image)



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: Tech Support
Posted: Wed Apr 19, 2017 8:00 am (GMT -5)

If you are using RSS2HTML to insert a feed into an existing webpage, then the encoding declared at the top of the HTML source for the whole webpage comes into play too, as it will be what the browser uses.

Since a webpage can only support one encoding you can run into situations where some text just can't be displayed correctly.

For example, if the encoding that your webpage needs is different than the encoding used in the RSS feed you are inserting. Or, if you are inserting multiple RSS feeds into a single webpage, and they each have different encodings.
_________________
Create RSS Feeds
Audio Recording and Editing



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Posted: Tue Apr 18, 2017 4:42 pm (GMT -5)

Still not worked, looking at the BBC weather feed I see it gives the encoding in the feed as UTF-8, does that mean you need no encoding statement in the template?
Secondly, although it has UTF-8 as the encoding, the letter "A" characters have the character ^ above it, otherwise they appear correct.



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: Tech Support
Posted: Tue Apr 18, 2017 2:57 pm (GMT -5)

Correct, you can only have one and it will need to go in the template header.
_________________
Create RSS Feeds
Audio Recording and Editing



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Posted: Tue Apr 18, 2017 2:46 pm (GMT -5)

I assume that you can only have one? Am I right that it goes in the template header?
Regards, Dave.



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: Tech Support
Posted: Tue Apr 18, 2017 2:42 pm (GMT -5)

Without knowing the encoding of the source feeds (they don't seem to include one) you kind of have to guess which one to use in your template.

If utf-8 isn't helping, then the next most popular is this:

encoding="iso-8859-1"
_________________
Create RSS Feeds
Audio Recording and Editing



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Posted: Tue Apr 18, 2017 12:50 pm (GMT -5)

[quote="ArmouredWurzel"]Ah I see it, in the sample template header?[/quote]

I must be looking in the wrong place as id did not fix the problem!

Grateful for your guidance.

Dave.



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Posted: Tue Apr 18, 2017 12:35 pm (GMT -5)

Ah I see it, in the sample template header?

Regards,

Dave.



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Posted: Tue Apr 18, 2017 12:30 pm (GMT -5)

Sorry but are you saying in the header of the page that is calling the feeds?

My code looks like this:

[color=blue]




$XMLFILE = "http://www.bournemouthecho.co.uk/news/rss/";
$TEMPLATE = "sample-template-short-2012.html";
$MAXITEMS = "5";
include("rss2html.php");

?>


[/color]
Grateful if you could be a little more specific in where the code needs to go.

Thanks,

Dave.



General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: Tech Support
Posted: Mon Apr 17, 2017 2:05 pm (GMT -5)

Dave,

That's a bit odd, both of your feeds are missing the encoding declaration.

You'll want to add encoding="UTF-8" to your RSS header.

For example, with this feed:
http://www.pcadvisor.co.uk/latest/rss

you would want to update this:


to this:

_________________
Create RSS Feeds
Audio Recording and Editing






General RSS Discussions - RE: Special characters in feed titles make them unreadable!
Author: Tech Support
Posted: Mon Apr 17, 2017 7:42 am (GMT -5)

What's the link to your feed? This usually happens when your website doesn't use UTF-8 encoding but I'd like to have a look to be sure.
_________________
Create RSS Feeds
Audio Recording and Editing



General RSS Discussions - Special characters in feed titles make them unreadable!
Author: ArmouredWurzel
Subject: Special characters in feed titles make them unreadable!
Posted: Sat Apr 15, 2017 8:07 am (GMT -5)

I am getting feed titles such as "“I’m absolutely gobsmacked”: Former landmark ......." which clearly means the feed title is unreadable. Sometime back I recall updating a template to overcome this issue but now some feed titles have the issue re-appearing. Grateful if anyone could advise me how to correct this issue.

Regards, Dave.



RSS2SQL (RSS to MySQL Feed Importer) - RE: rss2sql error message
Author: upholder
Subject: rss2sql and browser message
Posted: Fri Apr 07, 2017 1:54 pm (GMT -5)

No records(0) under feeditems table but do have 7 records under feedinfo table,also I am having another question I,did get following error message " $errorCode = 76
xml_error_string() = Mismatched tag
xml_get_current_line_number() = 11
xml_get_current_column_number() = 8
xml_get_current_byte_index() = 754"when setting up for one of feeds,I did know someone post related to this request in this forum,do you have any direction what would that be,thanks again.