Login to only General and mods

[ssnobben]

Your phpBB+ Version: 1.0.0-RC3
What exactly do you want help with? Installed over a fresh phpBB 3.0.6
What exactly do you want help with? Board needs cleaning before or after installing phpBB3+
MODs installed: No
Your phpBB3 knowledge: Basic Knowledge

PHP Version: 5,2,8
Database Version: MySL 5.0.87

Please describe your problem from start to end, in short terms
Hi

I have a problem with log in to back end. I can log in but seems to have get some problem with the permission settings.

When log in to back end I get only the General tab and the mod tab...I dont know what have happend but how do I change in the db so I can get the right permissions back to a super admin so I can get all tabs working again?

Rgds
Please list any extra mods installed
no extra mods installed only RC 3 and phpBB 3.0.6
Extra info,images and codes

[DoYouSpeakWak??]

Thats very strange. The permissions you mention cannot be turned that much off.

Do you need to clean your board before installing phpbb3+ or have you allready installed it ?

[ssnobben]

No I dont need to clean the board. I have installed a clean phpBB 3.0.6 and RC3 and it working fine but I need to change the permissions for the super admin in the database.

How do I change the permissions so I can make the user a super admin in phpBB 3.0.6 ?

rgs

and Happy New Year too!

[DoYouSpeakWak??]

You should update to RC4 that is out. RC3 had some rather nasty bugs due to updating from 3.0.5 to 3.0.6.

Setting admin permissions is easy. Got to acp > Permissions > Administrators. Enter a user and set the permissions for him/her.

But be aware that neither phpbb3 or phpbb3+ has a permission for each admin tool. If you allow access to acp to another users there will be some stuff you wont be able to turn off or on. hope you understand.

Good luck.

[ssnobben]

Well I dont know if you understand.

If you click on the pic I attach you see that I log in as an admin but I o n l y got two tabs=

* General
* .MODs

Thats the problem I cant go furter into the acp (Setting admin permissions is easy. Got to acp > Permissions > Administrators. Enter a user and set the permissions for him/her.)

Its not easy if you cant get into the acp thats why I have to do this setting in the db with phpMyadmin..

so the question is how do I do that?

( I will try to make a update too and see how that works out ..)

[ssnobben]

I could fix it so I am on the way now.. stole this from the support phpBB forum..

Hmm I thought it had an option to change your password. I must be thinking of another section.

Never mind.

In phpmyadmin, run the following, which will create an admin user named admin1 with a password of admin. From that point you should be able to get into the ACP. Change your table prefix if it is not phpbb_.

Code:

Code: Select all

Select all
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');


[cisco007]

nice little snippet there ssnobben, I don't really know how you got that problem, i have been installing and testing this packages since early on and never had any problems! Maybe it was a problem with the server not uploading the all the files correctly!

[ssnobben]

well got everything working now so thanks all you guys. see also the site map there!

[cisco007]

how did you fix it, or what was the problem?

[ssnobben]

The problem was that I could not log into the admin part of my site as admin with super admin rights, so I have to make a new admin password and then change password so it match user name and password for my Joomla admin account also. Meaning that I have double log in working from phpBB and Joomla.

rgds