Hide / Unhide Albums Not Working

ultravista

Joined: 2006-10-08
Posts: 121

Posted: Sat, 2010-10-09 16:12

My G2 installation on a Linux GoDaddy plan is having issues lately. Not only am I getting server 500 errors, the hide / unhidde gallery is not functioning.

I had several galleries hidden, now when I untick the box, the "unhide" starts but times out. When I try to hide and unhide again, the same thing occurs.

Is there a command line or data base command I can issue to unhide all galleries without using the admin panel?

It is almost like the permissions are stuck somewhere.

------------------
Gallery URL = http://www.ultravista.com/g2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.14 cgi-fcgi
Webserver = Apache
Database = mysqlt 5.0.91-log, lock.system=flock
Toolkits = Gd, Exif, ImageMagick, jpegtran, NetPBM
Acceleration = partial/900, partial/900
Operating system = Linux linhost259.prod.mesa1.secureserver.net 2.4.21-63.ELsmp #1 SMP Tue Nov 3 18:23:59 EST 2009 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)
Rows in GalleryAccessMap table = 3767
Rows in GalleryAccessSubscriberMap table = 16645
Rows in GalleryUser table = 2
Rows in GalleryItem table = 16645
Rows in GalleryAlbumItem table = 810
Rows in GalleryCacheMap table = 103666

nivekiam

Joined: 2002-12-10
Posts: 16504

Posted: Sat, 2010-10-09 16:35

That can be a really resource intensive operation if being performed on an album with lots of sub-items.

Try changing from file locking to database locking. You'll probably want to change back as file locking on Linux is typically faster and more reliable than database locking. Go to Site Admin > General (first page you land on) to change that setting.

I'd also clear G2's cache:
FAQ: How can I clear cached data?

With lots of items in a G2 install it's probably best to utilize users and groups instead of hiding or password protecting albums. Create users, create groups, add users to groups. Assign permissions to groups and require people to login. I know it's probably not what you're looking for, but on a low-end shared host who over sells their services it's probably the best answer if you continue to have issues.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

ultravista

Joined: 2006-10-08
Posts: 121

Posted: Sat, 2010-10-09 18:34

nivekiam - I will give that a shot. The main album has about 10 sub-albums, and each of those sub-albums have several sub-albums as well.

For example: UFC > UFC 100 > Fight 01 through Fight 06

ultravista Joined: 2006-10-08 Posts: 121	Posted: Sat, 2010-10-09 16:12
	My G2 installation on a Linux GoDaddy plan is having issues lately. Not only am I getting server 500 errors, the hide / unhidde gallery is not functioning. I had several galleries hidden, now when I untick the box, the "unhide" starts but times out. When I try to hide and unhide again, the same thing occurs. Is there a command line or data base command I can issue to unhide all galleries without using the admin panel? It is almost like the permissions are stuck somewhere. ------------------ Gallery URL = http://www.ultravista.com/g2/main.php Gallery version = 2.3 core 1.3.0 API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5 PHP version = 5.2.14 cgi-fcgi Webserver = Apache Database = mysqlt 5.0.91-log, lock.system=flock Toolkits = Gd, Exif, ImageMagick, jpegtran, NetPBM Acceleration = partial/900, partial/900 Operating system = Linux linhost259.prod.mesa1.secureserver.net 2.4.21-63.ELsmp #1 SMP Tue Nov 3 18:23:59 EST 2009 i686 Default theme = matrix gettext = enabled Locale = en_US Browser = Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C) Rows in GalleryAccessMap table = 3767 Rows in GalleryAccessSubscriberMap table = 16645 Rows in GalleryUser table = 2 Rows in GalleryItem table = 16645 Rows in GalleryAlbumItem table = 810 Rows in GalleryCacheMap table = 103666
	XUser login Username: * Password: * Create new account Request new password
nivekiam Joined: 2002-12-10 Posts: 16504	Posted: Sat, 2010-10-09 16:35
	That can be a really resource intensive operation if being performed on an album with lots of sub-items. Try changing from file locking to database locking. You'll probably want to change back as file locking on Linux is typically faster and more reliable than database locking. Go to Site Admin > General (first page you land on) to change that setting. I'd also clear G2's cache: FAQ: How can I clear cached data? With lots of items in a G2 install it's probably best to utilize users and groups instead of hiding or password protecting albums. Create users, create groups, add users to groups. Assign permissions to groups and require people to login. I know it's probably not what you're looking for, but on a low-end shared host who over sells their services it's probably the best answer if you continue to have issues. ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

ultravista Joined: 2006-10-08 Posts: 121	Posted: Sat, 2010-10-09 18:34
	nivekiam - I will give that a shot. The main album has about 10 sub-albums, and each of those sub-albums have several sub-albums as well. For example: UFC > UFC 100 > Fight 01 through Fight 06

Hide / Unhide Albums Not Working

XUser login