Problem with g2helper.inc

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

I was pretty much successful in getting gallery2 and phpbb3 gold integrated. The problem now is the authorization administration. When I try to change any forum authorizations in ACP, I get this error page:

Gallery Integration Error
File: C:\wamp\www\aof\phpBB3\g2helper.inc
Line: 453

Any idea what this could be??

Thanks!
Tom

Quick update:
I looked a little bit further and it seems to be related to the group problem http://www.nukedgallery.net/posts3805-start15.html and the changes in includes/functions_users.php - I made the latest changes that were suggested in that thread and it seems to work as long as only one forum in chosen - with multiple entries chosen, it ends with a white screen and no changes done.

AdBot

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

Did you make these changes also as linked in the page before your referenced page? http://www.nukedgallery.net/postxf3735-0-15.html [nukedgallery.net]

There are some issues with admin roles/groups/users and yes/no/never permissions being addressed right now. I'm not sure if your issue is related to those or you are describing something else.

The integration tries to give more descriptive error messages, is that error message all that is given?

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

Yes, I had these changes already implemented.
Let me try to give a little bit more detail on what I do/try to do:
Go to
Administrator Control Panel -> Permissions -> Forum permissions
Now, if in "select a forum" on the right, I choose only one forum and click on submit, everything seems to work except for these problems:
- if I remove a single authorization, I end up with a blank screen but the authorization is gone when I go back to check
- if I chose more than one forum or multiple groups to be added, the only error message I get is the "Gallery Integration Error", File: .....g2helper.inc, Line: 453. and nothing gets added or removed

Let me know what else I can do to help finding the problem. Unfortunately my php skills aren't the greatest...

Thanks,
Tom

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

Thanks Tom, I'll check into this asap.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

Ok, I see the problem here. I think this is fixed with the following changes. This is fixed in the next release as this code is also part of the G2 admin permission problem.

Code: › #
#-----[ OPEN ]------------------------------------------
#
includes/acp/auth.php

#
#-----[ FIND ]------------------------------------------
#
   if ($auth['a_gallery2'] < 1)

#
#-----[ REPLACE WITH ]------------------------------------------
#
   if ($auth['a_gallery2'] < 1 && empty($forum_id[0]))

#
#-----[ FIND ]------------------------------------------
#
   elseif ($auth['a_gallery2'] === 1)

#
#-----[ REPLACE WITH ]------------------------------------------
#
   elseif ($auth['a_gallery2'] === 1 && empty($forum_id[0]))

#
#-----[ FIND ]------------------------------------------
#
   if ($permission_type !== false)

#
#-----[ REPLACE WITH ]------------------------------------------
#
   if ($permission_type !== false && empty($forum_id))

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

I made these changes and get another error now when I tried to remove two groups from a forum permission:

General Error
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 376
CALL: dbal->sql_error()

FILE: includes/acp/auth.php
LINE: 1093
CALL: dbal->sql_in_set()

FILE: includes/acp/acp_permissions.php
LINE: 822
CALL: auth_admin->acl_delete()

FILE: includes/acp/acp_permissions.php
LINE: 252
CALL: acp_permissions->remove_permissions()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_permissions->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

That's interesting. I don't even see anything in the backtrace that has anything to do with the integration. Does this work without the integration mods in auth.php? I'll try to duplicate the problem on my test machine later...

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

Yes, If I take the last changes out, I am back to the olf behavior.

Tom

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

I must be missing something. If I use the original 0.0.4 mod, I get a blank page when adding/removing forum group permissions. Using the mods posted above, I am able to add/remove permissions at will with single or multiple groups and it seems to work fine.

ACP->Permissions->Forum permissions->select forum in either window->add permissions to one or more groups - works fine...

ACP->Permissions->Forum permissions->select forum in either window->remove permissions to one or more groups - works fine...

ACP->Permissions->Forum permissions->select forum in either window->edit permissions to one or more groups - works fine...

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

Hmm - could you put all your files in an archive and post it here? That way I could replace one file after the other and see where that gets me. Maybe I am missing something. The files I was using were from 11-15-07 - version 004. I was adding it to the latest phpbb release (the golden one).
If you are interested I can give you access to the forum ACP and ftp - but I assume there are more important things on the todo list and if I am the only one running into this problem, it will most likely be a problem with my installation anyhow...

Tom

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1144

Tom - check your pm...

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

Thanks! I will try it in the evening and let you know.

Tom

BigTom · Beginner Joined: Aug 27, 2007 Posts: 11

It works great now! Thanks for all your efforts! Greatly appreciated!

It was the auth.php the code around "if ($clear_prefetch)" looked completely different in my old version.

Thanks again!

Tom

Web Hosting India