Hi Aikon,

I don't know when this started but although the module seems to be working fine, I just saw these error messages appearing randomly on my site :-


Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/xxx/public_html/modules/Multiheadlines/functions.php on line 580

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/xxx/public_html/modules/Multiheadlines/functions.php on line 289

It means that just before the execution of mysql_real_escape_string() the link to the sql couldn't be established[for some reason].

In order to escape the strings[special strings] in accordance with the sql server connection charset, this function mysql_real_escape_string has to have a link to the sql server to "know" what charset is used on that sql server[db connection].
If can't get a link to sql server will throw this warning.
This has some thing to do with your hosting and it's settings/maintenance...etc, I guess.

If this will occur frequently you can use the old and deprecated[that will do, though] function mysql_escape_string which doesn't need a connection to the mysql server....or you can suppres the warning with a "@".

I think this has been discussed here, please do a search with the keyword "mysql_real_escape_string" you'll get plenty to read

Many thanks for the detailed reply Aikon. I get it now ... I think.

I'll do a search here to read more on it.

By the way, as a temporary measure, I did the mod like you suggest (without the "real") and it seems to stop the errors but could it be the cause as to why I see some blank feed items in the module page?

The headline block seems to work fine though.

Quote:

but could it be the cause as to why I see some blank feed items in the module page

No. I guess no. Might be something wrong with the source of feeds[feed url]....perhaps this is how[wrongly] the other site is serving the feeds in that rss file...take a look at it....don't know for sure though.

You are probably right Aikon ... as always.

All of the site I watch with MultiHeadlines seem very quiet today so have not been able to check the module again but I'm just dying for 2.1 now anyway. Any chance for it being a Xmas present?

Merry Christmas and Happy New Year to you and your family!

Quote:

All of the site I watch with MultiHeadlines seem very quiet today so have not been able to check the module again...

You just have to point your browser toward that backend file and look the source of that page [view source or CTRL+F3] to see if the there are some description between description or title tags.

Quote:

... but I'm just dying for 2.1 now anyway. Any chance for it being a Xmas present?

Unfortunately no. I am really sorry for this loooong delay but as I said in another post I started some things and I must finish it first. Once again sorry.

Quote:

Merry Christmas and Happy New Year to you and your family

Thank's very much...I also want Happy Holidays!!! to you and dear ones.

Aikon wrote:

You just have to point your browser toward that backend file and look the source of that page [view source or CTRL+F3] to see if the there are some description between description or title tags.

I did that and they appear fine, even through Feedburner. Just to explain, see the image below.

Quote:

Unfortunately no. I am really sorry for this loooong delay but as I said in another post I started some things and I must finish it first. Once again sorry.

No, no , no problems. I'm sure when it comes it'll be very good.

Quote:

Thank's very much...I also want Happy Holidays!!! to you and dear ones.

Same to you and yours. Don't worry about the above picture yet, look at it in 2008.

What exactly is the source[url] of that file...I'll do a check on it.

Hi Aikon,

First of all ... Happy New Year to you!

The source URLs are :-

http://feeds.feedburner.com/RedRc

and

http://www.petitrc.com/_forumphp/external.php?type=RSS2&forumids=218

Thanks!

Apparently both of the feed urls are ok. Check it out.
for RedRC - here
and for petitRC - here.

Yes, both feeds are OK. Seems that the problem originated to where I started this thread.

When I changed the function mysql_escape_string back to the original mysql_real_escape_string , the problem with the blank headlines disappeared.