Hi,

Just reporting a potential bug with query cache when using datso gallery.

When I have MySQL5 selected I get these errors in datso backend:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/wikivorce.com/httpdocs/divorce/administrator/components/com_datsogallery/ admin.datsogallery.php on line 1986

When I change to MySQL it works OK.

Many thanks

As a follow up to this ... i have now had to disable query cache.

Althought the selecting MySQL (first in dropdown) got rid of the errors with datso.....it eventually brought my site down .... i had 470 connections to the database open and i guess apache just gave up.

For info i have:

- Joomla 1.0.12
- The latest vsn of query cache.
- dedicated host with APC
(oh and was using APC option in all my configs of query cache)

Well, if DatsoGallery would use the Joomla API correctly, it would work. They use $database->query(), but then call mysql functions. Poor coding, and nothing that querycache can do about it...

Is there any way to have query cache exclude certain components (or perhaps calls to certain tables - in my case any datso table pre-fix) like page cache does with its 'nocache' and 'skip' options?

Well... edit qcache.php... Around line 76, you'll see

Code:

$nocache = array("#__session", "session_id","publish_up <=", "publish_down >=");

add whatever table you want matched into that array...

thanks, that makes sense.

I will give it a try.

-----------


On another topic, about 5 mths ago i gave up on using pagecache 1.0 because i had too many problems with it .... blank pages etc

Today I installed Pagecache 2.0.1 on my site which has many many extensions / components ....fully expecting to see lots of conflicts / issues.

After some config tweaking....it didnt like the APC option...so im using file...(6 hours in) it is working beautifully.

Congrats on how far you have come with Page Cache 2.0

I have 80 people online on my site as i type this and it is performing very well.

Glad to hear it!!! That's why I made PageCache, not to speed up sites necessarially, but to make them handle more load...

sir,
I have problem with datso gallery

lightbox image not showing

I think there is permission issue

but I take permission of image folder






regards,
Uday

Post edited by: udaydahale, at: 2010/01/28 08:04

Post edited by: udaydahale, at: 2010/01/28 09:29

Post edited by: udaydahale, at: 2010/01/28 09:30