Not an admin????(FIXED)

[dropmachine]

So, I can log in to the newest installation of Reviewpost, but it tells me I'm not an admin! If i'm not the admin, i'd sure like to know who is.

This is a fresh install, done about 5 minutes ago.

It says "You are not a valid administrator or moderator! "

grr./

[Chuck S]

well maybe a bit more information would help here as in a url and integration type

[dropmachine]

sorry about that.

Addy is: http://www.dropmachine.com/reviews/members/index.php

Integrated with PHPBB.

[Chuck S]

I dont see any issues here with phpbb2 integration

Content visible to verified customers only.

On install a usergroups table is created with 10 fields and the 3 inserts above also have 10 fields

So using phpmyadmin what exists in your reviewpost usergroups table??

[dropmachine]

This is what is in my review post usergroup table

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: infongd5810
-- Generation Time: Aug 29, 2005 at 05:52 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.10-2
--
-- Database: `db115147467`
--

-- --------------------------------------------------------

--
-- Table structure for table `rp_usergroups`
--

CREATE TABLE `rp_usergroups` (
`groupid` int(5) NOT NULL auto_increment,
`groupname` varchar(50) NOT NULL default '',
`cpaccess` smallint(3) NOT NULL default '0',
`uploads` smallint(3) NOT NULL default '1',
`reviews` smallint(3) NOT NULL default '1',
`editpho` int(3) NOT NULL default '1',
`editposts` int(3) NOT NULL default '1',
`modaccess` smallint(3) NOT NULL default '0',
`reqmod` int(3) NOT NULL default '0',
`uplimit` int(3) NOT NULL default '0',
PRIMARY KEY (`groupid`)
) TYPE=MyISAM AUTO_INCREMENT=2524 ;

--
-- Dumping data for table `rp_usergroups`
--

INSERT INTO `rp_usergroups` VALUES (663, 'TEAM', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `rp_usergroups` VALUES (2455, 'Dirtbags', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `rp_usergroups` VALUES (2523, 'core', 0, 0, 0, 0, 0, 0, 0, 0);



ANother fun bit i just noticed. When you click on the default catagory, it gives me a 404 error. Thats a bit weird. Should I maybe just reinstall it?

[dropmachine]

I am going to reinstall it, see how that goes. Who knows, maybe something went nuts. There are no reviews in there, so no big loss anyways.

[Chuck S]

Interesting your core usergroups are not in there but I see nothing wrong with them below as I already stated let me know

Content visible to verified customers only.

[dropmachine]

Alright so I reinstalled it, and the same thing happened. I tried putting the code above in through PHPmyadmin and this is what i got:

SQL-query:

$query[] = "CREATE TABLE {$rp_db_prefix}usergroups (groupid int(5) NOT NULL auto_increment, groupname varchar(50) NOT NULL default '', cpaccess smallint(3) NOT NULL default '0', uploads smallint(3) NOT NULL default '1', reviews smallint(3) NOT NULL default '1', editpho int(3) NOT NULL default '1', editposts int(3) NOT NULL default '1', modaccess smallint(3) NOT NULL default '0', reqmod int(3) NOT NULL default '0', uplimit int(3) NOT NULL default '0', PRIMARY KEY (groupid)) TYPE=MyISAM"


I really have no idea about this stuff.

[dropmachine]

More stuff.

So, not sure if this matters, but in myadmin is says I've installed version 2.91, not 3.0.

Maybe thats part of the problem?

[Chuck S]

add this

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

[clockwood8494]

Originally Posted by omegatron

add this

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

I had the same problem after doing a fresh install of v3 over an existing DB. The above code fixed the problem for me. Thanks.

[Chuck S]

Yep thanks