pp-classifieds, phpbb2 install problem

[dave_lilley]

During the install, everything seems fine until step 4.

After I fill in the info for step 4 and click Configure Phoropost, I get four error messages at the top of the screen for step 5:

Error: Column count doesn't match value count at row 1
Error: Table 'sailorsmarket.usergroups' doesn't exist
Error: Table 'sailorsmarket.usergroups' doesn't exist
Error: Table 'sailorsmarket.usergroups' doesn't exist

MySQL: 4.1.9
PHP: 4.3.10
phpBB2: 2.0.13 (clean install, no mods)
pp-classifieds 2.11

name of the site: sailorsmarket.com
name of the db for forums and classifieds: sailorsmarket
prefix for pp-c: pp_
prefix for phpbb2: phpbb_

All of the directories, as well as config-inc.php are set to 777.

I made sure to use the correct prefixes for the db's, and I've tried this several times. If I go back to step 4 and try it again, I get:

Error: Table 'pp_usergroups' already exists
Error: Column count doesn't match value count at row 1
Error: Table 'sailorsmarket.usergroups' doesn't exist
Error: Table 'sailorsmarket.usergroups' doesn't exist
Error: Table 'sailorsmarket.usergroups' doesn't exist

If I drop pp_usergroups, and go back to step 4, I get the original errors.

If I try to continue with step 5, I get “PhotoPost Classifieds has been successfully installed!” However, when I click on adm-index.php and try to log in, I see “You are not a valid administrator or moderator!”

I have gone so far as to drop all of my tables for the forums and classifieds, and do a clean install of each (forums first. I get the same error every time.

Dave

[dave_lilley]

The pp_usergroups table was empty so I inserted a row, put in the correct id for the phpbb2 admin group (2), set the groupname to Adminstrator, and set all of the other flag fields to 1. That let me in as an administrator, but when I tried to refresh the groups, I got the same old errors and "You are not a valid administrator!"

[dave_lilley]

I found and fixed the problem. In ./forums/phpbb2.php, the $usergroups variable wasn't being properly "prefixed". In the insert and create table statements, it was coded as {$pp_db_prefix}usergroups, but it should have been {$Globals['pp_db_prefix']}usergroups.

Additionally, the insert statements for Anonymous INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous',0,0,0,0,0,0,0,0,0,0), were missing one field.

They should look like this: INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous',0,0,0,0,0,0,0,0,0,0,0).

Anyway, it works now, and I am able to update the groups through the console.

If it ok with the Photopost crew, I will attach the updated file.

Thanks,
Dave

[medieval]

I just made the second change to the latest install (v242, 9/29 build) and now I can refresh usergroups without an error for phpbb2. Thanks!