New Install - No Admin

[Steve_C]

I just installed a fresh copy of 4.8d with vb 3.0.3 integration and everything seemed fine up until there is no ADMIN link when I am logged in and when I try the adm-index.php, it only displays a few of the options (no config, categories, etc).

http://www.mcfarlaneguide.com/photos/index.php

I have verified my admin settins within vb.

Steve, there are hundreds of threads here on the same subject. Please check to ensure your usergroup settings in PhotoPost have all 1's for the flags for the admin group. Use phpMyAdmin to view the settings.

[Steve_C]

Got it. That was it. I made sure it was set to groupid 6 but didn't look at the others.Thanks.

[derrickdn]

Sorry, I am a little tardy ... I am looking at phpMyadmin panel but not sure what to do next!? I just dont want to mess up the table. Can anyone help me to change the GroupID, please!

Really appreciate,

Derrickn

[Chuck S]

As the threads say in the photopost usergroups table the administrators line must have a groupid of 6 and cpaccess of 1

[derrickdn]

I clicked the usergroups table but can't find the administrors line
as you said. Below is the entire listing of my photopost usergroups ...
I tried to change groupid to 6 & cppanel to 1 but I guess I didn't
do it from administrators line so I still not be able to access
the admin panel yet! I may have missed out something huh ?!
Thanks

" Field Type Attributes Null Default Extra Action
groupid int(5) No auto_increment
groupname varchar(50) No
cpaccess smallint(3) No 0
modaccess smallint(3) No 0
uploads smallint(3) No 1
comments smallint(3) No 1
diskspace int(10) Yes NULL
uploadsize int(10) Yes NULL
editpho int(3) No 0
editposts int(3) No 0
canassign int(3) No 0
reqmod int(3) No 0
useralbums int(3) No 0
Check All / Uncheck All With selected:"

[Steve_C]

Browse the groupid then change (edit) the admin value from 5 (photoposts admin setting to 6 (vbulletins admin setting).

[derrickdn]

Would it still be the same (value 6) with phpBB & not using vb, Steve? I tried but still not be able to get it to work ...

[Chuck S]

In phpBB the administrators groupid should be 2 and cpaccess 1

Below are the inserts from phpbbs

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

[Steve_C]

Oops... missed you were using phpBB... sorry.

[derrickdn]

It's ok Steve it was my fault not to specify it from the beginning

Omegatron,
Could you show me step-by-step to insert the values to my phpBB usergroup table? I am not familiar w/ running mySQL queries ... or I could give you access to phpmyadmin so you could do this!
I already changed value in photopost usergroup table as you advised ...

Thanks in advance,

Derrickn

[Chuck S]

Derrick via phpmyadmin you can delete out of the photopost usergroups table any entries are in there.

Then go to the sql window in phpmyadmin and copy and paste the insert queries I pasted above

If you run a table prefix make sure to add that to the front of usergroups

[ascender]

Hi,

I've just tried pasting the above inserts into phpmyadmin and get the following error back - #1136 - Column count doesn't match value count at row 1

Any ideas? I've added the pp_ prefix to the query first.

Edited to say: I've found the answer (I think) in another thread where someone corrected the query.

This is all driving me nuts though.....

Thanks,

Mike.

[Chuck S]

Rename this attached file phpbb.php and upload to your install and then rerun install.php to get usergroups back and working