What tests? As I said:

Quote:

Ok, as I said maybe if I run some tests on your site I'll get to bottom of this.

I meant on your site. For that I need access passwords/infos [ftp, mysql and so on...]!!!!

Otherwise I can't help you, I really don't know what is the problem. Never heard of this kind of problem nor I can replicate it.

From what I can see in the code, if are not using the save feeds to database option, the script should not even be using the functions.
I am just wondering now if the option (un check) is being saved to the DB.
I'll do some investigating as I am still having periodic problems with this.

Quote:

From what I can see in the code, if are not using the save feeds to database option, the script should not even be using the functions.

What functions are you referring too?

Quote:

I am just wondering now if the option (un check) is being saved to the DB.

What option?..."Multiheadlines turned on"?

Quote:

I'll do some investigating as I am still having periodic problems with this.

What kind of problems?

Sorry Aikon I should have been more explicit.
I am still getting the same errors reported earlier in this thread which appear under the site footer.
I get one instance of an error relating to the use of mysql_real_escape_string in functions.php line 580
and multiple instances relating to mysql_real_escape_string in functions.php line 289

Line 289 is within the function insert_todb
As I am NOT using the save to database option, surely that function should not even be in use? I have since checked the DB table and the value IS set to '0' which is correct.

As you suggested, I have changed the offending line to

Quote:

$title=@mysql_real_escape_string(stripslashes(check_html($title, "nohtml")));

- the use of '@' suppresses the error message as you would expect but I cannot figure out why the function is even called if I am not saving data to the database.

I have not changed line 580 at all.

The error was sporadic in that, it doesn't appear for days, then suddenly you cannot get rid of them for hours, then they disappear again - it is almost as if there is some data refreshing happening that is driven from the users visit.

I am not using any of the blocks and am using the latest version 2.0.5

As I learned about MySQL[and there is still to learn] the server [MySQL] makes the comunications with the local clients through a file called mysql.sock. Default location of this file is in /tmp folder.

I think when those errors occurs mysql.sock has been removed by some sort of maintance service[or something] from server, e.g. a cron job that removes the obsolete/old files from the /tmp directory. In this case the fix would be to change the location of mysql.sock file.

There can be many reasons why the connection to MySQL server fails but this could be the most likely, due to sporadic caracter of it.

The best fix for this [in the case you woun't get along with you host - and I'm saying this because mine somethimes doesn't know how to do things in order to improve the host service and is to lazy to do something] is to suppress the errors with @ character everywhere the mysql_real_escape_string function appears cause is temporary and it does affect nothing.

I would answer gladly to the other question too, but I still don't know what option is

Quote:

save to database option

?
It's "Colect feeds" or "Multiheadlines turned on" from General Settings page?

I am a hosting provider and have had my techs running around in circles checking everything they can think of including your own suggestion but they have not found anthing yet.

Regarding the function insert_todb
In my General Settings the option "If checked, feeds will be collected into the database, so this will increase day by day." - this is NOT checked.
And Multiheadlines is set to 'YES'.

I may be misunderstanding how your scripts works - I thought having these values set meant that no feeds were saved in the database (other than storing the feed url etc in the feed configuration settings) - that is to say, the database was not used for caching the feeds.

I cannot figure out why the function insert_todb is triggered when a visitor enters the site.

So it is about "Colect feeds" option.

If this option is checked prune system wouln't be active so the feeds will just keep comming into database. In a matter of days/weeks your database will be very big depending on how many feed url you have and how often is released news[feeds] on that url.

If this option is NOT checked then prune system will delete the feeds from your database at a certain time or number of feeds, specified one line below this option in the same page, leaving though some of them.

In either case you must gather[save into DB] the feeds[in order to display, categorize them and so on], so thats why is needed this function.

Quote:

I thought having these values set meant that no feeds were saved in the database (other than storing the feed url etc in the feed configuration settings) - that is to say, the database was not used for caching the feeds.

No. This operation is done with function "Multiheadlines turned on" - the last option on general setting page at the bottom, when is set to set to No

Aikon, thank you for your reply.