July 8th, 2004, 12:31 AM
I checked all table and database names, but after installing, erasing and installing again, I'm getting this error..
MySQL error reported!
Query: SELECT groupid, groupname, cpaccess, uploads, comments, diskspace, uploadsize, editpho, editposts, modaccess, useralbums, reqmod, canassign FROM usergroups
Result: Table 'photopost.usergroups' doesn't exist
Database handle: Resource id #4
I set it to use my forums (Threads) user DB.
where have I gone wrong?
July 8th, 2004, 09:01 AM
Looks like the usergroup import did not happen.
You can run this query in phpmyadmin for your photopost database
CREATE TABLE usergroups (groupid int(5) NOT NULL auto_increment, groupname varchar(50) NOT NULL default '', cpaccess smallint(3) NOT NULL default '0', modaccess 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 '0', editposts int(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;
INSERT INTO usergroups VALUES (1,'Administrator',1,1,1,1,'','',1,1,1,0,0);
INSERT INTO usergroups VALUES (2,'Moderator's','','1','1','1','','',1,1,1,0,0);
INSERT INTO usergroups VALUES (3,'Registered','','',1,1,'','',1,1,1,0,0);
July 9th, 2004, 01:32 AM
okay, did that, now when i try to login, it kicks me back to the login page and says I need to register..
July 9th, 2004, 07:04 AM
Are you using your loginname or displayname? Remember Threads has two names. Photopost uses U_Username not U_LoginName so try your displayname not loginname
July 18th, 2004, 07:44 PM
they are the same, doesn't work either way...
even tried creating a new account and using that, and it's a no go.
anyone else run photopost on a seprate domain/sub domain from their forums?
it seems to work okay if it's under my forums like domain.com/forums/photopost/
but I'm trying to get it to work on it's own system under photopost.domain.com
and it just doesn't like it..
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.