Bug report ?

[Manalo001]

hello
with virtuemart 1.1.3 php 5.2.6 jommla 1.5.9
Random errors after select categories. (sometimes appears on a category selected sometimes not with the same...)

Warning: mysql_real_escape_string() expects parameter 2 to be resource, boolean given in /homez.109/colorsin/www/libraries/joomla/database/database/mysql.php on line 193

This errors was reported few times since one year on the forum but not really solutions.

Can you help me to solve my problem please?
Thanks
thierry

[zimba7k]

same problem for me with the 1.1.2 virtue mart and 1.5.9 Joomla

I was wondering :
1. if it was related to the server speed
2. if by changing the error reporting level it would be possible to hide the warning that doesn't have any functional consequences.

[aravot]

Never seen the error, don't know what the cause of it is.

[Manalo001]

i agree , probably a problem with the response server.
It's very difficult to have the same error on the same item menu twice.
warning not prevent to work correctly so if we could hide it ...

if you're lucky you can have this warning on www.colorsinbox.com by selecting menu few times and you 'll see ! (users tell us many times about this warning and i could see it in 2 minutes)

[zimba7k]

I'm upgrading the server and will let you now if with more threads to the db it still appears.

To be continued

[aravot]

Which SEF are you using?

[aravot]

It seems a connection issue base on this post http://forum.joomla.org/viewtopic.php?f=428&t=355340&view=previous

[zimba7k]

yeah I believe (and want to make sure) it's when the database doesn't have any thread free to execute the request

[zimba7k]

Yeap : that was it, too much requests processed lead to having not enough threads available to the database.

I have changed to 10 thread and don't experience the bug anymore.

Hope that helps.

[zimba7k]

Never had the problem again, so I guess it's the solution.