UBB.Developers Forums UBB.threads 7 Development How Do I? Threads 6.5 b4 / Photopost 4.8d / Photoclassifieds

I can't get them to play together, after a clean install of threads (which works fine) I try to install photopost. Updating config is fine, then the second part (External registation) I enter all the values, click submit and I get...


MySQL error reported!

Script: install

Query: SELECT groupid, groupname, cpaccess, uploads, comments, diskspace, uploadsize, editpho, editposts, modaccess, useralbums, reqmod, canassign FROM pp_usergroups

Result: Table 'domainname.pp_usergroups' doesn't exist

Database handle: Resource id #5

Any ideas? The PP board suggested a separate db for photopost. But I've run them together in the past. could this be a Threads issue (new release etc..)? BTW I substituted domainname for the actual domainname above.

Okay got it to work. I manually added this via phpmyadmin

CREATE TABLE pp_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 pp_usergroups VALUES (5,'Administrator',1,1,1,1,'','',1,1,1,0,0);
INSERT INTO pp_usergroups VALUES (1,'Banned','','','','','','',0,0,0,0,0);
INSERT INTO pp_usergroups VALUES (3,'Unregistered','','','','','','',0,0,0,0,0);
INSERT INTO pp_usergroups VALUES (4,'Registered','','',1,1,'','',1,1,1,0,0);
INSERT INTO pp_usergroups VALUES (2,'COPPA','','','','','','',0,0,0,0,0);

Now it says I'm not an admin when I try to enter the admin section of pp. But the main page of pp shows me as an administrator. ???

am I the only one who had no problems doing this

Must be... Only problem now is it is not reading me as an admin in pp.

okay well this is what I did but I don't use head tags so it's not an issue for me..

Works great, except I cannot login to pp and upload images etc...

http://www.ubbdesign.com/portfolio/index.php

let me take a look at my instructions

Dunno if it makes a difference, but I'm using external registration, when pp was installed.

okay I updated the file attachment above try that one. I just double checked it..

I use threads users database it doesn't even hit the photoposrt one

some may ask why make those two files hack.inc.php and configextras.php but I feel it makes the most sense seeing as I always upgrade and this allows more freedom. You can easily skip those and set them in the config.inc.php and to the main.inc.php but I like it this way

also there are some steps I am sure you can leave out like the insertion I do into the who's online table but I rather be safe than sorry.

tried and running... Omegatron also answered on the PP board, about the login. so working wth both your help. Dang this used to be 123... I must be tired..

cool.

Done... *phew* what a pain...

I didn't think so

Not no your mod, just the install etc. A client of mine wanted threads, photopost, and photoclassifieds. With all the tweaks etc, and the usergroup not being created.. prolly me

ouch yeah kinda hard sometimes like that.

FYI, your mod (as far as header etc) works for ppclassifieds also, seeing as it uses similar architechture..

The problem will be who's online. Seeing as file names are similar, there might be some confusion...

yeah we really need to start renaming things away from index.php and login.php and into things like photopostindex.php and reviewpostlogin.php

You can identify them by using not only the scriptname, but also the directory.