Unable to access admin page

[skj310]

I think it's time i join this discussion, as i too have had a headache with my upgrade from 4.8.2 to 4.8.6.

Things to note: integrating photopost with phpnuke 7.4 (which means phpbb).

So i looked at the resolutions that were posted in this thread and they just didn't seem to hit home with me, something seemed a-miss. Thing is that i've done various photopost upgrades and have struggled with making things click with phpnuke before. So i knew that it was a LARGE chance the my problems would lie in forums/nuke.php (they did!)

First ... was my usergroup table accurate?
Verifying the import_user_group function in nuke.php ...

$query[] = "INSERT INTO {$pp_db_prefix}usergroups VALUES ('1','Anonymous',0,0,0,0,0,0,0,0,0,0)";
$query[] = "INSERT INTO {$pp_db_prefix}usergroups VALUES ('2','Admin',1,1,1,0,0,1,1,1,1,0)";

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

Something not quite right here. For one the photopost usergroups table contains 14 fields, not 12. The second thing that didn't seem to work was that {$pp_db_prefix} would not resolve to what was written either the config-inc.php or config-int.php files (i.e. $pp_db_prefix should equal "pp_").

The 2nd part that bothered me was $setup=mysql_query... should this call the ppmysql_query function?

In the end i modified this bit of code to look like this:

$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous',0,0,0,0,0,0,0,0,0,0,0,0)";
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('2','Admin',1,1,1,0,0,1,1,1,1,0,1,0)";

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$setup = ppmysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

NOW if i clear the photopost usergroups table and execute the function import_user_groups ... BOOOM!!! My photopost usergroup table populates exactly as it should.

Still no "Admin" option on my main photopost page. Bugger! I'm still logged in as admin to phpnuke, this should work! It worked with photopost 4.8.2. Where else can there be a problem.

I got to thinking ... hmmm maybe the authenticate function. This is where the thread mentioned adding "$ubbgroups = array(); $User = array();" which i previously tried, and to no avail! So what else? I noticed that the login for guests was set to

$ubbgroups[0] = -1;

Which was a headache from 4.8.2 and i figure should be:

$ubbgroups[0] = 1;

... since "1" is the anonymous user in phpnuke world.

But that's not the problem! Still no admin panel!

Finally I caught on this slice of code ... a slight change from 4.8.2

$xloop=0; $unl_up=0; $unl_disk=0; $nouploadlimit=0; $nomod=0;
$vbgroups = explode( ",", $usergroups);
$CatPerms = array();

foreach ( $vbgroups as $groupvalue ) {

can't say i really understand the need for using $vbgroups in this for loop when previously the for loop was executed against $ubbgroups. So I figure, why not ... give it a whirl

$xloop=0; $unl_up=0; $unl_disk=0; $nouploadlimit=0; $nomod=0;
$vbgroups = explode( ",", $usergroups);
$CatPerms = array();

foreach ( $ubbgroups as $groupvalue ) {

HOLY COW!!! Now i can see my "admin" panel option on the main menu! I click it and bam! it works!

So photopost, tell me ... have i jumped off the deep end?

[Chuck S]

Yes that is a bug in the new version that I just fixed for customer the other day

I think I know the cause of the problem. My Admin, Anonymous, and Regular Users groups didn't get auto-created by the install either. I created the SQL query based on Omegatron's post above, and phpMyAdmin said: "#1136 - Column count doesn't match value count at row 1 "

The following code in forums/phpbb2.php appears to be incorrect:

Content visible to verified customers only.

I believe it should be:

Content visible to verified customers only.

I didn't change the code in my install, so I haven't actually tested this fix, but the way I found out that the code was wrong was much in the same way that skj310 did - - running the queries manually in phpMyAdmin. After I added the last 2 fields to each query, it worked. I now have an admin menu.

-jared

[Chuck S]

This has been fixed in the downloadable build since I posted well over a week ago.

The phpbb2 usergroup inserts definately have 14 fields which is the ones I posted as the fix.

Most likely you where working from an older distribution download.

Ahhh, yes. I had missed the word *update* in that post, and assumed it to be the same 4.86. Naming it 4.86a or 4.87 would have made that more obvious.

-jared

[Chuck S]

Well we have been good about just sliding in the fixes for any discovered bugs.

Renaming things in general like we did with 4.7a,b,c,d,e,f,g,h,i,j like we tried to do just utterly confused everyone. Thats why when someone posts a support thread and it is an issue from like say 4.8.6 they downloaded beginning of January that has been fixed I have just been saying redownload the distribution and upload the new files

[simmonet]

Exactly when it happened for me too

Anyone have a step by step for us relatively non techies to fix quickly?

Just replacing files work?

Would really appreciate some suggestions

Thanks

Grant

[Chuck S]

As stated if your using the latest files this is fixed as it was submitted a few weeks ago and corrected

[simmonet]

Went to phpmyAdmin and updated Admin record access=1, now works

Thanks for your assistance.

[Diana5735]

I just downloaded and installed V 4.8.6 successfully through the Install. I did the TWO fixes as described in this thread with no avail. The build did not have the corrections.

I am integrating PhotoPost into PHPBB2 and I am using the user database from PHPBB. I configured the install to use the same database as my PHPBB.

Im relatively new to PHPBB and VERY new to PhotoPost. I have gathered or made the assumption that the Admin User that I use to admin my PHPBB board is the SAME user that I will use to Admin PhotoPost. I can logon onto Photopost using that user and password fine, but I don't get the Admin panel. I checked the PHPBB setup to ensure that the userid I am using is setup as the Administrator which it is, which if figured cuz I use that logon to access the Admin in phpbb.

HELP.

I am not familiar with accessing phpbb through the phpMyAdmin function as Simmonet described to set the Admin Access = 1.

Thanks for your help.

Diana

[Chuck S]

Diana

You must be an admin to have an admin link as in be in usergroup 2 which means you have to have a user level of 1 not 0 in phpbb.

Honestly I dont know what is happening as the current download is correct

There are 14 usergroup fields and the inserts have 14 entries. If you belong to usergroup 2 then you should have an admin link.

Try logging in with the main phpbb admin and see if you have an admin link as you should

You can PM me the link to your board and admin login

[ascender]

At last!

Been struggling with this for a while now, its not the easiest if you're just learning how to use phpmyadmin.

Fresh install of 4.8.6 and the CPACCESS was set to 0 for admin and moderators so I couldn't get into the admin panel. I also had to make the manual change to the phpbb2 file.

I can see why you offer an installation service now!

Cheers,


Mike.

[Chuck S]

see you other post

FWIW, I just did a fresh install of 5.0 (new directory on server, empty database w/no tables, etc). Same problem with phpbb2 integration.

Thanks to this thread, though, at least I know how to fix it!

I just enter this into phpMyAdmin:

INSERT INTO usergroups VALUES ('1','Anonymous','','','','','',0,0,0,0,0,0,0), ('2','Admin',1,1,1,'','',1,1,1,1,0,0,0), ('3','Regular Users','',1,1,'','',1,1,0,1,0,0,0);

Next I will try to figure out why it says "Top Posters" at the top of every page - - before the header.

-jared

Edit: Well, I get the link to the Admin area now, but all adm-index says is "Top Posters". View source acts as if I don't have frame support enabled.

I'll start up another thread for this, though.

[Janl]

I purchased PhotoPost yesterday and everything installed correctly without any problems. I installed it in the same database as phpBB and set up the gallery and the forums. Had people register and post in both the forum and the gallery. Then I started to think that I needed some moderators. I made a moderators group in phpBB and then went into the control panel of PhotoPost. I clicked on Edit Usergroups and clicked on (Refresh usergroups from your forum software?). Suddenly I was not an Admin any more. I couldn't even post to the gallery. I fixed the problem by re-installing the usergroups table and this gave me back my admin rights. However, there seems to be some problem with creating moderators with phpBB. Will there be a fix for this soon?

Thanks

Jan

[Chuck S]

My comment above is for phpbb2 but should be the same for 4.8.6 although you will need to probally adjust the inserts to the correct number of rows

[Janl]

I'm totally lost here. Am I in the wrong thread? All I want to do is add a moderator group to PhotoPost but when I do it adds the moderator group but erases all the other groups including the Admin group and I lose all admin priviledges. I've struggled for over a day to get this integrated into my site. The template is a nightmare to customise but everything looks good now and works, except when trying to add a moderators group. Please help as I've already invested a lot of time and money in this script.

Thank you

Jan

[Chuck S]

Try out photopost 503 so we are dealing with the same code.

I dont have 486 and why deal with old bugs when the new code should take care of the issue

[Janl]

Originally Posted by omegatron

Try out photopost 503 so we are dealing with the same code.

I dont have 486 and why deal with old bugs when the new code should take care of the issue

Are you responding to me? I only purchased the script yesterday. Has it been upgraded since then? It is version 503, by the way.

[Chuck S]

Did you adjust the file as I noted above and uncomment the lines stated.