Unable to login after conversion

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
barrypoore
Registered User
Posts: 22
Joined: Fri Mar 24, 2023 3:42 pm

Unable to login after conversion

Post by barrypoore »

I have ran the conversion from SMF 2.0.14 to PHPBB 3.2.11, now when I try to login the following MySQL error is returned once I click the submit button:

Unknown column 'user_pass_convert' in 'field list' [1054]

Can anyone shed any light on this, also my forum is stuck in maintenance mode, can this be undone in the database?

Many thanks.
barrypoore
Registered User
Posts: 22
Joined: Fri Mar 24, 2023 3:42 pm

Re: Unable to login after conversion

Post by barrypoore »

In regards to being stuck in maintenance mode, I just had to rename the install folder
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26706
Joined: Fri Aug 29, 2008 9:49 am

Re: Unable to login after conversion

Post by Mick »

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', '[email protected]', '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
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel©
🇬🇧

Return to “[3.2.x] Convertors”