Gallery has stopped working and is timing out.

doubleviking

Joined: 2008-10-10
Posts: 8
Posted: Tue, 2009-10-20 00:50


Gallery version 2.3
PHP version 5.2.5
Apache 1.3.41
MySQL 5.0.51a

I started adding photos today (like usual) -- had a few thousand pics in total and growing -- and suddenly I started seeing mysql queries taking 60 seconds involving the view count table

SELECT g2_ImageBlockCacheMap.g_itemId, g2_ItemAttributesMap.g_viewCount FROM g2_ImageBlockCacheMap LEFT JOIN g2_ImageBlockDisabledMap ON g2_ImageBlockCacheMap.g_itemId=g2_ImageBlockDisabledMap.g_itemId, g2_ItemAttributesMap WHERE g2_ImageBlockCacheMap.g_userId = 5 AND g2_ImageBlockCacheMap.g_itemType = 1 AND g2_ImageBlockDisabledMap.g_itemId IS NULL AND g2_ImageBlockCacheMap.g_itemId = g2_ItemAttributesMap.g_itemId ORDER BY RAND() LIMIT 1:

So gallery2.3 has stopped working. Any help?

Or can you show me how to disable view counts totally? I tried to turn off some parts of the code but failed miserably..

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Tue, 2009-10-20 02:16

http://gallery.menalto.com/node/91837

http://gallery.menalto.com/node/33037

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here