Login Issues

Semere · December 3rd, 2004, 10:53 PM

Hi all,
Just installed photopost agian from the longest time of not having it. Now I am trying to login to the admin section http://www.artheon.com/gallery/adm-index.php and when I try to do this it takes me to http://www.artheon.com/gallery/index.php when I try to navigate to the /adm-index.php it tells me I am not a valid Administrator or Moderator. I am the only person registered to the gallery and it is a fresh installation. Could someone help the newbie out some? I also have no integration going. I am not trying to integrate either.

Thanks agian,
Roger

frisser · December 4th, 2004, 01:24 AM

Yes, have the same problem

If I look in the database everything is installed correctly only usergroups is empty. I know from my previous version that there are values in the usergroups (Administrator, Banned etc.... ) and they are not there anymore.
I use the internal Photopost user registration system (no forum software) and have this problem with version 4.8.2 and the lastest beta 4.8.5b3
And after I filled in the Photopost user registration (final step) I receive this error message:
Error: Column count doesn't match value count at row 1
Error: Column count doesn't match value count at row 1
Error: Column count doesn't match value count at row 1
Error: Column count doesn't match value count at row 1
Error: Column count doesn't match value count at row 1

Semere · December 4th, 2004, 07:51 AM

I have vb3 however I don't want to integrate these two applications at this time. The only problem I have is when I try to access the admin page it tells me I am not a valid administrator or moderator.

frisser · December 4th, 2004, 01:45 PM

I think it's the problem with the Internal Photpost User registration system... so if you install Photopost with vb3 (or other forum script) you don't have these problems??
Hopefully someone out there have a solution for this problem, I really would like to use the script!

Chuck S · December 4th, 2004, 02:19 PM

Semere you choose internal registration correct. If you view your Photopost usergroups table in a mysql database viewer like phpmyadmin what is there?

For an internal install you should have entries like this

INSERT INTO usergroups VALUES (5,'Administrator',1,1,1,1,'','',1,1,1,0,0);
INSERT INTO usergroups VALUES (1,'Banned','','','','','','',0,0,0,0,0);
INSERT INTO usergroups VALUES (3,'Unregistered','','','','','','',0,0,0,0,0);
INSERT INTO usergroups VALUES (4,'Registered','','',1,1,'','',1,1,1,0,0);
INSERT INTO usergroups VALUES (2,'COPPA','','','','','','',0,0,0,0,0);

Note admin is usergroup 5

Let me know the answer and we can go from there.

Frisser

The problem with 4.8.5 VB usergroups is the CREATE usergroup is a bit whacked.

Try doing this

DROP that usergroups table and run this in phpmyadmin replacing what prefix you have on there.

CREATE TABLE 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', comments smallint(3) NOT NULL default '1', diskspace int(10) default NULL, uploadsize int(10) default NULL, editpho int(3) NOT NULL default '1', editposts int(3) NOT NULL default '1', modaccess smallint(3) NOT NULL default '0',useralbums int(3) NOT NULL default '0',reqmod INT(3) DEFAULT '0' NOT NULL, canassign INT(3) DEFAULT '0' NOT NULL, PRIMARY KEY (groupid)) TYPE=MyISAM;

THEN add this insert

INSERT INTO usergroups VALUES (6,'Administrator',1,1,1,1,'','',1,1,1,0,0);

You should be able to login and refresh the usergroups to add the rest

Semere · December 4th, 2004, 05:50 PM

Umm I am not real good with databases. If you would tell me how to decipher this information for you I would be more than glad to. However I was kinda thinking that the install script would take care of stuff like this.

This is what I see I have no clue if it is what you need.

groupid int(5) No auto_increment Change Drop Primary Index Unique Fulltext
groupname varchar(50) No Change Drop Primary Index Unique Fulltext
cpaccess smallint(3) No 0 Change Drop Primary Index Unique Fulltext
modaccess smallint(3) No 0 Change Drop Primary Index Unique Fulltext
uploads smallint(3) No 1 Change Drop Primary Index Unique Fulltext
comments smallint(3) No 1 Change Drop Primary Index Unique Fulltext
diskspace int(10) Yes NULL Change Drop Primary Index Unique Fulltext
uploadsize int(10) Yes NULL Change Drop Primary Index Unique Fulltext
uplimit int(5) No 0 Change Drop Primary Index Unique Fulltext
editpho int(3) No 0 Change Drop Primary Index Unique Fulltext
editposts int(3) No 0 Change Drop Primary Index Unique Fulltext
useralbums int(3) No 0 Change Drop Primary Index Unique Fulltext
reqmod int(3) No 0 Change Drop Primary Index Unique Fulltext
canassign int(3) No 0 Change Drop Primary Index Unique Fulltext

Chuck S · December 4th, 2004, 05:58 PM

Are there any entries under your usergroup tables?

Login?

Chuck S · December 4th, 2004, 06:05 PM

Okay I registered on your gallery and logged in fine

You have two admin users?

Administrator userid 1

http://www.artheon.com/gallery/member.php?uid=1

and

Admin userid 2

http://www.artheon.com/gallery/member.php?uid=2

You sure your logging with the first one Administrator as that is the one the install script would have made admin. I would suspect you created a second account called Admin and then are trying to login with that one. The Administrator one is admin of the gallery until such time as you made Admin an administrator.

Semere · December 4th, 2004, 06:15 PM

No what happened was I thought I screwed up the install so I deleted 4.8.5 or whatever and then installed 4.8.2 But I dont know how to clean up the database So I gues I now have two administrators. Administrator is from the original install admin is from 4.8.2 or whatever.

Semere · December 4th, 2004, 06:17 PM

As for are there any entries I dont know what you are asking or how I get it. I can login to phpmyadmin but I dont know where to get the information for you.

Chuck S · December 4th, 2004, 06:29 PM

Okay if you view your usergroups table the entry for Administrators will have a groupid of 1 for an internal install and cpaccess will have a value of 1

You would have an admin link if this is true

Chuck S · December 4th, 2004, 06:34 PM

I see what you did. You should be fine now.

You had a problem with 4.8.5 and since you installed in the same tables 4.8.2 of course the usergroup fields don't match between versions so your usergroup inserts failed.

Yep You should have cleared the old tables or installed with a table prefix to avoid complications

Your good to go my man