Force login no longer showing up?

leonki

Joined: 2010-12-18
Posts: 32

Posted: Thu, 2013-09-05 23:02

I finally bit the bullet and upgraded from G2 to G3. The transition was not that simple (as I had to change my workflow - go back to Lightroom and export all my DNG images to JPEG images to get the correct white balance, modifications, etc.)

I finally have it setup the way I like it except for 1 tiny issue. I don't want guest users to see any albums. It's a private gallery installation for family members only.

I'm not sure what I did, but now when a "guest" user goes to the root, they get a "There aren't any photos here yet!" rather than a login screen (as it was when I first installed it). How can I fix this? what did I do wrong?

Thanks.

floridave

Joined: 2003-12-22
Posts: 27300

Posted: Fri, 2013-09-06 13:38

Edit permissions for the root album. I suspect that you have only edited permissions on only the sub albums.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

leonki

Joined: 2010-12-18
Posts: 32

Posted: Sat, 2013-09-07 01:23

I did. Only registered users can view and view full size. The rest have everything ticket off!

The the main album the first entry in MySQL objects DB? Maybe it got somehow corrupt? What should the values be?

leonki

Joined: 2010-12-18
Posts: 32

Posted: Sat, 2013-09-07 02:42

Ok. Upon further digging into the installer folder the following should do it:

INSERT INTO {items} VALUES (1,NULL,NULL,UNIX_TIMESTAMP(),'',NULL,1,1,NULL,NULL,2,0,NULL,'','',1,NULL,NULL,2,NULL,'weight','ASC
',1,NULL,NULL,'Gallery','album',UNIX_TIMESTAMP(),0,1,NULL,'1','1');

If I delete the first row and insert the above values should it fix the problem I'm seeing?

leonki

Joined: 2010-12-18
Posts: 32

Posted: Sun, 2013-09-08 01:09

Well, not sure what caused the hick-up, but I reset the first row of access_caches and access_intents to their default install values in PhpMyAdmin, and the green allow all to view/view full size showed up. When I selected them back to being off, the login screen now shows up correctly!

floridave

Joined: 2003-12-22
Posts: 27300

Posted: Sun, 2013-09-08 02:54

Don't know why you needed to muck about with the DB. As you see, with a fresh install, and setting permissions work as expected.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

leonki

Joined: 2010-12-18
Posts: 32

Posted: Sat, 2013-09-14 00:50

No doubt a fresh clean install works correctly. But after I was done importing my 25K pictures from G2, something was messed up in the DB which required a manual correction. There are bugs in the code, no doubt, I'm just glad I know enough about PHP/MySQL to fix the problem.

floridave

Joined: 2003-12-22
Posts: 27300

Posted: Sat, 2013-09-14 15:30

please point out the bugs so we can fix them.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

leonki Joined: 2010-12-18 Posts: 32	Posted: Thu, 2013-09-05 23:02
	I finally bit the bullet and upgraded from G2 to G3. The transition was not that simple (as I had to change my workflow - go back to Lightroom and export all my DNG images to JPEG images to get the correct white balance, modifications, etc.) I finally have it setup the way I like it except for 1 tiny issue. I don't want guest users to see any albums. It's a private gallery installation for family members only. I'm not sure what I did, but now when a "guest" user goes to the root, they get a "There aren't any photos here yet!" rather than a login screen (as it was when I first installed it). How can I fix this? what did I do wrong? Thanks.
	XUser login Username: * Password: * Create new account Request new password
floridave Joined: 2003-12-22 Posts: 27300	Posted: Fri, 2013-09-06 13:38
	Edit permissions for the root album. I suspect that you have only edited permissions on only the sub albums. Dave _____________________________________________ Blog & G2 \|\| floridave - Gallery Team

leonki Joined: 2010-12-18 Posts: 32	Posted: Sat, 2013-09-07 01:23
	I did. Only registered users can view and view full size. The rest have everything ticket off! The the main album the first entry in MySQL objects DB? Maybe it got somehow corrupt? What should the values be?

leonki Joined: 2010-12-18 Posts: 32	Posted: Sat, 2013-09-07 02:42
	Ok. Upon further digging into the installer folder the following should do it: INSERT INTO {items} VALUES (1,NULL,NULL,UNIX_TIMESTAMP(),'',NULL,1,1,NULL,NULL,2,0,NULL,'','',1,NULL,NULL,2,NULL,'weight','ASC ',1,NULL,NULL,'Gallery','album',UNIX_TIMESTAMP(),0,1,NULL,'1','1'); If I delete the first row and insert the above values should it fix the problem I'm seeing?

leonki Joined: 2010-12-18 Posts: 32	Posted: Sun, 2013-09-08 01:09
	Well, not sure what caused the hick-up, but I reset the first row of access_caches and access_intents to their default install values in PhpMyAdmin, and the green allow all to view/view full size showed up. When I selected them back to being off, the login screen now shows up correctly!

floridave Joined: 2003-12-22 Posts: 27300	Posted: Sun, 2013-09-08 02:54
	Don't know why you needed to muck about with the DB. As you see, with a fresh install, and setting permissions work as expected. Dave _____________________________________________ Blog & G2 \|\| floridave - Gallery Team

leonki Joined: 2010-12-18 Posts: 32	Posted: Sat, 2013-09-14 00:50
	No doubt a fresh clean install works correctly. But after I was done importing my 25K pictures from G2, something was messed up in the DB which required a manual correction. There are bugs in the code, no doubt, I'm just glad I know enough about PHP/MySQL to fix the problem.

floridave Joined: 2003-12-22 Posts: 27300	Posted: Sat, 2013-09-14 15:30
	please point out the bugs so we can fix them. Dave _____________________________________________ Blog & G2 \|\| floridave - Gallery Team

Force login no longer showing up?

XUser login