MODS.DB9.DK

[Brad Walker]

I installed both the Auto Group and the Mass Email mod in my forum, have been pleased with the functionality except:

After installing Auto Group and then creating a new group with members who have 0 or more posts ("Everyone") I find that I can not view this group with the Usergroup/Control Panel. I just get a blank page, no errors, nothing.

I am able to view other groups, just not the one that I automatically moved people into using this mod.

This viewing problem occurs regardless of whether I try to view as a moderator/admin or as a group member.

Any suggestions on places to look for a solution?

[Beeveer]

Try the Large Group Fix also available here. The standard page is very inefficient.

[Brad Walker]

Thanks for the suggestion, but I managed to implement the feature I wanted -- which was creating a group with all of my users -- with a file import and a few SQL lines instead.

[Homeskillet]

Heya...any way you could share how you did it?

[Brad Walker]

Heya...any way you could share how you did it?

Sure. You'll need to have some familiarity with MYSQL and with phpAdmin. This will create a new usergroup with every user in it -- it's not as complicated as it looks.

1. Create the new usergroup using the phpBB Admin panel, then get the group_id (usually four digits) from the phpbb_user_group table using phpAdmin.

2. Export the phpbb_users table as a file using phpAdmin. Specify the csv for MS Excel option.

3. Open the csv file with Excel and delete all columns except the first one, which has the user_id. Insert a new column at the beginning of the spreadsheet with the group_id information from step 1. Add a third column with a 0 in it. Copy as necessary so that the group_id is in the first column for every user_id and the 0 is in the third column for every user_id.

4. Save the file as a csv file, comma delimited. Ignore any warnings about file format.

5. Open the file with Word Pad or a similar text editor. Find and replace all the commas with semi-colons. Each line of the file should look like this: 9999;888;0 where 9999 is the group_id and 888 is the user_id. There should be one line for each user in your database. Resave the file with a .txt extension.

6. Go back to phpAdmin, open up the php_user_group table and click on the Structure tab. At the bottom of the page should be an option to "Insert data from a textfile into table". Click on it.

7. You should be able to get by with all the default options, but you may need to change the Load Method to Data Local if Data alone doesn't work.

8. Submit the form and the database should be automatically updated.

There are a lot of steps, but they're fairly straightforward. I would strongly suggest that you backup the MYSQL files before trying this and that you do a test run with one or two users initially to make sure it all works, rather than trying to do everyone first time out of the box. Also, there may be easier ways to do this, but this is the one I used and that worked well for me.

Hope this helps.