The bottom portion is probably due to a module that was once running, and how it must have either been hardcoded to access a specific database or that it added some type of config of it's own into the tables to remember the database.briandevcali wrote:did a search for that and changed the admin to admin1 and admin as password with a query. now logged in as that and it says "This Board is Currently Disabled". I dont know where i would go to manage the back end of this site.
also has this error at the bottom:
[phpBB Debug] PHP Notice: in file /newsmod/featuresConfig.php on line 40: mysql_connect(): Access denied for user 'portalmaster'@'localhost' (using password: YES)
Could not connect to DB server!
briandevcali wrote:right now i am trying to get into the site to manage it via the phpBB management portion of things. How can I change the admin username and password from the mysql database?
The following has been quoted from an old support topic for phpBB 3.0.x, original topic.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_.
Executing SQL Queries in phpMyAdmin KB
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_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', 'email@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
As soon as you have done this, use the temporary admin account to update 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).
That's because the version of the files and the version of the database are different.briandevcali wrote:Perfroming this produced an error "Unknown column 'user_form_salt' in 'field list' "
At least one user has their style set to one that is not on the server.briandevcali wrote:Template path could not be found: styles/PortalStones/template