MySQL error - no "usergroups" row

[DeltaJo]

Trying to install version 1.8, using my UBBThreads as my database.

I get this error:

MySQL error reported!

Script: install

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

Result: Table '127083_threads.ads_usergroups' doesn't exist

Database handle: Resource id #5

Sure enough there is no ads_usergroups row.

[JCS100]

Getting the same error...Fresh install.

Threads 6.5 b4 and Photopost 4.8d , new install of both.

[djroketboy]

I found it best to create a new DB for the classifieds, and then use your user DB for your forum software, i tried it a couple other ways and ran into all sorts of issues... when setting it up, it gives you 2 places to connect to a DB...

[JCS100]

New as in separate?

[JCS100]

Okay I manually added this...

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

And it let me finish installing. But now it says I'm not an admin...

[Chuck S]

Remember JC you installed the admin user as usergroup 5 which is a photopost install. Threads uses usergroup 1 as the admin group not 5

You need to delete all those entries in the usergroup table except 1 and edit groupid 1 to be your Administrator entry.

INSERT INTO pp_usergroups VALUES (1,'Administrator',1,1,1,1,'','',1,1,1,0,0);

You can then import the others afterward.

[JCS100]

Makes sense, will try ...

[JCS100]

Okay renumbered em via phpmyadmin. Now, why did I have all this trouble? I did a clean isntall of threads and photopost. Shouldn't they readily work together, without editing of any script or db?

Me consufed...

[Chuck S]

There is a function import_user_groups() in the threads.php file for some reason yours choked

[JCS100]

Yup, tried it on my site and the clients, it did both times. Either I'm repeating the mistake or it's in the code I guess.

[JCS100]

Okay clean isntall again, of threads and PP. All went well except submitting the external reg. settings resulted in

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/******/gallery/forums/threads.php on line 370

with the blue block saying to visit adm-index.php, clicking the linkr esults in "not an admin..."

And vieiwn the pp index page shows this at the top..

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/******/gallery/forums/threads.php on line 285

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/******/gallery/forums/threads.php on line 285

[Chuck S]

I will do a STOCK install and test it out although everyone looks fine in the import usergroup settings. It simple looks at the threads groups table and imports a line for each one.

Now what is interesting is your line 370 error and 285 as well are both listing of the usergroups table example below

while ( list($groupid, $groupname, $cpaccess, $uploads, $comments, $diskspace, $uploadsize, $editpho, $editposts, $modaccess, $useralbums, $reqmod, $canassign) = mysql_fetch_row( $resultcur ) ) {

These are the normal listings of the usergroups setting. So in essense your usergroups table is not getting imported or created at all.

By the way JC your commenting in a classifieds thread about photopost

[JCS100]

Well I had the same prob in both

[JCS100]

Any news Chuck?

[DeltaJo]

Is it safe to assume that support will not be given on this issue?

I just need to know if I should go ahead with my purchase of an alternate product to replace this non-working product which is nonetheless sold as an out-of-beta, stable and functioning product.

It also seems to be an unsupported product, now that I've purchased it.

Just a followup would be nice. A word or two.

I did spend a good chunk of my money on this script in good faith and can't even install the latest version of it due to what appears to me to be an acknowledged bug which is also being experienced by at least a couple of other purchasers.

I do understand the concept of being "busy", but as I said, a simple word or two indicating tacit acknowledgement of the problem and "we're working on it" -- is minimally expected by a normal purchaser of a non-functioning product.

[JCS100]

Deltajo, Are you going to use PPC with the ubb.threads package or will it eb a standalone or use another bulletin board? It apepars this problem is due to a break in communication when trying to set it up to use the 'threads userbase instead of it's own. With the ever changing code and updates of other non photopost products, it can be difficult to tie up all the loose ends. That coupled with 'threads being out in beta form (current release is 6.5 b4) can throw a wrench into the works. I'm a beta tester for threads and I know how much changed since the last release.

If you need help with the install you can contact me privately at admin@ubbdesign.com

[DeltaJo]

JCS100:
I'm using my UBBThreads 6.4.1 as my database -- which has been around for many many months now, and I know PhotoPost products are fully compatible with it since I have used PhotoPost Pro with it and the support people here all have too -- they're Threads users too and are more than familiar with the products being used together.

As you said yourself, there seems to be something wrong with the script in that it fails to connect with UBBThreads installations. Note that PhotoPost Classifieds is sold as being compatible with UBBThreads 6.x. I have not attempted to install using any beta versions of anything.

I know it can be difficult in any case, and I'm very understanding and patient. All I'm asking for is the common courtesy due me as a patient understanding customer who bought a product in good faith and has been nothing less than perfectly polite in asking for help.

I will contact you privately, and thanks for your help.

[steffonator]

I have the same problem. I there a fix for this?

I use Threads 6.4.2 and PhotoPost 4.7j
PP Class have it's own DB

MySQL error reported!

Script: index

Query: SELECT groupid,cpaccess,modaccess,diskspace,uploadsize,uploads,comments,editpho,editposts,useralbums,reqmod FROM ppc_usergroups WHERE groupid='4' LIMIT 1

Result: Table 'stvmrkt.ppc_usergroups' doesn't exist

Database handle: Resource id #7

/Stefan

[Michael P]

Sorry for the delay, I wasn't aware of this thread.

It appears the init_user_groups function was mistakenly erased in the current release, you need to replace the lines in forums/threads.php around line 437:

Content visible to verified customers only.

with:

Content visible to verified customers only.

I will update the forums/threads.php in the downloadable build to reflect the change.