View Full Version : New Install - No Admin
July 15th, 2004, 02:43 PM
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).
I have verified my admin settins within vb.
July 15th, 2004, 02:50 PM
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.
July 15th, 2004, 02:54 PM
Got it. That was it. I made sure it was set to groupid 6 but didn't look at the others.Thanks.
July 20th, 2004, 07:52 PM
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!
July 20th, 2004, 08:20 PM
As the threads say in the photopost usergroups table the administrators line must have a groupid of 6 and cpaccess of 1
July 20th, 2004, 08:47 PM
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 ?!
" 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:"
July 20th, 2004, 08:52 PM
Browse the groupid then change (edit) the admin value from 5 (photoposts admin setting to 6 (vbulletins admin setting).
July 20th, 2004, 09:18 PM
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 ...
July 20th, 2004, 09:32 PM
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);
July 20th, 2004, 09:33 PM
Oops... missed you were using phpBB... sorry.
July 20th, 2004, 10:13 PM
It's ok Steve :) it was my fault not to specify it from the beginning
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,
July 21st, 2004, 08:00 PM
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
February 25th, 2005, 05:43 PM
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.....
February 25th, 2005, 07:05 PM
Rename this attached file phpbb.php and upload to your install and then rerun install.php to get usergroups back and working
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.