Installation Error at Step 3

[spadbuoy]

When I reach the final step in install.php and click the "Complete PhotoPost Classifieds Installation" button, I receive the error below. For some reason the "usergroups" table isn't being created during installation when the other tables are.

MySQL error reported!

Script: install

Query: SELECT groupid, groupname, cpaccess, uploads, comments, uploadsize, editpho, editposts, modaccess, reqmod, highlight, bold, italic FROM usergroups

Result: Table 'classifieds.usergroups' doesn't exist

Database handle: Resource id #12

[spadbuoy]

After reading this thread from last July and looking at the init_user_groups() subroutine in forums/threads.php, I manually created a "usergroups" table with phpmyadmin and succeeded in finishing the install.

[Chuck S]

If you installed classifieds 2.0 you might want to redo that.

The new usergroups table has this structure

The latest download I show is correct you might want to check out the threads.php in that download as the table structure is different than classifieds 6 months ago.

[spadbuoy]

I purchased and downloaded v2.0 this morning from the Member's Area so that's the version of forums/threads.php I used to create the table. Not sure why install.php wouldn't create it. I tried several things but couldn't complete the install because "usergroups" could not be found.

[Chuck S]

Okay but what I am saying regardless is your should use the init_usergroups function in the new file and then populate the inserts. Your missing important features if your using a n old usergroups structure.

This is what I see in the threads file

$query[] = "CREATE TABLE {$pp_db_prefix}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',
uploadsize int(10) default NULL,
editpho int(3) NOT NULL default '0',
editposts int(3) NOT NULL default '0',
reqmod INT(3) DEFAULT '0' NOT NULL,
highlight INT(3) DEFAULT '0' NOT NULL,
bold INT(3) DEFAULT '0' NOT NULL,
italic INT(3) DEFAULT '0' NOT NULL,
PRIMARY KEY (groupid)) TYPE=MyISAM";

13 fields

Then the import usergroups function

$query="INSERT INTO {$Globals['pp_db_prefix']}usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,uploadsize,editpho,editposts,reqmod,highlight,bold,italic) VALUES('$gid','$name','$modaccess','$cpaccess','$uploads','$comments','$uploadsize','$editpho','$editposts','$reqmod', $highlite, $bold, $italic)";

again 13 fields

I see no reason it would fail

[spadbuoy]

That's what I did. I reinstalled again but before I reached the point that produced the MYSQL error (step 3), I manually created the "usergroups" table using the init_usergroups function in the new file as a guide. I then clicked the "Complete...Installation" and was told I had successfully installed the software.

[Chuck S]

Good above you had meantioned about using some fix in a 6 month old thread. Just wanted to make sure you where not using an old usergroups table.

[etaslim]

I got the same problem. After step 3, I got an error message similiar like this thread http://www.photopost.com/members/fo...ad.php?t=110789. Is this issue has been solved with the latest build/version of classifieds 2.0? Cause I've redownload and installed it but still get the same error after step 3:

Content visible to verified customers only.

[Chuck S]

The error is this

This line in the forum integration files is this

$query[] = "CREATE TABLE {$pp_db_prefix}usergroups (groupid int(5) NOT NULL auto_increment,

needs to be this

$query = "CREATE TABLE {$pp_db_prefix}usergroups (groupid int(5) NOT NULL auto_increment,


Notice its $query not $query[] as we are not doing an array.

I will make sure the files are updated.

[etaslim]

thanks omegatron, I've changed the code in the vb3 file & now it works perfectly.