Forum doesn't show information inserted directly into DB

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
phpusher
Registered User
Posts: 9
Joined: Fri Oct 24, 2014 11:48 pm

Forum doesn't show information inserted directly into DB

Post by phpusher »

Support Request Template
What version of phpBB are you using? phpBB 3.1.1
What is your board's URL? No answer given
Who do you host your board with? No answer given
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
What styles do you currently have installed? prosilver
What language(s) is your board currently using? No answer given
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? Just now
Please describe your problem.

I just added a bunch of ranks to my forum, to assign each group its own rank. I did that by directly inserting into the database, since there are a lot of groups and the table looked really easy.
But now I don't see the new ranks in the forum. I already cleared my cache, that didn't help (would have surprised me if it did). In the ACP, the rank is set for every group and if I manually switch back to the default rank and then back to the group rank, I can see that, and only that rank in the forum.

Is there a possibility to get the forum to notice, that each group has a rank now? What else does the ACP do, when changing the rank, besides inserting into the database?

Thanks for the help :)
Generated by SRT Generator
phpusher
Registered User
Posts: 9
Joined: Fri Oct 24, 2014 11:48 pm

Re: Forum doesn't show information inserted directly into DB

Post by phpusher »

Okay, of course I find the answer right after I gave up and posted here :D
It's not enough to set the rank in the groups table, it has to be set in the users table, too.
For anybody that is interested in this (I doubt it :lol:):

I chose the same rank_id as group_id, as this makes things much easier. So adding the ranks is easiest with CSV import in phpmyadmin. There has to be a rank for every manually created group, or else you have to edit the WHERE condition. Then for the groups table, use this command:

Code: Select all

UPDATE phpbb_groups SET group_rank=group_id WHERE group_id>7;
This gives every group its own rank.
Then add the rank to the users table:

Code: Select all

UPDATE phpbb_users SET user_rank=group_id WHERE group_id>7;
Pretty self-explanatory I guess - not much different from the line above.
Locked

Return to “[3.1.x] Support Forum”