Just make sure to make sure your personal account has the option for Founder checked yes.stevemaury wrote: ↑Fri Apr 17, 2020 2:45 am 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 notCode: 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', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
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: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
- anyone could use that account to log in to your board if you didn't change the password.
- 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).
User type is already set to 3...janus_zonstraal wrote: ↑Thu Nov 10, 2022 12:33 pm table ....._users => search admin1 change "user_type" to 3 (founder)
This can happen if you're still referring to data on the previous host (e.g. persistent cookies, cookie_secure, SSL, path).matjazv wrote: ↑Wed Nov 09, 2022 8:58 am Everything worked fine, except that on new instalation I don't get link to the ACP link at the bottom of page. If I try with URL "adm/index.php?sid=b83b8...." I get "Access to the Administration Control Panel is not allowed as you do not have administrative permissions." message - which is clearly wrong - my user (should) have admin permissions.
yes, FQDN is now bb.domain.com - previous was phpbb.domain.com. But I changed server_name in phpbb_config table to new fqdn
Login in browser private mode. No changes... can you point out where in phpbb_config are settings for persistent cookies, cookie_secure, SSL, path?janus_zonstraal wrote: ↑Thu Nov 10, 2022 1:39 pm Change your cookies in the database as warmweer wrote.
Or maybe you can login with a other browser or in private mode.
Hi, I check settings, in cookie_domain is new value corresponding to board fqdn, cookie_name is different than on old board, cookie_path an cookie_secure are both (old and new board) set to "/" and "0". I don't have field cookie_notice anywhere...janus_zonstraal wrote: ↑Thu Nov 10, 2022 1:54 pm Search for
cookie_domain
cookie_name
cookie_notice
cookie_path
cookie_secure
This is standard prosilver... see image - this is setting before exporting to new board.janus_zonstraal wrote: ↑Fri Nov 11, 2022 8:30 am What style is that?
Can you switch to the standard prosilver?