Usergroup refresh bug with RP and PhpBB

[petr55]

I have Photopost 5.02 and ReviewPost 2.9 Running against PhpBB 2.0.11 user registration system and forum.

When I added a group in PhpBB and went to Photopost to refresh, the Admin and Anonymous usergroup was erased and only the new usergroup remained. In the process it locked me out of the admin function totally.

I had to restore the usergroup table to get it back to normal.

Almost the same happens with Reviewpost. But it flashed something about table or something missing (it was too quick to read).

Is there a fix for this?

Thanks
Petr

Originally Posted by omegatron

I see the issue me taking a baseball bat to Michael LOL

In phpbb2.php find this in the import usergroups function

//$query = array();
//$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous','','','','','','',0,0,0,0,0,0)";
//$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('2','Admin',1,1,1,'','','',1,1,1,1,0,1)";
//$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('3','Regular Users','',1,1,'','','',1,1,0,1,0,0)";

//for ( $x=0; $x < count($query); $x++) {
// $iquery = $query[$x];
// $setup = mysql_query($iquery, $link);
// if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
//}

uncomment all the lines like so

$query = array();
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('1','Anonymous','','','','','','',0,0,0,0,0,0)";
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('2','Admin',1,1,1,'','','',1,1,1,1,0,1)";
$query[] = "INSERT INTO {$Globals['pp_db_prefix']}usergroups VALUES ('3','Regular Users','',1,1,'','','',1,1,0,1,0,0)";

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

Thanks, that fixed the bug for Photopost. Although it has the annoying resetting of existing usergroup settings. Also mentioned here:
http://www.photopost.com/members/for...d.php?t=113289


But I still have a problem with Review post. Can you please look into that for me?

THanks
Petr

[Michael P]

ReviewPost doesn't work the same as PhotoPost with regard to usergroup settings; RP uses the "old" code of deleting usergroups and resetting them to the default requiring you to re-enter the values you had in place.

In an update we'll look to add in the saving of data during importing.