ACP links and admin premissions missing

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Fri Jan 11, 2019 8:50 am

Exabot wrote:
Fri Jan 11, 2019 7:47 am
I removed old styles from the database, but ACP still does not display...
And delete database all phpbb/Pages files

It is forbidden to enter the Administrator Dashboard because you do not have administrator privileges.

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Fri Jan 11, 2019 12:50 pm

Don't know what to do anymore. :|

"Check user premissiond" - it works but header bug

Code: Select all

[phpBB Debug] PHP Notice: in file [ROOT]/phpbb/auth/auth.php on line 479: Undefined index: a_
[phpBB Debug] PHP Notice: in file [ROOT]/phpbb/auth/auth.php on line 481: Undefined index: a_

Warning: Cannot modify header information - headers already sent by (output started at /data01/virt55555/domeenid/www.mydomen.eu/phpbb/includes/functions.php:3314) in /data01/virt55555/domeenid/www.mydomen.eu/phpbb/includes/functions.php on line 4564

User avatar
warmweer
Registered User
Posts: 1776
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: ACP links and admin premissions missing

Post by warmweer » Fri Jan 11, 2019 3:32 pm

Exabot wrote:
Fri Jan 11, 2019 12:50 pm
Don't know what to do anymore. :|
Actually it wasn't clear to me what you've been doing up to now, deleting styles from the database.
Now with all the "Undefined index: a_" errors I would bet that other things are broken also.
And I would just restart.
Exabot wrote:
Fri Jan 11, 2019 6:28 am
I tried this way https://www.phpbb.com/support/docs/en/3 ... /upgrade3/ forum files are now new.
The default style of the forum is still to read platinum (no files to server)... and user control panel displays all old styles.. Cache clear.
The problem seems to be in the database, but where...
Luckily you've got a backup and can retry. I do suspect however that you didn't sanitise the 3.0 completely.
Styles that you're not going to use or don't exist anymore in 3.2, don't bother to inactivate, just remove them.
You also menioned a "phpbb/Pages files" which you deleted from the database. Is this a remnant of a 3.0 mod which you didn't remove?
And the fact that Elegance was the default style makes me think that you didn't set prosilver as default and only active style before upgrading.
A bug is a feature that hasn't made it to the manual (yet)

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Sat Jan 12, 2019 5:52 pm

I think the role of the administrator has been changed (forum administrator etc.), because the MCP is still there and viewing user rights works.
How to modify / view it through the database?

User avatar
warmweer
Registered User
Posts: 1776
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: ACP links and admin premissions missing

Post by warmweer » Sat Jan 12, 2019 6:10 pm

Exabot wrote:
Sat Jan 12, 2019 5:52 pm
I think the role of the administrator has been changed (forum administrator etc.),
What's a "forum administrator"?
A bug is a feature that hasn't made it to the manual (yet)

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Sat Jan 12, 2019 6:15 pm

warmweer wrote:
Sat Jan 12, 2019 6:10 pm
Exabot wrote:
Sat Jan 12, 2019 5:52 pm
I think the role of the administrator has been changed (forum administrator etc.),
What's a "forum administrator"?
role.png

User avatar
warmweer
Registered User
Posts: 1776
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: ACP links and admin premissions missing

Post by warmweer » Sat Jan 12, 2019 6:18 pm

Exabot wrote:
Sat Jan 12, 2019 6:15 pm
warmweer wrote:
Sat Jan 12, 2019 6:10 pm
Exabot wrote:
Sat Jan 12, 2019 5:52 pm
I think the role of the administrator has been changed (forum administrator etc.),
What's a "forum administrator"?
role.png
ah, OK, my mistake I hadn't noticed the "role" part.
Still, you can make a new role and decide your own settings.
A bug is a feature that hasn't made it to the manual (yet)

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Sat Jan 12, 2019 6:21 pm

warmweer wrote:
Sat Jan 12, 2019 6:18 pm
Exabot wrote:
Sat Jan 12, 2019 6:15 pm
warmweer wrote:
Sat Jan 12, 2019 6:10 pm
Exabot wrote:
Sat Jan 12, 2019 5:52 pm
I think the role of the administrator has been changed (forum administrator etc.),
What's a "forum administrator"?
role.png
ah, OK, my mistake I hadn't noticed the "role" part.
Still, you can make a new role and decide your own settings.
Trough phpmyadmin? How to decide own settings?

User avatar
warmweer
Registered User
Posts: 1776
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: ACP links and admin premissions missing

Post by warmweer » Sat Jan 12, 2019 7:10 pm

Exabot wrote:
Sat Jan 12, 2019 6:21 pm
Trough phpmyadmin? How to decide own settings?
If you have phpMyAdmin access you can make the emergency admin, or even give yourself founder status. If you copy your board on localhost, you can assign all kinds of permission on localhost and then copy those to your live forum.

On second thought - considering you earlier questions, I wouldn't recommend it.
A bug is a feature that hasn't made it to the manual (yet)

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Sat Jan 12, 2019 7:21 pm

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.

Code: 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_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not phpbb_

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running database queries.

As soon as you have done this, use the temporary admin account to change the details on the original admin account, then delete the temporary account.
This is because:
  1. anyone could use that account to log in to your board if you didn’t change the password.
  2. this temporary user has not been fully set up (e.g. it is not a member of the “Registered users” group, so it won’t have normal access to your forums).
To remove the account you will first need to remove “founder” status from it: ACP > USERS AND GROUPS tab > Manage Users > Admin1 > Overview > Founder = No
It doesn't help.
I have a founder premissions (user_type = 3)
user_premissions:

Code: Select all

zik0zjzik0zjzik0zjzik0xs









































zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc

zik0zjzijbpc

zik0zjzijbpc


zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc

zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc


zik0zjzijbpc

zik0zjzijbpc






zik0zjzijbpc


zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc





zik0zjzijbpc
zik0zjzijbpc


zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zijtvjzijbpc

zik0zjv2ptkw

zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc


zik0zjzijbpc



zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc

zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc


zijtvjzijbpc

ziimf3zijbpc
ziimf3zijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc

zik0zjzijbpc
zik0zi00x0cg

zik0zi00x0cg
zik0zjzijbpc
zik0zjzijbpc
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg

zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zi00x0cg
zik0zjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc

zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
zijtvjzijbpc
qlbufy0070u8
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc
zik0zi00x0cg
zik0zjzijbpc
zik0zjzijbpc
zik0zjzijbpc

User avatar
Lumpy Burgertushie
Registered User
Posts: 65514
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: ACP links and admin premissions missing

Post by Lumpy Burgertushie » Sun Jan 13, 2019 3:05 am

what does "doesn't help " mean.

the point of doing that is so you can get back in the admin panel to fix your problem.

are you saying that with that new admin account you can not access the admin panel?


robret
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Sun Jan 13, 2019 6:58 am

Lumpy Burgertushie wrote:
Sun Jan 13, 2019 3:05 am
what does "doesn't help " mean.

the point of doing that is so you can get back in the admin panel to fix your problem.

are you saying that with that new admin account you can not access the admin panel?


robret
Yes, ACP links missing. :?

User avatar
Lumpy Burgertushie
Registered User
Posts: 65514
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: ACP links and admin premissions missing

Post by Lumpy Burgertushie » Sun Jan 13, 2019 7:37 am

how about a link to the board please.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

Exabot
Translator
Posts: 127
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot » Mon Jan 14, 2019 10:36 am

Works!! From the database table phpbb_acl_options missing a_ table.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Exclusive and 25 guests