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: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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
Jr. Extension Validator
Posts: 6487
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ACP links and admin premissions missing

Post by warmweer »

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.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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
Jr. Extension Validator
Posts: 6487
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ACP links and admin premissions missing

Post by warmweer »

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"?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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
Jr. Extension Validator
Posts: 6487
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ACP links and admin premissions missing

Post by warmweer »

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.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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
Jr. Extension Validator
Posts: 6487
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ACP links and admin premissions missing

Post by warmweer »

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.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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: 68550
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: ACP links and admin premissions missing

Post by Lumpy Burgertushie »

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'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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: 68550
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: ACP links and admin premissions missing

Post by Lumpy Burgertushie »

how about a link to the board please.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Exabot
Translator
Posts: 211
Joined: Sun Jan 18, 2015 8:21 pm
Location: Estonia

Re: ACP links and admin premissions missing

Post by Exabot »

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

Return to “[3.2.x] Support Forum”